Apply Conditional Formatting to Multiple Cells with a Single Formula in Excel
Apply Conditional Formatting to Multiple Cells with a Single Formula in Excel Excel tutorial for conditional formatting that shows you[…]
Read more
Tag: excel2020
Add a Row after Every Row using Excel’s SORT
Excel Tutorial 2020 In this tutorial, we will learn about Add a row after every row using Excel’s SORT.
Read more
Excel’s Filter can give you wrong answers!
Excel Tutorial 2020
Read more
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
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