INF1617 - Microsoft Excel 2016 Advanced

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 3 are sufficient to be able to protect worksheet data, perform advanced data operations using summarising, data consolidations, filters and PivotTables, macros, and much more.

 

At Course Completion

After completing this course, students will be able to:

 

  • modify Excel options
  • protect data in worksheets and workbooks
  • import data into Excel and export data from Excel
  • use data linking to create more efficient workbooks
  • group cells and use outlines to manipulate the worksheet
  • create summaries in your spreadsheets using subtotals
  • use the Data Consolidation feature to combine data from several workbooks into one
  • create, use and modify data tables
  • create and work with scenarios and the Scenario Manager
  • understand and create simple PivotTables
  • construct and operate PivotTables using some of the more advanced techniques
  • create and edit a PivotChart
  • use advanced filters to analyse data in a list
  • use a variety of data validation techniques
  • create and use a range of controls in a worksheet
  • share workbooks with other users
  • create recorded macros in Excel

 

Prerequisites

Microsoft Excel 2016 - Level 3 assumes some knowledge of the software as well as a general understanding of personal computers and the Windows operating system environment.

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

Get Adobe Reader

Download INF1617 - Microsoft Excel 2016 Advanced (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
 
 
 
 
INF1616 - Microsoft Excel 2016 Intermediate
AUD$ 350
 
 
11
24
14
16
13
21
18
 
 
 
 
| Powered by nopCommerce