The Power Modeling Bootcamp: Advanced Excel in 10 Days
4.6 (179 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,913 students enrolled
Wishlisted Wishlist

Please confirm that you want to add The Power Modeling Bootcamp: Advanced Excel in 10 Days to your Wishlist.

Add to Wishlist

The Power Modeling Bootcamp: Advanced Excel in 10 Days

Advanced Excel step-by-step: Formatting, Tips & Tricks, Shortcuts, Functions, Financial Modeling in Practice: Hands-on!
4.6 (179 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,913 students enrolled
Created by 365 Careers
Last updated 1/2017
Curiosity Sale
Current price: $10 Original price: $150 Discount: 93% off
30-Day Money-Back Guarantee
  • 5.5 hours on-demand video
  • 141 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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 two free gifts – once you complete 50% and 100% of the course!
  • 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
View Curriculum
  • The course is designed for intermediate and advanced Excel users. This is not a beginners course
  • Microsoft Excel 2003, 2010, 2013, 2016

You’re here because you want to build sophisticated financial models.

And you’re here because you want to take your Excel skills to the next level.

Well then, you’ve come to the right place. Welcome to The Power Modeling Bootcamp!

A 10-day journey that will have a major impact on your future career. We will teach you in-demand skills that will allow you to transform your career.

Every day, we will keep you engaged by providing a combination of video lectures, course notes, take-away templates, quizzes, exercises, and even homework. And this is a great opportunity to add practical focus to what you learn in the program.

From Day 1, you will jump right in and perform right away.
So, this isn’t a boring experience! 

The depth and breadth of topics we’ve selected is challenging and rewarding, providing a 360-degree approach to financial modeling in Excel.

Our strong focus on real-world examples ensures a super hands-on experience. We’ve designed a process that allows you to learn and see how things are applied in practice. 

What makes this course different from the rest of the Excel or Financial Modeling courses out there?

• High quality of production –HD videos (This isn’t a collection of boring lectures!)
• Knowledgeable instructors – The program has been created by professionals who have gained their experience while working with investment banks, Fortune 500 firms, and advisory companies.
• Complete training – we will cover all topics you need when building a financial model.
• Jam-packed with materials – Course Notes & Excel files, Shortcuts, Exercises, Quiz questions, Homework - You name it! Everything is inside!
• Excellent support: If you don’t understand a concept or you simply want to drop us a line, you’ll receive an answer within 1 or 2 business days.
• Dynamic: We don’t want to waste your time! The instructor keeps up a very good pace throughout the whole course.
• Bonus prizes: Upon completion of 50% and 100% of the course, you will receive two bonus gifts. 

Why should you consider enrolling in the program?

1. Salary. Acquire technical skills and differentiate yourself. More quickly. More dramatically.
2. Stress management. The more you sweat in training, the less you bleed in battle.
3. Growth. If you take your career seriously (and we know you do; otherwise you wouldn’t be reading this) you have to grow quicker and faster.

And it gets even better; by signing up and completing 50% and 100% of the course, you will receive life-time access to two of our other courses as a gift.
“Microsoft Word 2016: Beginner and Intermediate Training”, provided you complete the course at 50%, and
“Beginner to Pro in PowerPoint”, provided you complete 100% of the course.

Please don’t forget the course comes with Udemy’s 30-day unconditional money-back-in-full guarantee. And why not give such a guarantee, when we are convinced the course will provide a ton of value for you?

Just go ahead and subscribe to this course! If you don't acquire these skills now you will miss an opportunity to separate yourself from the others. Don't risk your future success! Let's start learning together now!

Who is the 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
76 Lectures
Day 1: Course Introduction & Professional-looking Excel formatting
10 Lectures 43:19

Quiz - Formatting
1 question

Cell styles allows you to be faster…

Quiz - Cell Styles
2 questions

Pasting values, formulas, and formats with Paste Special

Quiz - Paste Special
1 question

Formatting Cells Part I - Working with data in Excel

Formatting Cells Part II - Customize numbers the way you like

Quiz - Format Cells
5 questions

Highlight key data with Excel Conditional Formatting

Quiz - Conditional Formatting
2 questions

Filter by color

Recording Macros - The perfect way to avoid repetitions
Day 2: Be 3.0x faster than average users - shortcuts and quick navigation tools
7 Lectures 23:25
The secret of fast scrolling: navigation and keyboard shortcuts

Fix the top row of your Excel tables

Use multiple screens simultaneously

Quiz - Split Screens
1 question

Excel formulas that make sense - Named Ranges

Creating drop-down menus in Excel

F1 to F12 - Using Excel's function keys

Quiz - F keys
2 questions

How to select visible cells only

Quiz - Select visible cells
1 question
Day 3: Excel mechanics - A collection of indispensable tools
9 Lectures 34:09
Fixing cell references properly

Quiz - Fixing cell references
3 questions

Grouping Excel rows and columns - The correct way to do it!

Quiz - Group rows and columns
2 questions

Working on multiple sheets at the same time

Find & Replace - Our favourite Excel tool

Quiz - Find & Replace
1 question

Quiz - Find & Replace Formatting
2 questions

Create easily printable documents by using Set Print Area

What Are Circular References in Excel?

Circular References - An example

Quiz - Circular References
1 question

Trace precedents - Display the relationship between formulas and cells

Quiz - Trace precedents
3 questions
Advanced Excel functions made easy
4 Lectures 13:33
What is a nested function?

Advanced Excel functions: Sum; Sumif; Sumifs

Advanced Excel functions: Round functions

Advanced Excel functions: Iferror
Day 4: Advanced Excel functions - Part 1
8 Lectures 47:49
Advanced Excel functions: Vlookup & Hlookup

Advanced Excel functions: Index; Match; Index & Match

Advanced Excel functions: Indirect; Vlookup & Indirect

Advanced Excel functions: Rows; Columns; Vlookup & Columns

Advanced Excel functions: Choose; Vlookup & Choose

Advanced Excel functions: Offset; Offset & Match
Day 5: Advanced Excel functions - Part 2
5 Lectures 31:39
Financial functions: FV and PV

Discounting Cash flows and calculating Net Present Value (NPV)

Financial functions: IRR

Financial functions: PMT and building a complete loan schedule

Date functions
Day 6: Excel Tips & Tricks
4 Lectures 25:08
Excel tips & tricks: Part 1

Excel tips & tricks: Part 3

Excel tips & tricks: Part 4
Day 7: Financial modeling fundamentals
6 Lectures 23:11

Financial modeling Don'ts - Worst practices we should avoid

Financial modeling Do's - This is what solid modelers do

The different types of models

What is the right level of detail in a financial model?

Quiz: Financial modeling
5 questions
Forecasting future financials - A cornerstone of financial modeling
5 Lectures 18:58
Forecasting guidelines: apply these principles when forecasting financials

How to build a complete model

Forecasting Income statement financials

Forecasting Balance sheet financials - Part one

Forecasting Balance sheet financials - Part two
Day 8: Building a complete 3-statement model
8 Lectures 30:22
Introduction to the Exercise

Let's create a mapping of financials

Building an output P&L sheet

Filling in the output P&L sheet with historical financials

Calculating percentage variances and applying conditional formatting

Building an output Balance sheet

Using Index, Match, Match to fill in the output Balance sheet

Adding the forecast period
2 More Sections
About the Instructor
365 Careers
4.5 Average rating
10,154 Reviews
76,585 Students
19 Courses
Creating opportunities for Business & Finance students

365 Careers is a firm specializing in high-end business, financial, data science, and office producitvity training programs. Our growing list of courses includes Excel (Microsoft Excel for Beginner and Advanced users), PowerPoint, Word, Outlook, Accounting, Finance 101, Investment Banking, Financial Modeling, Company Valuation, Financial Planning & Analysis, Job Hunting, Strategy, Management, Marketing, Decision Making and Negotiation, and Python trainings. Our goal is to provide to our students the practical instruments they will need in order to perform successfully at their future workplace.