The Microsoft Excel Course: Advanced Excel Training

Excel: Advanced Excel Formatting, Excel Functions, Excel Modeling in Practice: Hands-on!

Created by: 365 Careers
Creating opportunities for Data Science and Finance students

What Will I Learn?

• Differentiate yourself at work. Quickly and dramatically
• Get hired in Finance – financial modeling skills are the critical edge you need at interviews
• Take your career to the next level!
• Get a certificate of completion
• Build financial models from scratch (shown step-by-step)
• Format sheets and charts professionally
• Learn new keyboard shortcuts and be even faster in Excel
• Understand advanced Excel functions
• Build nested functions
• Use Excel’s financial functions and understand concepts like: Present Value, Future Value, Discounted Cash Flows, Net Present Value, and IRR
• Build flexible Excel models
• Use Cell Styles and format spreadsheets easier and faster
• Learn several hidden Excel tips and tricks
• Understand the core principles of financial modeling
• Learn financial modeling best practices
• Design principles for good model building
• Build integrated financial models
• Forecast financials and use scenario analysis tools

Requirements

• The course is designed for intermediate and advanced Excel users. This is not a beginners course
• Microsoft Excel 2003, 2010, 2013, 2016

Target audience

• Aspiring financial analysts, investment bankers, private equity analysts, business intelligence consultants
• People who are ambitious and want to grow faster than their peers
• Anyone who wants to use Excel at its best and wants to build complete financial models