Excel 3D Formulas
Excel 3D Formulas Learn how to create a 3D formula in Excel, a formula that pulls data from the same[…]
Read more
Tag: excel2020
NOT() Function in Excel – Reversing True/False
Excel Tips and Tricks NOT() Function in Excel – Reversing True/False Credit TeachExcel
Read more
IF() Statement in Excel for Beginners
Excel Tips and Tricks How to use the IF() statement function for Excel – this is a tutorial for the[…]
Read more
Advanced Excel Analysis Tip: Highlight Sort and Group the Top / Bottom Performers in a List in Excel
Excel Tips and Tricks Better analyze data in Excel by learning how to highlight and organize the data so that[…]
Read more
50 Ultimate Excel Tips and Tricks for 2020
Excel Tips and Tricks The ultimate compilation of Excel tips and tricks to enhance your productivity using Excel. Updated for[…]
Read more
Excel Dynamic Array Formulas
Excel Tips and Tricks In January 2020 Microsoft released Dynamic Array Formulas for Excel. I’ll show you the six new[…]
Read more
New Excel Linked Data Types!
Excel Tips and Tricks A number of new Linked Data Types are available in Excel. Data Types are external data[…]
Read more