Financial Analyst for 2020

By ResearcherStore Categories: B-Business
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

Financial Analyst for 2020

“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:

  1. Microsoft Excel for Beginner and Intermediate Users: Become Proficient with the world’s #1 productivity software
  2. 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
  3. Finance Basics: Interest Rates, Financial Math Calculations, Loan Calculations, Time Value of Money, Present and Future Value of Cash Flows
  4. 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
  5. Capital Budgeting: Decide whether a company’s project is feasible from a financial perspective and be able to compare different investment opportunities
  6. Microsoft PowerPoint for Beginner and Intermediate Users: The #1 tool for a 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:

  1. Calculate a company’s sales in Excel
  2. Register its bookkeeping entries and produce useful financial statements + calculate financial ratios
  3. Calculate a complete loan schedule for the company’s debt
  4. Analyze the company’s business performance
  5. Create a PowerPoint presentation based on the results
  6. Receive personalized feedback
  7. Receive a gift

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?

  1. High quality of production: HD video and animations (this isn’t a collection of boring lectures!)
  2. Knowledgeable instructor (experience in companies like Pwc and Coca-Cola)
  3. Complete training: We will cover all major topics and skills you need to become a top-class Financial Analyst
  4. Extensive Case Studies: To help you reinforce everything you’ve learned
  5. Course Challenge: Solve our Course Challenge and make this course an interactive experience
  6. 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
  7. 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?

  1. Salary. A Financial Analyst job usually leads to a very well-paid career
  2. Promotions. Financial Analysts acquire valuable technical skills, which makes them the leading candidates for senior roles within a corporation
  3. Secure Future. There is a high demand for Financial Analysts on the job market, and you won’t have to be concerned about finding a job
  4. Growth. This isn’t a boring job. Every day, you will face different challenges that will test your existing skills

 

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 this course is for:

  1. People who want a successful career in Finance
  2. Anyone who wants to learn the practical skills of Financial analysis
  3. People who are ambitious and want to learn faster than their peers
Show More

What Will You Learn?

  • 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 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!

Course Content

The Complete Financial Analyst Course

  • 001 What Does the Course Cover
    03:27
  • 002 Everything We Will Learn Has a Practical Application
    00:00
  • 003 The Best Way to Take This Course
    00:00
  • 004 Microsoft Excel The Worlds 1 Software for the Office
    00:00
  • 005 Excel Made Easy A Beginners Guide to Excel Spreadsheets
    00:00
  • 006 Data Entry Techniques in Excel
    00:00
  • 007 How to Make Your Spreadsheets Look Professional
    00:00
  • 008 Inserting Deleting and Modifying Rows Columns
    00:00
  • 009 Excel Formulas for Beginners
    00:00
  • 010 A Beginners Introduction to Excel Functions
    00:00
  • 011 Work Efficiently by Using Cut Copy and Paste
    00:00
  • 012 Pasting Values Formulas and Formats with Paste Special
    00:00
  • 013 Inserting a Line Break with Alt Enter
    00:00
  • 015 Create Easily Printable Excel Documents
    00:00
  • 016 How to Wrap Text in Excel and Adjust a Cells Size
    00:00
  • 017 Insert Hyperlinks in Excel Spreadsheets
    00:00
  • 018 Using Excels Freeze Panes to Handle Large Datasets
    00:00
  • 019 Find Excel Functionalities in a Quicker Way Tell Me What You Want to Do
    00:00
  • 020 A Quick Introduction to Excels Pivot Tables
    00:00
  • 021 Initial Formatting Is Key for Creating Professional Looking Spreadsheets
    00:00
  • 022 Macros Are a Great Timesaver Heres Why
    00:00
  • 023 The Secret to Faster Scrolling in Excel
    00:00
  • 024 Using Absolute and Relative Cell References
    00:00
  • 026 How to Create Dynamic Names in Excel Spreadsheets
    00:00
  • 027 Using Named Ranges to Make Formulas More Readable
    00:00
  • 028 Custom Number Formatting
    00:00
  • 029 How to Add a Drop down List in Excel
    00:00
  • 030 Using Custom sort to Sort Multiple Columns Within a Table
    00:00
  • 031 Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts
    00:00
  • 032 Key Excel Functions Sum Sumif Sumifs
    00:00
  • 033 Key Excel Functions Count Counta Countif Countifs
    00:00
  • 034 Key Excel Functions Average Averageif
    00:00
  • 035 Key Excel Functions Left Right Mid Upper Lower Proper Concatenate
    00:00
  • 036 Find the Highest and the Lowest Values in a Range Max Min
    00:00
  • 037 Use Round in Your Financial Models
    00:00
  • 038 Excels Lookup Functions Vlookup Hlookup Made Easy
    00:00
  • 039 Index Match and Their Combination The Perfect Substitute of Vlookup
    00:00
  • 040 Using Excels Iferror Function to Trap Spreadsheet Errors
    00:00
  • 041 Create Flexible Financial Models with Choose
    00:00
  • 042 Goal Seek Will Help You Find the Result You Are Looking For
    00:00
  • 043 Perform Sensitivity Analysis with Excels Data Tables Functionality
    00:00
  • 044 Understand Your Data Source Before You Start Working on It
    00:00
  • 045 Ordering the Source Worksheet
    00:00
  • 046 Create a Code The Best Way to Organize Your Data and Work Efficiently with It
    00:00
  • 047 Learn How to Create a Database
    00:00
  • 048 Using Lookup Functions Vlookup to Fill the Database Sheet
    00:00
  • 049 Use Sumif to Complete the Database Sheet
    00:00
  • 050 Using Index Match as a Substitute of Vlookup
    00:00
  • 051 Mapping of the Rows in the Database Sheet
    00:00
  • 052 Building the Structure of the PL Sheet
    00:00
  • 053 A Practical Example of Professional Formatting in Excel
    00:00
  • 054 Populate the PL Sheet with Sumif
    00:00
  • 055 Learn How to Find Mistakes with Countif
    00:00
  • 056 Calculating Growth Rates in Excel
    00:00
  • 057 Introduction to Excel Charts
    00:00
  • 058 Beginners Guide to Inserting Charts in Excel
    00:00
  • 059 Modifying Excel Charts The Easy Way to Do It
    00:00
  • 060 Make Your Excel Charts Look Sexier Proven Tips
    00:00
  • 061 Creating a Bridge Chart in Excel 2016 As Easy as It Gets
    00:00
  • 062 New Ways to Visualize Your Data Treemap Charts
    00:00
  • 063 How to Represent Trends with Sparklines
    00:00
  • 064 Pivot Tables Excels Dynamic and Interactive Tables
    00:00
  • 065 Creating a Pivot Table Choosing Row and Column Parameters
    00:00
  • 066 Design the Layout and Format of Your Pivot Tables
    00:00
  • 067 Additional Techniques That Will Ease Your Work with Pivot Tables
    00:00
  • 068 One of the Most Useful Excel Functions GetPivotData
    00:00
  • 069 Welcome to the Future Pivot Table Slicers
    00:00
  • 070 Introduction to the Course Challenge
    00:00
  • 071 COURSE CHALLENGE Part 1
    00:00
  • 072 Introduction to the Case Study
    00:00
  • 073 Working with an SAP data extraction
    00:00
  • 074 Preliminary mapping of the data extraction
    00:00
  • 075 Creating an output structure of the FMCG model
    00:00
  • 076 Improving the layout and appearance of the FMCG report
    00:00
  • 077 Inserting formulas and automating calculations
    00:00
  • 078 Creating a Master Pivot Table The main data source for the FMCG report
    00:00
  • 079 GetPivotData is great Extracting data from the Master Pivot Table
    00:00
  • 080 Combining Slicers and GetPivotData The key to our success
    00:00
  • 081 Getting fancy with Excel slicers Good looking Excel slicers
    00:00
  • 082 This is how the report can be used in practice by high level executives
    00:00
  • 083 Introduction to the Exercise
    00:00
  • 084 Lets create a mapping of financials
    00:00
  • 085 Building an output PL sheet
    00:00
  • 086 Filling in the output PL sheet with historical financials
    00:00
  • 087 Calculating percentage variances and applying conditional formatting
    00:00
  • 088 Building an output Balance sheet
    00:00
  • 089 Using Index Match Match to fill in the output Balance sheet
    00:00
  • 090 Adding the forecast period
    00:00
  • 091 Calculating historical percentage ratios and use Index and Match for scenarios
    00:00
  • 092 Building a flexible model with Choose Match
    00:00
  • 093 Building a flexible model with Vlookup Columns
    00:00
  • 094 Calculating historical DSO DPO DIO Other assets and Other liabilities
    00:00
  • 095 Forecasting DSO DPO DIO Other assets and Other liabilities
    00:00
  • 096 Building a Fixed asset roll forward
    00:00
  • 097 Building a Financial liabilities schedule
    00:00
  • 098 Building an Equity schedule
    00:00
  • 099 Preparing a Cash flow structure
    00:00
  • 100 Calculating Cash flows and completing the model
    00:00
  • 101 Accounting The Science Behind Financial Figures
    00:00
  • 102 What is Accounting and Why Do You Need It
    00:00
  • 103 The Importance of Bookkeeping Good Accounting Records Are Essential
    00:00
  • 104 An Introduction to Financial Accounting
    00:00
  • 105 The Three Core Financial Statements PL Balance Sheet and Cash Flow
    00:00
  • 106 The Key Accounts You Will Find in a PL
    00:00
  • 107 The Main Balance Sheet Items
    00:00
  • 108 The Revenue Recognition Principle Why Is it so Important
    00:00
  • 109 The Expense Recognition Principle When to Recognize Expenses
    00:00
  • 110 Historical Cost vs Fair Value Accounting
    00:00
  • 111 The Accounting Equation and Its Importance
    00:00
  • 112 Elements of the Accounting System General Ledger
    00:00
  • 113 T Accounts The Best Way to Understand Debits and Credits
    00:00
  • 114 PL T Accounts
    00:00
  • 115 How to Calculate Depreciation Expense
    00:00
  • 116 The Double Entry Principle The Core Principle of Bookkeeping
    00:00
  • 117 Case Study The Accounting Transactions of a Lemonade Stand 14
    00:00
  • 118 Case Study The Accounting Transactions of a Lemonade Stand 24
    00:00
  • 119 Case Study The Accounting Transactions of a Lemonade Stand 34
    00:00
  • 120 Case Study The Accounting Transactions of a Lemonade Stand 44
    00:00
  • 121 Calculating Cash Flows Understand if a business makes or burns cash
    00:00
  • 122 The three parts of Cash Flow statements explained
    00:00
  • 123 Cash Flow computations The Direct method
    00:00
  • 124 Cash Flow computations The Indirect method
    00:00
  • 125 Calculating Cash Flow in practice A complete example
    00:00
  • 126 Timing of Cash Flows and Why It Plays an Important Role for a Business
    00:00
  • 127 Timing of Income Principles of Revenue Recognition
    00:00
  • 128 Timing of Expenses Principles of Cost Recognition
    00:00
  • 129 The Four Type of Accruals Arising in Accounting Transactions
    00:00
  • 130 What is a 10 K Report and Why Is It important for Investors
    00:00
  • 131 Finding Downloading and Going Through the Annual Report of PG
    00:00
  • 132 What is the Role of Auditing Firms and What Are the Benefits of an Audit
    00:00
  • 133 Indispensable Tools for Financial Statement Analysis
    00:00
  • 136 Horizontal vs Vertical Financial Statement Analysis
    00:00
  • 137 Calculating Days Payable DPO Days Receivable DSO and Days Inventory DIO
    00:00
  • 138 Using Accounting Ratios to Assess Business Performance
    00:00
  • 139 Case Study Calculating Ratios and Analyzing PGs Financials 12
    00:00
  • 140 Case Study Calculating Ratios and Analyzing PGs Financials 22
    00:00
  • 141 COURSE CHALLENGE Part 2
    00:00
  • 143 Finance 101 Important Financial Principles That You Will Need
    00:00
  • 144 Understanding the Time Value of Money
    00:00
  • 145 Why Interest Rates Play an Important Role in the Economy
    00:00
  • 146 The Components Forming Interest Rates in Real Life
    00:00
  • 147 What Is Libor and What Does It Serve For
    00:00
  • 148 The Difference Between Fixed and Variable Interest Rates
    00:00
  • 149 What Is Default Risk and How Does a Bank Account For It
    00:00
  • 150 Corporate Loan Specifics
    00:00
  • 151 Calculating the Present Value of Future Cash Flows
    00:00
  • 152 A Tool That Helps Us Decide Whether a Project Is Feasible Net Present Value
    00:00
  • 153 Using Annuities
    00:00
  • 154 Calculating a Complete Loan Schedule
    00:00
  • 155 COURSE CHALLENGE Part 3
    00:00
  • 156 Microsoft PowerPoint The Most Popular Presentation Software for the Office
    00:00
  • 157 The Structure of the PowerPoint Ribbon
    00:00
  • 158 General Considerations About Slide Structure
    00:00
  • 159 Learn How to Insert Objects in PowerPoint
    00:00
  • 160 Shortcuts Allow Us To Be Much Faster When Working in PowerPoint
    00:00
  • 161 Add Frequently Used Buttons to the Quick Access Toolbar
    00:00
  • 162 How to Easily Align Objects in PowerPoint
    00:00
  • 163 Editing Shapes in Your Presentation The Format Shape Menu
    00:00
  • 164 How to Format Text Boxes in a PowerPoint Presentation
    00:00
  • 165 Changing an Objects Size and Learning About Rotation Options
    00:00
  • 166 Work Efficiently By Using Slide Masters
    00:00
  • 167 Modifying the Beginning and Ending of a Line Object
    00:00
  • 168 Join Shapes Together By Using Connector Lines
    00:00
  • 169 Group or Ungroup Shapes Pircutres or Other Objects
    00:00
  • 170 This is How You Can Fit Text When It Is Larger than a Shape
    00:00
  • 171 PowerPoints Smart Art Feature Offers Great Return for Your Time
    00:00
  • 172 Creating Eye Catching Text Effects in PowerPoint
    00:00
  • 173 Practical Exercise Creating an Organisational Chart
    00:00
  • 174 COURSE CHALLENGE Part 4 Snorgared SAnet cd
    00:00

Student Ratings & Reviews

No Review Yet
No Review Yet