Curriculum
5 Sections
32 Lessons
26 Weeks
Expand all sections
Collapse all sections
ADVANCE EXCEL
19
1.1
Module 1: Excel Basics and Customization
1.2
Module 1 Excel Basics and Customization (Assignment Questions)
1 Week
1.3
Module 2: Advanced Functions and Formulas
1.4
Module 2 Advanced Functions and Formulas (Assignment Questions)
1 Week
1.5
Module 3: Data Validation Techniques
1.6
Module 3 Data Validation Techniques (Assignment Questions)
1 Week
1.7
Module 4: Data Organization and Analysis
1.8
Module 4 Data Organization and Analysis (Assignment Questions)
1 Week
1.9
Module 5: Power Functions for Data Analytics
1.10
Module 5 Power Functions for Data Analytics (Assignment Questions)
1 Week
1.11
Module 6: Data Visualization Techniques
1.12
Module 6 Data Visualization Techniques (Assignment Questions)
1 Week
1.13
Module 7: Macros and Automation
1.14
Module 7 Macros and Automation (Assignment questions)
1 Week
1.15
Module 8: What-If Analysis Tools
1.16
Module 8 What-If Analysis Tools (Assignment Questions)
1 Week
1.17
Module 9: New Features and Enhancements in Excel
1.18
Module 9 New Features and Enhancements in Excel (Assignment Questions)
1 Week
1.19
Advance Excel Quizzes
1 Week
50 Questions
SQL (Structured Query Language)
23
2.1
Module 1: SQL Basics
2.2
Module 1 SQL Basics (Assignment Questions)
1 Week
2.3
Module 2: DML, DDL & DQL
2.4
Module 2 DML, DDL & DQL (Assignment Questions)
1 Week
2.5
Module 3: SQL Constraints
2.6
Module 3 SQL Constraints (Assignment Questions)
1 Week
2.7
Module 4: Querying Data
2.8
Module 4 Querying Data Assignment Questions
1 Week
2.9
Module 5: SQL Joins
2.10
Module 5 SQL Joins (Assignment Questions)
1 Week
2.11
Module 6: SQL Functions
2.12
Module 6 SQL Functions (Assignment Questions)
1 Week
2.13
Module 7: Aggregate Functions and Grouping
2.14
Module 7 Aggregate Functions and Grouping (Assignment Questions)
1 Day
2.15
Module 8: Subqueries and Nested Queries
2.16
Module 8 Subqueries and Nested Queries (Assignment Questions)
1 Week
2.17
Module 9: Window Functions
2.18
Module 9 Window Functions (Assignment Questions)
1 Week
2.19
Module 10: Indexing and Performance Optimization
2.20
Module 10 Indexing and Performance Optimization (Assignment Questions)
1 Week
2.21
Module 11: Data Warehousing Concepts
2.22
Module 11 Data Warehousing Concepts (Assignment Questions)
1 Week
2.23
SQL (Structured Query Language) Quizzes
1 Hour
50 Questions
Power BI
11
3.1
Module 1: Introduction to Power BI
3.2
Module 1 Introduction to Power BI (Assignment Questions)
1 Week
3.3
Module 2: Data Visualization
3.4
Module 2 Data Visualization (Assignment Questions)
1 Week
3.5
Module 3: Power BI Service, Publishing & Sharing
3.6
Module 3 Power BI Service, Publishing & Sharing (Assignment Questions)
1 Week
3.7
Module 4: Data Transformation
3.8
Module 4 Data Transformation (Assignment Questions)
1 Day
3.9
Module 5: Data Modeling & DAX
3.10
Module 5 Data Modeling & DAX (Assignment Questions)
1 Week
3.11
Power BI Quizzes
1 Hour
50 Questions
Tableau
14
4.1
Module 1: Tableau Overview
4.2
Module 1 Tableau Overview (Assignment Questions)
1 Week
4.3
Module 2: Data Sources
4.4
Module 2 Data Sources (Assignment Questions)
1 Week
4.5
Module 3: Worksheets
4.6
Module 3 Worksheets (Assignment Questions)
1 Week
4.7
Module 4: Calculations
4.8
Module 4 Calculations (Assignment Questions)
1 Week
4.9
Module 5: Sorting & Filtering
4.10
Module 5 Sorting & Filtering (Assignment Questions)
1 Week
4.11
Module 6: Data Visualization
4.12
Module 6 Data Visualization (Assignment Questions)
1 Week
4.13
Module 7: Projects
4.14
Tableau Quizzes
1 Hour
50 Questions
Final Exam
2
5.1
Business Analytics Final Quizzes
1 Hour
50 Questions
5.2
Business Analytics Final Test
3 Hours
Business Analytics
Search
Module 2: Advanced Functions and Formulas
Topics:
Conditional Expressions
Writing IF Statements
Using Logical Functions: AND, OR, NOT
Lookup and Reference Functions
VLOOKUP, HLOOKUP, MATCH, INDEX
VLOOKUP with Exact and Approximate Matches
Nested VLOOKUPs and Dynamic Ranges
Data Consolidation using VLOOKUP
Modal title
Main Content