INF1616 - Microsoft Excel 2016 Intermediate

AUD$ 350
*
*
Academy IT strive to provide you with the training you need when you need it most. If you require a course and can’t attend on the dates provided or if they are not suitable to your staffing or project timelines – please call PH: (08) 7324 9800 to negotiate an alternative booking time.

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.

 

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.

To view the course outline please ensure you have Adobe Reader installed.

Get Adobe Reader

Download INF1616 - Microsoft Excel 2016 Intermediate (PDF)

Location:

Related Courses
Course Name
Price
< 
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
> 
INF1615 - Microsoft Excel 2016 Introduction
AUD$ 350
 
 
5
11
9
8
6
11
7
 
 
 
 
INF1617 - Microsoft Excel 2016 Advanced
AUD$ 350
 
 
18
30
23
27
25
28
28
 
 
 
 
| Powered by nopCommerce