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
Formatting
Formatting
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 learn how to set up and validate common useful departmental spreadsheets and protect them from unwanted alterations.
6 Lessons
Simple QLA
Conditional cell rules
Data Validation
Filtering data
Locking and protecting sheets
Your Turn - Examples