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

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

Guerrilla Data Analysis Using Microsoft Excel - 3rd Edition

May 2022

Two of the leading Excel channels on YouTube join forces to combat bad data. This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These are tips honed by Bill Jelen, "MrExcel," and Oz do Soleil during their careers run as financial analysts.

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.

see more products »

Excel 2024: Excel Stories

More Reading

Featured Products