Skip to main content

The global body for professional accountants

13
UNITS

Online course | Learnsignal

MS Excel practical applications

Gain skills in Microsoft Excel, tailored specifically for real-world business and accounting scenarios

Overview

The sky reflected onto a tiered glass building

This practical course is designed to equip learners with hands-on skills in Microsoft Excel, tailored specifically for real-world business and accounting scenarios. Whether you are managing budgets, tracking inventory, performing basic costing, or preparing bookkeeping records, each module in this course focuses on building functional Excel models that mirror everyday professional tasks.

Covering essential tools such as form design, slicers, variance analysis, and bookkeeping templates, the content emphasises practical application over theory. Ideal for finance professionals, small business owners, and aspiring Excel users, this course will empower you to use Excel not just as a spreadsheet tool, but as a powerful engine for data-driven decision-making and operational efficiency.

By completing this course, you will understand how to:

  • create data entry forms in Excel
  • customise slicer styles, layout, and interaction options to enhance data presentation
  • accurately allocate overheads using absorption rates and create effective visual aids like bar-of-pie charts to communicate cost structures
  • apply key Excel functions like VLOOKUP, IF, and SUMIFS to dynamically compute and analyse inventory data across different conditions and store locations
  • develop visually insightful BVA dashboards, using conditional formatting, pie charts, and logic-based indicators for management reporting.

 

Modules included in the course:

  • Designing a form in MS Excel
  • Using slicers in MS Excel
  • Basic costing in MS Excel
  • Basic inventory management in MS Excel
  • Budget vs actual (BvA) analysis in MS Excel
  • Basic bookkeeping in MS Excel.
  • This course consists of multiple modules and units. Each module includes video lectures, reading materials, quizzes and practical examples to enhance your understanding. 
  • CPD certificate is available upon successful completion of the course. 
  • Course produced by Learnsignal.
  • 12-months access.
Pricing and booking information

Price

Price 229.99 GBP

Location

Global

Date & time

On demand

Book on ACCA Learning opens in a new tab

Course providers

Logos of ACCA and Learnsignal