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
English
Curiosity Sale
Current price: $10 Original price: $150 Discount: 93% off
30-Day Money-Back Guarantee
Includes:
  • 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
Requirements
  • The course is designed for intermediate and advanced Excel users. This is not a beginners course
  • Microsoft Excel 2003, 2010, 2013, 2016
Description

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
05:36:27
+
Day 1: Course Introduction & Professional-looking Excel formatting
10 Lectures 43:19



Quiz - Formatting
1 question

Cell styles allows you to be faster…
06:33

Quiz - Cell Styles
2 questions

Pasting values, formulas, and formats with Paste Special
02:30

Quiz - Paste Special
1 question

Formatting Cells Part I - Working with data in Excel
04:47

Formatting Cells Part II - Customize numbers the way you like
04:40

Quiz - Format Cells
5 questions

Highlight key data with Excel Conditional Formatting
05:40

Quiz - Conditional Formatting
2 questions

Filter by color
01:43

Recording Macros - The perfect way to avoid repetitions
03:13
+
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
06:52

Fix the top row of your Excel tables
01:14

Use multiple screens simultaneously
03:41

Quiz - Split Screens
1 question

Excel formulas that make sense - Named Ranges
01:36

Creating drop-down menus in Excel
01:49

F1 to F12 - Using Excel's function keys
05:30

Quiz - F keys
2 questions

How to select visible cells only
02:43

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

Quiz - Fixing cell references
3 questions

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

Quiz - Group rows and columns
2 questions

Working on multiple sheets at the same time
02:06

Find & Replace - Our favourite Excel tool
03:51

Quiz - Find & Replace
1 question


Quiz - Find & Replace Formatting
2 questions

Create easily printable documents by using Set Print Area
01:12

What Are Circular References in Excel?
05:06

Circular References - An example
02:22

Quiz - Circular References
1 question

Trace precedents - Display the relationship between formulas and cells
04:50

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

Advanced Excel functions: Sum; Sumif; Sumifs
04:20

Advanced Excel functions: Round functions
04:08

Advanced Excel functions: Iferror
01:56
+
Day 4: Advanced Excel functions - Part 1
8 Lectures 47:49
Advanced Excel functions: Vlookup & Hlookup
08:27

Advanced Excel functions: Index; Match; Index & Match
07:26


Advanced Excel functions: Indirect; Vlookup & Indirect
05:52

Advanced Excel functions: Rows; Columns; Vlookup & Columns
05:21


Advanced Excel functions: Choose; Vlookup & Choose
05:49

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

Discounting Cash flows and calculating Net Present Value (NPV)
07:02

Financial functions: IRR
03:30

Financial functions: PMT and building a complete loan schedule
06:16

Date functions
05:52
+
Day 6: Excel Tips & Tricks
4 Lectures 25:08
Excel tips & tricks: Part 1
06:39


Excel tips & tricks: Part 3
06:35

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


Financial modeling Don'ts - Worst practices we should avoid
05:49

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

The different types of models
04:42

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

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
02:51

How to build a complete model
02:15

Forecasting Income statement financials
05:58

Forecasting Balance sheet financials - Part one
02:34

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

Let's create a mapping of financials
02:49

Building an output P&L sheet
04:07

Filling in the output P&L sheet with historical financials
02:57

Calculating percentage variances and applying conditional formatting
03:14

Building an output Balance sheet
03:54

Using Index, Match, Match to fill in the output Balance sheet
05:10

Adding the forecast period
04:18
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.