Using the IF function
Using the IF function
Efficient use of Excel
Buy now
Learn more
Introduction
1.0 Introduction
String Manipulation
Text to Columns
Concatenate
Upper, Proper, Lower
Summary of case functions
Left, Mid, Right
String Manipulation - Example
Your Turn - Examples
Data Analysis
CountIf
Count - Summary
Using the IF function
1
Nested IF
Averages and range
XLookup Grade Boundaries
1
VLookup Grade Boundaries
Index-Match Grade Boundaries
Your Turn - Examples
Formatting
Simple QLA
Conditional cell rules
Data Validation
Filtering data
1
Locking and protecting sheets
Your Turn - Examples
Summary
Exit Video
1
Examples - All
1
Preview unavailable
You must log in or sign up to view this lesson.
Login
Sign up
Efficient use of Excel
Buy now
Learn more
Introduction
1.0 Introduction
String Manipulation
Text to Columns
Concatenate
Upper, Proper, Lower
Summary of case functions
Left, Mid, Right
String Manipulation - Example
Your Turn - Examples
Data Analysis
CountIf
Count - Summary
Using the IF function
1
Nested IF
Averages and range
XLookup Grade Boundaries
1
VLookup Grade Boundaries
Index-Match Grade Boundaries
Your Turn - Examples
Formatting
Simple QLA
Conditional cell rules
Data Validation
Filtering data
1
Locking and protecting sheets
Your Turn - Examples
Summary
Exit Video
1
Examples - All
1