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

للحصول على شهادة

  • 1- التسجيل
  • 2- مشاهدة الكورس كاملا
  • 3- متابعة نسبة اكتمال الكورس تدريجيا
  • 4- بعد الانتهاء تظهر الشهادة في الملف الشخصي الخاص بك