Course curriculum

    1. How to use this course

    2. How to maximize the benefits of this course

    1. Lesson 1: Data Basic

    2. Lesson 2: The value of data

    3. Lesson 3: The curious case of data growth

    4. Data Basic Lecture Note

    5. First Quiz

    6. Lesson 4: Data wisdom

    7. Lesson 5: Data in decision making

    8. Lesson 6: Data as a resource

    9. Data Wisdom Lecture Note

    10. Second Quiz

    11. Lesson 7: Data ethics and privacy

    12. Lesson 8: Data life cycle

    13. Lesson 9 - Common data mistake

    14. Data In-depth Lecture Note

    15. Third Quiz

    16. Week 1 - Social Media Post

    1. Module 2: Download Resource

    2. Lesson 1: Introduction to Excel

    3. Practical 1: Introduction to Excel Practical Class

    4. Practical 2: Navigating Excel

    5. Lesson 2: Working with tables

    6. Practical 3: Managing data with tables

    7. Lesson 3: Aggregate and Arithmetic operations

    8. Practical 4: Aggregate and Arithmetic operations

    9. Lesson 4: Other functions in Excel

    10. Practical 5: Applying formatting functions

    11. Lesson 5: Visualizing data in Excel

    12. Practical 6: How to visualize data

    1. Module 3: Download Resource

    2. Lesson 1: Introduction

    3. Practical 1: Data Preparation

    4. Practical 2: Working with Tables in Excel

    5. Practical 3: Table Formulas

    6. Practical 4: Vlookup

    7. Practical 5: Conditional Arithmetic Procedures

    8. Practical 6: Central Tendency

    9. Practical 7: Pivot Table

    1. Module 4 - Download Resource

    2. Lesson 1: Getting started with data visualization in Excel

    3. Practical 1: Building the first charts

    4. Practical 2: Visualizing Contribution Differently

    5. Practical 3: Visualizing Sales per Segment

    6. Practical 4: Quarterly Sales per Region

    7. Lesson 2: Exploring more complex charts

    8. Practical 5: Combo Chart

    9. Lesson 3: The art of data visualization

    10. Lesson 4: Visualizing disaggregated data with PivotCharts

    1. Excel - Capstone Project

About this course

  • Free
  • 79 lessons
  • 7 hours of video content

Discover your potential, starting today