Find Courses Find Providers Providers - Promote Your Courses About Us

Microsoft Excel - Advanced

Training Courses

Would you like to see more Microsoft Excel courses?

Training course summary

Sponsored links

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.

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.

Regions:
  • London
  • Midlands
  • South East England
  • South West England
Delivery:
  • In House
  • Public
Category:
Difficulty:
  • Introductory

Further Details

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 Excels 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.

Pre-requisites: All attendees must be proficient with basic Mouse, Keyboard and Windows skills. You should be familiar with the topics covered in our 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

Guide price

£195 +VAT

 

Sponsored links

Interested in this course?

 

 
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Terms of use
Website design by Brit-net