Get started

By signing up, you agree to our Terms of Use and Privacy Policy.
Reset your password
Enter your email and we'll send you instructions on how to reset your password.

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

Group Training

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

Program 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…

Program Outline

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

Download full Program agenda/brochure

CALL

Call us

CHAT

Live chat

CONTACT

Contact us
500 +

Expert Instructors

100 +

PROFESSIONAL Courses

150000 +

Professionals Trained

Got any queries?
By submitting, you agree to our Terms of Use and Privacy Policy.

Acknowledgements

Our Accreditations

Call us

USA +1 518 302 6767
UK +44 20 8144 4436
IND +91 741 666 4433
HKG +852 8192 9294