Data Analytics using Excel Online Course
Data Analytics using Excel Online Course
This engaging video course offers a comprehensive journey through Excel, starting with basics like navigating the interface, data entry, and formatting. It covers essential topics such as formulas, data quality, sorting, filtering, and pivot tables. You'll also explore data visualization through charts, financial analysis, and advanced functions like Scenario Manager and Goal Seek. With practical examples, the course helps you build strong skills in data analysis and manipulation, preparing you to solve real-world business challenges using Excel.
Who is this Course for?
This course is perfect for professionals like business analysts, data enthusiasts, and anyone looking to improve their data skills. It’s also great for students aiming for careers in data science, business intelligence, or similar fields. If you want to learn how to use Microsoft Excel for data analysis, this course will teach you the key skills and techniques.
What you will learn
- View, enter, and format data types in Excel.
- Understand and apply Excel formulas and functions.
- Sort data and use filters, including advanced techniques.
- Work with Excel charts like clustered columns, line graphs, and waterfalls.
- Identify and avoid formula errors.
- Create problem statements to handle complex “or” criteria.
Course Table of Contents
Course Introduction
- Introduction to the Course
- Navigating Excel
- Data Types in Excel
Using Excel Spreadsheets for Data Analysis
- Viewing and Entering Data
- Formatting and Data Types in Excel
- Excel Formula Basics
- Exploring Excel Functions
- Referencing Data in Formulas
- Exercise 1
Cleaning and Managing Data
- Introduction to Data Quality
- Importing File Data
- Removing Duplicate Data
- Identifying Data Attributes
- Cleaning Data
- Exercise 2
Analyzing Data
- Sort and Filter Data
- Concatenation and SUMIF
- Tackling Complicated "OR" Criteria
- Summarizing Data Using Pivot Tables
- Creating a Pivot Chart
- Working with Excel Charts
- Analyzing Financial Data
- Waterfall Charts
- Conditional Formatting
- Using Database Functions
- Evading Formula Errors
- Exercise 3
What-If Analysis and Analysis ToolPak
- Scenario Manager in What-If Analysis
- Data Tables in What-If Analysis
- Goal Seek in What-If Analysis
- Loading the Analysis ToolPak
- Correlation and Covariance in Analysis ToolPak
- Descriptive Statistics, Moving Average, and Exponential Smoothing
- Additional Analytical and Statistical Applications
- Exercise 4
- Closing
