Excel 2019 Advanced - Northern Beaches Community College

Thanks for adding:

Proceed to Checkout

Continue browsing

X

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.

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

Course testimonials:

  • Thank you, I really enjoyed the course! Nikki was very engaging and the content & materials provided were excellent.