Excel Tips
Excel 2024: Prevent Default Conversions »
January 3, 2025
Since the beginning of time, Excel has performed some annoying conversions. The conversions happened automatically when you imported from a CSV or Text file, Pasted from another application, or typed data in Excel.
December 31, 2024
In late 2023, Microsoft added a checkbox icon to the Insert tab. As I write this in January 2024, the feature is still in beta. Adding a checkbox to a cell seems to be a special number format that displays True/False values as either checked boxes or unchecked boxes.
Excel 2024: New Scrolling Tricks »
December 25, 2024
Excel now offers horizontal scrolling and smooth scrolling. Smooth scrolling is a popular improvement, particularly for people who store a lot of text in a cell.
Excel 2024: Use the Windows Magnifier »
December 23, 2024
Someone always asks how to use Windows Magnifier on my live Power Excel seminars, so I will write up the key steps.
Excel 2024: Surveys & Forms in Excel »
December 17, 2024
I often start my live Excel seminars off by asking you to point your cell phone camera at a giant bar code I have projected on the screen. That QR code leads to a three-question survey. Answers automatically flow into my Excel worksheet and those answers get used in the afternoon demo of 3D Maps.
Excel 2024: Format as a Façade »
December 13, 2024
Excel is amazing at storing one number and presenting another number. Choose any cell and select Currency format. Excel adds a dollar sign and a comma and presents the number, rounded to two decimal places.
December 9, 2024
Excel 2013 added a new data-cleansing tool called Flash Fill.
Excel 2024: Build Org Charts with the Visio Data Visualizer in Excel »
December 5, 2024
Most people with Microsoft 365 will have a new Visio Data Visualizer tool in Excel. It is found on the Insert tab, in the Add-Ins group.
Excel 2024: Perform Sentiment Analysis in Excel »
December 2, 2024
It is easy to quantify survey data when it is multiple choice: You use a pivot table to figure out the percentage for each answer. But what about free-form text answers? These are hard to process if you have hundreds or thousands of them.