Text to Columns | String Manipulation | Efficient use of Excel | Products | Complete Mathematics

Text to Columns

Text to Columns

In this video we demonstrate how to split a single column of text into multiple columns.

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