Before we dig into Modern Excel, can you please help me out? What, exactly, is “Modern Excel”? I can’t find a standard definition on the Microsoft site, or anywhere else!
Continue reading “Do Your Excel Files Collapse Like Jenga Blocks?”
Category: Excel Formulas
How to Get Started With Excel FILTER Function
In the video below, I show how to get started with the Excel FILTER function, which is available in Office 365.
You can enter a formula in one cell, and the results spill down onto the worksheet, to show all the results. And unlike other filters in Excel, the FILTER result list will update automatically, if you change the criteria.
Continue reading “How to Get Started With Excel FILTER Function”
Compare List of Numbers With Excel RANK Function
Which student got the top score? If you have test results, or another list of numbers in Excel, you could sort them to see which scores are at the top. But if you want to leave the list in alphabetical order, you can use the RANK function to show the rank for each score.
Continue reading “Compare List of Numbers With Excel RANK Function”
Excel Easter Eggs and Hidden Treasures
In the olden days of computing, some programs, including Excel, had hidden features called Easter eggs, so here’s a quiz for you.
Combine Excel Text with Conditions – TEXTJOIN Function
To quickly combine text and numbers from multiple cells in Excel, use the TEXTJOIN Excel function.
I’ll show you two examples, and you can scroll down to watch the video demo. Continue reading “Combine Excel Text with Conditions – TEXTJOIN Function”
Get This Excel Advent Calendar With No Macros
December is only 3 days away, so it’s time for an Excel Advent Calendar! I’ve made a new version this year, and it doesn’t use macros, just basic Excel features. Even if you don’t need an Advent calendar, take a look to see how the calendar is set up. It might give you ideas for other types of Excel projects.
Continue reading “Get This Excel Advent Calendar With No Macros”
Which Excel Lookup Functions Do You Use Most Often?
I’ve got an Excel lookup functions question for you, in the quick poll below. And I’ve got some breaking news for you too!
Continue reading “Which Excel Lookup Functions Do You Use Most Often?”
Troubleshoot Excel Formulas with ERROR.TYPE Function
Did you know that you can use the Excel ERROR.TYPE function to identify specific types of errors on a worksheet? And after the error type is identified, you can use that information to provide help with error troubleshooting.
There’s a short video below, that shows an example, and there’s a list of the Excel error values that this function can identify.
Continue reading “Troubleshoot Excel Formulas with ERROR.TYPE Function”
Excel Text in Multiple Rows – No Merged Cells
I add lots of screen shots to my Excel tutorials, so it’s easier to follow the steps. And if I’m explaining a formula, it’s helpful to show that on the worksheet too.
However, some Excel formulas can get pretty long, and I found a way to fix that problem! You can see all the solutions that I tried, or skip to the end, to see the final solution.
Continue reading “Excel Text in Multiple Rows – No Merged Cells”
How to Sum Filtered Excel Data – AGGREGATE or SUBTOTAL
When an Excel list is filtered, how can you show a total sum or count for numbers in the visible rows only? There are two Excel functions for that task — SUBTOTAL (all Excel versions) and AGGREGATE (Excel 2010 and later). See how these functions work, and decide which one to use.
Continue reading “How to Sum Filtered Excel Data – AGGREGATE or SUBTOTAL”