Skip to content
info@sejal-learn.com
Instagram
X-twitter
Youtube
Linkedin
Facebook
Login
Sign Up
info@sejal-learn.com
Instagram
X-twitter
Youtube
Linkedin
Facebook
Login
Sign Up
Course Catalog
About
Contact Us
Home
All Programs
Computers
Certification Guides
Microsoft
Mastering Formulas and Functions
Mastering Formulas and Functions
Curriculum
5 Sections
23 Lessons
10 Weeks
Expand all sections
Collapse all sections
Chapter 6: Leveraging Lookup Formulas
10
1.1
Navigating with VLOOKUP
1.2
Quiz for Navigating with VLOOKUP
5 Questions
1.3
Hoisting HLOOKUP
1.4
Quiz for Hoisting HLOOKUP
5 Questions
1.5
Exploring MATCH and INDEX
1.6
Quiz for Exploring MATCH and INDEX
6 Questions
1.7
Cruising with XLOOKUP
1.8
Quiz for Cruising with XLOOKUP
8 Questions
1.9
Troubleshooting Lookup Formulas
1.10
Quiz for Troubleshooting Lookup Formulas
7 Questions
Chapter 7: Transforming Text and Numbers
10
2.1
Reworking Text without Retyping
2.2
Quiz for Reworking Text without Retyping
8 Questions
2.3
Extracting or Splitting Text
2.4
Quiz for Extracting or Splitting Text
6 Questions
2.5
Combining LEFT and FIND
2.6
Quiz for Combining LEFT and FIND
7 Questions
2.7
Tinkering with TEXTBEFORE and TEXTAFTER
2.8
Quiz for Tinkering with TEXTBEFORE and TEXTAFTER
5 Questions
2.9
Swapping out Text and Formulas
2.10
Quiz for Swapping out Text and Formulas
7 Questions
Chapter 8: Harnessing Logic Functions
8
3.1
Making Basic Formulaic Decisions
3.2
Quiz for Making Basic Formulaic Decisions
7 Questions
3.3
Handling Error Values
3.4
Quiz for Handling Error Values
5 Questions
3.5
Evaluating Data Based upon Criteria
3.6
Quiz for Evaluating Data Based upon Criteria
7 Questions
3.7
Refining Advanced Formulaic Decisions
3.8
Quiz for Refining Advanced Formulaic Decisions
6 Questions
Chapter 9: Carving Data with Dynamic Arrays
4
4.1
Sifting Through Data Dynamically
4.2
Quiz for Sifting Through Data Dynamically
7 Questions
4.3
Managing Spilled Ranges
4.4
Quiz for Managing Spilled Ranges
7 Questions
Chapter 10: Tracing and Debugging Formulas
14
5.1
Tracking Precedent and Dependent Cells
5.2
Quiz for Tracking Precedent and Dependent Cells
6 Questions
5.3
Evaluating Formulas
5.4
Quiz for Evaluating Formulas
6 Questions
5.5
Revealing Formula Underpinnings
5.6
Quiz for Revealing Formula Underpinnings
7 Questions
5.7
Investigating Issues with Error Checking
5.8
Quiz for Investigating Issues with Error Checking
5 Questions
5.9
Cleaning Up Circular References
5.10
Quiz for Cleaning Up Circular References
5 Questions
5.11
Monitoring Changes via the Watch Window
5.12
Quiz for Monitoring Changes via the Watch Window
6 Questions
5.13
Controlling When Excel Calculates
5.14
Quiz for Controlling When Excel Calculates
5 Questions
This content is protected, please
login
and
enroll
in the course to view this content!
Your Journey Starts Here
Course Catalog
About
Contact Us
Login/Sign Up
Modal title
Main Content
