|
Intermediate Microsoft Excel
Length of course: 1 day
Intermediate Microsoft Excel is a one day course designed for those who wish to further their knowledge of Microsoft Excel beyond the introductory level.
“The small group worked really well”
Prerequisites:
You should be at least competent in the topics covered within our Introduction to Microsoft Excel course, or preferably you would have attended one of our Introduction to Microsoft Excel courses prior to this.
“Very enjoyable”
Benefits:
This course extends the knowledge learned in the Introduction to Excel course, covering more advanced formulas, formatting and automation. The course uses examples and exercises to show how to use these tools to create more complex professional spreadsheets and analyse figures.
Course Topics:
- Using Microsoft Office Online and templates
Custom fill
Hide and unhide worksheets and workbooks
Naming cells, ranges and managing names
Auditing a worksheet
Using nested functions
Using Lookups
Converting text to columns
Creating and using tables
Add validation to a worksheet
Create drop down lists
Conditional formatting
Formatting backgrounds
Customising printing
Formatting charts
Understanding Macros
|
 | |
| IOSH MANAGING SAFELY | Begins: 07/06/2013
Duration: 4 days - 7th, 14th, 21st, 28th June
Cost: £520 plus VAT
* * * |
| HYDRAULICS | Begins: 11/06/2013
Duration: 3 Days
Cost: £695 + VAT
* * * |
| PUMPS | Begins: 27/06/2013
Duration: 2 Days
Cost: £465 + VAT
* * * |
| HYDRAULICS | Begins: 05/07/2013
Duration: 3 Days
Cost: £695 + VAT
* * * |
| PNEUMATICS | Begins: 16/07/2013
Duration: 3 Days
Cost: £695 + VAT
* * * |
| IOSH MANAGING SAFELY | Begins: 05/08/2013
Duration: 4 days - 5th, 6th, 7th, 8th August
Cost: £520 plus VAT
* * * |
| BELTS & CHAINS | Begins: 15/08/2013
Duration: 2 Days
Cost: £465 + VAT
* * * |
| IOSH MANAGING SAFELY | Begins: 04/10/2013
Duration: 4 days - 4th, 11th, 18th, 25th October
Cost: £520 plus VAT
* * * |
| PUMPS | Begins: 06/11/2013
Duration: 2 Days
Cost: £465 + VAT
* * * |
| IOSH MANAGING SAFELY | Begins: 02/12/2013
Duration: 4 days - 2nd, 3rd, 4th, 5th December
Cost: £520 plus VAT
* * * |
| |  | |
|
