Excel 2019 Advanced

Course Outline

Advanced Microsoft Office Excel course focusing on more advanced features of Excel. This is a great follow on course from the Excel 2019 Intermediate. Learn functions, labels and names, data consoildation, pivot tables and macros. This course would suit those who have intermediate excel skills but want to learn more advanced techniques and functions of the software.

Topics include

Lookup functions
Labels and Names
Protecting Data
Data Consolidation
PivotTables
Solver
Recorded Macros

Prerequisites

Students must have prior knowledge of the following:

Entering and Editing Data
Data formatting options
Worksheet formatting options
Page setup options
Moving and copying data
Creating simple formulas
Working with any of Excel’s functions (eg. =SUM, =AVERAGE, =LOOKUP)
Using “AutoFill” when copying formulas
Headers and Footers
Basic Charts
Auto Fill Options

Prerequisites

Confident keyboarding skills and Excel Intermediate course or equivalent skills and knowledge

Students must have Excel 2016/2019 or Office 365 installed on their computer.

Excel 2019 Advanced

Wed 22 Nov - Wed 29 Nov 2023
6:15pm - 9:15pm (UTC+11:00)

NBMC Brookvale Campus

Nicky Bull

When	Time	Where	Session Notes
Wed 22 Nov 2023	6:15pm - 9:15pm (UTC+11:00)	Room 3 - Level 1 - NBMC Brookvale Campus
Wed 29 Nov 2023	6:15pm - 9:15pm (UTC+11:00)	Room 3 - Level 1 - NBMC Brookvale Campus

NBMC Brookvale Campus

Levels 1 and 2, 14 William Street

Brookvale 2100

Site Directions

Note: no left turn into William Street from Pittwater Road. Enter via Harbord Road or Corrie Road.

Public Transport

No on site parking available. Restricted hours street parking in part of William Street from 9am to 6pm. On street parking available further along William Street, in Corrie Road and surrounding residential streets. Student facilities include: Kitchen with fridge and microwave. Tea/coffee making facilities with snacks available for purchase.

Other Information

Exit bus at Warringah Mall main bus stop, which is on the corner of William Street and Pittwater Road.

Sessions

When	Time	Where	Session Notes
Wed 22 Nov 2023	6:15pm - 9:15pm (UTC+11:00)	Room 3 - Level 1 - NBMC Brookvale Campus
Wed 29 Nov 2023	6:15pm - 9:15pm (UTC+11:00)	Room 3 - Level 1 - NBMC Brookvale Campus