Get started

Reset your password

Enter your email and we'll send you instructions on how to reset your password.

Advanced Microsoft Excel Training

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.

USD 200

Enroll now

Group Training

Looking for a personalized training for a group (3 or more participants) at your preferred location?
Contact us

Course Overview

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. 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, GreyCampus Excel courses will cover what you need to know to become an Excel Power User.

1-year access to audio-video lectures
Course completion certificate

Course Outline

Data Analytics using Microsoft Excel

Introduction
Communicating the Story that Data Insights Represent

Introduction

Role of Data Insights in Decision Making

Communicating Visually and Effectively

Summary
Visual Interpretation and Communication of Data

Data Interpretation

Analyzing Quantitative Data

Analyzing Qualitative Data
Chart Thought Starter: Do's and Don’ts

Psychology of Data Visualization

Smart Data Discovery

Using Microsoft Excel as Story-Telling Tool

Introduction to the module

Exploring Data Patterns

Analyzing Data Trends
Data Insights—360° View

Analyzing impact of data metrics by dimensions

Linear regression (Through scatter plots)

Pareto Analysis

Using decomposition tree concepts in excel for root cause analysis
Using Microsoft Excel Self-Service BI as a Storytelling Tool

Introduction

Practice Data Modelling through Power Pivot

The Last Mile

View all

Download full course agenda/brochure

CALL

CHAT

Live chat

CONTACT

Frequently asked questions

Faqs

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

A: Some knowledge about basic data warehousing and data modeling 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.

Q. Who should take up this course?

A: All business professionals, developers, data analysts, project managers and other IT professionals can take up this course.

Q. How will this tool help my performance?

A: The latest options and tools introduced in the MS Excel 2013 helps you generating Pivot Tables and Charts from complex datasets, implement Slicers and Sparklines to dashboards, use ‘What-If-Analysis’ and Data representation techniques and many more that will be covered in the Instructor-Led Training.

Q: What skills will I gain from this course?

A: As we've mentioned in the description learning MS Excel is useful for everything from analyzing basic household budgets to building sophisticated financial models or designing complex dashboards.

Q: How do I enroll for training?

A: You can enroll for this course through any of the following online modes. The receipt of the payment will be issued to the candidate automatically via email.

Visa debit/credit card
American Express and Diners Club card
Master Card, or
PayPal

Q: How experienced or qualified is the trainer?

A: At GreyCampus, we make sure quality comes first. All our trainers go through a rigorous selection process.

Q: What is the instructor helpline and how does it work?

For up to 30 days after completion of classes, you can reach out to GreyCampus Support (support@greycampus.com) to resolve any queries you may get on the course coverage.

Q: How does GreyCampus' 100% money back guarantee work?

A: Without BootCamp: Training sessions without BootCamps are governed by a 3-day trial policy. In the unlikely case of being dissatisfied with the course content, a delegate must reach out to the support team at support@greycampus.com within 3 days from the date of purchase. After verification, the entire amount will be credited in the original payment mode.

The refund policy mentioned above will stand void and thus unenforceable in case a delegate is found to be involved in any of the following scenarios:

Accessing more than 30% of the content available
Downloading eBook or any offline material
Attempting one or more mock tests
Using exam vouchers

BootCamp: BootCamp training refunds are subject to the 1st day of 1st training class refund policy. Upon finding the training unsatisfactory, the delegate must inform GreyCampus within 24 hours from the time when the first session began. All such communications should be directed to the support team reachable at support@greycampus.com. In such cases, the delegate will be refunded the entire amount paid in the original mode of payment.

The guarantee is valid for participants who have paid the entire enrollment fee.

Q. What happens when you register?

A: For both Bootcamp and without Bootcamp:

As soon as you register, an automated email with your receipt and your access credentials for audio-video lectures is sent to your registered email ID.

For Bootcamp*

Within 24 hours you will receive a welcome email directly from the training coordinator managing the specific workshop batch you've opted for.
3 working days before the batch start date: You will receive a reminder from the training coordinator about the upcoming training.
On the workshop start date (1 hour before starting off): Your training coordinator will reach you to check if you're having issues with logging online.
Last day of the workshop: Your training coordinator will ask you to share your feedback for the training.
1 working day from the last day of the workshop: Your training coordinator will reach out to you with the next steps, like how to download your certificate(s) and how to avail the post-training helpline (as applicable)

Q: What does the 30 Day Instructor Helpline mean?

A: Instructor helpline: 30-day access to an instructor (via email) for doubt clearing and issue resolution.

Classroom and Live-online training: The Instructor helpline period is valid for 30 days from the last day of the training.

Online self-learning course: The Instructor helpline is valid for 30 days from the day you have enrolled in the course.

Send your questions/ doubts to support@greycampus.com to avail this service.

500 +

Expert Instructors

100 +

PROFESSIONAL Courses

150000 +

Professionals Trained

Got any queries?