The Complete Financial Analyst Course 2016

S$205.00
Take This Course
The Complete Financial Analyst Course 2016

Course Description
Next Update: FP&A and Budgeting (coming in July 2016)

“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.” Forbes

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

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 a number of 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
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 have the right amount of training for each of these critical aspects.

Here comes the fun part!

We have a challenge for you! After each major block you have covered, 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 get back to you 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 in order to become a top notch Financial Analyst
Extensive Case Studies that will 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
Bonus prizes: Upon completion of 50% and 100% of the course, you will receive two bonus gifts
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 challenge your existing skills
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Students of this course, who complete 50% of the lessons, get full, lifetime access to our five-star rated course, “Job Search Success Strategies: Proven Job Hunting Strategies.” It has a full price of $95.

Students of this course, who complete 100% of the lessons, get full, lifetime access to our five-star rated course, “Financial Modeling: Build a Complete DCF Valuation Model.” It has a full price of $95.

All students who complete the course and send us their solutions for the Course Challenge will:

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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?

What are the requirements?
Absolutely no experience is required. We will start from the basics and gradually build up your knowledge. Everything is in the course.
You will need Microsoft Excel 2010, 2013, or 2016
You will need Microsoft PowerPoint 2010, 2013, or 2016
What am I going to get from this course?
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!
What is the target audience?
People who want a successful career in Finance
Anyone who wants to learn the practical skills of Financial Analysis
People who are ambitious and want to learn faster than their peers

Curriculum

Section 1: Welcome! Course Introduction
What Does the Course Cover?
03:26
Everything We Will Learn Has a Practical Application
03:27
The Best Way to Take This Course
02:16
Section 2: Microsoft Excel – Quick Introduction
Microsoft Excel: The World’s #1 Software for the Office
01:00
Excel Made Easy: A Beginner’s Guide to Excel Spreadsheets
03:34
A Quick Tour of the Excel Ribbon
02:43
Data Entry Techniques in Excel
03:00
Data Entry Techniques in Excel
1 question
How to Make Your Spreadsheets Look Professional
05:52
Inserting, Deleting, and Modifying Rows & Columns
01:49
Inserting, Deleting, and Modifying Rows & Columns
1 question
Excel Formulas for Beginners
03:01
Excel Formulas for Beginners
1 question
A Beginner’s Introduction to Excel Functions
03:50
Work Efficiently by Using Cut, Copy, and Paste
02:15
Work Efficiently by Using Cut, Copy, and Paste
1 question
Section 3: Microsoft Excel – Useful Tools
Inserting a Line Break with Alt + Enter
00:54
Do More with Your Sales Data with Excel’s Text to Columns Feature
02:05
Do More with Your Sales Data with Excel’s Text to Columns Feature
1 question
Create Easily Printable Excel Documents
01:17
How to Wrap Text in Excel and Adjust a Cell’s Size
00:47
Macros Are a Great Timesaver! Here’s Why.
03:04
Macros Are a Great Timesaver! Here’s Why.
1 question
Insert Hyperlinks in Excel Spreadsheets
02:05
Using Excel’s Freeze Panes to Handle Large Datasets
01:16
Find Excel Functionalities in a Quicker Way – Tell Me What You Want to Do
00:46
A Quick Introduction to Excel’s Pivot Tables
02:17
Section 4: Microsoft Excel – Best Practices That Will Make a Difference
Initial Formatting Is Key for Creating Professional – Looking Spreadsheets
02:05
The Secret to Faster Scrolling in Excel
01:40
The Secret to Faster Scrolling in Excel
1 question
Using Absolute and Relative Cell References
02:20
Using Absolute and Relative Cell References
1 question
Find and Select Cells That Meet Specific Conditions
01:45
Find and Select Cells That Meet Specific Conditions
1 question
How to Create Dynamic Names in Excel Spreadsheets
01:27
How to Create Dynamic Names in Excel Spreadsheets
1 question
Using Named Ranges to Make Formulas More Readable
01:39
Custom Number Formatting
01:42
How to Add a Drop-down List in Excel
01:58
Using Custom-sort to Sort Multiple Columns Within a Table
01:28
Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts
04:38
Quiz Number 1
5 questions
Section 5: Microsoft Excel – Beginner, Intermediate & Advanced Functions
Key Excel Functions: Sum, Sumif, Sumifs
04:24
Key Excel Functions: Count, Counta, Countif, Countifs
04:06
Key Excel Functions: Average & Averageif
01:59
Key Excel Functions: Average & Averageif
1 question
Key Excel Functions: Left, Right, Mid, Upper, Lower, Proper, Concatenate, &
04:29
Key Excel Functions: Left, Right, Mid, Upper, Lower, Proper, Concatenate, &
1 question
Find the Highest and the Lowest Values in a Range: Max & Min
00:52
Use Round in Your Financial Models
01:01
Excel’s Lookup Functions: Vlookup & Hlookup Made Easy
07:47
Index, Match, and Their Combination – The Perfect Substitute of Vlookup
07:27
Index, Match, and Their Combination – The Perfect Substitute of Vlookup
1 question
Using Excel’s Iferror Function to Trap Spreadsheet Errors
01:43
Create Flexible Financial Models with Choose
02:24
Goal Seek Will Help You Find the Result You Are Looking For
02:17
Goal Seek Will Help You Find the Result You Are Looking For
1 question
Perform Sensitivity Analysis with Excel’s Data Tables Functionality
04:10
Perform Sensitivity Analysis with Excel’s Data Tables Functionality
1 question
Quiz Number 2
5 questions
Section 6: Microsoft Excel – Practical Exercise “Build a P&L From Scratch”
Understand Your Data Source Before You Start Working on It
02:42
Ordering the Source Worksheet
02:03
Create a Code: The Best Way to Organize Your Data and Work Efficiently with It
01:54
Learn How to Create a Database
02:00
Using Lookup Functions (Vlookup) to Fill the Database Sheet
05:26
Use Sumif to Complete the Database Sheet
04:10
Using Index & Match as a Substitute of Vlookup
04:04
Mapping of the Rows in the Database Sheet
02:12
Building the Structure of the P&L Sheet
02:13
A Practical Example of Professional Formatting in Excel
03:23
Populate the P&L Sheet with Sumif
05:32
Learn How to Find Mistakes with Countif
02:24
Calculating Growth Rates in Excel
03:10
Quiz Number 3
3 questions
Section 7: Microsoft Excel – Building Professional Charts in Excel
Introduction to Excel Charts
01:11
Beginner’s Guide to Inserting Charts in Excel
02:10
Modifying Excel Charts – The Easy Way to Do It
02:29
Make Your Excel Charts Look Sexier – Proven Tips
03:09
Creating a Bridge Chart in Excel 2016 – As Easy as It Gets
01:42
New Ways to Visualize Your Data – Treemap Charts
01:31
How to Represent Trends with Sparklines
03:52
Section 8: Microsoft Excel – Working with Pivot Tables in Excel
Pivot Tables – Excel’s Dynamic and Interactive Tables
01:35
Creating a Pivot Table: Choosing Row and Column Parameters
03:47
Design the Layout and Format of Your Pivot Tables
02:14
Additional Techniques That Will Ease Your Work with Pivot Tables
04:33
One of the Most Useful Excel Functions – GetPivotData
03:45
Welcome to the Future – Pivot Table Slicers
04:20
Introduction to the Course Challenge
01:04
COURSE CHALLENGE – Part 1
01:26
Section 9: Pivot Tables & Slicers in Practice – World-Class Financial Reporting Shown Here
Introduction to the Case Study
02:09
Working with an SAP data extraction
03:23
Preliminary mapping of the data extraction
02:10
Creating an output structure of the FMCG model
02:29
Improving the layout and appearance of the FMCG report
03:59
Inserting formulas and automating calculations
02:30
Creating a Master Pivot Table: The main data source for the FMCG report
01:55
GetPivotData is great! Extracting data from the Master Pivot Table
05:45
Combining Slicers and GetPivotData: The key to our success
03:20
Getting fancy with Excel slicers – Good-looking Excel slicers
03:12
This is how the report can be used in practice by high-level executives
03:59
Section 10: Accounting – Introduction to Accounting & Bookkeeping
Accounting: The Science Behind Financial Figures
01:30
What is Accounting and Why Do You Need It
05:11
The Importance of Bookkeeping – Good Accounting Records Are Essential
02:34
An Introduction to Financial Accounting
02:48
Quiz Number 3
2 questions
Section 11: Accounting – The Three Main Statements in Financial Accounting
The Three Core Financial Statements: P&L, Balance Sheet and Cash Flow
02:14
The Key Accounts You Will Find in a P&L
06:06
The Main Balance Sheet Items
04:40
Quiz Number 4
3 questions
Section 12: Accounting – Understanding the Big Picture: Why, What, When, and How Much
The Revenue Recognition Principle – Why Is it so Important?
02:19
The Expense Recognition Principle – When to Recognize Expenses
02:02
Historical Cost vs. Fair Value Accounting
02:14
Section 13: Accounting – The Core Principles of Accounting
The Accounting Equation and Its Importance
02:05
Elements of the Accounting System: General Ledger
01:47
T-Accounts: The Best Way to Understand Debits and Credits
04:24
P&L T-Accounts
03:01
How to Calculate Depreciation Expense
04:27
The Double-Entry Principle – The Core Principle of Bookkeeping
05:19
Quiz Number 5
4 questions
Section 14: Accounting – Practical Exercise: The Accounting Transactions of a Lemonade Stand
Case Study – The Accounting Transactions of a Lemonade Stand (1/4)
10:24
Case Study – The Accounting Transactions of a Lemonade Stand (2/4)
07:39
Case Study – The Accounting Transactions of a Lemonade Stand (3/4)
07:30
Case Study – The Accounting Transactions of a Lemonade Stand (4/4)
08:14
Section 15: Accounting – Preparing a Cash Flow Statement: Understanding Cash Flow Analysis
Calculating Cash Flows – Understand if a business makes or burns cash
02:36
The three parts of Cash Flow statements explained
02:09
Cash Flow computations – The Direct method
01:59
Cash Flow computations – The Indirect method
03:34
Calculating Cash Flow in practice: A complete example
06:18
Section 16: Accounting – The Importance of Timing
Timing of Cash Flows and Why It Plays an Important Role for a Business
01:18
Timing of Income: Principles of Revenue Recognition
06:16
Timing of Expenses: Principles of Cost Recognition
03:51
The Four Type of Accruals Arising in Accounting Transactions
04:15
Quiz Number 6
3 questions
Section 17: Accounting – Introduction to Financial Statement Analysis
What is a 10-K Report and Why Is It important for Investors?
02:33
Finding, Downloading and Going Through the Annual Report of P&G
06:53
What is the Role of Auditing Firms and What Are the Benefits of an Audit?
02:33
Indispensable Tools for Financial Statement Analysis
01:41
Quiz Number 7
2 questions
Section 18: Accounting – Subtleties of Financial Statement Analysis
Financial Statement Analysis – A Natural Continuation of Financial Accounting
01:58
First Steps in Financial Statement Analysis
03:02
Horizontal vs. Vertical Financial Statement Analysis
03:37
Calculating Days Payable (DPO), Days Receivable (DSO) and Days Inventory (DIO)
01:23
Using Accounting Ratios to Assess Business Performance
07:36
Quiz Number 8
2 questions
Section 19: Accounting – Practical Case Study “Analyzing P&G’s Financials”
Case Study – Calculating Ratios and Analyzing P&G’s Financials (1/2)
06:55
Case Study – Calculating Ratios and Analyzing P&G’s Financials (2/2)
04:43
COURSE CHALLENGE – Part 2
01:42
Section 20: Fundamentals of Business & Financial Analysis
Fundamentals of Business & Financial Analysis
41 pages
Section 21: Finance 101 – The Time Value of Money and Interest Rate Components
Finance 101: Important Financial Principles That You Will Need
00:44
Understanding the Time Value of Money
01:29
Why Interest Rates Play an Important Role in the Economy?
01:27
The Components Forming Interest Rates in Real Life
02:59
What Is Libor and What Does It Serve For?
01:07
The Difference Between Fixed and Variable Interest Rates
01:58
What Is Default Risk and How Does a Bank Account For It?
06:39
Corporate Loan Specifics
01:42
Section 22: Finance 101 – The Value of Cash Flows with Different Timing
Calculating the Present Value of Future Cash Flows
05:11
A Tool That Helps Us Decide Whether a Project Is Feasible: Net Present Value
04:00
COURSE CHALLENGE – Part 3
01:17
Section 23: PowerPoint – Introduction to PowerPoint
Microsoft PowerPoint: The Most Popular Presentation Software for the Office
00:51
The Structure of the PowerPoint Ribbon
05:14
General Considerations About Slide Structure
03:57
Learn How to Insert Objects in PowerPoint
04:06
Shortcuts Allow Us To Be Much Faster When Working in PowerPoint
02:33
Add Frequently Used Buttons to the Quick Access Toolbar
03:23
How to Easily Align Objects in PowerPoint
03:53
Editing Shapes in Your Presentation – The Format Shape Menu
04:46
How to Format Text Boxes in a PowerPoint Presentation
03:51
Changing an Object’s Size and Learning About Rotation Options
01:39
Work Efficiently By Using Slide Masters
04:25
Section 24: PowerPoint – Tips & Tricks That Will Transform You Into An Advanced User
Modifying the Beginning and Ending of a Line Object
01:46
Join Shapes Together By Using Connector Lines
03:46
Group or Ungroup Shapes, Pircutres or Other Objects
01:45
This is How You Can Fit Text When It Is Larger than a Shape
02:03
PowerPoint’s Smart Art Feature Offers Great Return for Your Time
03:32
Creating Eye-Catching Text Effects in PowerPoint
02:04
Practical Exercise – Creating an Organisational Chart
07:58
COURSE CHALLENGE – Part 4
02:34

Instructor Biography
365 Careers, Creating opportunities for Business & Finance students
365 Careers is a firm specializing in high-end financial training programs. Our growing list of courses includes Excel (Microsoft Excel for Beginner and Advanced users), PowerPoint, Financial Modeling, Company Valuation, Accounting and Investment Banking trainings. Our goal is to provide to our students the practical instruments that they will need in order to perform successfully at their future workplace.

Microsoft Excel and PowerPoint are the top productivity tools in today’s corporate world. By choosing our trainings, you will be well on your way of becoming an expert in MS Excel and PowerPoint.

Course Features

  • Lectures
    Fatal error: Uncaught Error: Call to undefined method LP_Course::get_lessons() in /home2/waf6oo0adwwo/public_html/wp-content/themes/eduma/inc/learnpress-v2-functions.php:624 Stack trace: #0 /home2/waf6oo0adwwo/public_html/wp-content/themes/eduma/learnpress-v2/single-course/content-landing.php(64): thim_course_info() #1 /home2/waf6oo0adwwo/public_html/wp-content/plugins/learnpress/inc/lp-template-functions.php(2492): include('/home2/waf6oo0a...') #2 /home2/waf6oo0adwwo/public_html/wp-content/themes/eduma/learnpress-v2/content-single-course.php(65): learn_press_get_template('single-course/c...', Array) #3 /home2/waf6oo0adwwo/public_html/wp-content/plugins/learnpress/inc/lp-template-functions.php(2492): include('/home2/waf6oo0a...') #4 /home2/waf6oo0adwwo/public_html/wp-content/plugins/learnpress/inc/lp-template-functions.php(1563): learn_press_get_template('content-single-...') #5 /home2/waf6oo0adwwo/public_html/wp-includes/class-wp-hook.php(286): learn_press_content_single_course('') #6 /home2/waf6oo0adwwo/public_html/wp-i in /home2/waf6oo0adwwo/public_html/wp-content/themes/eduma/inc/learnpress-v2-functions.php on line 624