Advance Microsoft Excel

Overview / who should attend and why?

This course is suitable for people who have attended the intermediate course on Excel or who have a highly proficient knowledge of the program but want to use the tool to a far greater extent.  It will provide you with the knowledge to manage large data sets through a detailed understanding of the advance features of Microsoft Excel.  The course is ideal for people who will be using Excel frequently and need to be able to work with complex spreadsheets and problems.

Course Objectives

• To use examples and real data to show the advanced skills of Microsoft Excel
• To enable the what if functions to be used easily
• To enable pivot tables and other manipulations to take place
• To show the use of filters and macros
• To enable the delegate to be able to use the advance functions of Excel

Course Content

The course is designed to enable the delegate to work through a number of exercises.  It is flexible enough so that questions and examples can be worked through during the day.  The course covers the following activities.

• Customizing the Work Area
• Working with Built-in toolbars
• Using Custom toolbars
• Creating buttons on worksheets
  
• Advanced Formula Construction
• Using Names
• Using the IF function
• Using the VLOOKUP function
  
• Lookups and Data Tables
• Working with lookup functions
• Creating data tables
• Data projection using ‘What if’ scenarios
  
• Using Pivot Tables
• Creating pivot tables
• Modifying pivot tables
• Grouping and summarising data in a pivot table
  
• Working with Multiple Worksheets
• Working with workbooks
• Linking cells in different workbooks
• Workbook versus links and workspaces
  
• Consolidating and Analysing Data
• Consolidating data from more than one worksheet
• Using the goal seek and solver utilities
• Using Scenario Manager to view a worksheet with different input values
  
• Using Protection and Display Options
• Using comments
• Protecting workbooks
  
• Introduction to Macros
• Running macros
• Recording a macro
• Viewing and editing VBA code

Benefits of attendance

At the end of this course you will have a complete understanding of the higher functions of Excel. You will be able to perform the most advanced calculations and functions, manipulate data using pivot tables and ‘advanced’ analysis, record macros and integrate with other office applications.

Costs / Duration and Location

• The cost of this training course is £300
• The duration is one day 9:00 till 16:00
• Please contact us for locations