May 8, 2024 - by Bill Jelen
Pivot tables offer a myriad of calculations in the Field Settings dialog box. Here is a faster way to change a calculation:
1. Drag Revenue to the Values area twice.
2. Double-click on the heading Sum of Revenue2. Excel opens the Value Field Settings dialog.
3. Click on Show Values As and select % of Column Total from the dropdown.
4. Type a new name in the Custom Name field, such as % of Total.
Excel 2024: Create a Year-over-Year Report in a Pivot Table »
May 6, 2024 - by Bill Jelen
Let's say you have two years worth of detail records. Each record has a daily date. When you build a pivot table from this report, you will have hundreds of rows of daily dates in the pivot table.
Excel 2024: Create Your First Pivot Table »
May 2, 2024 - 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.
Excel 2024: Consolidate Quarterly Worksheets »
April 30, 2024 - 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.
Master Your Data with Power Query in Excel and Power BI
August 2021
Despite the moniker "data monkey," we information workers are often more like data magicians. Our data seldom enters our world in a ready-to-consume format; it can take hours of cleaning, filtering, and reshaping to get things ready to go. Power Query will make this process faster the first time and reduce it to a single button click every subsequent time.
April 2022
The 6th Edition of MrExcel XL, updated with new functions released for Microsoft 365.
Microsoft Excel Inside Out (Office 2021 and Microsoft 365)
December 2021
Dive Into Microsoft Excel for Office 2021 and Microsoft 365 and really put your spreadsheet expertise to work. This supremely well-organized reference packs hundreds of timesaving solutions, tips, and workaroundsall you need to make the most of Excels most powerful tools for analyzing data and making better decisions.
Microsoft 365 Excel: The Only App That Matters
June 2022
Excel Worksheet, Power Query, Power Pivot, Power BI. Calculations, Analytics, Modeling, Data Analysis and Dashboard Reporting for the New Era of Dynamic Data Driven Decision Making & Insight!