April 18, 2019 - by Bill Jelen
Pivot tables let you summarize tabular data to a one-page summary in a few clicks. Start with a data set that has headings in row 1. It should have no blank rows, blank columns, blank headings or merged cells.
Select a single cell in your data and choose Insert, Pivot Table.
Excel will detect the edges of your data and offer to create the pivot table on a new worksheet. Click OK to accept the defaults.
Excel 2019: Get Ideas from Artificial Intelligence »
April 17, 2019 - by Bill Jelen
A new artificial intelligence feature debuted in Office 365 in early 2018. Originally called Insights, the feature was re-branded as Ideas and moved to the far right side of the Home tab of the Ribbon by September of 2018. Excel Insights will analyze your Excel data to search for patterns and return a series of interesting facts or trends about the data.
Excel 2019: Consolidate Quarterly Worksheets »
April 15, 2019 - by Bill Jelen
There are two ancient consolidation tools in Excel. To understand them, say that you have three data sets. Each has names down the left side and months across the top. Notice that the names are different, and each data set has a different number of months.
Power Excel With MrExcel - 2017 Edition »
This is the print book edition of "Power Excel with MrExcel - 2017 Edition" - by Bill Jelen. Master Pivot Tables, Subtotals, Visualizations, VLOOKUP, Power BI and Data Analysis.
The Absolute Guide to Dashboarding & Reporting with Power BI »
Learn Power BI Dashboarding Techniques by Watching A Pro!
Microsoft Excel 2019 Pivot Table Data Crunching »
Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you’ve never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power–including valuable improvements in Excel 2019 and Excel in Office 365.
If you want to be able to supercharge Power BI, you need to learn to write DAX. Data Analysis Expressions (DAX) is the formula language of Power BI and Power Pivot for Excel. This book prompts the reader to put your new skills to the test. Written to give you hands-on practice using Power BI Desktop and writing DAX.
MrExcel LX – The Holy Grail of Excel Tips »
A book for people who use Excel 40+ hours per week. Illustrated in full color.
