Excel Level 3 - Virtual

Course Overview

Become an expert Excel user!

This course is designed to enable the proficient user to gain extended use of the spreadsheet package. The day starts with a brief review of commands covered in the Level 1 and 2 courses, followed by an in-depth look at some of the advanced tools of this package, such as Scenarios, Auditing and the Solver. The course covers conditional formatting, creating templates, data validation and data analysis tools. There will also be a detailed look at creating and using macros to enhance spreadsheet efficiency.

This is a VIRTUAL course.

This is a one-day course running from 9:30 am - 4:00 pm.
Training is hands-on and tutor-led.
We provide a comprehensive training manual and certification.
This course can be run as a company specific option.

• Course Content

  General Review

  General review of existing knowledge and the
  commands covered in Levels 1 and 2.
  
  

  Goal Seek and Solver

  Finding values for one or more input cells to optimise
  the value of a formula.
  
  

  Scenario Manager

  Setting up a scenario; switching between scenarios.
  
  

  Auditing

  Error checking.
  
  

  Data Validation

  Creating comments and defining valid cell entries.
  

  Templates

  Creating and saving a template.
  
  

  Conditional Formatting

  Setting and using conditional formatting.
  
  

  Macros

  Creating and running macros; assigning macros to
  buttons, keystrokes, menus and toolbars.
  
  

  Hyperlinks

  Using hyperlinks to move to specific cell references
  in spreadsheets.

• Prerequisites

  To gain the maximum benefit from this course, an attendee should have attended our Levels 1 and 2 courses, or have an equivalent understanding of Excel, especially the use of formulae, functions and multiple worksheets.
  
  Delegates will need a PC / laptop with a reliable internet connection and audio and video capability.

• Qualification

  This course covers material from the Advanced European Computer Driving Licence and the Microsoft Office Specialist Expert Excel syllabus.

• What Next?

  Access
  Use the powerful Access database capability to keep and organise all your records. Learn how to create tables of information, design useful forms, query your database and produce professional reports.