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
155kb Adobe PDF 362 downloads
Excel for Finance Staff