إنشاء حساب
الرئيسية
الكورسات
Launch a new career
FP&A & Advanced Income Statement Analysis: Complete Excel & Financial Modeling Course
Pivot Table Automation with Calculated Field and Calculated Item (When and How to Use Each)

Pivot Table Automation with Calculated Field and Calculated Item (When and How to Use Each)

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