Overview

The Excel for Accountants (Basic) course is a short course consisting of 10 video-led modules. The course is primarily aimed at accountants, bookkeepers and accounting professionals and aims to provide learners with a solid foundation with which to build further skills.

Excel is an incredibly powerful tool for accountants, and it is a key skill that any accountant or accountancy professional should become familiar with. For financial insight and analysis, crunching numbers and compiling non-numerical data, Excel continues to be the tool of choice throughout the accounting and finance field.

Learning to improve at Excel is a great accounting career move. With a large amount of functionality it's easy to get overwhelmed, particularly when you are just starting out. Master the basics of Excel and build a solid foundation in which to build further skills.

Pre-requisites

• PC or Mac with a full version of Microsoft Excel (any version from 2003 to 2013 or Microsoft 365).
• Not a requirement but a benefit to have some work-related projects to which you can readily apply what you learn.

Relevant audiences

• Accountants, accountancy professionals and finance professionals with limited knowledge about Microsoft Excel

Learning Outcomes

• Conduct insightful analysis of small or large data sets.
• Effectively manage your worksheets.
• Master Excel's most common und useful functions.

Syllabus

Section 1: Introduction

• Unit 1.1 - Getting Started

Section 2: The Basics

• Unit 2.1 - Setting up for Success

Section 3: Formatting Text and Numbers

• Unit 3.1 - Working with Number and Date Formatting
• Unit 3.2 - Formatting Based on Conditions

Section 4: Getting Started with Functions and Formulas

• Unit 4.1 - Basic Functions and Formulas
• Unit 4.2 - Absolute, Relative and Mixed Cell References

Section 5: Organising Data

• Unit 5.1 - Organising Data for Quicker Analysis

Section 6: The Power of Paste

• Unit 6.1 - Exploring Paste Options

Section 7: A Range By Any Other Name

• Unit 7.1 - Naming Cells and Ranges

Section 8: Extract or Combine Data

• Unit 8.1 - Manipulating Data Efficiently