Call our Course Adviser hotline
RIGHT NOW on

COURSE TITLE:

Microsoft Excel Training UK

LEVEL:

Introduction : Intermediate : Advanced

COURSE LENGTH:

1 day

COURSE PRICES:

• On Site Price, at your Home or Office: £297 p/person per day. Special Group Rates
• Off Site Price, at our Training Centre: £190 p/person per day. Special Group Rates
• Closed Courses available for groups of 4 or more - Contact Us for a quote or call now on 0870 041 2102

*All prices quoted exclude VAT

COURSE OVERVIEW:

Microsoft Excel will enhance your use of spreadsheets for data input, maintaining lists and detailed analysis.
Regardless of your role at work Microsoft Excel is used today by most people to maintain lists of data - staff information, stock levels and so on, to calculate numerical data, to analyse company data and much more. This is one of the most commonly used software packages yet many people do not feel confident about it and many others are unaware of the various features Excel has to offer.

The course outlines below set out the full range of topics you can choose to cover during your on-site training course, and you can build your course around your exact training requirements, or any specific projects you or your staff are working on at present.
You will find that this approach makes our courses the most effective and productive use of your training budget available today.
For off-site courses use the outline below as a guide to the modules available, contact us now for a full off-site course outline and training dates.

Introduction Level

Introduction to Excel basics
The workbook environment

Enter and edit data
Navigate in a worksheet
Correcting data
Edit cell contents
Use AutoComplete
Save a file
Open a second and third file
Navigation and movement techniques

Modifying a workbook
Work with ranges
Create formulae

Move and copy data
Cut and paste data
Drag and drop data
Insert rows and columns
Use the clipboard
Use the fill series feature

Format a worksheet
Number formats
Text alignment
Copy and paste formats
Change font size and type
Add borders to cells
Change column width and row height
Shrink text to fit
Align cell contents
Merge and split cells
Apply an autoformat

Print a worksheet
Check spelling
Use print preview
Print a large worksheet
Additional print options

Set page display and print options
Freeze, unfreeze rows and columns
Set print titles
Set page margins
Create a header and footer
Change page orientation
Insert and remove a page break
Print a range

Intermediate Level

Absolute references
Work with multiple worksheets
Work with multiple workbooks
Link cells in different workbooks
Create workspaces

Formula construction
Logic functions: IF, nested IF functionAND, OR function
SUMIF, COUNTIF functions

Create, edit and delete comments
Use the auditing toolbar
Use data validation

Sort data
Single-level and multiple-level sorting
Sorting options
Data list design considerations

Filtering data
Create custom filters

Group and outline data
Add subtotals to a worksheet
Apply conditional formatting

Protect and display options
Protect the worksheet
Hide information

Create and apply styles
Create a custom numeric format

Create, edit and use templates

Create charts
Create a chart sheet
Create an embedded chart

Modify charts
Apply and use various chart types
Add and delete chart items
Move and size chart items
Format a chart
Format chart text and numbers
Insert and format labelsPreview and print charts

Advanced Level

Insert and edit graphic objects to enhance
worksheets and charts
Format graphic objects

Advanced techniques for filtering data
Multiple-condition criteria
Manage a filtered list

Create name ranges
Use name ranges in formula
Manage name ranges

LOOKUP functions
VLOOKUP, HLOOKUP functions
IS, ERROR functions

Create Pivot tables
Edit pivot tables
Group and summarise data in pivot tables

Consolidate and analyse data
Consolidate data from more than one worksheet

Use Goal Seek and Solver utilities
Use Scenario Manager to view a worksheet with different input values

Protect and display options
Protecting workbooks
Create and apply custom views
Use custom views with report manager

Share your workbook
Set revision tracking
Merge workbooks
Track changes

Introduction to macros
Record a macro in one workbook, for all workbooks
Record an absolute, relative and generic macro
Run a macro
Delete a macro
View and edit VBA code
Assign a macro to a button in the workbook
Assign a macro to a toolbar
Customise the work area
Modify existing toolbars
Create custom toolbars

Work with interactive excel web documents
Save excel worksheets as web documents
Spreadsheet web components

Query data
Database functions
External databases and queries
Running a Web Query on the Internet

BACK TO TOP