It looks like you're using IE11...
This browser offers limited functionality on our website. We recommend you use the latest version of Chrome, Safari, Edge and Firefox.
One day; 9.30am to 4.30pm
Microsoft Excel provides ways to help automate the business tools you need for your data analysis, list keeping, and calculations as well as the presentation tools for reporting your results.
This course is designed for users who are proficient in the functionality of Microsoft Excel. It is aimed at teaching the user improved ways of working with spread sheets and charts as well as introducing new topics such as working with databases and creating macros.prerequisites:
Attendance at an Excel course or basic knowledge of Excel topics such as chart creation and basic formulas.
Check Points:
Exercise | Details |
---|---|
Exercise 1 | Introduction and refresher exercise
|
Exercise 2 |
|
Exercise 3 | Formulae
|
Exercise 4 | Advanced formulae
|
Exercise 5 |
Naming cells
|
Exercise 6 |
Charting
|
Exercise 7 |
Charting
|
Exercise 8 |
Linking charts between Excel and Word
|
Exercise 9 |
Charting
|
​Exercise 10 |
Database facilities
|
Exercise 11 |
Filter by colour
|
Exercise 12 |
|
Exercise 13 | Functions within databases
|
Exercise 14 |
Pivot tables
|
After reading this manual you will be able to:
You will complete all of these using Microsoft Excel.
External attendees: £110 plus VAT per candidate.