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
Category: Excel
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
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