Advanced Excel Workshop

 

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.

Request More Information

Exam Insights

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…

Learning Experience

SKILLS

Develop the skill set to use the MS Excel for better performance at your workplace.

ALIGNMENT

Our Advanced MS Excel course is aligned to the upcoming trends in the market.

OUTCOME

Master MS Excel to become more efficient at your organization. 

learning experience

Program Curriculum

  •  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
components
Study Plan

Study Plan

  • Hands-on Workshop

  • 8-hour Bootcamp Training

  • Course Completion Certificate

  • 30-day Instructor Helpline

Certificate

certificate

Where some of
our global
alumni work

image 8image 2

image 3

image 4image 5

image 7image 6

 

Student Experiences

  • Hannah Patterson

    Hannah Patterson

    This was a great learning experience with advanced Excel skills. Totally recommend to others. 

  • Joe Sanders

    Joe Sanders

    Excellent training from GreyCampus. Loved it and learned so much. 

Upcoming Schedules

 

Our instructors, mentors, and support team gear themselves towards ensuring that all students fare well in the program and achieve the success their efforts deserve

Group Training

For group enrolment of 5+ students or custom training requirements.

Get certified in Advanced Excel