March 13, 2026 - by Bill Jelen
Use the Hank’s Pizza dataset to prove whether the $1 slice can work. Build your best analysis using Excel, AI, or both.
In case you haven’t seen it, there is a new Microsoft Excel commercial running on TV:
Excel: How Can I Add or Subtract Days, Months, or Years from a Date? »
March 9, 2026
I heard that date math in Excel is easy! How so?
Excel: How Can I Combine a Date with Words in a Cell, and Make It Look like a Date? »
March 6, 2026
How can I combine a date with text in Excel, and have it appear as a date?
Excel: How Can I Set up Dates to Display the Way I Want after Importing? »
March 4, 2026
I imported some dates and they are all showing up as 23-Jan-2015. Can I display the dates as 1/23/2015?
Power BI for the Excel Data Analyst
July 2022
A step-by-step guide on how to use Power BI. Written with Excel fans in mind, but with every Power BI student at its heart.
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.
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...
July 2025
Whether you're just starting out or you're the office Excel wizard, MrExcel 2024 Navigating Excel is your all-in-one field guide to mastering Microsoft Excel’s newest and most powerful features.
