The Art of Data Analytics in the Real World

Jun 7, 2026

Course Objectives & Learning Outcomes

  • Manage, transform and analyse data using the various functions and power of Microsoft Excel.
  • Understand how SQL (Structured Query Language) can be used with databases to ingest, manipulate and store data.

Course Structure

  • Pivot Table
    o Creating Pivot Tables
    o Sorting and Filtering Pivot Tables
    o Formatting Pivot Tables
    o Creating Pivot Charts
  • Functions & Formulas
    o IF and Related Functions
    o Lookup and Reference Functions
    o Power Functions, Statistical Functions, Math Functions
    o Date and Time Functions
    o Array Functions
    o Text Functions
  • Advanced Charts
    o Creating Basic Charts
    o Style Charts with Design Tabs
    o Fine Tune Chart Elements
  • Simple Data Analysis
    o Installing Data Analysis Tool
    o Goal Seeker & Solver
    o Histogram
    o Linear Regression
  • Basics of SQL (M/S SQL Server 2018/9)
    o Basics of Databases and Tables
    o Database and Table Designs
    o Normal Forms
    o Basics CRUD operations on Tables
    o Where, Having Clauses
    o Joins (Inner/Outer)
    o Aggregate Queries
    o Sub-queries
    o Basics of Stored Procedures

Reward

  • E-Certificate of Completion by Kaplan will be awarded upon completion of the course
Register Here
Share