top of page

Learn from the real world scenario and Practice Data

Create graphs & tables by using spreadsheets efficiently. Perform complex calculations and automate large volumes of data in mere seconds.

Enroll Now for
MS Excel Advanced Course

Get started today.

About Course

MS Excel Basic course is specifically designed for the people who are a complete beginners and do not have any prior  knowledge regarding the MS Excel. If you are a complete beginner looking to start your journey in learning you have come to the right place. Start learning the skill-set needed by today’s employers.

Course Timeline

Week 1

  • Introduction to the power query tab, power query as an alternative to text to column

  • Import multiple excel files and combine them into the proper data set

  • Combined multiple tables in the same excel workbook with the help of blank query (Excel.CurrentWorkbook function)

  • Merge, Append, and Unpivot features

  • Six types of Merges

Week 2

  • Group By Feature- 5 Examples

  • Group By- 4th Argument (Unique list or Consecutive occurrences)

  • Two-Way Lookup- Exact Match

  • Two-Way Lookup- Approximate Match

  • Import of data from Web

Week 3

  • Power Pivot Introduction and Creation of Relationships between Tables as a replacement to VLOOKUP

  • Columnar Database

  • How to use PQ & PP together to create Data Model PivotTable

  • Choice between Standard PivotTable & Data Model PivotTable

  • Choice between Power Pivot & Power BI

Week 4

  • Creation of a simple dashboard using the Four Charts option

  • Introduction to DAX Formulas

  • SUMX Function & Date Table

  • Excel Power Pivot Dashboard

  • DAX Studio

Week 5

  • Introduction to Power BI

  • Import Of Data from Web

  • Merge, Combine and Append Data

  • Import Of Folders

  • Tooltip

  • Objects & Actions (Buttons)

Week 6

  • Dax Formulas

  • Slicers

  • Text functions

  • Date functions

  • Number functions

  • M Code

Week 7

  • AI visuals

  • KPI visual

  • Calculate Table Function

  • Running Totals Function

  • Cards & Filters

  • Column from Examples & Conditional column

Week 8

  • SUMMARIZE function

  • Date Table

  • How to create a forecast

  • Power BI Service

Who should enroll for the course?


Business Executives

Data enthusiasts

Aspiring marketers

Aspiring Accountants

Aspiring Chartered Accountants

Working Professional

Special Offer!

Up To 50% OFF

Rs. 15,000/-

Rs. 30,000/-

remote jobs in human resources

Course Highlights

Human resource services

Live Online Classes​

job recruitment for freshers

Daily Assignments and Practice Sheet

recruiting companies

Weekly Tests

Why choose us?

Daily Live Classes

human resources roles
job sites for freshers

Regular Personal and Group Discussions

job websites for freshers

30 hours of Rigorous Training

human resources work from home

1 Capstone Project

New batch starting soon

Download MS Excel Advanced Course Brochure

Frequently Asked Questions

bottom of page