Excel Intermediate - Adelaide - Monday, 9th September 2019

Excel Intermediate - Adelaide - Monday, 9th September 2019


Excel Intermediate (full day) for PC versions 2016, 2013, 2010 and 365, and Apple Mac version 2016 and 365, 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 colleages as a talented Excel user without entering the advanced skills of Excel Advanced.

Add To Cart

Subjects covered in this course include:

• Working with VLOOKUP

• Linking cells between Excel tabs

• Templates

• PivotTable and PivotChart basics

• Drop-down menus in cells

• Working with SUMIF and COUNTIF

• Sorting in depth

• Filtering in depth

• Naming cells

• Calculating with dates

• Absolute referencing

• Working with SUBTOTAL

• Protecting worksheets

• Logic tests (eg: IF, AND, OR)

• Conditional formatting

• Print area, page breaks and page scaling

and much more including our T7 Tips and Tricks section.

Before enrolling into this course, you must be comfortable and familiar with the skills covered in Excel Basics such as SUM and AVERAGE formulas, sorting data, creating basic charts and filtering data. If you are not familiar with these skills, you will need to attend and complete Excel Basics prior to attending Excel Intermediate . This course is ideal for analysing large blocks of data.

Pricing above is pre-GST.