Preview Complimentary Data Management Program

Automatically Fill Data with Auto Fill

Convert sequential dates to same date using smart tag

Practice File

Incrementing time by one hour

Practice File

Data Visualization with Conditional Formatting basics

Text That Contains

Practice File

Duplicate values

Practice File

Filter Data Like Pro with Advanced Filter

Single criterion

Practice file

And criterion

Practice file

Learn to Write Complex Formulas with Excel Functions

VLOOKUP vs INDEX & MATCH

Practice File

Result column is on the left

Practice File

Speed Up Data Entry with Flash Fill

1 Split first and last names

Practice File

2 Concatenate first and last names

Practice File

Let's Learn Some Data Cleaning Techniques

Remove spaces using TRIM

Practice file

Using LEN Function

Practice file

Automate Data with Macro Recording

Vlookup Macro Recording

Practice file

Perform Data Analysis with Pivot Table Slicer

Conditional Formatting in Pivot Table

Practice file

Data Visualization with Excel Charts

Create recommended charts in Excel

Recommended chart