Microsoft Excel 2007 Intermediate

Short course

In Liverpool, Manchester and Chorley

£ 195 + VAT

Description

  • Type

    Short course

  • Level

    Advanced

Suitable for: Those who have attended out Introduction course 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

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 Basics

Functions

Database tools
•IF functions
•Sorting data – ascending, descending, left to right
•VLOOKUP and HLOOKUP
•Sorting data in custom sequences
•Function to combine data from multiple cells
•Filtering data with AutoFilter
•Date functions
•Creating customised and advanced filters
•Nested functions
•Using data forms to enter, delete and search for data
•Using Subtotals to calculate sub sets of data Tools
•Naming cells and ranges
•Protecting cells
•Linking workbooks
•Linking applications (Excel with Word or PowerPoint)

Formatting
•Hiding columns, rows and formulas
•Grouping columns and rows
•Applying conditional number formatting

Microsoft Excel 2007 Intermediate

£ 195 + VAT