Advanced Excel Formulas & Functions (119569563) - Online

Description

CPA Members only

CPA Australia has partnered with Corporate Finance Institute (CFI ) to curate a collection of data and digital courses exclusively for CPA members. CFI courses have an emphasis on hands-on, practical learning and skills acquisition.  They teach in-demand industry practices, tools and techniques that help accounting and finance professionals build confidence, stand out from the competition, and make a positive impact on their careers.

Learn the most advanced formulas, functions and types of financial analysis to be an Excel power user. This advanced Excel training course is designed specifically for spreadsheet users who are already proficient and looking to take their skills to an advanced level.

This advanced program will help you become a world-class financial analyst for careers in investment banking, private equity, corporate development, equity research and financial planning and analysis (FP&A). By watching the instructor build all the formulas and functions right on your screen, you can easily pause, rewatch, and repeat exercises until you’ve mastered them.

CPA Australia handles your personal information in accordance with the CPA Australia Privacy Policy. By proceeding you may be redirected to an external website to access the course.

Our Privacy Policy includes the following statement under the subsection 'Links to external websites':  
•    We may provide links to websites operated by third parties. 
•    We are not responsible for the privacy practices or the content of such websites which will be governed by their own privacy policies to which you are advised to refer. 
•    Your satisfactory completion of the course may be recorded in your CPD Diary.

CFI programs will be supplied to CPA Australia members as standalone courses for 12 months from the date of purchase and as such, any associated CFI certifications are not able to be supplied. Refunds or extensions for purchases of CFI courses will only be available in exceptional circumstances and will be based on CPA Australia and CFI’s cancellation terms.

Learning objectives

• Explain the importance of communicating financial information effectively
• Apply best practices when creating financial presentations
• Explain the key structure of an effective presentation
• Construct a sample presentation using the outputs from CFI’s Amazon Case Study financial model
   

Audience

For anyone working in investment banking, equity research, corporate development, financial planning and analysis (FP&A) this course will give you the confidence you need to be a leader in performing financial analysis at your organisation.