1 Day Corporate Training

Computer Training Courses

Microsoft Excel

Course Level: Advanced

Click on the escalator to select another level.

Course Objectives:

To acquire more in-depth knowledge of formulae, data analysis and automation using Excel

Prerequisites:

Attendance at an Intermediate Excel Course. Or 6 - 9 months experience of using Excel regularly. Good Knowledge of formatting techniques /operators /functions

Duration:

1 Day

Course Content:

Session 1 - Introduction

Introduction to the course
Discussion of needs

Session 2 - The Basics

Creation of Spreadsheets
Shortcuts and proper practice
Formatting techniques
Printing requirements

Session 3 - Formulae / Charts / Drawing

Advanced Functions
Range Names and Calculations
* Enhancing Charts
* Microsoft Map
* OfficeArt

Session 4 - Consolidation

3 dimensional spreadsheets
Using Workgroups
Cell Linking

Session 5 - Analysing Data

Goal Seek
Scenarios
Auditing Tools

Session 6 - PivotTables

PivotTable selection
Automatic Sorting
Pivot Table Options
Formulas and calculations

Session 7 - Automating Work

Design and use of Templates
Macros - Use and Design
Personal.xls
Customising toolbars

*Session 8 - Collaboration

Shared Workbooks
Revisions

*Session 9 - Database Functions

Using Excel as a database
Using Ranges
Sorting and Querying Data
Autofilter / Advanced Filter
Subtotals

* Optional parts of the course depending on ability and requirements of participants

Previous Level - Intermediate Excel

Click here to reserve a place on this course

Home I Company Profile I Accreditations I Recruitment I FAQs I Links
Course Schedule I Delivery I Where We Are I Enquiry Form I Email Us