4.54 out of 5
4.54
10447 reviews on Udemy

The Complete Financial Analyst Course 2018

Excel, Accounting, Financial Statement Analysis, Business Analysis, Financial Math, PowerPoint: Everything is Included!
Instructor:
365 Careers
80,174 students enrolled
English [Auto-generated] More
Work comfortably with Microsoft Excel
Format spreadsheets in a professional way
Be much faster carrying out regular tasks
Create professional charts in Microsoft Excel
Work with large amounts of data without difficulty
Understand Accounting and Bookkeeping principles
Build a company’s P&L from scratch
Build a company’s Balance Sheet from scratch
Perform Financial Statement Analysis
Understand the importance of timing in terms of revenue and cost recognition
Calculate Liquidity, Solvency, Profitability, and Growth ratios in order to analyze a company’s performance
Understand 10-K reports
Assess whether a project is feasible through the Net Present Value Technique
Calculate a complete loan schedule
Understand the difference between variable and fixed interest rates
Perform industry analysis
Understand what drives a company’s value
Know how to analyze a business
Work comfortably with Microsoft PowerPoint
Create professional company presentations in PowerPoint
Become a successful Financial Analyst in no time – if you follow the course fully!

**Updated for December 2018!**

“If you’re trying to prepare for an eventual career in finance, but are still looking to round out your knowledge of the subject, The Complete Financial Analyst Course might be a perfect fit for you.”, Business Insider

“A Financial Analyst Career is one of the top-paying entry-level jobs on the market.” 

“Even in the toughest job markets, the best candidates find great positions.”, Forbes

You simply have to find a way to acquire practical skills that will give you an edge over the other candidates.

But how can you do that?

You haven’t had the proper training, and you have never seen how analysts in large firms do their work …

Stop worrying, please! We are here to help.

The Complete Financial Analyst Course is the most comprehensive, dynamic, and practical course you will find online.

It covers several topics, which are fundamental for every aspiring Financial Analyst:

  • Microsoft Excel for Beginner and Intermediate Users: Become Proficient with the world’s #1 productivity software

  • Accounting, Financial Statements, and Financial Ratios: Making Sense of Debits and Credits, Profit and Loss statements, Balance Sheets, Liquidity, Solvency, Profitability, and Growth Financial Ratios

  • Finance Basics: Interest Rates, Financial Math Calculations, Loan Calculations, Time Value of Money, Present and Future Value of Cash Flows

  • Business Analysis: Understanding what drives a Business, Key Items to be Analyzed and their Meaning, the Importance of Industry Cycles, Important Drivers for the Business of Startup, Growth, Mature and Declining Companies, Important Drivers for an Industry

  • Capital Budgeting: Decide whether a company’s project is feasible from a financial perspective and be able to compare between different investment opportunities

  • Microsoft PowerPoint for Beginner and Intermediate Users: The #1 tool for visual representation of your work, a necessary skill for every Financial Analyst

As you can see, this is a complete bundle that ensures you will receive the right training for each critical aspect.

Here comes the fun part!

We have a challenge for you! After covering each major roadblock, you will be asked to solve a challenge. You will:

  • Calculate a company’s sales in Excel

  • Register its bookkeeping entries for 2015 and produce useful financial statements + calculate financial ratios

  • Calculate a complete loan schedule for the company’s debt

  • Analyze the company’s business performance

  • Create a PowerPoint presentation based on the results

  • Receive personalized feedback

  • Receive a gift

  • Participate in our monthly Amazon Gift Card Lottery(!)

Sounds interesting, right?

At the end of the challenge, you will send us the work you’ve done, and we will reply with personalized feedback. This makes for an interactive student experience that optimizes what you will learn from the course.

What makes this course different from the rest of the Finance courses out there?

  • High quality of production: HD video and animations (this isn’t a collection of boring lectures!)

  • Knowledgeable instructor (experience in companies like Pwc and Coca-Cola)

  • Complete training: We will cover all major topics and skills you need to become a top-class Financial Analyst

  • Extensive Case Studies: To help you reinforce everything you’ve learned

  • Course Challenge: Solve our Course Challenge and make this course an interactive experience

  • 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 business day

  • Dynamic: We don’t want to waste your time! The instructor keeps up a very good pace throughout the whole course

Why should you consider a career as a Financial Analyst?

  • Salary. A Financial Analyst job usually leads to a very well-paid career

  • Promotions. Financial Analysts acquire valuable technical skills, which makes them the leading candidates for senior roles within a corporation

  • Secure Future. There is high demand for Financial Analysts on the job market, and you won’t have to be concerned about finding a job

  • Growth. This isn’t a boring job. Every day, you will face different challenges that will test your existing skills

Please don’t forget that 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!

Welcome! Course Introduction

1
What Does the Course Cover?
2
Everything We Will Learn Has a Practical Application
3
The Best Way to Take This Course
4
Download all course materials

Microsoft Excel - Quick Introduction

1
Microsoft Excel: The World's #1 Office Software
2
Excel Made Easy: A Beginner's Guide to Excel Spreadsheets
3
Data Entry Techniques in Excel
4
How to Make Your Spreadsheets Look Professional
5
Data Entry Techniques in Excel
6
Inserting, Deleting, and Modifying Rows & Columns
7
Inserting, Deleting, and Modifying Rows & Columns
8
Excel Formulas for Beginners
9
Excel Formulas for Beginners
10
A Beginner's Introduction to Excel Functions
11
Work Efficiently by Using Cut, Copy, and Paste
12
Work Efficiently by Using Cut, Copy, and Paste
13
Pasting Values, Formulas and Formats with Paste Special

Microsoft Excel - Useful Tools

1
Inserting a Line Break with Alt + Enter
2
Do More with Your Sales Data with Excel's Text to Columns Feature
3
Do More with Your Sales Data with Excel's Text to Columns Feature
4
Create Easily Printable Excel Documents
5
How to Wrap Text in Excel and Adjust a Cell's Size
6
Insert Hyperlinks into Excel Spreadsheets
7
Using Excel's Freeze Panes to Handle Large Datasets
8
Find Excel Functionalities in a Quicker Way - Tell Me What You Want to Do
9
A Quick Introduction to Excel's Pivot Tables

Microsoft Excel - Best Practices That Will Make a Difference

1
Initial Formatting Is Key for Creating Professional-looking Spreadsheets
2
Macros Are a Great Timesaver! Here's Why.
3
Macros Are a Great Timesaver! Here's Why.
4
The Secret to Faster Scrolling in Excel
5
The Secret to Faster Scrolling in Excel
6
Using Absolute and Relative Cell References
7
Using Absolute and Relative Cell References
8
Find and Select Cells That Meet Specific Conditions
9
Find and Select Cells That Meet Specific Conditions
10
How to Create Dynamic Names in Excel Spreadsheets
11
How to Create Dynamic Names in Excel Spreadsheets
12
Using Named Ranges to Make Formulas More Readable
13
Custom Number Formatting
14
How to Add a Drop-down List in Excel
15
Using Custom-sort to Sort Multiple Columns Within a Table
16
Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts
17
Quiz Number 1

Microsoft Excel - Beginner, Intermediate & Advanced Functions

1
Key Excel Functions: Sum, Sumif, Sumifs
2
Key Excel Functions: Count, Counta, Countif, Countifs
3
Key Excel Functions: Average & Averageif
4
Key Excel Functions: Left, Right, Mid, Upper, Lower, Proper, Concatenate, &
5
Key Excel Functions: Left, Right, Mid, Upper, Lower, Proper, Concatenate, &
6
Find the Highest and Lowest Values in a Range: Max & Min
7
Use Round in Your Financial Models
8
Excel's Lookup Functions: Vlookup & Hlookup Made Easy
9
Index, Match, and Their Combination - The Perfect Substitute for Vlookup
10
Index, Match, and Their Combination - The Perfect Substitute for Vlookup
11
Using Excel's Iferror Function to Trap Spreadsheet Errors
12
Create Flexible Financial Models with Choose
13
Goal Seek Will Help You Find the Result You Are Looking For
14
Goal Seek Will Help You Find the Result You Are Looking For
15
Perform Sensitivity Analysis with Excel's Data Tables Functionality
16
Perform Sensitivity Analysis with Excel's Data Tables Functionality
17
Quiz Number 2

Microsoft Excel - Financial functions in Excel

1
Discounting cash flows in Microsoft Excel
2
Calculating Internal Rate of Return (IRR) in Excel
3
Using the PMT function to create a complete loan schedule
4
Date functions in Excel

Microsoft Excel - Practical Exercise "Build a P&L From Scratch"

1
Understand Your Data Source Before You Start Working on It
2
Ordering the Source Worksheet
3
Create a Code: The Best Way to Organize Your Data and Work Efficiently with It
4
Learn How to Create a Database
5
Using Lookup Functions (Vlookup) to Fill the Database Sheet
6
Use Sumif to Complete the Database Sheet
7
Using Index & Match as a Substitute for Vlookup
8
Mapping the Rows in the Database Sheet
9
Building the Structure of the P&L Sheet
10
A Practical Example of Professional Formatting in Excel
11
Populate the P&L Sheet with Sumif
12
Learn How to Find Mistakes with Countif
13
Calculating Growth Rates in Excel
14
Quiz Number 3

Microsoft Excel - Building Professional Charts in Excel

1
Introduction to Excel Charts
2
Beginner's Guide to Inserting Charts in Excel
3
Modifying Excel Charts - The Easy Way
4
Making Your Excel Charts Sexier - Proven Tips
5
Creating a Bridge Chart in Excel 2016 - As Easy as It Gets
6
New Ways to Visualize Your Data - Treemap Charts
7
How to Represent Trends with Sparklines

Microsoft Excel - Working with Pivot Tables in Excel

1
Pivot Tables - Excel's Dynamic and Interactive Tables
2
Creating a Pivot Table: Choosing Row and Column Parameters
3
Design the Layout and Format of Your Pivot Tables
4
Additional Techniques That Will Ease Your Work with Pivot Tables
5
One of the Most Useful Excel Functions - GetPivotData
6
Welcome to the Future - Pivot Table Slicers
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.5
4.5 out of 5
10447 Ratings

Detailed Rating

Stars 5
5934
Stars 4
3229
Stars 3
984
Stars 2
195
Stars 1
105
65bd526d4cb48406b424c27ddb60f9f3
30-Day Money-Back Guarantee

Includes

16 hours on-demand video
2 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion
Demos
Support Buy $0