MS Excel 2016 – Level 3 (P251)

Advanced Techniques to Help You Manage Your Data

Reserve your space now for your preferred course date. As the COVID-19 situation evolves, we will keep you informed whether the workshop will run in a classroom setting or live online. Regardless of format, you can be assured that we will deliver the same acclaimed training you expect from PMC.

Excel is a popular tool for creating spreadsheets, analyzing data, and charting information. This advanced level, one-day course is intended to help everyday users of Excel present their data in more effective ways using PivotTables and PivotCharts. Users will also learn about advanced analysis tools like the Scenario Manager, Goal Seek, Solver, and advanced functions. Basic macros will also be covered in this course.

Learning Outcomes

By the end of this seminar, you will be able to:

  • Use more advanced functions: VLOOKUP, IF, database functions to summarize data
  • Understand concepts of What-If-Analysis: Goal Seek, Data tables, Scenarios and Solver
  • Summarize data by using subtotals
  • Create and use Pivot Tables and Pivot Charts
  • Record basic macros
Please follow and like us:

Print Friendly

Workshop Topics

Summarizing Data

  • Automatic subtotals
  • Working with subtotaled lists

More Advanced Functions

  • Using lookup tables
  • Using functions to summarize data
  • Logical functions

Projecting Figures

  • Goal seek
  • Data tables

What-If Analysis

  • Scenario concepts
  • Creating scenarios
  • Managing scenarios


  • Solver concepts
  • Defining the problem
  • Solving the problem


  • Data list and Excel table concepts
  • PivotTable concepts
  • Creating PivotTables
  • Modifying PivotTable layouts
  • Working with PivotTables
  • Options
  • Pivot charts
  • Slicers


  • Create simple macros
  • Scenario reports

Register Online

Once you register the first attendee, you’ll have the ability to add additional attendees or purchase other workshops

Details Price Qty
Workshop - October 29, 2020show details +$480.25 (CAD)*  

* price includes taxes

Online event registration and ticketing powered by Event Espresso

Who Should Attend This Course?

Experienced Excel users who need to manage large amounts of data using Pivot Tables to summarize and analyze the data. Users will learn more advanced functions and Excel What-If tools to make business decisions.

Does This Course Address Your Competency Development Needs?

This training workshop addresses:

• Achievement / Results Orientation
• Computer and Digital Technology
• Document Use
• Planning / Organizing
• Working with Data and Numbers