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

CountIf

Lesson unavailable

Please login to your account or buy the course.