Advanced Microsoft Excel Training

3k learners
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.

  • 2-day Bootcamp Training

  • 1-year access to audio-video lectures

  • 100% money-back guarantee**

  • 12 PMI PDUs

USD 400
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

Introduction
Introduction
Role of Data Insights in Decision Making
Communicating Visually and Effectively
Summary
Data Interpretation
Analyzing Quantitative Data
Analyzing Qualitative Data
Psychology of Data Visualization
Smart Data Discovery
Introduction to the module
Exploring Data Patterns
Analyzing Data Trends
Analyzing impact of data metrics by dimensions
Linear regression (Through scatter plots)
Pareto Analysis
Using decomposition tree concepts in excel for root cause analysis
Introduction
Practice Data Modelling through Power Pivot
The Last Mile
View all
View less

CALL

Call us

CHAT

Live chat

CONTACT

Contact us

Frequently Asked Questions

Faqs

A: Some knowledge about basic data warehousing and data modeling concepts would be an added advantage. Working knowledge with Excel is mandatory.
A: No. Not mandatory. However, people with such background would be able to apply the concepts easily to their working environment.
A: All PDU E-Certificates will reach participants within 2 business days after the training.
A: All business professionals, developers, data analysts, project managers and other IT professionals can take up this course.
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.
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. 
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
A: At GreyCampus, we make sure quality comes first. All our trainers go through a rigorous selection process.
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.
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.
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)
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 queries?

Acknowledgements

PMI
IASSC
axelos
itil
PRINCE2
Microsoft
Workshop by location
DISCLAIMER

Disclaimer

PMI®, PMBOK®, PMP® and PMI-ACP® are registered marks of the Project Management Institute, Inc.

The Swirl logo™ is a trade mark of AXELOS Limited.

ITIL® is a registered trade mark of AXELOS Limited. Used under license of AXELOS Limited. All rights reserved.

PRINCE2® is a registered trade mark of AXELOS Limited. Used under license of AXELOS Limited. All rights reserved.

IASSC® is a registered trade mark of International Association for Six Sigma Certification.

Certified ScrumMaster® (CSM) is a registered trade mark of SCRUM ALLIANCE®

CISSP® is a registered mark of The International Information Systems Security Certification Consortium (ISC)2.

CCNA® is a trademark of Cisco.

Microsoft and MS Project are the registered trademarks of the Microsoft Corporation.

SAP Trademark(s) is/are the trademark(s) or registered trademark(s) of SAP SE in Germany.
|
United States