3 month pass for all pmp live online trainings

MS Excel 2013 Advanced Training - Instructor Led

This course is intended for the data analysts and end users who are willing to explore the self-service business intelligence tools in Microsoft Excel 2013. This training is best suited for all business professionals: data analysts, developers, IT professionals, project leads, and project managers.

Upcoming Batches

  • Time
  • Delivery
Dec 19 - Dec 20
08:30 pm - 04:30 am Instructor-led 599
Jan 30 - Jan 31
08:30 pm - 04:30 am Instructor-led 599

Course Description

Microsoft Excel is by far the world’s most popular spreadsheet program and is useful for everything from maintaining simple household budgets to building sophisticated financial models or designing complex dashboards. It is also interesting to note that most BI, CRM & Analytics products in the market use an “export to Excel” feature as their selling proposition. Analyzing Business Data with Excel shows you how to solve real-world business problems by taking Excel’s data analysis features to the maximum, rather than focusing on individual Excel functions and features. Since most of the organizations already have highly skilled Excel users, they migrate swiftly to a self-service BI capability and tend to create their own BI solution intuitively without much dependence on IT. Whether you are new to Excel or an advanced user, Grey Campus Excel courses will cover what you need to know to become an Excel Power User.

This training would be very useful to participants across various industries and functional specializations such as MIS, Finance, Marketing, Operations, Human Relations, Information Technology and Administration. This interactive training targets specific business situations, and then demonstrates how to create spreadsheets for those problem areas. Attend these extraordinary, information-packed, powerful sessions to increase your productivity, improve the quality, accuracy & make a better report. This course is recommended for end users seeking proficiency in the use of Microsoft Excel 2013 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2013.

Training Components


  Instructor Led

Instructor Interaction


Training Duration

2 Days Live Online

Recorded Videos on Basic Excel Concepts


E-Learning Access

1 Year

12 PMI PDUs Certificate


  • High impact, proven training – Over 30000 professionals globally have participated in our training programs.

  • Experienced, expert instructors – Our Instructors come with a rich, 10+ years' of industry experience.

Course Objectives

At the end of the training the participants would learn/use/acquire the following techniques/knowledge:

  • Excel Advancements – some amazing features incorporated only in last few years
  • Generating Pivot Tables and Charts from complex datasets, instantly
  • Implementing Slicers and Sparklines to build interactive dashboards
  • Exploring Data Validation techniques and creating dynamic lists
  • Using ‘What-If-Analysis’ and Data representation techniques
  • Explore and connect to data sources using Power Query
  • Extract and transform data using Power Query
  • Comprehend the Power Pivot user interface
  • Build a cascading relationship and manage data models
  • Build a relationship between tables from different sources
  • Build a report using Power View
  • Hide columns, sort, change data types, and filter

Salient Features

  • High impact, proven training – Over 30000 professionals globally have participated in our training programs.

  • Experienced, expert instructors – Our Instructors come with a rich, 10+ years' of industry experience.

Registration Process

  • Step 1: Check for programs (check here)

  • Step 2: Click on 'Enroll' to register.

  • Step 3: Immediately on registration, you will receive an email from us with the payment details and access details for the on-demand e-learning component

  • Step 4: Receive an introduction and further communication from your GreyCampus training coordinator for the program you have registered for.


Q: What are the Pre-requisites for this course?

A: Some knowledge about basic data warehousing and data modelling concepts would be an added advantage. Working knowledge with Excel is mandatory.

Q: Do I need to have statistics background to understand the concepts?

A: No. Not mandatory. However, people with such background would be able to apply the concepts easily to their working environment.

Q. When will participants get their PDU Certificates?

A: All PDU E-Certificates will reach participants within 2 business days after the training.

Contact Us

Request Quote

Other Related Courses