Excel 2024: Excel Stories

March 20, 2025 - by Bill Jelen

Live 'On Stage' In Person: The Power Excel Seminars

That poster from Hatch Show Print on my website sort of started out as a joke. I was flying through Nashville and saw a display of old country music letterpress posters on the wall. The little sign by the posters said they were produced on a 100-year-old hand-cranked press and that the company was still operating in Nashville. I called them and hired them to produce a 'concert' poster for my live Excel seminars. They had to think I was a little nuts. The print shop manager, Jim Sherraden, often did an informative presentation about the history of Hatch, and he cited my poster as the first to list a website URL.

The author Bill Jelen laughs with his poster from Hatch Show Print: Live! On Stage, In Person MrExcel Bill Jelen will entertain and inform you with his Power Excel Seminar. Unleash the Power of Excel - Pivot Tables, Subtotals, Charting, Formulas - Tips & Tricks to save you one hundred hours per year.

I do my half-day or 1-day seminar for accounting groups across the country. Every large city has a local chapter of the Institute of Managerial Accountants or the Institute of Internal Auditors. The people who belong to these groups usually need 20-30 hours of continuing education (CPE) each year. If you join the organization and go to 12 lunch meetings, half of your CPE is done. The organizations will often sponsor a 1- or 2-day event with speakers so their members can earn the remaining CPE at one time. I often am invited to speak at these events. The poster on the door lets people know that they are not in for the usual tax update. (I don't mean to offend the wonderful people going through the new tax laws - someone's got to do that.)

More Reading

Excel 2024: More Excel Tips »

March 17, 2025 - by Bill Jelen

More than 200 ideas were sent in for this book. While the following ideas did not get much press here, they are self-explanatory in a 140-character tweet.

Excel 2024: Favorite Keyboard Shortcuts »

March 10, 2025 - by Bill Jelen

As I started polling readers about their favorite Excel tips, a large number of them were keyboard shortcuts. Following keyboard shortcuts are presented in order of popularity.

Excel 2024: Customize the Quick Access Toolbar »

March 3, 2025 - by Bill Jelen

Even though the Excel team does not think many features are Home-tab-worthy, you can add your favorite features to the Quick Access Toolbar (QAT).

Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot

January 2025

Learn to use pivot tables and pivot charts in Microsoft Excel to produce powerful, dynamic reports in minutes: take control of your data and your business! Even if you’ve never created a pivot table before, this book will help you leverage their flexibility and analytical power and includes exploration of new array functions and Copilot capabilities in analysis creation.

Power Query Beyond the User Interface

February 2025

You've already transformed your data (along with your life) by learning Power Query. This book will take that transformation a lot further by teaching you the M language that sits behind Power Query's User Interface.

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.

Financial Modelling Using Dynamic Arrays

December 2024

This book tries hard to raze a laugh (yes, that' s what was meant... ). Instead, through numerous examples and case studies, it details the impact of the ecosystem introduced by dynamic arrays in Excel, injecting life into the jaded, stale world of financial modelling.

see more products »

Excel 2024: Excel Stories

More Reading

Featured Products