Excel Advanced

Software: Microsoft Excel

Training Course: Advanced Microsoft Excel

Location: London

To Book Call: 0700 233 6600 or click here

Summary: This course will help participants obtain an in-depth understanding of the more complex components that make up Microsoft Excel .

Pre-requisites: All attendees must be proficient with basic Mouse, Keyboard and Windows skills. You should be familiar with the topics covered in our Excel Introduction and Intermediate courses either by previous hands-on experience or by having attended our or a similar course(s).

Duration: 1-Day
Start & Finish Times: 10am to 5pm

Objectives: This course is the next step in exploring what Excel has to offer. The course is designed to introduce other features of Excel that will enable users to be more exploitative of Excel 's abilities.

Who should attend: If you have attended or understand the concepts covered at introductory and intermediate levels, this course may be your next step. Its main focus is to introduce users to more specialist areas of Excel 's functionality. We would suggest that you have a demand for the skills described below, as the tools are not necessarily part of most peoples ‘Everyday’ Spreadsheet work.

Overview of Content

More Database tools: Review of Auto Filter. Using The Advanced filter.

Working with Pivot Tables: What are Pivot Tables? Creating a Basic Pivot Table Outline. The Pivot Table Tool Bar. Understanding Pivot Table Fields and Data. Moving Fields to redistribute and Group Pivot Data. Change Pivot Table Criteria, ‘SUM’, ‘TOTAL’, AVERAGE’.

Advanced Excel Tools: What is Goal Seek? Using Goal Seek. What is Scenario Manager? Subtotals.

Automating Print Settings and Ranges: (2000 – 2002 Users only) what is a Report Manager? Setting up Print Ranges. Adding Print Ranges to the Report Manager. Using the Report manager.

Macros: What are Macros? What is VBA? Where are Macros stored? Record a simple Macro. Play Back a Macro. Add a Macro to the Worksheet with an Object. Add a Macro to a toolbar. View your Macro Code.

Data Consolidation: Sharing Workbooks. Tracking Changes in Workbooks. What is Data Consolidation?

More Advanced Chart Features: Create Custom Default Charts. Add new data to existing Charts. Add Pictures to Chart Data Markers. Review of Chart elements.

Public Course Cost. £220.00
Top up Cost. £110.00
Company Room Rates & Work Shops – Please call for quote
Associated courses: Excel Advanced; Excel Programming