Formulas are THE MOST IMPORTANT EXCEL SKILL you can master. In this lesson I cover some little known Excel formula writing tips, tricks and tools that’ll give you ninja level skills and enable you to decipher any formula. Even ones you haven’t written yourself.
An Excel Named Range is a powerful tool and something we should all be using to make our formulas quick and easy to write and read.
How much time do you spend editing the ranges referenced in your formulas because you’ve added new data to your source?
0:22 Cell Reference Best Practice
2:55 Formula Structure
4:55 Formula Constants
6:30 Formula Navigating tips
8:06 F9 Formula Evaluating
8:54 Evaluate Formula Tool