Thanks for adding:

Proceed to Checkout

Continue browsing

X

Excel 2019 Powerful New Features

Course Outline

Learn functions, labels and names, data consolidation, 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

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

Please Bring

  • Notepad and pen
  • USB Flash drive

How to enrol

You can enrol online and over the phone using a credit card

$155 Limited GST free / $139.50
Excel 2019 Powerful New Features

<h2>Course Outline</h2>

<p>Learn functions, labels and names, data consolidation, pivot tables and macros. This course would suit those who have intermediate excel skills but want to learn more

...
$136 Limited GST free / $122.40
Excel 2019 Powerful New Features

<h2>Course Outline</h2>

<p>Learn functions, labels and names, data consolidation, pivot tables and macros. This course would suit those who have intermediate excel skills but want to learn more

...

If there isn't a class to suit you, please the waiting list.

Contact us

Narrabeen Annex: 1525 Pittwater Road,
North Narrabeen NSW 2101
Office Hours: 8.30am to 4.30pm, Mon to Fri

Brookvale Campus: Level 1, 14 William St, Brookvale NSW 2100
Office Hours: 8.30am to 4.30pm, Mon to Thur

Post: NBCC Reply Paid 1966, Dee Why NSW 2099

Phone: 02 9970 1000

Registered Training Organisation Code 90113