Excel For Accountants (Basic)

Course

Online

£ 39 VAT inc.

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Class hours

    3h

  • Duration

    Flexible

  • Online campus

    Yes

  • Delivery of study materials

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

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 budding accountant or accountancy professional should try to 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 excel at Excel is a great accounting career move. With so much functionality it’s very 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.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now closed

About this course

This short course aims to take you from a novice to an expert in under 2 hours!

What you get with this Excel for Accountants (Basic) course:
12 brand new demo videos with professional voiceovers
11 modules with text, that are relevant and easy to understand
10 downloadable exercises
Quiz questions in every module
Specific objectives and top concepts
In this course you’ll learn:
Worksheet organisation and navigation tips
Understanding Number and Date Formatting
Conditional Formatting
Constructing Formulas using Basic Functions
The Importance of Absolute Cell References
Sorting and Filtering Data
Looking beyond simple Paste
The advantages of naming Ranges
Manipulating data with Text Functions
The magic of Flash Fill

CPD UK

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2019

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 4 years

Subjects

  • Excel
  • Accountants
  • MS Excel
  • Basics
  • Success
  • Numbers
  • Formatting text
  • Date Formatting
  • Conditions
  • Formatting

Course programme

Syllabus:

Section 1: Introduction
  1. 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

Excel For Accountants (Basic)

£ 39 VAT inc.