End of Financial Year Sale on now | Save 20% off courses site wide | Use code: EOFY20 at checkout | *T&C apply

Financial Analysis using Excel - UTS Open
Skip to main content

Financial Analysis using Excel



Enquire now




6 wks

Join Waitlist

Have a question ?

In this comprehensive and practical online course, you will develop your excel skills to perform financial analysis with precision and efficiency. Our expert instructors will guide you through every step of the process, providing hands-on training and real-world examples to ensure that you master the necessary techniques.

About this course

As Excel is the backbone of financial analysis, this course is designed to equip you with the essential skills to use data to create complex financial models, analyse and present financial information to derive insights that drive effective business decisions.

This course is designed for existing users of Excel or similar spreadsheet programs needing to vastly increase their modelling & analytical skills especially in the disciplinary areas of finance, accounting, management & procurement.

Key benefits of this course

This course has been designed to:

  • A thorough grounding in the tools & features available in Excel
  • Techniques to assist in auditing & understanding existing workbooks
  • Coverage of essential Excel functions for modelling, forecasting & financial analysis
  • Methods to generalise formulas for more dynamic & flexible calculations for modelling & analysis
  • Approaches to simplify calculations & increase the transparency of models & analyses
  • Practical guidance on the layout & structuring of workbooks for financial modelling.


Full price: $2,650 (GST-free)*

*Price subject to change. Please check price at time of purchase. 

Enrolment conditions

Course purchase is subject to UTS Open Terms and Conditions. 

Additional course information

Course outline

This course is unique in being 100% online while being comprehensive, practical, and hands-on. The live online sessions occur twice a week across six weeks.

Key outcomes include:

  • Significant upgrade to your modelling & analytical skills
  • Learn proven methodologies & techniques to build more transparent & powerful models & reports whilst reducing complexity
  • Gain effective approaches to build robust sensitivity into models
  • Build a useful & effective framework for assimilating technical knowledge
  • Develop measurable improvements in accuracy, productivity & transparency
  • 48 to 56 hours of continuing professional education for accountants


Mandatory requirements

To complete this online course, you will need a personal computer with adequate internet access and sufficient software and bandwidth to support web conferencing. You will also require an operating system with a web browser compatible with Canvas, Zoom and Microsoft Teams.

Desired requirements

This course is designed for existing users of Excel or similar spreadsheet programs needing to vastly increase their modelling & analytical skills especially in the disciplinary areas of Finance, Accounting, Management & Procurement.


Discounts are available for this course as follows: 

  • 10% discount for UTS alumni
  • 10% discount for group enrolments of 3 or more from the same organisation.

Discounts cannot be combined and only one discount can be applied per person per course session. Discounts can only be applied to the full price. Discounts cannot be applied to any offered special price. 

How to obtain your discount voucher code (group enrolments)

Please contact the team at support@open.uts.edu.au with details of group enrolments, to obtain your discount voucher code. 

How to apply your discount voucher  

  • If you are eligible for a UTS alumni or student discount, please ensure you have provided your UTS student number during checkout. If you are an alumni and have forgotten your UTS student number, email support@utsopen.uts.edu.au with your full name, UTS degree and year of commencement.  
  • Add this course to your cart 
  • Click on "View Cart" (blue shopping trolley at top right of screen). You will need to sign in or sign up to UTS Open 
  • Enter your eligible code beneath the "Have a voucher code?" prompt and click on the blue "Apply" button 
  • Verify your voucher code has been successfully applied before clicking on the blue "Checkout" button. 

Contact us

Who is this course for?

  • Anyone who uses Excel to perform their role, looking to improve their productivity and accuracy
  • Financial modellers and those building valuation and forecasting models
  • Business Analysts responsible for forecasting and performance analysis
  • Accountants, finance managers & financial controllers budgeting and analysing business performance
  • Fund accountants and managers in equity and property funds
  • Financial advisers, public accountants, management consultants
  • Procurement, project planning and logistical staff responsible for financial and logistical planning
  • Managers responsible for their own analysis & forecasting
  • Postgraduate finance & MBA students from both financial & non-financial disciplines.
We use cookies

We use cookies to help personalise content, tailor and measure ads, plus provide a safer experience. By navigating the site, you agree to the use of cookies to collect information. Read our Cookie Policy to learn more.

Acknowledgement of Country

UTS acknowledges the Gadigal people of the Eora Nation, the Boorooberongal people of the Dharug Nation, the Bidiagal people and the Gamaygal people, upon whose ancestral lands our university stands. We would also like to pay respect to the Elders both past and present, acknowledging them as the traditional custodians of knowledge for these lands.