- This event has passed.
Microsoft Excel Intermediate
August 31, 2018 @ 9:00 am - 3:30 pm$220
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
- Linking cells between Excel tabs
- 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
Group discount available
Click here to register
Click here to download a flyer for this event