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
Tag: Excel
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
Using Excel’s XLOOKUP Function
Excel Training Learn how to use the fairly new and fantastic XLOOKUP function in Microsoft Excel. XLOOKUP replaces the VLOOKUP[…]
Read more