Microsoft Excel training at your office (onsite / in company)

Training

In Nottingham, Manchester, London and 5 other venues

£ 499 + VAT

Description

  • Duration

    1 Day

To gain a better understanding of Microsoft Excel. To save time by using shortcuts? Suitable for: All Excel users as the content can be customised to your needs. You can use the module list in the course description as a menu.

Facilities

Location

Start date

Ellesmere Port (Cheshire)
See map

Start date

On request
Glasgow (Glasgow City)
See map

Start date

On request
Leeds (West Yorkshire)
See map

Start date

On request
London
See map

Start date

On request
Manchester (Greater Manchester)
See map

Start date

On request
Newcastle Upon Tyne (Tyne and Wear)
See map

Start date

On request
Nottingham (Nottinghamshire)
See map

Start date

On request
Warrington (Lancashire)
See map

Start date

On request
See all (8)

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

-----Excel basic training course-----

Entering and editing data

Creating workbooks
Entering and editing labels and values
Entering and editing formulas
Saving and updating workbooks


Modifying a worksheet
Moving and copying data
Moving and copying formulas
Using absolute references
Inserting and deleting ranges

Using functions
Entering functions
Using AutoSum
Using AVERAGE, MIN, and MAX

Formatting worksheets
Formatting text
Formatting rows and columns
Number formatting
Using Format Painter and AutoFormat

Printing
Preparing to print
Page Setup options
Printing worksheets

Creating charts
Chart basics
Modifying charts
Printing charts

Web features
Saving workbooks as Web pages
Hyperlinks
Sending workbooks via e-mail

-----Excel intermediate course-----

Working with large worksheetsViewing options
Hiding, displaying, and outlining data
Printing large worksheets

Using multiple worksheets and workbooks
Using multiple worksheets
Linking worksheets by using 3-D formulas
Consolidating data
Linking workbooks
Managing workbooks

Customizing Excel
Using the Options dialog box
Customizing toolbars and menus

Advanced Formatting
Borders and shading
Using special number formats
Working with dates
Working with styles
Other advanced formatting

List management
Examining lists
Sorting and filtering lists
Advanced filtering

Advanced charting
Chart formatting options
Using combination charts
Using graphic elements

Documenting and auditing
Auditing features
Comments and text boxes
Protection
Workgroup collaboration

Using templates
Built-in templates
Creating and managing templates

-----Excel advanced course-----

Working with advanced formulas
Using names
Using decision-making functions
Creating nested functions
Using financial functions

Lookups and data tables
Working with lookup functions
Using MATCH and INDEX
Creating data tables

Advanced list management
Creating subtotals
Validating cell entries
Exploring database functions
Working with data forms

Working with PivotTables and PivotCharts
Working with PivotTables
Rearranging PivotTables
Formatting PivotTables
Working with PivotCharts

Exporting and importing
Exporting and importing text files
Exporting and importing XML data
Querying external databases

Using analytical options
Working with Goal Seek and Solver
Working with the Analysis ToolPak
Working with scenarios
Working with views

Working with macros
Running and recording a macro
Working with VBA code
Function procedures

Interactive Web pages
Creating interactive Web spreadsheets
Publishing PivotTables on the Web

Additional information

Payment options: For up to 8 delegates including all required equipment and travel to your office

Microsoft Excel training at your office (onsite / in company)

£ 499 + VAT