Beginner to Pro - Financial Analysis in Excel 2017
4.2 (14 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.
2,454 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Beginner to Pro - Financial Analysis in Excel 2017 to your Wishlist.

Add to Wishlist

Beginner to Pro - Financial Analysis in Excel 2017

Become an Excel power user by learning all the functions, formulas, and formatting you will need to for finance
4.2 (14 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.
2,454 students enrolled
Created by ThinkTank Careers
Last updated 5/2017
English
English
Curiosity Sale
Current price: $23 Original price: $95 Discount: 75% off
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 4 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • How to build a professional financial analysis setup
  • How to use powerful Excel functions and formulas
  • How to build pivot tables
  • Financial modeling
  • Recording Macros
  • Build dynamic queries
  • Build drop down lists
  • Clean formatting
  • Forecasting
  • Build dashboards
  • Integrated financial statements
  • Entering numbers in excel
  • Basic application and how to use Excel
View Curriculum
Requirements
  • The capability to download Microsoft Excel to your computer
  • Eagerness to learn
  • Basic finance knowledge
Description

Why this course is for you

You want to increase your Excel skills to become more efficient at work, school, or any personal project. You want to learn powerful Excel functions that will allow you to automate much of your work and make your life easier.  You want to learn how to setup and format different financial setups and use advance functions to deeper analyze your data.

The functions and formulas you will learn will not only teach you how to use Excel for finance, but it will teach you tools to become an Excel power user in other areas. I will teach you shortcuts and tips that will impress anyone employer.

At the end of each section I have also created quizzes for you to make sure you are understanding the concepts and remember them for life!

What you will learn:

  1. The basics of excel: how to input numbers, how to input formulas, and the different functions of Excel
  2. How to create a professional financial analysis setup
  3. Build a common size income statement
  4. Functions that will help you analyze your data at a deeper
  5. Create multiple scenarios
  6. Vlookup, hlookup, index & match functions
  7. How to build dynamic queries
  8. Finance functions (NPV, IRR, Payback Period)
  9. How to create a macro
  10. How to create integrated financial statements (Balance Sheet, Income Statement, Statement of Cash Flows)
  11. How to create debt schedules and pp&e schedules
  12. Forecasting revenues
  13. Running a statistical regression
  14. How to create pivot tables and dashboards

What you will need:

  1. A computer, laptop, or tablet
  2. Microsoft Excel
  3. Hunger to learn 

30-day money back guarantee

In the rare case that you feel the course was not helpful or isn't for you I will refund your money up to 30 days.  You have nothing to lose and everything to gain.


Who is the target audience?
  • Anyone looking to master Excel with a focus on finance
  • Anyone who is looking to go into the finance profession
  • Anyone studying finance or taking a finance course
  • Anyone who wants to use Excel for their own business
Students Who Viewed This Course Also Viewed
Curriculum For This Course
36 Lectures
03:06:09
+
Introduction
2 Lectures 02:27
+
Excel Overview
1 Lecture 07:02
Basic Overview
07:02
+
Simple Financial Setup
4 Lectures 19:20
Objectives
00:31

Freeze Panes, Formatting,
06:51

Simple Forecasting, Copy & Paste, Percentages
08:47

Formatting, Grouping, Copy Tabs
03:11

Simple Setup Quiz
3 questions
+
Simple Functions
5 Lectures 23:35
Objectives
00:34

Averages, Weighted Averages, Median
05:12

Dates
05:10


Min, Max, Small, Large
05:17

Simple Functions Quiz
3 questions
+
Advanced Financial Setup
3 Lectures 10:50
Objectives
00:36

Common Size Income Statement
05:20

Naming Cells
04:54

Advanced Setup Quiz
1 question
+
Advanced Functions
4 Lectures 27:25
Objectives
00:39

Data Validation, Drop Down List
10:00

Vlookup, Hlookup, Index & Match
10:23

NPV, IRR, Payback Period
06:23

Advanced Functions Quiz
3 questions
+
Macros
2 Lectures 05:46
Objectives
00:19

Macros
05:27
+
Times Series Forecasting
4 Lectures 25:44
Objectives
00:32

Forecasting Part 1
06:17

Forecasting Part 2
09:20

Forecasting Part 3
09:35

Forecasting Quiz
2 questions
+
Financial Modeling
6 Lectures 34:52
Objectives
00:33

Income Statement
06:58

Balance Sheet
08:17

Statement of Cash Flows
05:08


PP&E Schedule
05:00

Financial Modeling Quiz
3 questions
+
Pivot Table & Dashboard
4 Lectures 28:32
Objectives
00:33

Pivot Table 1
07:26

Pivot Table 2
06:57

Dashboards
13:36
1 More Section
About the Instructor
ThinkTank Careers
4.3 Average rating
18 Reviews
3,121 Students
3 Courses
ThinkTank Careers

ThinkTank Careers is a team of professional businessmen and women who have come together to educate individuals in our respective professions.  All of our teachers are college graduates with years of work experience in our fields. Our careers range from finance to management to bloggers. We are diverse group of individuals who hope to educate as many students as possible.  

* Please note discounts may be slightly higher than advertised amount due to rounding and currency conversion.