Microsoft Excel 2007 Advanced

Keys Training

Short course

In Manchester, Liverpool and Chorley

£ 201-500

The best Excel courses

See all

See all

Description

  • Type

    Short course

  • Level

    Advanced

Analyse data using pivot tables. Develop solutions to financial and budgeting questions. Control the output of printed work with report manager. Verify calculations and trace errors using auditing facility. Automate routine tasks with macros. Suitable for: Those who have attended our Intermediate level Excel training or equivalent.

Facilities

Location

Start date

Chorley (Lancashire)
See map
Doncaster House, Moorland Gate, Cowling Brow, Chorley, PR6 9DR

Start date

On request
Liverpool (Merseyside)
Ground Floor, The Campanile, Chaloner Street, Queens Dock, L3 4AJ

Start date

On request
Manchester (Greater Manchester)
See map
Quay West, Trafford Wharf Road, M17 1PL

Start date

On request

Start date

On request

About this course

This course is designed for experienced Excel users who have completed the Excel Intermediate course or have equivalent knowledge. Delegates should already be able to create detailed worksheets using complex formulas and should be familiar with conditional and nested functions.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Review of Excel day to day features

Pivot TablesMacros
•Creating a pivot table
•Recording a simple macro
•Rearranging pivot tables
•Editing a macro
•Formatting pivot tables
•Assigning a macro to keyboard or toolbar button
•Creating charts

Analytical ToolsAuditing Facility
•Using Goal seek and Solver
•Tracing Precedents/Dependents
•Creating Scenarios
•Checking for errors
•Applying data validation to cells with input text and error messages

Report Manager
•Using Report Manager
•Managing views and reports

See related categories

Microsoft Excel 2007 Advanced

£ 201-500

The best Excel courses

See all

See all