top of page
Search

Formula Auditing - Excel

ree

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!





Recent Posts

See All
Another Thought On Growth

One of my first projects when I joined Broadband Catalysts was to figure out how to query a very large and complicated BigQuery dataset. I made some progress but not near enough. I was incredibly worr

 
 
 
Today I Learned - 11/12/15

Today I learned you can drag and drop colors in QGIS in the symbology options. I've been using this program for over a year and a half. Still learning neat tricks. Is it possible I've heard this befor

 
 
 
Map Academy - Exploring Data

Today I watched Map Academy's video - Explore and think BEFORE you map! while waiting for some ✨magical computer processing✨ to happen. It was a great reminder of the importance of exploring, verifyi

 
 
 

Comments

© 2023 by Julia Byers

  • LinkedIn

Powered and secured by Wix

bottom of page