Excel: Management Accounting
Offered By: LinkedIn Learning
Course Description
Overview
Learn how to use Excel for key managerial accounting tasks. In this hands-on course, explore performing variance analysis, doing activity-based costing, and using ratio analysis.
Syllabus
Introduction
- Welcome to the wonderful world of managerial accounting
- Managerial accounting and FP&A
- Variance analysis in managerial accounting
- Activity-based costing and applications
- Uses of ratio analysis
- Budgeting in Excel
- Variances in Excel
- Waterfall charts in Excel
- Interpreting a variance bridge chart
- Profit drivers and variance analysis
- Interpreting financial results
- Basics of ABC
- Assigning direct costs
- Assigning indirect costs
- Product line profitability
- ABC vs. traditional accounting
- Recommendations from ABC analysis
- Review of financial statements
- Liquidity ratios in Excel
- Debt ratios in Excel
- Profitability ratios in Excel
- Operational ratios in Excel
- The DuPont system
- Controllership and budgeting in Excel
- Budgets vs. forecasts
- Drivers of cash flow
- Using operating leverage
- Continuing your journey in managerial accounting
Taught by
Michael McDonald
Related Courses
Introduction to Financial AccountingUniversity of Pennsylvania via Coursera Analyse Financière
First Finance Institute via First Business MOOC Financial Analysis
First Finance Institute via First Business MOOC The Language and Tools of Financial Analysis
University of Melbourne via Coursera Accounting Analytics
University of Pennsylvania via Coursera