November 21, 2024 - by Bill Jelen
This is a feature that does deserve to be in this book. I am putting it in the book to warn you about the feature. Next to all of the great Power Query features is a drop-down for Data From Picture. The concept - use your phone to take a picture of a receipt. Then, copy the image, use Picture From Clipboard and Excel can insert data from the picture into Excel.
Excel 2024: Use Fuzzy Match in Power Query »
November 18, 2024 - by Bill Jelen
There's a research and development team at Microsoft known as Microsoft Labs. Almost 10 years ago, it invented a free Fuzzy Match add-in for Excel. A fuzzy matching algorithm looks for words that share a percentage of characters in common.
Excel 2024: Clean Data with Power Query »
November 14, 2024 - by Bill Jelen
Power Query is built in to Windows versions of Office 365, Excel 2016, Excel 2019 and is available as a free download in Windows versions of Excel 2010 and Excel 2013. The tool is designed to extract, transform, and load data into Excel from a variety of sources.
Excel 2024: Improve Your Macro Recording »
November 11, 2024 - by Bill Jelen
I loved the 1985 version of the Macro Recorder in Lotus 1-2-3. The code was hard to understand, but it worked. There are some defaults in the Excel Macro Recorder that cause misery for anyone trying to record macros. Here are three tips to make the macro experience possibly better.
April 2022
The 6th Edition of MrExcel XL, updated with new functions released for Microsoft 365.
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!
Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)
December 2021
Use Microsoft 365 Excel and Excel 2021 pivot tables and pivot charts to produce powerful, dynamic reports in minutes: take control of your data and your business!
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.