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

Community College Annex: 1525 Pittwater Road
North Narrabeen NSW 2101
Post: NBCC Reply Paid 1966, Dee Why NSW 2099

Phone: 02 9970 1000

Registered Training Organisation Code 90113