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
Introduction
Introduction
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
This course will demonstrate some of the most useful features and functions of Excel to save you time when creating and maintaining individual teacher markbooks or departmental spreadsheets.
1 Lesson
1.0 Introduction