Excel Formula Auditing Tracing and Other Basics
Channel: DataResearchLabs
Date: 2021-01-19

Excel Formula Auditing Tracing and Other Basics

This Quick Trainer video walks you thru Excel's formulas, not to be confused with functions.  You will learn what formulas are and why you should use them (hint: automation, repeatability, and visualization).  You will learn about math operators (addition, subtraction, multiplication, division, exponents, and parentheses).  You will learn about Cell Ranges like "A1:C2" and Absolute vs. Relative Cell References.  You will learn about Formula Auditing and Error Tracing to troubleshoot spreadsheet calculation issues.  You will learn about Named Cells and Calculation Options too.


------- Chapter Timestamps (click to jump forward): -----------------------------
 0:00 - Intro
 0:21 - What are Formulas?
 4:34 - Why Should I Use Formulas?
 5:42 - Math Operators
 7:53 - Cell Ranges
10:44 - Relative vs. Absolute Cell References
13:06 - Formula Auditing & Error Tracing
18:01 - Named Cells
21:29 - Calculation Options
22:18 - The End


Watch related playlist videos: 
- XL#1 Basic Excel:  https://www.youtube.com/playlist?list=PLVHoUDdbskUQXl0S6nS2QUMB69rrf1zcF
- XL#2 Advanced Excel:  https://www.youtube.com/playlist?list=PLVHoUDdbskUTHC-HjacbwcUFhA4itl3AP


Connect with me on social media:
- LinkedIn:  https://www.linkedin.com/in/mpiercead576/
- YouTube:  https://www.youtube.com/channel/UCQciXv3xaBykeUFc04GxSXA
- GitHub:  https://github.com/DataResearchLabs


Subscribe to my YouTube Channel:
- https://www.youtube.com/channel/UCQciXv3xaBykeUFc04GxSXA?sub_confirmation=1


Background Music:
- None


#XL #Excel #ExcelTutorial