Microsoft Office 2016 - Excel Essentials

Microsoft Excel will help you to solve simple or complex problems with confidence. In doing so, Excel learns your patterns, organising your data to save you time. With Microsoft Excel, you can create spreadsheets with ease from templates or on your own, and perform calculations with modern formulas. Microsoft Excel 2016 has new charts and graphs help you present your data in compelling ways, with formatting, sparklines, and tables to better understand your data. Easily create forecasts with just a click to predict trends. This Microsoft Excel course in Sydney, aims to give the new Microsoft Excel spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel. Particular emphasis is placed on developing accurate and well-designed spreadsheets, employing sound design and documentation principles.

Ideal for

This course is ideal for anyone who has little or no knowledge of spreadsheets or Microsoft Excel. Basic knowledge of the Windows computer operating system is required.

Learning outcomes

At the completion of this course you should 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

We provide

Comprehensive course notes

Other Information

This short course is conducted using Microsoft Office 2016 in a Microsoft Windows environment. Due to the comparative complexity of each application in the Microsoft Office suite, the time spent on each application will not necessarily be equal and will be guided by student needs on the day.

Avoid disappointment. Enrol early.

Please ensure that you have given a valid email and mobile number as all course changes will be communicated via sms or email.

$299LimitedGST free
/
$239.20
/
$269.10

Microsoft Office 2016 - Excel Essentials

<p><b><a href="/courses/business-classes-sydney/Microsoft.Office.365.courses">Learn Microsoft Office</a></b> 2016 Excel in Sydney.</p><p>Microsoft Excel will help you to solve simple or complex