MS Excel (Advanced)

Overview

This one-day course is designed to help a delegate develop spreadsheets using more advanced functions and formulas.

Course Details

Objectives

Working with Tables
Creating PivotTables
Grouping dates in a PivotTable
Using the VLOOKUP, HLOOKUP and IF Functions
Using the PMT, FV functions and using What-if-Analysis
Recording Macros
Importing and Export data
Templates
Sharing Workbooks
Conditional Formatting

Delivery Methods

Course is facilitated by a competent & experienced subject matter trainer, who utilises the following techniques to ensure that the session is practical and experiential: Questions, Discussions, Exercises & Assessments.

Who should attend?

Any delegate wanting to develop their skills in using Microsoft Excel to design spreadsheet solutions and use tools for creating and formatting more complex spreadsheets, that solve more difficult problems.

Includes

Comprehensive Manual
Lunch and Refreshments (not applicable to on-site / online training)
Electronic Certificate (on successful completion of the course)
Electronic Delegate Feedback Questionnaire

Ready to Build a More Skilled Team?

Give your staff the practical training they need to work with more confidence, capability, and professionalism. Explore PST Training’s courses, workshops, and seminars today.