Skip to content
Home
Programs
Close Programs
Open Programs
Cybersecurity
Courses
Community
News
Knowledgebase
GIS
Courses
Community
News
Knowledgebase
Agile Methodologies
Courses
Community
News
Knowledgebase
Catalog
About
News
Contact Us
Login
Sign Up
Login
Sign Up
Login
Sign Up
Home
All Programs
Computers
Certification Guides
Microsoft
Mastering Formulas and Functions
Mastering Formulas and Functions
Curriculum
5 Sections
23 Lessons
Lifetime
Expand all sections
Collapse all sections
Chapter 6: Leveraging Lookup Formulas
10
1.1
Navigating with VLOOKUP
1.1
Quiz for Navigating with VLOOKUP
5 Questions
1.2
Hoisting HLOOKUP
1.2
Quiz for Hoisting HLOOKUP
5 Questions
1.3
Exploring MATCH and INDEX
1.3
Quiz for Exploring MATCH and INDEX
6 Questions
1.4
Cruising with XLOOKUP
1.4
Quiz for Cruising with XLOOKUP
8 Questions
1.5
Troubleshooting Lookup Formulas
1.5
Quiz for Troubleshooting Lookup Formulas
7 Questions
Chapter 7: Transforming Text and Numbers
10
2.1
Reworking Text without Retyping
2.1
Quiz for Reworking Text without Retyping
8 Questions
2.2
Extracting or Splitting Text
2.2
Quiz for Extracting or Splitting Text
6 Questions
2.3
Combining LEFT and FIND
2.3
Quiz for Combining LEFT and FIND
7 Questions
2.4
Tinkering with TEXTBEFORE and TEXTAFTER
2.4
Quiz for Tinkering with TEXTBEFORE and TEXTAFTER
5 Questions
2.5
Swapping out Text and Formulas
2.5
Quiz for Swapping out Text and Formulas
7 Questions
Chapter 8: Harnessing Logic Functions
8
3.1
Making Basic Formulaic Decisions
3.1
Quiz for Making Basic Formulaic Decisions
7 Questions
3.2
Handling Error Values
3.2
Quiz for Handling Error Values
5 Questions
3.3
Evaluating Data Based upon Criteria
3.3
Quiz for Evaluating Data Based upon Criteria
7 Questions
3.4
Refining Advanced Formulaic Decisions
3.4
Quiz for Refining Advanced Formulaic Decisions
6 Questions
Chapter 9: Carving Data with Dynamic Arrays
4
4.1
Sifting Through Data Dynamically
4.1
Quiz for Sifting Through Data Dynamically
7 Questions
4.2
Managing Spilled Ranges
4.2
Quiz for Managing Spilled Ranges
7 Questions
Chapter 10: Tracing and Debugging Formulas
14
5.1
Tracking Precedent and Dependent Cells
5.1
Quiz for Tracking Precedent and Dependent Cells
6 Questions
5.2
Evaluating Formulas
5.2
Quiz for Evaluating Formulas
6 Questions
5.3
Revealing Formula Underpinnings
5.3
Quiz for Revealing Formula Underpinnings
7 Questions
5.4
Investigating Issues with Error Checking
5.4
Quiz for Investigating Issues with Error Checking
5 Questions
5.5
Cleaning Up Circular References
5.5
Quiz for Cleaning Up Circular References
5 Questions
5.6
Monitoring Changes via the Watch Window
5.6
Quiz for Monitoring Changes via the Watch Window
6 Questions
5.7
Controlling When Excel Calculates
5.7
Quiz for Controlling When Excel Calculates
5 Questions
This content is protected, please
login
and
enroll
in the course to view this content!
Login
or
Sign Up
Home
Programs
Close Programs
Open Programs
Cybersecurity
Courses
Community
News
Knowledgebase
GIS
Courses
Community
News
Knowledgebase
Agile Methodologies
Courses
Community
News
Knowledgebase
Cybersecurity
Courses
Community
News
Knowledgebase
Catalog
About
News
Contact Us
Linkedin
Instagram
Modal title
Main Content
