Data Analytics using Excel Online Course

Data Analytics using Excel Online Course

This course takes you through a complete journey in Excel, starting with navigation, data entry, and formatting, before moving into formulas, functions, and data quality techniques like importing and cleaning. You’ll learn advanced tools such as sorting, filtering, concatenation, SUMIF, Pivot Tables, and Pivot Charts, along with creating professional charts for data visualization. The course also covers financial analysis, conditional formatting, database functions, error handling, and What-If Analysis using Scenario Manager, Data Tables, and Goal Seek. With the Analysis ToolPak, you’ll explore correlations, covariances, and descriptive statistics, as well as moving averages and smoothing methods. Packed with practical examples, this course equips you to apply Excel effectively to real-world business challenges.

Who should take the course?

This course is ideal for students, business professionals, analysts, and anyone who wants to learn how to analyze and interpret data using Microsoft Excel. It’s well-suited for beginners with little to no prior experience in data analytics who are looking to build practical skills for academic projects, workplace tasks, or business decision-making. Whether you’re an aspiring data analyst, a professional aiming to improve productivity, or someone looking to make data-driven decisions, this course will help you master data analytics with Excel.

What you will learn

• Learn to view, enter, and format data types in Excel
• Understand and apply Excel formulas and functions
• Learn to sort data and apply filters, including advanced filtering techniques
• Work with Excel charts, including clustered columns, line graphs, and waterfalls
• Apply techniques to recognize and avoid formula errors
• Create problem statements to tackle complicated “or” criteria

Course Outline

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