Curriculum

ADVANCED EXCEL

Module 1: Getting to Know Excel

The Ribbon
The Work Surface

Navigation
Formatting

Module 2: – Essential Formula Knowledge - I

Formula Anatomy
Cell Referencing

Function Anatomy

Module 3: Essentials Formula Knowledge - II

Logic Functions
Conditional Math

Temporal Function(EOMONTH)
Function Anatomy

Module 4: Functions

Math Functions
Text Functions

Understanding Dates
Understanding Time

Module 5: - Search Functions

VLOOKUP
Other Lookup Method (Index & Match )

HLOOKUP

Module 6: Optimizing Data

Sorting
Filtering

Naming Ranges

Module 7: Data Analysis

Creating PivotTables
Formatting PivotTables

Calculated Fields in PivotTables

Module 8: Getting and Transforming Data

Importing Data from a Text File

Contiguous Data

Module 9: Presenting and Reporting with Formats

Conditional Formats with Built-In Rules
Cell Formatting

Conditional Formats with Custom Rules

Module 10: – Presenting and Reporting with Charts

Building Column Charts
Building Bar Chart

Building Pie Charts
Building Line Charts

Module 11: Validating and Updating

Data Validation
Comments & Notes

Apply built-in number styles

VBA

Module 1: Introduction To VBA

Introduction to Excel
Introduction to Programming
VBA Syntax And Grammar
Introduction to Cloud Compu

Quick Review of Macros
Working with Macros
How to use Visual Basic Editor

Module 2: Understanding VBA Editor

The Visual Basic Editor
Parts of the VBA Editor
About VBA Forms, Sub Procedures & Modules

Creating Forms
Using Controls and their Properties
Running VBA Forms in Excel

Module 3: VBA Syntax And Grammar

Objects – The Grammar
Using Properties and Methods
Understanding Parameters

The Object Browser
Understanding object hierarchy
Editing Specific Cells

Module 4: Storing Data In Variables

How and when to declare variables
Selecting data types

Fixed and dynamic arrays
Constants

Module 5: Control Structure And Program Flow

IF (Else If, Else)
Select Case()

For Next Loop
Do Until Loop and Do While Loop

Module 6: Building Procedure

Creating Sub procedures
Calling procedures

Passing arguments to procedures

Module 7: Building Intuitive Interface

Communicating with the user through the message box

Gathering user information with the input box

Module 8: Creating Customized Dialogs with User Forms

Command buttons
List and Combo boxes

Labels
Option buttons

Module 9: Functions

Using Excel Worksheet Functions in VBA
User-Defined Functions

Adding Help to User Defined Functions

Module 10: Error Handling

Run Time Error
GoTo line

Resume Next

TABLEAU

Module 1: - Introduction To Tableau

Why Data Visualization?
What is Tableau
Uses of Tableau

Tableau Installation
Saving and sharing your work

Module 2: Tableau Data Connections

Data Connections in the Tableau Interface
Types of Join
When to Use Joining
Creating Data Extracts in Tableau

What is Data Blending
When to Use Data Blending
Joining vs. Blending

Module 3: Organizing and Simplifying Data

Creating Filters
Customizing Filters
Sorting of Data
Using Parameters
Fixed Sized Bins

Formatting and Annotations
Applying Filters
Working with Sets
Creating Parameters
Tableau Bins

Module 4: – Data Visualization I

Bar Charts
Horizontal bar charts
Stacked bar charts
Side-by-Side bar chart
Text tables
Heat maps

Symbol maps
Filled Maps
Pie Charts
Tree maps
Area Charts
Scatter Plots
Histogram

Module 5: – Data Visualization II

Using Pareto Charts
Using Waterfall Charts

Using Gantt Charts
Using Box Plots

Module 6: Calculations

Working with string functions
Working with number functions
Working with Quick Table Calculations
Logic and Conditional Calculations

Working with Dates and Times
Working with aggregate options
Working with date functions
Conditional Filters

Module 7: Formatting

Introduction to Formatting
Options in Formatting Visualizations
Working with Labels and Annotations

Effective Use of Titles and Captions
Introduction to Visual Best Practices

Module 8: Mapping

Importing and Modifying Custom Geocoding

Working with Symbol Map and Filled Map

Module 9: Stories and Dashboards

Using Storytelling
Creating your first dashboard and Story
Adding interactivity to your Dashboard

Using Dashboard Actions
Use of Running Actions

Module 10: Working with Tableau Public Portal

Publishing to Tableau Public – Overview of publishing

Sharing work

POWER BI

Module 1: Power BI Introduction

Power BI Desktop
Flow of Work in Power BI Desktop

A Brief History of Power BI

Module 2: - Power Query

Data Transformation
Overview of Power Query
Ribbon
Saving the Work
Datatypes
Basic Filtering
Filter Multiple Columns

Remove Columns
Name / Rename a Column
Reorder Columns or Sort Columns
Add Column
Merge Columns
Transpose Columns
Remove Duplicates
Remove Blank Rows
Remove Errors

Module 3: M Language

IF..ELSE Conditions
Remove Columns ()
Split Columns ()

Replace Value()
GROUP BY Options Table
Group (), Sort ()
Table.Pivot()

Module 4: DAX

Calculated Column, Measures
Columns Vs Measures

DAX Syntax & Operators
DAX Operators

Module 5: - Math & Statistical Functions

ROUND, ROUNDUP, ROUNDDOWN
DIVIDE
EVEN, ODD

POWER, SIGN
SQRT, FACT

Module 6: Time Intelligence

YEAR, MONTH, DAY
WEEKDAY, WEEKNUM
FORMAT

DATE, TODAY, NOW
HOUR, MINUTE, SECOND, TIME
DATEDIFF, CALENDAR

Module 7: Text Functions

LEN, CONCATENATE (&) LEFT, RIGHT, MID UPPER, LOWER

TRIM, SUBSTITUTE, BLANK

Module 8: Logical Functions

IF
TRUE, FALSE NOT,

OR, IN, AND
IF ERROR SWITCH

Module 9: Report View User Interface

Fields Pane, Visualizations pane, Ribbon, Views
Grouping and Binning Introduction
Using grouping, Creating Groups on Text Columns

Sorting Data in Visuals
Changing the Sort Column, Changing the Sort Order
Sort using column that is not used in the Visualization

Module 10: Visualizations

Visualizing Data
Bar and Column Charts
Stacked Bar Chart
Stacked Column Chart
Clustered Bar Chart

Clustered Column Chart
Pie and Donut Charts
Scatter Charts
Line Chart, Area Chart

MYSQL

Module 1: Introduction

What is Data, Field and database?
Limitations of File Management System

Basic Concepts of Advantages of DBMS
Installing SQL

Module 2: – DDL and DML Statements

Create, Alter and Drop Table
Insert, Update and Delete Statement

Truncate Statement

Module 3: Working with Queries (DQL)

Understanding Select Statement
Usage of Top, Distinct, Null etc...Keyword
Using String and Arithmetic Expressions

Exploring Where Clause with Operators
Sorting data using Order By clause
Working with basic of Sub Queries

Module 4: – Aggregate Functions

Using functions in Queries

Count, Sum, Min, Max, Avg Group By and Having Clause

Module 5: Joins and Sets

Introduction to Joins
Inner Join
Self Join

Outer Join
Cross Join
Set Operations using Unions, Intersect

Module 6: Implementing Views

Introduction & Advantages of Views

Creating, Altering, Dropping Views

Module 7: Data Control language

Creating Users
Granting & revoking of privileges

Managing users

Module 8: Working with Indexes

Introduction

Creating and Dropping Indexes

Module 9: – Transaction Control Language (TCL)

Transactions process

Working with commit, rollback and savepoint

Module 10: Working with Stored Procedures

Introduction to stored procedures
Benefits of Stored Procedures

Creating, Executing Modifying, Dropping Stored Procedure

Module 11 – Implementing Triggers

Introduction to triggers
Creating, Altering, Dropping triggers

Before and after triggers

Module 12: Built-in functions in SQL

Working with character, date and number functions

Data Analytics and Visualization

Courses Information

Curriculum

ADVANCED EXCEL

Module 1: Getting to Know Excel

Module 2: – Essential Formula Knowledge - I

Module 3: Essentials Formula Knowledge - II

Module 4: Functions

Module 5: - Search Functions

Module 6: Optimizing Data

Module 7: Data Analysis

Module 8: Getting and Transforming Data

Module 9: Presenting and Reporting with Formats

Module 10: – Presenting and Reporting with Charts

Module 11: Validating and Updating

VBA

Module 1: Introduction To VBA

Module 2: Understanding VBA Editor

Module 3: VBA Syntax And Grammar

Module 4: Storing Data In Variables

Module 5: Control Structure And Program Flow

Module 6: Building Procedure

Module 7: Building Intuitive Interface

Module 8: Creating Customized Dialogs with User Forms

Module 9: Functions

Module 10: Error Handling

TABLEAU

Module 1: - Introduction To Tableau

Module 2: Tableau Data Connections

Module 3: Organizing and Simplifying Data

Module 4: – Data Visualization I

Module 5: – Data Visualization II

Module 6: Calculations

Module 7: Formatting

Module 8: Mapping

Module 9: Stories and Dashboards

Module 10: Working with Tableau Public Portal

POWER BI

Module 1: Power BI Introduction

Module 2: - Power Query

Module 3: M Language

Module 4: DAX

Module 5: - Math & Statistical Functions

Module 6: Time Intelligence

Module 7: Text Functions

Module 8: Logical Functions

Module 9: Report View User Interface

Module 10: Visualizations

MYSQL

Module 1: Introduction

Module 2: – DDL and DML Statements

Module 3: Working with Queries (DQL)

Module 4: – Aggregate Functions

Module 5: Joins and Sets

Module 6: Implementing Views

Module 7: Data Control language

Module 8: Working with Indexes

Module 9: – Transaction Control Language (TCL)

Module 10: Working with Stored Procedures

Module 11 – Implementing Triggers

Module 12: Built-in functions in SQL

Courses

Related Courses

Trending Courses

Data Science

Machine Learning & AI

Python

Cloud Computing

AWS

IT-IMS (Networking & Server)

Web App. Development

Data Analytics

Power BI Course

faqs

Frequently asked questions