Excel For Accountants (Intermediate)

Excel With Business

Course

Online

£ 39 VAT inc.

The best Other Accounting courses

See all

See all

Description

  • Type

    Course

  • Level

    Advanced

  • 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 (Intermediate) course is a short course consisting of 10 video-led modules. The course is primarily aimed at accounting professionals. It aims to teach ten important topics that will assist finance staff with daily Excel tasks.

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

Perform calculations using Time and Date functions
Lookup information using HLOOKUP and VLOOKUP
Perform more complex lookups using INDEX and MATCH
Make decisions with IF Statements
Incorporate logical operators into formulas
Create a Loan Amortization table using the PMT function
Clean and prepare raw data
Create PivotTables and PivotCharts
Analyse large datasets using Power Pivot
Use Goal Seek, Data Tables and Scenarios to analyse data
Automate common tasks using Macros

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 5 years

Subjects

  • Excel
  • Finance
  • Financial
  • Financial Training
  • MS Excel
  • Getting started
  • Date
  • Manipulating Dates
  • Looking
  • Decision Making

Course programme

Syllabus:
  • Section 1: IntroductioUnit
  • 1.1 - Getting Started
Section 2: Date and Time Calculations
  • Unit 2.1 - Formatting and Manipulating Dates and Times
Section 3: Looking Up Information▸
  • Unit 3.1 - Looking
  • up Functions
Section 4: Decision Making
  • Unit 4.1 - Logical Functions
Section 5: Financial Functions
  • Unit 5.1 - Creating a Loan Amortization Schedule
Section 6: PivotTables and PivotCharts
  • Unit 6.1 - Data Cleaning Tips and Tricks
  • Unit 6.2 - Creating and Working with PivotTables and PivotCharts
  • Unit 6.3 - Analysing Large Data Sets
Section 7: WhatIf Analysis
  • Unit 7.1 - The Three Types of What-If Analysis
Section 8: Automating tasks with Macros
  • Unit 8.1 - Executing Repetitive Tasks Efficiently

See related categories

Excel For Accountants (Intermediate)

£ 39 VAT inc.

The best Other Accounting courses

See all

See all