AusManagement Logo
 
Skip Navigation Links
Home
About UsExpand About Us
MYOB trainingExpand MYOB training
Reckon trainingExpand Reckon training
Xero trainingExpand Xero training
QuickBooks Online Expand QuickBooks Online
Bookkeeping Expand Bookkeeping
Cashflow & BudgetsExpand Cashflow & Budgets
Online LearningExpand Online Learning
Microsoft trainingExpand Microsoft training
ConnectionsExpand Connections
Choosing a ProductExpand Choosing a Product
News and BlogExpand News and Blog
HelpdeskExpand Helpdesk
Contact

courses Skip Navigation Links
MYOBExpand MYOB
QBOExpand QBO
XEROExpand XERO
OFFICEExpand OFFICE
RECKON ACCOUNTSExpand RECKON ACCOUNTS
WORKSHOPS

webinars Skip Navigation Links
Office WebinarsExpand Office Webinars
Reckon WebinarsExpand Reckon Webinars
Calxa WebinarsExpand Calxa Webinars
MYOB WebinarsExpand MYOB Webinars
QBO WebinarsExpand QBO Webinars
XERO WEBINARSExpand XERO WEBINARS

products Skip Navigation Links
MYOB ProductsExpand MYOB Products
ManualsExpand Manuals

4. Excel for Finance Staff

 There are limited places in this course, tailored for Finance staff - Book Today!

 A great course designed specifically for finance staff who use Excel on a regular basis either in conjunction with financial software or on its own, for analysis and presentation of data for reporting.

Has your manager ever asked you to perform what you believed was impossible? You will build on your Excel knowledge to manipulate data with ease and produce outstanding results more efficiently and effectively and saving time in your busy, demanding finance role. 

Session content includes:

Import and export data from other applications into Excel 

Learn about a range of functions including Mathematical and statistical functions in Excel

Understand when to use a range of text functions

Work with financial functions

Understand why conditional formatting is used on ranges in a worksheet

Become an expert is sorting data in a list in a worksheet

Use advanced filters to analyse data in a list

Work with a variety of data validation techniques

Comprehend group cells and use outlines to manipulate the worksheet

Create and manage accessible worksheets - and understand the importance of them

Construct and operate a range of PivotTables using different and advanced techniques 

Filter data in a table
use a range of logical functions

  Course Dates/Book Online >>


Want to know more? Open our PDF Course outline below or contact AMC today!

Phone: 02 6215 9715 or

Email: courses@ausmanagement.com.au


Downloads
Click to view Excel for Finance Staff
155kb Adobe PDF 362 downloads
Excel for Finance Staff
spacer
-

2018 Australian Management Control ABN: 65 066 670 353