Microsoft Excel Level 3
Short course
In Salford
Description
-
Type
Short course
-
Location
Salford
-
Duration
1 Day
Advanced features within Excel
Facilities
Location
Start date
Start date
About this course
Confidence in using Excel, and have knowledge to our Intermediate level
Reviews
Course programme
Microsoft Excel Level 3
Course Summary
Summary: Advanced features within Excel.
- Welcome and brief recap on level 2.
- Ask any relevant question. Expect an honest answer.
- Creating and using Excel templates.
- Commonly used formulae's explained and tested.
- Let's twist, pivoting your data and charts, why and how.
- Protecting your carefully crafted data. Stopping the "oops"
- Getting the right data into the right place - always and automatically.
- Flagging changing data with colours and borders.
- Hyperlinking to other programmes, the internet and email.
- Automating repetitive tasks - with shortcuts, buttons and toolbar icons.
- Looking up data from lists. Validating. Preventing "dirty data"
- Let's get creative. Putting it all together at last.
- Using your workbooks to practise.
Duration: 1 day
Group: Microsoft
Contents
Prerequisites Confidence in using Excel, and have knowledge to our Intermediate level.
Duration 1 day
Course Objectives
Advanced features within Excel.
Course Content
- Welcome and brief recap on level 2.
- Ask any relevant question. Expect an honest answer.
- Creating and using Excel templates.
- Commonly used formulae's explained and tested.
- Let's twist, pivoting your data and charts, why and how.
- Protecting your carefully crafted data. Stopping the "oops"
- Getting the right data into the right place - always and automatically.
- Flagging changing data with colours and borders.
- Hyperlinking to other programmes, the internet and email.
- Automating repetitive tasks - with shortcuts, buttons and toolbar icons.
- Looking up data from lists. Validating. Preventing "dirty data"
- Let's get creative. Putting it all together at last.
- Using your workbooks to practise.
Notes
Versions 2003, XP, 2000 & 97. If you have any specific questions please bring them along. Please note that this course does not cover Visual Basic skills.
Prerequisites
A good understanding of Excel
Course: Microsoft Excel Level 2
Suggested Next Steps
Course: Microsoft Access Level 1
Scheduled Dates and Fees
Start Dates Fee Notes
Thursday 29 January 2009 £145 (ex VAT)
Thursday 26 February 2009 £145 (ex VAT)
Thursday 26 March 2009 £145 (ex VAT)
Thursday 30 April 2009 £145 (ex VAT)
Thursday 28 May 2009 £145 (ex VAT)
Thursday 25 June 2009 £145 (ex VAT)
Microsoft Excel Level 3