This Excel Advanced course is for delegates who have a very good working knowledge of Excel. By the end of the day, delegates will be able to add pivot charts, pivot tables and slicers to their worksheets, create custom formats, use conditional formatting rules and record a macro.
Course Outline
Session 1
Understand absolute, relative and mixed cell references, and use them in formulae, use dynamic named ranges, audit a workbook, use data validation (drop-down boxes) to enter data.
Session 2
Create a pivot table, update a pivot table, add fields, change field options, change view and create slicers. Create a pivot chart, edit a pivot chart, apply styles and update a pivot chart.
Session 3
Create custom formats of numbers (for example specify how many digits a number in a cell should have, custom date or time), use conditional formatting rules (for example, using the ‘If Formula Is’ to format cells), how to find and exclude duplicates.
Session 4
Introduction to Macros – record a macro, assign a macro to a keyboard shortcut, assign a macro to the ribbon, save a macro in personal, save a macro in a workbook.
Next Date: February 2020
Please use the Course Enquiry button below to register your interest.
At a Glance…
Level: Excel Advanced Course (Level 3)
Equipment/Account needed: None
Duration: 10 am – 4 pm
Class Size: 8 or less
Course Materials: Manual & quick reference guide included
Requirements: It is expected that delegates can use Excel competently
Cost: £200
Refreshments: Free tea/coffee and snacks are provided
Lunch: Provided
Location: 4th Floor, The Melting Pot, Rose Street, Edinburgh, EH2 2PR