Two Excel Dynamic Array Functions: UNIQUE and SORT
Microsoft Excel Tips and Tricks Learn how to use two of the dynamic array functions that are in Microsoft 365:[…]
Read more
Category: Excel
Create an Excel Macro that Highlights Rows
Microsoft Excel Tips and Tricks Learn how to create a VBA Excel Macro that will highlight every other row of[…]
Read more
Using Excel’s XLOOKUP Function
Microsoft Excel Tips and Tricks Learn how to use the fairly new and fantastic XLOOKUP function in Microsoft Excel. XLOOKUP[…]
Read moreHow to Fix an Excel Table that’s Slow to Scroll or Respond
Microsoft Excel Tips and Tricks In this video, I demonstrate how to resolve a performance issue caused by whole column[…]
Read moreDo You Need to Switch from Excel VBA Macros to Office Scripts?
Microsoft Excel Tips and Tricks For decades Excel VBA Macros has been the best choice for automation topics in Excel.[…]
Read moreHow to Add Months to or Subtract Months From a Date in Excel
Microsoft Excel Tips and Tricks I demonstrate how to add or subtract months to or from a date in Excel.[…]
Read moreSecondary Axis Chart in Excel | Graph with Two Y Axis in Excel | Custom Combo Chart
Microsoft Excel Tips and Tricks I demonstrate how to create a chart with a secondary axis. A secondary vertical y[…]
Read more
Secrets to Building Excel Dashboards based on Non-financial Data
Microsoft Excel Tips and Tricks How to build Excel Dashboards based on non-financial data. Credit MyOnlineTrainingHub
Read moreHow to Import Emails from Outlook to Excel
Microsoft Excel Tips and Tricks I’ll show you how to get data from Outlook into Excel. This way you can[…]
Read moreEnhance your Checkboxes & to-do Lists with conditional Formatting in Excel
Microsoft Excel Tips and Tricks I demonstrate how to improve your Excel checklists by using conditional formatting. When a box[…]
Read moreHow to Transfer Data from one Worksheet to another Automatically in Excel Using VBA Macro
Microsoft Excel Tips and Tricks I demonstrate how to automatically transfer data from one worksheet to another using a VBA[…]
Read more
Convert or Transfer Data in Word into Excel Worksheet
Microsoft Excel Tips and Tricks I demonstrate how to transfer data held in a Microsoft Word document into an Excel[…]
Read more
Excel Remove Indentation on Multiple Cells at Different Levels
Microsoft Excel Tips and Tricks In this video, I demonstrate how to remove indentation on a group of cells, even[…]
Read moreHow to Split Cells & Text in Excel with Power Query
Microsoft Excel Tips and Tricks In this video, I demonstrate how to split cells in Excel, such as first and[…]
Read more
How to Send Emails from Excel with Attachments | Mail Merge the Smart Way!
Microsoft Excel Tips and Tricks In this tutorial I’ll show you how you can do a mail merge with pdf[…]
Read more