Formula Auditing - Excel

Today I began the course "Microsoft Excel: Formulas & Functions" from Maven Analytics. This is one of those I thought I might not need to go through, but I'm one section in and already learning something new, so I'm glad I'm not skipping anything!

One of the first things touched on after references and error types is Formula Auditing. I had no idea that existed! I can see how it would be really useful to be able to trace the formulas upstream and downstream or to show all your formulas as text.

I'm also learning new keyboard shortcuts, such as:

• CTRL + G

• CTRL + [

• CTRL + ]

I haven't finished all the Formula Auditing lessons yet, and there's more with shortcuts, but I couldn't wait to share what I'm learning!