The subjects covered in this course are ideal for standing out amongst your colleagues as a talented Excel user without
The Hartley Institute and T7 Training Systems present
Microsoft Excel Intermediate/Advanced A full-day workshop with Nicholas Jankovic for those who wish to learn correct spreadsheet procedures, develop powerful skills and learn time-saving techniques. Excel Intermediate/Advanced is an ideal course for people who currently use Excel and wish to increase their skills to beyond that of most corporate workers. The subjects covered in this course are ideal for standing out amongst your colleagues as a talented Excel user without entering the advanced skills of Excel Advanced.
Subjects covered in this course include: • Working with VLOOKUP
• Naming cells
• Linking cells between Excel tabs
• Calculating with dates
• Templates
• Absolute referencing
• PivotTable and PivotChart basics
• Working with SUBTOTAL
• Drop-down menus in cells
• Protecting worksheets
• Working with SUMIF and COUNTIF
• Logic tests (eg: IF, AND, OR)
• Sorting in depth
• Conditional formatting
• Filtering in depth
• Print area, page breaks and page scaling
and much more including our T7 Tips and Tricks section.
Where: The Hartley Institute Gerard Innovation Centre 54 Capper Street, Kent Town SA 5070
Contact: Rob Sieben 0408 083 083
[email protected]
When:
Cost:
Thursday 22nd March 2018 9:00am -3:30pm Refreshments provided
$200 ex GST per person $600 ex GST for groups of 4
T7 Training Systems
Microsoft Office courses and Adobe Suite training for individuals and staff
