Advanced Microsoft Excel
-
COURSE DATES AND LOCATIONS
DATE
Duration
LOCATION
FEES
Book Now
-
INTRODUCTION
In this course, We will teach you in-demand Excel techniques that will allow you to transform your career. Complete training – we will cover all topics you need to become an advanced Excel modeler. this is a great opportunity to add practical focus to the skills you will acquire while taking the course.
-
COURSE OBJECTIVES
By the end of the course, you‘ll be able to:
- New keyboard shortcuts and be even faster in Excel
- Understand advanced Excel functions
- Build nested functions
- 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
- Use Excel’s financial functions and understand concepts like:
- Present Value, Future Value, Discounted Cash Flows, Net
- Present Value, and IRR
- 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
-
COURSE AUDIENCE
This course is made for:
- Anyone who wants to use Excel at its best and wants to build complete financial models.
- Aspiring financial analysts, investment bankers, private equity analysts, and business intelligence consultants.
- People who are ambitious and want to grow faster than their peers.
-
COURSE OUTLINE
Day One:
- Course Introduction & Professional-looking Excel formatting
- Be 3.0x faster than average users – shortcuts and quick navigation tools
Day Two:
- Excel mechanics – A collection of indispensable tools
- Advanced Excel functions made easy
- Advanced Excel functions
Day Three:
- Advanced Excel functions
- Excel Tips & Tricks
Day Four:
- Financial modeling fundamentals
- Forecasting future financials – A cornerstone of financial modeling
Day Five:
- Building a complete 3-statement model
Keyword
Training Subject
Training Location