Excel Tips
Excel 2024: Create Your First Pivot Table »
May 2, 2024
Pivot tables let you summarize tabular data to a one-page summary in a few clicks. Start with a data set that has headings in row 1. It should have no blank rows, blank columns, blank headings or merged cells.
Excel 2024: Consolidate Quarterly Worksheets »
April 30, 2024
There are two ancient consolidation tools in Excel. To understand them, say that you have three data sets. Each has names down the left side and months across the top. Notice that the names are different, and each data set has a different number of months.
Excel 2024: Sort and Filter by Color or Icon »
April 29, 2024
Conditional formatting got a lot of new features, including icon sets and more than three levels of rules. This allows for some pretty interesting formatting over a large range. But once you format the cells, you might want to quickly see all the ones that are formatted a particular way.
April 24, 2024
For those of you who have never used subtotals, here is how to set them up.
Excel 2024: Sort Left to Right »
April 22, 2024
Every day, your IT department sends you a file with the columns in the wrong sequence. It would take them two minutes to change the query, but they have a six-month backlog, so you are stuck rearranging the columns every day.
Excel 2024: Sort East, Central, and West Using a Custom List »
April 19, 2024
At my last day job, we had three sales regions: East, Central, and West. The company headquarters was in the East, and so the rule was that all reports were sorted with the East region first, then Central, then West. Well, there is no way to do this with a normal sort.
Excel 2024: Set Up Your Data for Data Analysis »
April 17, 2024
Make sure to follow these rules when you set up your data for sorting, subtotals, filtering and pivot tables.
Excel 2024: Place Pictures In Cell From Local Computer »
April 15, 2024
For the last 30 years, you could use Insert, Picture in Excel. The image was added to a special drawing layer that floated above the grid. In June of 2023, that legacy experience became known as Place Over Cells. The new experience is to Place In Cell.
Excel 2024: Display Online Pictures In a Cell Using a Formula »
April 12, 2024
The IMAGE function debuted in August 2022. It is only for online images that are available through a URL.