Advanced Excel Training


Excel is a spreadsheet developed by MicroSoft capable of doing powerful data manipulation and analysis. It contains a daunting number of features including: calculations, pivot tables, charts/graphs, and even a macro programming language! Due to its broad capabilities, its main limitation is the lack of user knowledge of these resources. It is believed that the average person uses no more than 20% of Excel’s potential. This class introduces the students to methods which will facilitate their data analysis.

This hands-on training provides exposure to useful short-cuts, functions, and data manipulation techniques. The class includes exercises where the class is provided the opportunity to apply the new tools and shortcuts. They are encouraged to bring their own real data.

At the end of the session, participants will be able to:

  1. Use most helpful short-cuts.
  2. Apply built-in functions.
  3. Create and modify pivot tables.
  4. Insert slicers and filters.


1 day

Related tgg Training:

Related tgg Services:

We cannot display this gallery

Define your Problem Statement.

The first step towards breaking your organizational log jams is identifying and verbalizing the challenge you're facing. What are you trying to solve? This simple Problem Statement exercise can have profound implications for your team. It helps you define the issue and gives TGG some sense of where the soft spots could be in your Order to Cash process. We invite you to take a few moments to fill out this form. A TGG consultant will contact you shortly to discuss your Problem Statement and provide some insight on how we may be able to help.

Back to top