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
Tag: msexcel
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
Two Excel Dynamic Array Functions: UNIQUE and SORT
Excel Training Learn how to use two of the dynamic array functions that are in Microsoft 365: the UNIQUE function[…]
Read more
Create an Excel Macro that Highlights Rows
Excel Training Learn how to create a VBA Excel Macro that will highlight every other row of whatever area of[…]
Read more