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.

Learning outcomes
Contents
Additional information

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.

Price

Price 229.99 GBP

Location

Global

Date & time

On demand

Book on ACCA Learning

Course providers