Course Objectives
- 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
- Creating Pivot Tables
- Sorting and Filtering Pivot Tables
- Formatting Pivot Tables
- Creating Pivot Charts
- Functions & Formulas
- IF and Related Functions
- Lookup and Reference Functions
- Power Functions, Statistical Functions, Math Functions
- Date and Time Functions
- Array Functions
- Text Functions
- Advanced Charts
- Creating Basic Charts
- Style Charts with Design Tabs
- Fine Tune Chart Elements
- Simple Data Analysis
- Installing Data Analysis Tool
- Goal Seeker & Solver
- Histogram
- Linear Regression
- Basics of SQL (M/S SQL Server 2018/9)
- Basics of Databases and Tables
- Database and Table Designs
- Normal Forms
- Basics CRUD operations on Tables
- Where, Having Clauses
- Joins (Inner/Outer)
- Aggregate Queries
- Sub-queries
- Basics of Stored Procedures
Rewards
- Certificate of Completion by Kaplan (will be received within 1-2 working weeks upon course completion)
- 5 Kaplan Employability Statement (KES) points (only for eligible students)