Top 10 Microsoft Excel Keyboard Shortcuts in 1 minute
Microsoft Excel Tips and Tricks This 1 minute video will show you my top 10 Microsoft Excel keyboard shortcuts in[…]
Read moreTag: excel
Get a Free Library as you Learn Excel Power Query Tricks
Microsoft Excel Tips and Tricks You can create your own free video library with Power Query Custom Data Types. You’ll[…]
Read more
How to Create a Straight Line Depreciation Schedule in Excel
Microsoft Excel Tips and Tricks I demonstrate how to create a straight-line depreciation schedule in Excel. Straight-line depreciation assumes your[…]
Read moreEasily Unlock Protected Excel Sheets Without Password
Microsoft Excel Tips and Tricks Did you ever forget a password for one of your protected Excel sheets? In this[…]
Read moreSUM and COUNT Visible Cells Only | Exclude Hidden Cells
Microsoft Excel Tips and Tricks I demonstrate how to sum and count filtered data. If you want to exclude hidden[…]
Read moreExcel – IF Date is Before or After Another Date | IF Date is Before or After Today
Microsoft Excel Tips and Tricks , I demonstrate how to use dates within an IF formula. I want to be[…]
Read more
How to Add Text to the Beginning and End of a Cell in Excel – 3 Methods
Microsoft Excel Tips and Tricks I demonstrate how to add text to the beginning and/or end of a cell or[…]
Read moreExcel Spilled Results and Fixing the SPILL! Error
Microsoft Excel Tips and Tricks Learn how Excel can now “spill” results of formulas in Microsoft 365 versions of Excel.[…]
Read moreExcel Dynamic Dependent Drop-down Lists for Entire Column – No Complicated Formulas Required
Microsoft Excel Tips and Tricks I demonstrate how to create dependent drop-down lists in Microsoft Excel. A dependent drop-down list[…]
Read more
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
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 more