Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Excel: Management Accounting

via LinkedIn Learning

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
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
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
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
Conclusion
  • Next steps

Taught by

Michael McDonald

Reviews

4.6 rating at LinkedIn Learning based on 244 ratings

Start your review of Excel: Management Accounting

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.