Thanks for adding:

Proceed to Checkout

Continue browsing

X

Excel 2016 Advanced

Advanced Microsoft Office Excel course focusing on more advanced features of Excel. This is a great follow on course from the Excel 2016 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 funtions of the software.

Course Outline

  • 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

Please Bring

  • USB stick to class. Around 4gb storage is sufficent.
  • Notepad and pen
$132 Limited inc GST / $118.80
Excel 2016 Advanced

<p>Advanced Microsoft Office Excel course focusing on more advanced features of Excel. This is a great follow on course from the Excel 2016 Intermediate. Learn functions, labels and names, data

...

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

Related Courses

Course testimonials:

  • Great
  • The greatest asset in all of this is Nicky Bull. She is outstanding in every regard. Polite, pleasant and with a vast knowledge of MS Excel and how it has evolved. Lots of great, relevant and useful shortcut tips at every step. Great at gauging where everybody is at and customising course delivery to suit. I think it should be called MS Excel First Aid and would recommend a 12 month refresher reminder. I would also love to see a course designed around teaching the principles or fundamentals of good spreadsheet design. I'm sure many spreadsheets are doomed to making use of the best functionality because they are poorly designed, but we plod on with the bad design because we don't know any better. Thank you, Nicky. James Staples Complementary Medicines Group Warriewood
  • Great course; really enjoyed Nicky Bull as the trainer; now need to practice the skills learned

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