Introduction to Data Analysis with Excel

Dive into a comprehensive 2-hour training tutorial on data analysis with Excel. Learn to navigate Excel, understand data types, view and enter data, format cells, and master Excel formulas and functions. Explore data quality concepts, import file data, remove duplicates, identify data attributes, and clean datasets. Practice your skills with two hands-on exercises using downloadable course files. Gain essential spreadsheet skills for effective data analysis, from basic navigation to advanced data management techniques.

- Simon Sez IT Intro
- Course Introduction
- Navigating Excel
- Data Types in Excel
- Viewing, Entering and Copying Data
- Formatting and Data Types in Excel
- Excel Formula Basics
- Exploring Excel Functions
- Referencing Data in Formulas
- Exercise 01
- Introduction to Data Quality
- Importing File Data
- Removing Duplicate Data
- Identifying Data Attributes
- Cleaning Data
- Exercise 02