Advanced Excel Workshop

4k learners

Microsoft Excel is an essential, ubiquitous tool that's used everywhere from mom-and-pop stores to Fortune 500 heavyweights. Professionals across industries use Excel on a daily basis as an integral part of their job role.

  • Hands-on Workshop

  • 8-hour Bootcamp Training

  • Course Completion Certificate

  • 30-day Instructor Helpline

USD 200
Show Batches

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 an essential, ubiquitous tool that's used everywhere from mom-and-pop stores to Fortune 500 heavyweights. Professionals across industries use Excel on a daily basis as an integral part of their job role.

Although we use Excel every day, day after day, how many of us can honestly say that they know more than just the basics of this tremendously powerful software? Do you really know how Pivot tables work, or how that pretty-looking sales dashboard has been created?

This is just what we aim to solve through the Excel workshops on this page. And given the current economic scenario, we believe that sharpening your Excel skills in addition to your core work skills could mean the difference between having a job, or having to look for one. This is especially true for people in Mid-level management positions…

Course Outline

The Ribbon
The Work Surface
Navigation
First File
Formatting
Basic Math
Formula Anatomy
Cell Referencing
Function Anatomy
Math Functions
Basic Statistics
Logic Functions
Text Functions
Understanding Dates
Understanding Time
Formula Auditing
Temporal Functions
VLOOKUP with Approximate Match
VLOOKUP with Exact Match
Other Lookup Methods
Naming Ranges
Excel Tables
Learn about creating Excel tables, and their advantages
Creating PivotTables
Formatting PivotTables
Calculated Fields in PivotTable
What-If Analysis
Unpivoting Data
Importing Data from a Text File
Appending Tables
Outlining
Custom Number Formats
Conditional Formats with Built-In Rules
Conditional Formats with Custom Rules
Building Combination Line and Area Charts
Data Validation
Data Validation Lists
Styles
Custom Views
Page Setup Options
Security Considerations
View all
View less

CALL

Call us

CHAT

Live chat

CONTACT

Contact us
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