إنشاء حساب
الرئيسية
الكورسات
Launch a new career
FP&A & Advanced Income Statement Analysis: Complete Excel & Financial Modeling Course
Financial modeling using Excel

Financial modeling using Excel

FP&A & Advanced Income Statement Analysis: Complete Excel & Financial Modeling Course

الدرس السابق الدرس التالي

محتوى الكورس

جميع الدروس
36 درس
59:19 FP&A Crash course - Advanced income statement analysis
01:30 Excel Skills You NEED For FP&A and Data Analysis
12:10 Excel Charts & Graphs for Advanced Financial analysis📈
08:06 Cash Conversion Cycle Explained
14:08 How to calculate Working Capital and Cash Conversion Cycle
05:44 Financial modeling using Excel
10:03 How to analyze sales and average selling price (ASP)
15:52 Horizontal analysis of Financial statements (Income statement analysis) - Part 1
09:49 Horizontal analysis of Financial statements (Income statement analysis) - Part 2
09:38 Vertical Analysis of Income Statement (Coke vs Pepsi)
12:50 Purchasing decisions - Which vendor rebate is better?
17:11 Automate daily reporting in Excel using Pivot Tables
05:32 Income statement analysis
10:33 How to minimize labour costs by optimal production volume allocation
07:27 What is EBITDA and how to analyze it?
05:04 How Change in Selling prices impacts required Units Sold
02:34 How to Calculate Units to sell at different Selling prices
04:20 Advanced income statement analysis (including Price, volume, mix, cost)
16:00 Direct Material Usage (yield, mix) & price variance in Excel
08:17 Standard Margin vs Actual / Manufacturing Margin (Standard Costing & Variance Analysis)
31:40 Top 13 Excel Hacks for Accounting & Finance (from a fellow Finance Professional)!
10:39 Sort Pivot Table Values Largest to Smallest, text, dates and More (All about Sorting)
15:17 Pivot Table Automation with Calculated Field and Calculated Item (When and How to Use Each)
11:23 How to Lookup Names with Spelling Errors (All types of Spelling mistakes), Excel Vlookup and Xlookup
07:47 How to calculate selling price with cost and margin (Discount and Rebate included)
19:13 XLookup for Accountants and FP&A! Wow!
22:07 Variance Analysis (vs budget and prior year)
21:34 Advanced Pivot table tricks for Reporting and Analysis
11:44 Gross Profit Margin explained (Why its important?)
39:17 The Complete Sales and Profit Variance Analysis Course (Price, Volume, Mix impact on Profitability)
16:00 Excel Daily Sales Report - Automating monthly Days billed and Billings days
03:03 How to Convert Numbers stored as text to Numbers (blink of an eye)
10:22 Vlookup Automation - Do not worry about column number
33:00 Accounting Crash Course - Be job ready in 1.5 hours!
06:07 How to find selling price with cost and profit margin only
16:28 Create Waterfall Chart, Auto update Bar Colour and Data labels, Advanced Tutorial