February 24, 2025 - by Bill Jelen
You are presenting on a Zoom call. You've hidden columns in your spreadsheet that contain Salary, Manager, and Bonus. You need to unhide the Manager data in E but not unhide the Salary in D or the Bonus in F. Normally, you would select from column D to column G and unhide. But that would reveal the Salary and Bonus information on the call.
Excel 2024: Generate All Combinations Using BASE Function »
February 20, 2025 - by Bill Jelen
I occassionaly have a model where I need to test all possible combinations of several outcomes. For example, lets say that you have four different manufacturing lines and three scenarios that could happen per line.
Excel 2024: The Advanced Filter Treats Criteria as "Begins With" »
February 17, 2025 - by Bill Jelen
Check out this simple use of Advanced Filter. You are asking for all rows with the Product of Apple to be copied to the output range.
Excel 2024: Circle Invalid Data Automatically »
February 10, 2025 - by Bill Jelen
You have some numbers in a worksheet. Those cells should be between 60 and 90 inclusive.
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.
The Transformative Magic of Power Query M Code in Excel and Power BI
August 2024
A beginner’s guide to mastering the art of data metamorphosis to get just the data structure needed to create insightful data analysis solution
Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)
December 2021
Use Microsoft 365 Excel and Excel 2021 pivot tables and pivot charts to produce powerful, dynamic reports in minutes: take control of your data and your business!
Financial Modelling in Power BI
September 2022
The only book to produce all three financial statements in Power BI.