April 19, 2024 - by Bill Jelen
At my last day job, we had three sales regions: East, Central, and West. The company headquarters was in the East, and so the rule was that all reports were sorted with the East region first, then Central, then West. Well, there is no way to do this with a normal sort.
|
Sort AZ, and you will have Central at the top.  |
|
Sort the data ZA, and you will have West at the top.  |
Excel 2024: Set Up Your Data for Data Analysis »
April 17, 2024 - by Bill Jelen
Make sure to follow these rules when you set up your data for sorting, subtotals, filtering and pivot tables.
Excel 2024: Place Pictures In Cell From Local Computer »
April 15, 2024 - by Bill Jelen
For the last 30 years, you could use Insert, Picture in Excel. The image was added to a special drawing layer that floated above the grid. In June of 2023, that legacy experience became known as Place Over Cells. The new experience is to Place In Cell.
Excel 2024: Display Online Pictures In a Cell Using a Formula »
April 12, 2024 - by Bill Jelen
The IMAGE function debuted in August 2022. It is only for online images that are available through a URL.
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.
Financial Modelling in Power BI
September 2022
The only book to produce all three financial statements in Power BI.
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...
Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)
April 2022
Use this guide to automate virtually any routine Excel task: 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.