𝑭𝒊𝒏𝒂𝒏𝒄𝒊𝒂𝒍 𝑨𝒏𝒂𝒍𝒚𝒔𝒕 𝑪𝒐𝒖𝒓𝒔𝒆

Name: 𝑭𝒊𝒏𝒂𝒏𝒄𝒊𝒂𝒍 𝑨𝒏𝒂𝒍𝒚𝒔𝒕 𝑪𝒐𝒖𝒓𝒔𝒆
Price: 10.00 USD
Availability: InStock

Droit & Finance Tous niveaux Langue : EN Durée : 923 min 10 USD

Présentation de la formation

Maîtrisez les fondamentaux de l'analyse financière et d'Excel pour évaluer la viabilité de projets d'entreprise. Cette formation s'adresse aux professionnels et étudiants souhaitant acquérir des compétences pratiques en modélisation financière et en gestion de données. Vous apprendrez à concevoir des outils de calcul rigoureux et à interpréter les états financiers clés.

Objectifs d'apprentissage

Suivre et valider l integralite des 266 lecons du parcours
Maitriser les concepts cles de Droit & Finance
Reussir l examen final et obtenir le certificat YouCert

Compétences développées

Créer des tableurs Excel professionnels, dynamiques et esthétiques
Maîtriser les formules et fonctions essentielles pour l'analyse de données
Calculer la Valeur Actuelle Nette (VAN) et le Taux de Rendement Interne (TRI)
Élaborer et analyser un compte de résultat (P&L) ainsi qu'un bilan comptable

Programme des cours (266 modules)

|🤔|🌀|👍𝑬𝒗𝒆𝒓𝒚𝒕𝒉𝒊𝒏𝒈 𝑾𝒆 𝑾𝒊𝒍𝒍 𝑳𝒆𝒂𝒓𝒏 𝑯𝒂𝒔 𝒂 𝑷𝒓𝒂𝒄𝒕𝒊𝒄𝒂𝒍 𝑨𝒑𝒑𝒍𝒊𝒄𝒂𝒕𝒊𝒐𝒏 |📉|📊|👌| @Professional_Courses_With_KM
The Best Way to Take This Course @Professional_Courses_With_KM
How to Make Your Spreadsheets Look Professional
Excel Formulas for Beginners @Professional_Courses_With_KM
Inserting, Deleting, and Modifying Rows & Columns
A Beginner's Introduction to Excel Functions @Professional_Courses_With_KM
Insert Hyperlinks into Excel Spreadsheets
Green References
Beauty Saving The Professional Way of Saving Files
Use Sumif to Complete the Database Sheet
How to Create Dynamic Names in Excel Spreadsheets
A Tool That Helps Us Decide Whether a Project Is Feasible Net Present Value
Cost recognition principles
64: Find the Highest and Lowest Values in a Range Max & Min
Using Named Ranges to Make Formulas More Readable
38: Date functions in Excel
Calculating Internal Rate of Return IRR in Excel
40: What you will see next in this section
The project's P&L sheet
Balancing the Balance sheet
Using the PMT function to create a complete loan schedule
45: An introduction to the Case Study
Using Index & Match as a Substitute for Vlookup
66: = and + are interchangeable when you start typing a formula
67: How to Format Text Boxes in a PowerPoint Presentation
68: Working with text in Excel
60: Symptoms of inefficient working capital Trade payables
44: Calculating Internal Rate of Return IRR in Excel
37: Discounting cash flows in Microsoft Excel
47: Combining Slicers and GetPivotData The key to our success
48: Discounting project cash flows
49: Equity
50: Excel's Lookup Functions Vlookup & Hlookup Made Easy
51: Peer comparison D&A as a percentage of revenues
52: Building a Fixed asset roll forward
53: Calculating Cash Flows Understand if a business makes or burns cash
54: Calculating historical percentage ratios and use Index and Match for scenarios
56: Forecasting other assets
57: Case Study Calculating Ratios and Analyzing P&G's Financials 12
55: The Accounting Equation and Its Importance
59: Calculating WACC Weighted Average Cost of Capital
65: GetPivotData fix
61: Case Study: The Accounting Transactions of a Lemonade Stand 14
69: Asset categories practical example
70: Types of expenses
71: Finance 101 Important Financial Principles That You Will Need
72: Working capital optimization a roadmap
73: Changing an Object's Size and Rotation
74: Estimating cost of equity
75: Forecasting 'energy' and 'services' revenue
76: The Mapping Exercise
78: Types of assets
79: Calculating automotive cost of sales
80: Use Round in Your Financial Models
81: Financial Statement Analysis A Natural Continuation of Financial Accounting
83: Adding the forecast period
84: Calculating automotive gross profit
85: Organizing external inputs in a 'Drivers' sheet
86: Goal Seek Will Help You Find the Result You Are Looking For
87: Learn How to Find Mistakes with Countif
88: Using Excel's Iferror Function to Trap Spreadsheet Errors
89: A Useful Tool for Financial Analysis The Rank Function
Calculating DSO, DIO, DPO
91: Calculating Growth Rates in Excel
92: Create Flexible Financial Models with Choose
93: Producing a clean P&L output sheet
94: Fill in the P&L output sheet
95: Calculating investments in working capital
96: Forecasting Unlevered Free Cash Flow
97: Perform Sensitivity Analysis with Excel's Data Tables Functionality
98: Forecasting other liabilities
99: Completing Unlevered Free Cash Flow
100: Modeling Tesla's financing needs in the forecast period
101: How we account for trade payables
102: Intangible assets with finite life vs Intangible assets with infinite life
103: Index, Match, and Their Combination The Perfect Substitute for Vlookup
104: Building a fixed asset roll forward D&A schedule
105: Populate the P&L Sheet with Sumif
114: Types of liabilities
115: Calculating 'energy' and 'services' gross profit and cost of sales
113: Modeling Future Cash Flows
111: Forecasting operating expenses
112: Economic order quantity EOQ
106: Calculating Net income
107: Bridging Unlevered Free Cash Flow to Net Cash Flow
108: Discounting cash flows in Microsoft Excel
109: Date functions in Excel
116: Performing sensitivity analysis and wrapping up the Case Study
110: Accrual accounting
117: This is how the report can be used in practice by high level executives
118: A Practical Example of Professional Formatting in Excel
119: Getting fancy with Excel slicers
120: Liability categories practical example
121: Intangible assets created internally
122: Creating a Master Pivot Table The main data source for the FMCG report
123: Peer comparison Gross profit %
124: Depreciation & Amortization
125: How to Easily Align Objects in PowerPoint
126: Mapping the Rows in the Database Sheet
127: Using Slide Masters
128: The Difference Between Fixed and Variable Interest Rates
129: Practical Exercise Creating an Organisational Chart
130: Add Frequently Used Buttons to the Quick Access Toolbar
131: Using Index, Match, Match to fill in the output Balance sheet
132: Using Lookup Functions Vlookup to Fill the Database Sheet
133: Corporate Loan Specifics
134: GetPivotData is great! Extracting data from the Master Pivot Table
135: The Double Entry Principle The Core Principle of Bookkeeping
136: The idea behind stock splits
137: The revaluation model practical exercise
138: Welcome to the Future Pivot Table Slicers
139: Inventory optimization techniques
140: Building the Structure of the P&L Sheet
141: Key Excel Functions If
142: How to Edit Shapes in Your Presentation
143: The Different Cash Flow Types in a Capital Budgeting Exercise
144: The project's cash flow calculation
145: Trade payables management
146: How to Represent Trends with Sparklines
147: Introduction to the Course Challenge
148: The Weighted Average Cost of Capital WACC
149: Building a fixed asset roll forward estimating Capex
150: This is How You Can Fit Text When It Is Larger than a Shape
151: Modifying the Beginning and Ending of a Line Object
152: What are share repurchases and why companies do them
153: What Is Libor and What Purpose Does It Serve
154: Building an output Balance sheet
155: Calculating automotive revenue
156: PowerPoint's Smart Art Feature Offers Great Return for Your Time
157: Debt repayment and interest expenses calculation
158: Income taxes
159: Inserting formulas and automating calculations
160: Key Excel Functions Left, Right, Mid, Upper, Lower, Proper, Concatenate, &
161: Learn How to Create a Database
162: New Ways to Visualize Your Data Treemap Charts
163: Project specific Beta
164: Re order level
165: Shortcuts Allow Us To Be Much Faster When Working in PowerPoint
166: The revaluation model
167: Using Accounting Ratios to Assess Business Performance
168: Creating Eye Catching Text Effects in PowerPoint
169: Cash Flow computations The Indirect method
170: Ordering the Source Worksheet
171: Pivot Tables Excel's Dynamic and Interactive Tables
172: Trade receivables management
173: Calculating percentage variances and applying conditional formatting
174: Calculating the cash impact of extra working capital required
175: Cost of Equity
176: Create a Code The Best Way to Organize Your Data and Work Efficiently with It
177: Creating a Bridge Chart in Excel 2016 As Easy as It Gets
178: Estimating an average selling price of Tesla vehicles
179: Forecasting DSO, DPO, DIO, Other assets and Other liabilities
180: How to Calculate Depreciation Expense
181: Improving the layout and appearance of the FMCG report
182: Key Excel Functions Average & Averageif
183: One of the Most Useful Excel Functions - GetPivotData
184: Cost flow methods a practical exercise
185: A practical example
186: Calculating and analyzing solvency ratios
187: Calculating Cash Flow in practice A complete example
188: Calculating Cash flows and completing the model
189: Why use e invoicing
190: A technique to collect trade receivables sooner
191: Making Your Excel Charts Sexier Proven Tips
192: P&L T Accounts
193: Potential conflicts of interest when recognizing revenue
194: Dividend payments a timeline
195: Filling in the output P&L sheet with historical financials
210: Finding, Downloading and Going Through the Annual Report of P&G
196: Indispensable Tools for Financial Statement Analysis
197: Key Excel Functions Count, Counta, Countif, Countifs
Learn How to Insert Objects in PowerPoint
199: Preparing a Cash flow structure
200: Preparing a fixed asset rollforward schedule
202: Types of revenues exercise
203: The Four Type of Accruals Arising in Accounting Transactions
204: Calculating Present and Future Value
205: Case Study The Accounting Transactions of a Lemonade Stand 44
206: Comparing delivery figures with the ones of industry peers
207: Creating an output structure of the FMCG model
208: Debt covenants a practical example
209: Debt covenants
211: The Importance of Bookkeeping Good Accounting Records Are Essential
212: The Time Value of Money in a Capital Budgeting Setting
213: The two types of Income Statement formats
214: The types of dividends companies pay to shareholders
215: Timing of Expenses Principles of Cost Recognition
216: Types of revenues
217: Understand Your Data Source Before You Start Working on It
218: What is the Role of Auditing Firms and What Are the Benefits of an Audit
219: Additional Techniques That Will Ease Your Work with Pivot Tables
220: An Introduction to Financial Accounting
221: Calculating and analyzing liquidity ratios
222: Calculating Days Payable DPO, Days Receivable DSO and Days Inventory DIO
223: Calculating historical DSO, DPO, DIO, Other assets %, and Other liabilities %
224: Modifying Excel Charts The Easy Way
225: Overtrading vs excessive investment
226: What You Will See Next
227: Preliminary mapping of the data extraction
228: The difference between debt and equity
231: Historical Cost vs Fair Value Accounting
232: Horizontal vs Vertical Financial Statement Analysis
233: How Interest Rates Play an Important Role in the Economy
234: How to handle non paying customers A case study
235: Key Excel Functions Sum, Sumif, Sumifs
236: Modeling expected savings Building cars in Italy vs Building cars in Vietnam
237: Revenue recognition criteria technical
238: T Accounts The Best Way to Understand Debits and Credits
239: Design the Layout and Format of Your Pivot Tables
240: Fair value accounting
241: Forecasting Tesla's expected deliveries
242: General Considerations About Slide Structure
243: Group or Ungroup Shapes, Pictures or Other Objects
244: The different types of accounting standards
245: Technical aspects of cost recognition
246: The different types of equity
247: The Structure of the PowerPoint Ribbon
248: What is Accounting and Why Do You Need It
249: What is the difference between accounts payable and notes payable
250: When Do We Use Capital Budgeting
251: Working with an SAP data extraction
252: Building a flexible model with Vlookup & Columns
253: Building an Equity schedule
254: Building an output P&L sheet
255: Calculating and analyzing growth and profitability ratios
256: Case Study: The Accounting Transactions of a Lemonade Stand 34
257: Cash Flow computations The Direct method
258: Cost flow methods
259: The three financial statements
260: The three parts of Cash Flow statements explained
261: The different types of fixed assets
262: Enlarge the formula bar
263: Raising equity in different stages of a company's lifecycle
264: First Steps in Financial Statement Analysis
265: How to download Tesla's historical financials
266: Join Shapes Together By Using Connector Lines
268: Organizing inputs in the Drivers sheet
267: Let's create a mapping of financials
269: Solving a complete leasing exercise
270: The connection between Cost of Goods Sold and Inventory
271: The different types of Inventory we can have
272: The implications of using excessive leverage
273: The importance of timing when recognizing revenues
274: The importance of working capital optimization case study
275: The reason companies lease assets
276: What is leverage and why companies use financial leverage
277: Why a company needs to pay attention to trade receivables
278: The Expense Recognition Principle When to Recognize Expenses
279: Capitalizing interest expenses
280: Case Study Calculating Ratios and Analyzing P&G's Financials 22
281: Amortizing a loan
282: Beginner's Guide to Inserting Charts in Excel
283: Building a Financial liabilities schedule
284: Building a flexible model with Choose & Match
285: Calculating a Complete Loan Schedule
286: Case Study The Accounting Transactions of a Lemonade Stand 24
287: Creating a Pivot Table Choosing Row and Column Parameters
288 Elements of the Accounting System General Ledger
289 The input data we will work with
290 Timing of Income Principles of Revenue Recognition
291 Understanding the Time Value of Money
292 What if clients do not pay on time
293 The Revenue Recognition Principle Why Is it so Important
294 Timing of Cash Flows and Why It Plays an Important Role in a Business
296 What is a 10 K Report and Why Is It important for Investors
297 What is Capital Budgeting

Certification Numérique Vérifiable

Cette formation est certifiante. Après validation des modules et de l'examen en ligne, vous recevez un Certificat de Réussite officiel YouCertAcademy muni d'un QR Code unique vérifiable publiquement à l'adresse https://www.youcertacademy.com/verify.

Dispensé par : 𝑷𝒓𝒐𝒇𝒆𝒔𝒔𝒊𝒐𝒏𝒂𝒍 𝒄𝒐𝒖𝒓𝒔𝒆𝒔 𝒘𝒊𝒕𝒉 𝑲𝑴