✅ Download the free course exercise files to follow along
➡https://www.simonsezit.com/dataanaly...

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 paidfor courses so you can follow along and complete the exercises in this course. This will help you put what you are learning into practice.

✅ https://www.simonsezit.com/dataanaly...

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

Get unlimited training with Simon Sez IT’s 160+ courses ⏩ https://www.simonsezit.com/courses/

Level up your skills with a free 30day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssitfirst...

Watch more free popular training tutorials from Simon Sez IT:

Check out our FREE 300+ hour training course playlist here ➡
   • Simon Sez IT Long Training Courses  

✅ Check out our free video playlist for data visualization    • Data Visualization  Master the Tech ...  

✅Power BI Tutorials for Beginners video playlist    • Power BI Tutorials for Beginners. Mas...  

✅ Microsoft Excel Beginner's Training here    • Microsoft Excel Beginner's Training T...  

✅ Data Analysis using Microsoft Tools here    • Data Analysis using Microsoft Tools  

Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn:   / simonsezit  
FaceBook:   / simonsezit  

Subscribe to our channel:
https://www.youtube.com/simonsezittra...

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