academy-it-microsoft-office-excel-vendor-training

Excel 2016 Intermediate

$360.00

About this course

The skills and knowledge acquired in Microsoft Excel 2016 – Level 2 enable users to expand their knowledge and learn how to create more productive workbooks. It covers formulas and function techniques, advanced formatting and charting features and data manipulation tools like goal seeking.

Course Outline

Clear
SKU: INF1616 Categories: , , , Tag:

Description

At Course Completion

After completing this course, students will be able to:

  • use filling techniques
  • use a range of techniques to work with worksheets
  • apply a variety of page setup techniques
  • apply borders to cells and ranges in a worksheet
  • use common worksheet functions
  • create more complex formulas and functions
  • create and use defined names in a workbook
  • apply a range of number formatting techniques to worksheet cells
  • apply conditional formatting to ranges in a worksheet
  • use goal seeking to determine the values required to reach a desired result
  • understand and use Excel’s Quick Analysis tools
  • create and work with tables
  • use a range of elements and features to enhance charts
  • select and change the format of objects in a chart

Prerequisites

Microsoft Excel 2016 – Level 2 assumes the learner has the knowledge required to create, edit, print and chart simple worksheets. Understanding ranges and copying is also important.

Course Outline