×
Create CV Books Summaries Online Courses Blog Communities

Login

Sign up
MindLuster Logo
Categories
Recent

The Complete Financial Analyst

Marketing

Register in this Course

001 What Does the Course Cover

002 Everything We Will Learn Has a Practical Application

003 The Best Way to Take This Course

004 Microsoft Excel The Worlds 1 Software for the Office

005 Excel Made Easy A Beginners Guide to Excel Spreadsheets

006 Data Entry Techniques in Excel

007 How to Make Your Spreadsheets Look Professional

008 Inserting Deleting and Modifying Rows Columns

009 Excel Formulas for Beginners

010 A Beginners Introduction to Excel Functions

011 Work Efficiently by Using Cut Copy and Paste

012 Pasting Values Formulas and Formats with Paste Special

013 Inserting a Line Break with Alt Enter

015 Create Easily Printable Excel Documents

016 How to Wrap Text in Excel and Adjust a Cells Size

017 Insert Hyperlinks in Excel Spreadsheets

018 Using Excels Freeze Panes to Handle Large Datasets

019 Find Excel Functionalities in a Quicker Way Tell Me What You Want to Do

020 A Quick Introduction to Excels Pivot Tables

021 Initial Formatting Is Key for Creating Professional Looking Spreadsheets

022 Macros Are a Great Timesaver Heres Why

023 The Secret to Faster Scrolling in Excel

024 Using Absolute and Relative Cell References

026 How to Create Dynamic Names in Excel Spreadsheets

027 Using Named Ranges to Make Formulas More Readable

028 Custom Number Formatting

029 How to Add a Drop down List in Excel

030 Using Custom sort to Sort Multiple Columns Within a Table

031 Saving Time in Excel and Doing Everything Faster by Using Excel Shortcuts

032 Key Excel Functions Sum Sumif Sumifs

033 Key Excel Functions Count Counta Countif Countifs

034 Key Excel Functions Average Averageif

035 Key Excel Functions Left Right Mid Upper Lower Proper Concatenate

036 Find the Highest and the Lowest Values in a Range Max Min

037 Use Round in Your Financial Models

038 Excels Lookup Functions Vlookup Hlookup Made Easy

039 Index Match and Their Combination The Perfect Substitute of Vlookup

040 Using Excels Iferror Function to Trap Spreadsheet Errors

041 Create Flexible Financial Models with Choose

042 Goal Seek Will Help You Find the Result You Are Looking For

043 Perform Sensitivity Analysis with Excels Data Tables Functionality

044 Understand Your Data Source Before You Start Working on It

045 Ordering the Source Worksheet

046 Create a Code The Best Way to Organize Your Data and Work Efficiently with It

047 Learn How to Create a Database

048 Using Lookup Functions Vlookup to Fill the Database Sheet

049 Use Sumif to Complete the Database Sheet

050 Using Index Match as a Substitute of Vlookup

051 Mapping of the Rows in the Database Sheet

052 Building the Structure of the PL Sheet

053 A Practical Example of Professional Formatting in Excel

054 Populate the PL Sheet with Sumif

055 Learn How to Find Mistakes with Countif

056 Calculating Growth Rates in Excel

057 Introduction to Excel Charts

058 Beginners Guide to Inserting Charts in Excel

059 Modifying Excel Charts The Easy Way to Do It

060 Make Your Excel Charts Look Sexier Proven Tips

061 Creating a Bridge Chart in Excel 2016 As Easy as It Gets

062 New Ways to Visualize Your Data Treemap Charts

063 How to Represent Trends with Sparklines

064 Pivot Tables Excels Dynamic and Interactive Tables

065 Creating a Pivot Table Choosing Row and Column Parameters

066 Design the Layout and Format of Your Pivot Tables

067 Additional Techniques That Will Ease Your Work with Pivot Tables

068 One of the Most Useful Excel Functions GetPivotData

069 Welcome to the Future Pivot Table Slicers

070 Introduction to the Course Challenge

071 COURSE CHALLENGE Part 1

072 Introduction to the Case Study

073 Working with an SAP data extraction

074 Preliminary mapping of the data extraction

075 Creating an output structure of the FMCG model

076 Improving the layout and appearance of the FMCG report

077 Inserting formulas and automating calculations

078 Creating a Master Pivot Table The main data source for the FMCG report

079 GetPivotData is great Extracting data from the Master Pivot Table

080 Combining Slicers and GetPivotData The key to our success

081 Getting fancy with Excel slicers Good looking Excel slicers

082 This is how the report can be used in practice by high level executives

083 Introduction to the Exercise

084 Lets create a mapping of financials

085 Building an output PL sheet

086 Filling in the output PL sheet with historical financials

087 Calculating percentage variances and applying conditional formatting

088 Building an output Balance sheet

089 Using Index Match Match to fill in the output Balance sheet

090 Adding the forecast period

091 Calculating historical percentage ratios and use Index and Match for scenarios

092 Building a flexible model with Choose Match

093 Building a flexible model with Vlookup Columns

094 Calculating historical DSO DPO DIO Other assets and Other liabilities

095 Forecasting DSO DPO DIO Other assets and Other liabilities

096 Building a Fixed asset roll forward

097 Building a Financial liabilities schedule

098 Building an Equity schedule

099 Preparing a Cash flow structure

100 Calculating Cash flows and completing the model

101 Accounting The Science Behind Financial Figures

102 What is Accounting and Why Do You Need It

103 The Importance of Bookkeeping Good Accounting Records Are Essential

104 An Introduction to Financial Accounting

105 The Three Core Financial Statements PL Balance Sheet and Cash Flow

106 The Key Accounts You Will Find in a PL

107 The Main Balance Sheet Items

108 The Revenue Recognition Principle Why Is it so Important

109 The Expense Recognition Principle When to Recognize Expenses

110 Historical Cost vs Fair Value Accounting

111 The Accounting Equation and Its Importance

112 Elements of the Accounting System General Ledger

113 T Accounts The Best Way to Understand Debits and Credits

114 PL T Accounts

115 How to Calculate Depreciation Expense

116 The Double Entry Principle The Core Principle of Bookkeeping

117 Case Study The Accounting Transactions of a Lemonade Stand 14

118 Case Study The Accounting Transactions of a Lemonade Stand 24

119 Case Study The Accounting Transactions of a Lemonade Stand 34

120 Case Study The Accounting Transactions of a Lemonade Stand 44

121 Calculating Cash Flows Understand if a business makes or burns cash

122 The three parts of Cash Flow statements explained

123 Cash Flow computations The Direct method

124 Cash Flow computations The Indirect method

125 Calculating Cash Flow in practice A complete example

126 Timing of Cash Flows and Why It Plays an Important Role for a Business

127 Timing of Income Principles of Revenue Recognition

128 Timing of Expenses Principles of Cost Recognition

129 The Four Type of Accruals Arising in Accounting Transactions

130 What is a 10 K Report and Why Is It important for Investors

131 Finding Downloading and Going Through the Annual Report of PG

132 What is the Role of Auditing Firms and What Are the Benefits of an Audit

133 Indispensable Tools for Financial Statement Analysis

136 Horizontal vs Vertical Financial Statement Analysis

137 Calculating Days Payable DPO Days Receivable DSO and Days Inventory DIO

138 Using Accounting Ratios to Assess Business Performance

139 Case Study Calculating Ratios and Analyzing PGs Financials 12

140 Case Study Calculating Ratios and Analyzing PGs Financials 22

141 COURSE CHALLENGE Part 2

143 Finance 101 Important Financial Principles That You Will Need

144 Understanding the Time Value of Money

145 Why Interest Rates Play an Important Role in the Economy

146 The Components Forming Interest Rates in Real Life

147 What Is Libor and What Does It Serve For

148 The Difference Between Fixed and Variable Interest Rates

149 What Is Default Risk and How Does a Bank Account For It

150 Corporate Loan Specifics

151 Calculating the Present Value of Future Cash Flows

152 A Tool That Helps Us Decide Whether a Project Is Feasible Net Present Value

153 Using Annuities

154 Calculating a Complete Loan Schedule

155 COURSE CHALLENGE Part 3

156 Microsoft PowerPoint The Most Popular Presentation Software for the Office

157 The Structure of the PowerPoint Ribbon

158 General Considerations About Slide Structure

159 Learn How to Insert Objects in PowerPoint

160 Shortcuts Allow Us To Be Much Faster When Working in PowerPoint

161 Add Frequently Used Buttons to the Quick Access Toolbar

162 How to Easily Align Objects in PowerPoint

163 Editing Shapes in Your Presentation The Format Shape Menu

164 How to Format Text Boxes in a PowerPoint Presentation

165 Changing an Objects Size and Learning About Rotation Options

166 Work Efficiently By Using Slide Masters

167 Modifying the Beginning and Ending of a Line Object

168 Join Shapes Together By Using Connector Lines

169 Group or Ungroup Shapes Pircutres or Other Objects

170 This is How You Can Fit Text When It Is Larger than a Shape

171 PowerPoints Smart Art Feature Offers Great Return for Your Time

172 Creating Eye Catching Text Effects in PowerPoint

173 Practical Exercise Creating an Organisational Chart

174 COURSE CHALLENGE Part 4 Snorgared SAnet cd

We Appreciate Your Feedback

Excellent
1 Reviews
Good
0 Reviews
medium
0 Reviews
Acceptable
0 Reviews
Not Good
0 Reviews
4.5
2 Reviews
Vicente 

How can I watch it?, The videos are not avaliable
2025-06-10

KATAKAM RAHUL CHARY 

it was very use full
2025-04-16

Show More Reviews

Another Marketing Courses

How To Start Social Media Marketin
5 Lessons

How To Start Social Media Marketin

Search Engine Optimization
19 Lessons

Search Engine Optimization

Digital Strategy Brand Marketing Workshop
1 Lessons

Digital Strategy Brand Marketing Workshop

Marketing Automation
1 Lessons

Marketing Automation

YouTube Marketing Training
8 Lessons

YouTube Marketing Training

Google Adwords Training
8 Lessons

Google Adwords Training

Content Marketing
12 Lessons

Content Marketing

Google Ads and SEM and PPC Training
11 Lessons

Google Ads and SEM and PPC Training

Show More Course for Marketing

Financial analysts guide businesses and individuals in decisions about expending money to attain profit. They assess the performance of stocks, bonds, and other types of investments .

Trends
Recent
How To Start Social Media Marketin