Data Analyst Professional Certification Program
Welcome to Data Analytics Class
How to use this course
How to maximize the benefits of this course
Lesson 1: Data Basic
Lesson 2: The value of data
Lesson 3: The curious case of data growth
Data Basic Lecture Note
First Quiz
Lesson 4: Data wisdom
Lesson 5: Data in decision making
Lesson 6: Data as a resource
Data Wisdom Lecture Note
Second Quiz
Lesson 7: Data ethics and privacy
Lesson 8: Data life cycle
Lesson 9 - Common data mistake
Data In-depth Lecture Note
Third Quiz
Week 1 - Social Media Post
Module 2: Download Resource
Lesson 1: Introduction to Excel
Practical 1: Introduction to Excel Practical Class
Practical 2: Navigating Excel
Lesson 2: Working with tables
Practical 3: Managing data with tables
Lesson 3: Aggregate and Arithmetic operations
Practical 4: Aggregate and Arithmetic operations
Lesson 4: Other functions in Excel
Practical 5: Applying formatting functions
Lesson 5: Visualizing data in Excel
Practical 6: How to visualize data
Module 3: Download Resource
Lesson 1: Introduction
Practical 1: Data Preparation
Practical 2: Working with Tables in Excel
Practical 3: Table Formulas
Practical 4: Vlookup
Practical 5: Conditional Arithmetic Procedures
Practical 6: Central Tendency
Practical 7: Pivot Table
Module 4 - Download Resource
Lesson 1: Getting started with data visualization in Excel
Practical 1: Building the first charts
Practical 2: Visualizing Contribution Differently
Practical 3: Visualizing Sales per Segment
Practical 4: Quarterly Sales per Region
Lesson 2: Exploring more complex charts
Practical 5: Combo Chart
Lesson 3: The art of data visualization
Lesson 4: Visualizing disaggregated data with PivotCharts
Excel - Capstone Project