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).

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.

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.

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!

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.

see more products »

Excel 2024: Excel Stories

More Reading

Featured Products