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.