Excel tips and tutorials
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”
In your job, are there Excel tasks that need to be done at month end? Here’s how I use a hidden hyperlink to help with my month end routine. Continue reading “Hide Excel Hyperlink-Show Monthly-Conditional Format”
In our everyday life, the words Merge and Combine have almost the same meaning. However, when you’re working in Microsoft Excel, there are important differences in their meanings!
Continue reading “Should You Merge Cells or Combine Text in Excel”
Do you ever need to compare two lists in Excel, and see if there are some items in one list, that aren’t in the other list? The video below shows how to check for new items, and only add those to your existing list. You don’t want to have a list that’s full of duplicates entries!
Continue reading “How to Compare Two Lists in Excel-New Items”
What’s your favourite way to troubleshoot Excel formulas? Here are a few tips for current versions of Excel, and a preview of new features that are coming soon, for Excel 365.
Continue reading “Excel Formula Troubleshooting Tips and Tools”
Create a monthly Excel calendar, based on a few short formulas. Next, add formatting and a heading, and if you’re feeling fancy, show a list of the month’s holidays too! This example uses functions that are available in Excel 365, and in Excel for the Web.
Continue reading “Create Excel Monthly Calendar From 6 Formula Cells”
Do you ever use Excel to calculate a ratio? In business, you could compare income to expenses, and at home, you could use ratios to bake a cake, without a recipe. In my latest video, I show a quick Excel formula for the ratio between two numbers, in x:y format. And no, Excel doesn’t have a RATIO function, even though one overly-confident AI helper tool said it does!
Continue reading “Calculate Ratio with Excel Formula – 3 Steps”
Happy Groundhog Day! Have you made plans that you’ll be happy to repeat, day after day? Maybe these Excel REPT function examples will give you some ideas! There are written steps, screen shots, and 3 videos below.
Continue reading “Excel REPT Function Examples Groundhog Day”
Have you played with the ChatGPT app yet, to get AI help with your writing, or your Excel formulas? Yesterday, I asked it to write Excel TEXTJOIN formula examples, and things didn’t go too well!
Continue reading “Excel TEXTJOIN Function Bad Examples from ChatGPT”
If you had to split a text string into separate columns in Excel, how would you do that? There are built-in tools that could help you, and Excel functions and formulas will do the job too. If your version of Excel has the latest functions and features, there are fancy new text functions for you to try.
Continue reading “Split Text Into Columns in Excel-Get Specific Column”
