5. Excel Adv (Level 1)

Description

Excel Advanced (Level 1)
Duration: 1 Day (9 am - 1:00pm)
Location: Welwyn Garden City or Borehamwood
Includes: Refreshments and Documentation
Price: £150 per delegate

Not sure if this course is right for you? Why not take our Quick Quiz or FREE - Training Needs Analysis

Who is this course for?
This course is designed for users who have previously attended an intermediate course or who have an equivalent level of knowledge.
What will they learn?
By the end of this course delegates will be able to keep detailed records in Excel. They will be able to sort and filter data. They will be able to summarise that data into meaningful reports. They will be able to create their own functions as well as recording simple Macros in order to automate their spreadsheets.

Using Advanced Filter to Copy Data to a New Location
Using Automatic Subtotals
Creating Pivot Table Reports - Watch Video
Creating Pivot Chart Reports
Using Goal Seek & Solver
Scenario Manager
Recording a Simple Macro