Microsoft Excel - Mastering Data in Excel For Beginners

Focused View

Keith Griggs

35:39

101 View

1. Welcome and download project file

1. Welcome to the course.mp4

02:19

2.1 mastering data 01.xlsx

2. Download the course spreadsheet.html

2. Tables and filters

1. Creating a table of data.mp4

04:28

2. How to filter in excel.mp4

02:21

3. How to automatically format as a table with filters.mp4

03:10

3. Duplicates, splitting and merging

1. How to find and remove duplicates.mp4

05:28

2. How to split cells.mp4

06:09

3. How to merge two columns.mp4

02:53

4. Searching, replacing and percentages

1. how to search in excel.mp4

01:23

2. How to replace text in Excel.mp4

02:34

3. how to calculate a percentage increase.mp4

04:54

Description

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

Who is this for?

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

More details

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 download. 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 time, 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:
Beginning and intermediate Excel users who want to take their Excel skills to the next level

User Reviews

Rating

average 0

Total votes0

Focused display

I an English and live near London. I am a qualified accountant. I worked for many years in industry as a Financial Controller and CFO.I really love Excel and have been using it pretty much all day every day for over 30 years.Now my mission is to share my knowledge and passion for Excel so that other people can benefit from it as much as I do.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.