1.0 Introduction | Introduction | Efficient use of Excel | Products | Complete Mathematics

1.0 Introduction

1.0 Introduction

In this video we give a brief introduction to the Efficient use of Excel course.

Efficient use of Excel

Buy nowLearn 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 function1

Nested IF

Averages and range

XLookup Grade Boundaries1

VLookup Grade Boundaries

Index-Match Grade Boundaries

Your Turn - Examples

Formatting

Simple QLA

Conditional cell rules

Data Validation

Filtering data1

Locking and protecting sheets

Your Turn - Examples

Summary

Exit Video1

Examples - All1