Microsoft Excel Tips and Tricks This 1 minute video will show you my top 10 Microsoft Excel keyboard shortcuts in[…]
Read moreCategory: 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
Handling HTTP Errors in Power Query and Power BI
Excel Tips & Tricks Create your own custom error messages to help users know how to troubleshoot and fix errors[…]
Read more
Get a Free Library as you Learn Excel Power Query Tricks (Custom data types, Hyperlink data type!)
Excel Tips & Tricks You can create your own free video library with Power Query Custom Data Types. You’ll learn[…]
Read more
Properly Create Surveys with Microsoft Forms & Export to Excel
Excel Tips & Tricks With Microsoft Forms you can collect data from different people with fillable forms you can control[…]
Read moreHow to use Excel Index Match (the right way)
Excel Tips & Tricks How to do Index Match in Excel: The basics. Watch this video tutorial to find out[…]
Read morePivotTables – Set Default Layouts & Formatting and SAVE TIME!
Excel Tips & Tricks Tired of changing the layout of each new PivotTable? With default PivotTable layouts you can eliminate[…]
Read moreIcons you SHOULD have in your Excel Quick Access Toolbar
Excel Tips & Tricks Th QAT is Excel’s Prime Real Estate – the first 9 positions are extra special and[…]
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