Bill Jelen Boeken

Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience. Written by the world's foremost PowerPivot blogger and practitioner, the book's concepts and approach are introduced in a step-by-step manner tailored to the learning style of Excel users everywhere. The techniques presented allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months to produce. The "pattern-like" techniques and best practices contained in this book have been developed and refined over two years of onsite training with Excel users around the world, and the key lessons from those seminars costing thousands of dollars per day are now available within the pages of this easy-to-follow guide. This updated edition covers new features introduced with Office 2015.

You're beyond the basics--so dive in and really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Learn how the experts tackle Excel--and challenge yourself to new levels of mastery. Includes companion eBook and sample files. Topics include: Customizing the Excel workspace Best practices for designing and managing worksheets Creating formulas and functions Performing statistical, what-if, and other data analysis Core to advanced charting techniques Using graphics and sparklines Managing databases and tables Automating Excel with macros and custom functions Collaborating in Excel online, in the cloud, and more Extending Excel

Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad help you automate Excel tasks to get more done, faster than ever. Use this guide to automate virtually any routine Excel save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable; capture data from anywhere, and use it anywhere; and automate the best new features in Microsoft Excel. You'll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and complete, easy-to-adapt solutions. By reading this book, you About This Book • For everyone who wants to get more done with Microsoft Excel in less time • For business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data

Provides a series of practical, easy-to-follow patterns for common analysis, reporting, and dashboarding functions when using Power Pivot. Includes newer Excel products such as Power Query, Power View and Power Map

Provides comprehensive coverage on the spreadsheet software, including detailed solutions to everyday problems, real-world examples, troubleshooting help, and in-depth explanations of new features.

This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These are tips honed by Bill Jelen, “MrExcel,” during his 10-year run as a financial analyst charged with taking mainframe data and turning it into useful information quickly. Topics include perfectly sorting with one click every time, matching lists of data, data consolidation, data subtotals, pivot tables, and much more.

Using Excel 2010, you can create stunning charts, graphs, and data visualizations to communicate complex information effectively. One of the world’s leading Excel experts guides you through maximizing Excel 2010's visual features. Bill Jelen, known as "MrExcel," details when and how to utilize each chart type, demonstrating how to create impressive visuals while customizing them with themes, colors, and effects. Learn to craft charts that reveal trends, differences, and relationships, create stock analysis charts, and leverage Excel's flexible PivotCharts. You will also explore how to present data on maps using Microsoft MapPoint, utilize Sparklines and in-cell visualizations, and incorporate images and shapes with SmartArt. Additionally, discover how to export charts for external use and generate dynamic, customized charts automatically with Excel VBA. A dedicated chapter addresses evaluating the accuracy of charts created in Excel and recognizing misleading representations. This resource covers everything Excel users need for effective visual communication, from basic techniques to advanced methods like automatic chart generation with VBA, all part of the new MrExcel Library series, edited by Excel legend Bill Jelen.