INF1316 - Microsoft Excel 2013 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 2013 - Level 2 are designed for existing users of Excel who would like to expand their knowledge and learn more of the techniques associated with creating better and more productive workbooks. It covers formulas and function techniques, advanced formatting, setting complex printing options, using advanced charting features and data manipulation tools such as Pivot Tables and goal seeking. A large range of functions are examined which cover a broad occupational spectrum and requirement.

At Course Completion

After completing this course, students will be able to:

  • At the completion of this course you should 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 the dozen or so most popular and common worksheet functions
  • create more complex formulas and functions
  • use a variety of financial functions
  • use the date and time functions to perform calculations
  • 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
  • work with tables in Microsoft Excel
  • understand and create simple PivotTables
  • use a range of elements and features to enhance charts
  • select and change the format of objects in a chart

Prerequisites

Microsoft Excel 2013 - Level 2 assumes the learner has the knowledge required to create, edit, print and chart simple worksheets. Understanding ranges and copying is also important. It would be beneficial to have a general understanding of personal computers and the operating system environment.

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

Get Adobe Reader

Download INF1316 - Microsoft Excel 2013 Intermediate (PDF)

Location:

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