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
Data Analysis
Data Analysis
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
In this section of the course we look at some useful functions in Excel to efficiently analyse data.
9 Lessons
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