Description
Overview
This study text for the AAT Level 3 Diploma in Accounting teaches the spreadsheet skills you need to pass the Q2022 Unit ‘Management Accounting Techniques’.
You will learn the basic principles of using spreadsheets in accounting, along with more advanced formatting and data manipulation techniques. The book includes a large number of practical management accounting exercises to put your learning into practice.
This book should be used together with its companion: Management Accounting Techniques Tutorial. This is the main study text for the unit and will ensure you can apply the spreadsheet skills you have learned to situations in management accounting.
The book is based on Excel, part of the Microsoft Office 365 Suite (July 2021 version), but is designed to be used in conjunction with any commercial software package.
Download your spreadsheet files from the Resources tab.
All Osborne Books study materials are written by our expert authors in an easy-to-read style, giving you the knowledge and confidence to pass your AAT exams.
They Include:
- clear chapters
- practice exam-style questionsÂ
- Case StudiesÂ
- a FREE ebook copy
- more FREE study resources in the Osborne Books Student Zone
Table of Contents
- Spreadsheet basics
- Formatting the spreadsheet data
- Advanced formatting
- Spreadsheet functions
- Sorting, checking and importing dataÂ
- Statistical functions
- Charts
- Pivot tables and workbook management
- AAT LEVEL 3 - Q2022 - Spreadsheets for Management Accounting (SMA) Tutorial