Last updated 08/2020Duration: 36m | Video: .MP4, 1280x720 30 fps | Audio: AAC, 48 kHz, 2ch | Size: 672 MBGenre: eLearning | Language: English[Auto]

Master Data in Excel from a self confessed Microsoft Excel fanatic (Windows Excel 2007 to Excel 2019)

What you'll learn

Add a filter

Make a table

Find and remove duplicates

Split cells

Merge two columns

Search and replace

Calculate percentage increase

Requirements

A very basic knowledge of Excel

Have a Windows version of Excel installed

Description

Welcome to my Mastering Data in Excel course.You will learn the fundamentals of working with data, which really is the whole point of Excel.I used the Windows version of Excel current in 2020 to make this course, but other versions should not be that different.

I will be creating a spreadsheet during the course that you can . The idea is that you work along with me, then you can compare our spreadsheets. This is the very best way to learn.

I love Excel, and I hope to share my passion and enthusiasm for this amazing software onto you, as well as passing on all my skill and knowledge. Pretty soon you will be using Excel like a master, and you will save yourself so much , as well as look like a genius!In this course I cover

Creating a table of data

How to filter

How to automatically format a table with filters

How to find duplicates

How to split cells into columns

How to merge columns together

How to search and replace text in Excel

How to calculate a percentage increase.

I hope that you love this course and get a lot out of it.Happy Excelling!Keith

Who this course is for

Bning and intermediate Excel users who want to take their Excel skills to the next level