June 12, 2024 - by Bill Jelen
The mighty F4 key should be in your Excel arsenal for two completely different reasons:
Illustration: Cartoon Bob D'Amico
Excel 2024: Slicers for Pivot Tables From Two Data Sets »
June 11, 2024 - by Bill Jelen
Say that you have two different data sets. You want a pivot table from each data set and you want those two pivot tables to react to one slicer.
Excel 2024: Pivot Table with Sum and Average Total Rows (MDX) »
June 10, 2024 - by Bill Jelen
Check out this impossible pivot table. Details for Sum of Sales. Total for Sum of Sales. Then, without any details for Average of Sales, a Total row for Average of Sales. Notice that there are no hidden rows between row 33 and 34.
Excel 2024: Compare Budget Versus Actual via Power Pivot »
June 7, 2024 - by Bill Jelen
Budgets are done at the top level revenue by product line by region by month. Actuals accumulate slowly over time, invoice by invoice, line item by line item. Comparing the small Budget file to the voluminous Actual data has been a pain forever.
Programming PowerPoint with VBA
February 2022
This book assumes you already use PowerPoint and want to automate or enhance your presentations using Visual Basic for Applications (VBA). This book includes VBA samples for working with layouts, themes & masters, creating tables, drawing objects, charting, animation effects and event programming.
February 2024
This is the 7th edition of MrExcel XL. Updates for 2024 include: Remove Filter Items Using Search Box, The Consolas Font Makes it Easy to Tell Zero from the Letter O, Display Online Pictures In a Cell Using a Formula, Place Pictures In Cell From Local Computer, Using Artificial Intelligence with Copilot for Excel, and more...
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.
MrExcel 2021 - Unmasking Excel
February 2021
This is a 5th edition of MrExcel XL. Updates for 2021 include: LAMBDA, LET, Power Query Fuzzy Match, Sort & Filter in Sheet View, Cut-out people, Save object as image, STOCKHISTORY, Wolfram Alpha Data Types, Custom Data Types from Power Query, Weather data types, bilingual spreadsheets, Performance improvements, Unhide multiple worksheets, Action pen, Collapsible task panes, LET function to re-use calculations, store formulas using LAMBDA, Recursive LAMBDA, Branching LAMBDA, Lambda to return a picture, Excel function quick reference.