Excel: Management Accounting

Management accountants help executives make smarter, more informed business decisions. By providing advice and frequent, detailed internal updates, they help clarify their firm's current financial standing—and suggest how to boost profits going forward. In this hands-on course, professor Michael McDonald demonstrates how to use Microsoft Excel for the tasks performed most frequently by professionals working in a management or corporate accounting vertical. He covers topics such as performing variance analysis, doing activity-based costing (ABC), and using ratio analysis. Throughout the course, Michael includes exercises—together with downloadable exercise files—that you can complete to gain a practical understanding of these key concepts.

Learning objectives
Define activity-based costing and applications.
Examine the fundamentals of variances in Excel.
Explore the ways to interpret a variance bridge chart.
Recognize the fundaments of activity-based costing.
Define product-line profitability.
Explore the differences in activity-based costing versus traditional accounting.
Examine how to utilize the recommendations from activity-based costing analysis.
Recall the meaning of liquidity ratios in Excel.