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
Category: Excel
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 more
Easily 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 more
SUM 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 more
Excel – 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