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

✅ 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 👍🏽 ;-)