Introduction to Data Analysis with Excel: 2-Hour Training Tutorial

✅ Download the free course exercise files to follow along

In this Introduction to Data Analysis with Excel training, we show you how to use Excel spreadsheets for data analysis. We start off by identifying the data types in Excel and viewing and entering data. We then move on to the basics of Excel formulas and explore more Excel functions that are helpful for data analysis.

We'll also discuss how to clean and manage your data in Excel. We'll cover an introduction to data quality, importing file data, identifying data attributes, and more.

We've even included downloadable course exercise files from our paid-for courses so you can follow along and complete the exercises in this course. This will help you put what you are learning into practice.

📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!

00:00:00 - Simon Sez IT Intro
00:00:21 - Course Introduction
00:01:53 - Navigating Excel
00:15:15 - Data Types in Excel
00:21:12 - Viewing, Entering and Copying Data
00:30:08 - Formatting and Data Types in Excel
00:36:53 - Excel Formula Basics
00:48:37 - Exploring Excel Functions
00:58:16 - Referencing Data in Formulas
01:07:11 - Exercise 01
01:11:28 - Introduction to Data Quality
01:21:28 - Importing File Data
01:27:05 - Removing Duplicate Data
01:34:55 - Identifying Data Attributes
01:43:19 - Cleaning Data
01:50:59 - Exercise 02

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 300+ hour training course playlist here ➡️

💬Stay in touch!

🔔 Subscribe to our channel:

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

[DataAnalysisEnthusiast]

Hello, just started learning about Excel. I paused the video to make this comment, your explanation and detailing are so straight forward and easy to follow, Thanks a lot.

[maitv]

Easy to understand for beginner and do not have a lot of vocabularies, thank you so much

[ThinkWithAIML]

Tutorial Contents :

🕑 0:00 - Simon Sez IT Intro
🕑 0:21 - Course Introduction
🕑 1:53 - Navigating Excel
🕑 15:15 - Data Types in Excel
🕑 21:12 - Viewing, Entering and Copying Data
🕑 30:08 - Formatting and Data Types in Excel
🕑 36:53 - Excel Formula Basics
🕑 48:37 - Exploring Excel Functions
🕑 58:16 - Referencing Data in Formulas
🕑 1:07:11 - Exercise 01
🕑 1:11:28 - Introduction to Data Quality
🕑 1:21:28 - Importing File Data
🕑 1:27:05 - Removing Duplicate Data
🕑 1:34:55 - Identifying Data Attributes
🕑 1:43:19 - Cleaning Data
🕑 1:50:59 - Exercise 02

[markgodswill]

Thanks for sharing. It has improved my knowledge in sorting, using various mathematical functions, and enhancing the data quality

[talkwithjyoti]

really you are the power house of knowledge

[levybarakabama]

Thank you so much for the tutorial, Simon Sez IT. I thought that I mastered excel, but I just found that I need to update my knowledge continuously

[AS-dplt]

I appreciated the format used to teach each step. I also appreciated all the value provided for serious students.

[QTARUBA]

I'm enjoying this course... Awesome for beginners!!! Thank you!

[salehelmeselweck]

Very beneficial courses, I am very impressed of the simple and logic ways to convey the ideas in clear manner, I have seen many excel courses but but the structure of modules is confusing and unclear. Thank you for meaningful presentation.

[olgaanikeyeva]

Great Training! Thanks for organizing it so well and explaining everything in details.

[komalsaxena]

I am very impressed with simple and short way to do excel formulae in short spam time of time. 😊

[ekeossai]

Excellent tutorial. The simplicity and method of delivery was superb and fantastic.

[kemisolaolajide]

Great, good teaching and easy to understand 👍🏽

[GoodNews]

I like the way you teach, well measured for proper understanding, keep it up.

[edwardappiah]

Thank you very much for the tutorials, it was really helpful

[monicaekpu]

It's very impressive, its really very explainatory

[nhinvalerabayugao]

this is an amazing video!!!. I'm truly grateful for your efforts, thank you for sharing .. More power to your channel!!!

[daniellashobo]

this tutorial was so so good. my only problem was the xlookup part because my version doesn't have that yet, so i had to find an alternative by combining the index and match functions

[treytrey]

Thank you for the video. It would be nice if you let Excel 2021 users (desktop version) know that you are using MS 365 and it is Required to play along with your video, otherwise you are stuck at "data types". All of this training should start with what version of MS Excel you need to participate as there are many different levels and you can spend hours (apparently) searching for what you have and trying to guess what version Simon Says It is using.

[ayoolaalabi]

Simple and straightforward! I am grateful!