INF1317 - Microsoft Excel 2013 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 2013 - Level 3 are sufficient to be able to protect worksheet data, perform advanced data operations using summarising, data consolidations, filters and advanced PivotTable techniques, 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
  • use data linking to create more efficient workbooks
  • construct and operate PivotTables using some of the more advanced techniques
  • work with tables in Microsoft Excel
  • use advanced filters to analyse data in a list
  • use a variety of data validation techniques
  • use a range of Information functions
  • use a range of text functions
  • create and use a range of controls in a worksheet
  • share workbooks with other users
  • create recorded macros in Excel

Prerequisites

Microsoft Excel 2013 - 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 INF1317 - Microsoft Excel 2013 Advanced (PDF)

Location:

Related Courses
Course Name
Price
< 
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
> 
INF1315 - Microsoft Excel 2013 Introduction
AUD$ 350
 
 
18
11
13
8
5
 
 
 
 
 
 
INF1316 - Microsoft Excel 2013 Intermediate
AUD$ 350
 
 
15
18
16
17
11
 
 
 
 
 
 
| Powered by nopCommerce