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
Nested IF
Averages and range
XLookup Grade Boundaries
VLookup Grade Boundaries
Index-Match Grade Boundaries
Your Turn - Examples
Formatting
Simple QLA
Conditional cell rules
Data Validation
Filtering data
Locking and protecting sheets
Your Turn - Examples
Summary
Exit Video
Examples - All
Products
Course
Section
Lesson
Your Turn - Examples
Your Turn - Examples
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
Nested IF
Averages and range
XLookup Grade Boundaries
VLookup Grade Boundaries
Index-Match Grade Boundaries
Your Turn - Examples
Formatting
Simple QLA
Conditional cell rules
Data Validation
Filtering data
Locking and protecting sheets
Your Turn - Examples
Summary
Exit Video
Examples - All
Lesson unavailable
Please
login to your account
or
buy the course
.