INF1615 - Microsoft Excel 2016 Introduction

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

This is a beginner’s course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel 2016. Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.

 

At Course Completion

After completing this course, students will be able to:

 

  • navigate your way around Microsoft Excel 2016
  • create and work with a new workbook
  • open and navigate within workbooks and worksheets
  • make changes to data in a workbook
  • understand and work with ranges in a worksheet
  • copy and paste data in Excel
  • use the fill operations available to fill a data series
  • move the contents of cells and ranges within and between workbooks
  • understand, create and work with formulas and functions
  • understand and use formula cell referencing
  • use font formatting techniques
  • align the contents of cells in a number of ways
  • understand and use the number formatting features in Excel
  • format rows and columns in a worksheet
  • work with elements that make up the structure of a worksheet
  • sort data in a list in a worksheet
  • filter data in a table
  • print your workbook data
  • create effective charts in Microsoft Excel
  • obtain help for Excel whenever you need it
  • understand points to consider to avoid problems in your worksheets

 

Prerequisites

This course assumes little or no knowledge of spreadsheets or Microsoft Excel 2016. However, it would be beneficial to have a general understanding of personal computers and the operating system environment, especially in regard to working with files and folders

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

Get Adobe Reader

Download INF1615 - Microsoft Excel 2016 Introduction (PDF)

Location:

Related Courses
Course Name
Price
< 
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
> 
INF1616 - Microsoft Excel 2016 Intermediate
AUD$ 350
 
 
15
18
16
17
11
 
 
 
 
 
 
INF1617 - Microsoft Excel 2016 Advanced
AUD$ 350
 
27
24
22
26
22
18
 
 
 
 
 
 
| Powered by nopCommerce