PGA ICT Course II: Comprehensive Excel

Perk Group Africa building skills in Excel

Target Audience

The ideal option for organizations and groups:
- Wanting to maintain social distancing during lockdown phases but continue to train their staff
- With time or budget constraints
- With Excel users spread over wide geographic regions
- With an international presence or with differing time zones
- In countries where it is difficult to get qualified trainers to visit
- That would rather not fly to attend the course

Description

In this comprehensive specialization excel skills training, you will build on the strong foundations of very basic skills in excel.  This course will prepare you to become a power user of Excel and Perk Group Africa is determined to make this your last step before specializing at a professional level. The topics we have prepared will challenge you as you learn how to use advanced formula techniques and sophisticated lookups. You will clean and prepare data for analysis, and learn how to work with dates and financial functions. An in-depth look at spreadsheet design and documentation will prepare you for our big finale, where you will learn how to build professional dashboards in Excel.

This practical, 5 days Microsoft Excel Advanced Training Course focuses on the MS Excel skills that the typical basic to advanced business user would require. It is run on a monthly basis online and onsite in Nairobi. It is suitable for Intermediate and Advanced Excel users.

Syllabus

  • Basic MS Excel Tips and Tricks
  • Filtering and Sorting
  • The Specials- GOTO and Paste
  • Tools for text
  • Pivot Tables
  • Conditional Formatting
  • Function and Formula Basics
  • Text Functions
  • Key Lookup Functions
  • SUM, COUNT, AVERAGE IFS
  • Date functions and issues
  • Charting in Excel
  • How to protect an Excel Spreadsheet from opening

Learning Objectives

Some of the key outcomes will include:

  • Reviewing some of the new tools in the latest Microsoft excel
  • Easily cleaning up data received to report on
  • Understanding and making use of Pivot Tables, to turn data into reports
  • Reporting findings graphically via charts and other visualization techniques
  • Ability to create an automated reporting pack that changes month on month with no effort
  • Perform partial lookups where the words aren’t exactly the same
  • Get dates to work how you expect them to.