Download the free course exercise files to follow along
️https://www.simonsezit.com/data-analytics-in-excel-exercise-instructor-files/

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.

https://www.simonsezit.com/data-analytics-in-excel-exercise-instructor-files/

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 30-day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssit-first-month-free

Watch more free popular training tutorials from Simon Sez IT:

Check out our FREE 300+ hour training course playlist here ️
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

Check out our free video playlist for data visualization https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2

Power BI Tutorials for Beginners video playlist https://www.youtube.com/playlist?list=PLzj7TwUeMQ3i17tx3uoTc6xf9X7Nl2U-s

Microsoft Excel Beginner's Training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z

Data Analysis using Microsoft Tools here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jiDSWwQjtVvHqT09XdYFMi

Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn: https://www.linkedin.com/company/simon-sez-it/
FaceBook: https://www.facebook.com/SimonSezIT

Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1

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