Microsoft Excel Intermediate/Advanced T7 Training Systems

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. The Hartley Institute and T7 Training Systems present. Microsoft Excel Intermediate/Advanced. Where: The Hartley Institute. Gerard Innovation Centre.
40KB Sizes 0 Downloads 126 Views
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