Gain Advanced Skills in Microsoft Excel 2010: Training Course in Canberra, Melbourne

MS Excel 2010 Advanced Training Course from pdtraining in Canberra, Melbourne — Gain mastery in Microsoft Excel 2010

Develop advanced knowledge and practical skills in Microsoft Excel 2010.

To gain skills in excel 2010, consider participating in MS Excel 2010 Advanced Training Course delivered by pdtraining in Canberra, Melbourne and other cities in Australia.

This Excel 2010 advanced training course running in Sydney, Brisbane, Adelaide, Canberra, Melbourne and Perth, is rated 5.0/5.0 in overall quality by ProCert Labs, builds on the skills and concepts taught in Excel 2010: Intermediate.

Participants will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, you will learn about data validation and database functions such as DSUM. You will also learn how to import and export data, and how to query external databases.

This course will help participants prepare for the Microsoft Office Specialist core-level exam for Excel 2010 (exam 77-882) and the Microsoft Office Specialist Expert exam for Excel 2010 (exam 77-888).

For comprehensive certification training, participants should complete the Introduction, Intermediate, and Advanced courses for Excel 2010.

Advanced Excel Course Modules Include:

Introduction

Introduction
Personal learning goals of each participant
Plan and structure for the day

Logical and statistical functions

Logical functions
Math and statistical functions

Financial and date functions

Financial functions
Date and time functions
Array formulas
Displaying and printing formulas

Lookups and data tables

Using lookup functions
Using MATCH and INDEX
Creating data tables

Advanced data management

Validating cell entries
Exploring database functions

Exporting and importing

Exporting and importing text files
Exporting and importing XML data
Getting external data

Analytical tools

Goal Seek and Solver
The Analysis ToolPak
Scenarios

Macros and customer functions

Running and recording a macro
Working with VBA code
Creating functions