VR SCHOOL
ONLINE
Nexus Home
Course Catalog
Meta-Campus
Status
Enter The Nexus
Home
Courses
Mastering Formulas and Functions
Curriculum
5 Sections
23 Lessons
10 Weeks
Expand all sections
Collapse all sections
Chapter 6: Leveraging Lookup Formulas
5
1.1
Navigating with VLOOKUP
10 mins
1.2
Hoisting HLOOKUP
10 mins
1.3
Exploring MATCH and INDEX
10 mins
1.4
Cruising with XLOOKUP
10 mins
1.5
Troubleshooting Lookup Formulas
10 mins
Chapter 7: Transforming Text and Numbers
5
2.1
Reworking Text without Retyping
10 mins
2.2
Extracting or Splitting Text
10 mins
2.3
Combining LEFT and FIND
10 mins
2.4
Tinkering with TEXTBEFORE and TEXTAFTER
10 mins
2.5
Swapping out Text and Formulas
10 mins
Chapter 8: Harnessing Logic Functions
4
3.1
Making Basic Formulaic Decisions
10 mins
3.2
Handling Error Values
10 mins
3.3
Evaluating Data Based upon Criteria
10 mins
3.4
Refining Advanced Formulaic Decisions
10 mins
Chapter 9: Carving Data with Dynamic Arrays
2
4.1
Sifting Through Data Dynamically
10 mins
4.2
Managing Spilled Ranges
10 mins
Chapter 10: Tracing and Debugging Formulas
7
5.1
Tracking Precedent and Dependent Cells
10 mins
5.2
Evaluating Formulas
10 mins
5.3
Revealing Formula Underpinnings
10 mins
5.4
Investigating Issues with Error Checking
10 mins
5.5
Cleaning Up Circular References
10 mins
5.6
Monitoring Changes via the Watch Window
10 mins
5.7
Controlling When Excel Calculates
10 mins
This content is protected, please
login
and
enroll
in the course to view this content!
Modal title
Main Content