✅ 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/
🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 10,000+ ad-free videos and begin your transformation today! ➡️ https://simonsezit.lpages.co/ssit-14-day-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 👍🏽 ;-)