| Duration | One Day |
| Public scheduled course | £N/A plus VAT |
| Individual tuition | £420 plus VAT |
The cost of this course includes six months telephone Helpline support, course notes, lunch and a certificate |
|
|
This course is only available as private tuition |
|
“
As usual an excellent day at Media Training - I'm looking forward to booking the next course”
Manager, John Lewis plc
Microsoft Excel: Intermediate
Course Overview
A continuation from the introductory course, this one day course looks at more in-depth functionality and commands in Excel. You will look at different ways of formatting, analysing and presenting information and learn to use both databases and charts to analyse data.
Course content
Introduction
• Refresher on basic formulas and functions
• Preventing rounding errors
• Building in checks and proofs
• Conditional formulas
• Linking worksheets/workbooks
Further functions
• Logical functions; IF, AND, OR
• Conditional statistical functions
• Date and time functions
Creating business diagrams
• Creating Venn diagrams
• Editing diagrams
• Exporting diagrams
Databases
• Creating a database
• Sorting and filtering
• Sub-totalling
• Consolidations
• Enhanced list functionality
Formatting numbers
• Creating custom number formats
• Conditional formatting
• Controlling date formats
Creating charts
• The different types of charts
• Chart formatting features
• Using Trends
• Combining charts
• Linking Excel and Word
Security
• Worksheet protection
• Workbook protection
Questions and answers