Excel: Management Accounting

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.

Introduction

• Welcome to the wonderful world of managerial accounting

1. Major Tasks in Managerial Accounting

• Managerial accounting and FP&A
• Variance analysis in managerial accounting
• Activity-based costing and applications
• Uses of ratio analysis
• Budgeting in Excel

2. Variance Analysis in Excel

• Variances in Excel
• Waterfall charts in Excel
• Interpreting a variance bridge chart
• Profit drivers and variance analysis
• Interpreting financial results

3. Activity-Based Costing in Excel

• Basics of ABC
• Assigning direct costs
• Assigning indirect costs
• Product line profitability
• ABC vs. traditional accounting
• Recommendations from ABC analysis

4. Ratio Analysis in Excel

• Review of financial statements
• Liquidity ratios in Excel
• Debt ratios in Excel
• Profitability ratios in Excel
• Operational ratios in Excel
• The DuPont system

5. Budgeting and FP&A in Excel

• Controllership and budgeting in Excel
• Budgets vs. forecasts
• Drivers of cash flow
• Using operating leverage

Conclusion

• Continuing your journey in managerial accounting