Get a Free Library as you Learn Excel cPower Query Tricks
Excel Training You can create your own free video library with Power Query Custom Data Types. You’ll learn about Excel[…]
Read more
Author: Noel
How to Create a Straight Line Depreciation Schedule in Excel
Excel Training I demonstrate how to create a straight-line depreciation schedule in Excel. Straight-line depreciation assumes your asset depreciates by[…]
Read more
Easily Unlock Protected Excel Sheets Without Password
Excel Training Did you ever forget a password for one of your protected Excel sheets? In this video I’ll show[…]
Read more
SUM and COUNT Visible Cells Only | Exclude Hidden Cells
Excel Training I demonstrate how to sum and count filtered data. If you want to exclude hidden cells from your[…]
Read more
Excel – IF Date is Before or After Another Date | IF Date is Before or After Today
Excel Training , I demonstrate how to use dates within an IF formula. I want to be able to compare[…]
Read more