Pro Formula Writing Tips EVERY Excel User MUST Know

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.

Excel Named Range Shortcut

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.

https://www.myonlinetraininghub.com/excel-named-range-shortcut

Excel Dynamic Named Ranges

How much time do you spend editing the ranges referenced in your formulas because you’ve added new data to your source?

https://www.myonlinetraininghub.com/excel-dynamic-named-ranges

In this video

0:00 Introduction

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