Thanks for adding:

Proceed to Checkout

Continue browsing

X

Excel 2016 Advanced Plus

Microsoft Office Excel Advanced Plus focuses on more advanced features of Excel. This is a great follow on course from the Excel 2016 Intermediate. This course would suit those who have intermediate excel skills but want to learn more advanced techniques and funtions of the software.

Course Outline

BSBITU402 Develop & use complex spreadsheets

  • Create, use and edit macros
  • Develop, edit and use templates
  • Import and export data
  • Advanced formulae/functions: VLOOKUP, IF,
  • Graphing/Charts

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

Please Bring

  • USB stick to class. Around 4gb storage is sufficent.
  • Notepad and pen
Assessments are made against units of competency.
  • Develop and use complex spreadsheets (BSBITU402)

This course has no current classes. Please the waiting list.

Related Courses

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