Skip to content
Play overlay
Preview this course

Microsoft Excel in Accounting

Basic to advanced level of Microsoft Excel functions & formulas , certificate of double recognition, Free accounting

Accounting Lecture

Summary

Price
Save 33%
£20 inc VAT (was £30)
Offer ends 08 June 2024
Study method
Online, On Demand What's this?
Duration
3.7 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Reed courses certificate of completion - Free
Additional info
  • Tutor is available to students
496 students purchased this course

Add to basket or enquire

Overview

Are you scared of Microsoft EXCEL use in real life accounting!!!!

Just spend around 3 hours & master your Microsoft Excel skills.

Free 1 Hour Accounting course included in the price.

Boost your CV and have an extra certificate of achievement in Microsoft Excel use of Accounting.

This is a must course for accounting students, prospective & real life accountants, specially AAT,CAT,FIA,ACCA & university students. This course will help you to learn Spreadsheet Excel from beginning to advanced level. You will start from copy paste & end with PIVOT tables, V Look ups, Data manipulation and many more important accounting Excel tools.

Just checkout the content descriptions from the curriculum, you will feel what areas of Excel you are going to learn. For Accountants & Bookkeepers, this 3 hours course is a blessings.

The course is guided by world class course materials which is viewable.

Plenty of practice resources can be downloadable.

Taught by a chartered accountant from United Kingdom with 15 years of teaching experience.

You may claim CPD hours after course completion.

Master your Microsoft Excel for Accounting

Certificates

Reed courses certificate of completion

Digital certificate - Included

Will be downloadable when all lectures have been completed

Curriculum

4
sections
42
lectures
3h 41m
total

    • 1: Introduction 04:36
    • 2: Intro of spread sheet 12:36
    • 3: Fill handle use Preview 04:32
    • 4: Copy & Paste 01:59
    • 5: Paste special 01:53
    • 6: Insert, delete, hide, unhide, date & time 06:23
    • 7: Naming cells 03:16
    • 8: Spreadsheet Construction in real business situation 23:48
    • 9: Commission calculation 04:04
    • 10: Actual & budgeted sales 04:25
    • 11: If function Preview 04:54
    • 12: V12 Ch3 Illustration 11 If Function (3 min) 02:56
    • 13: Counta & compound countif 06:01
    • 14: Conditional formatting 05:15
    • 15: Ranking 02:36
    • 16: Charts & Graphs 15:57
    • 17: Simple data manipulation 03:56
    • 18: Printing 12:30
    • 19: Test your learning 05:43

    • 20: Data security 13:14
    • 21: Data validation 06:35
    • 22: Subtotal 05:29
    • 23: Filtering data Preview 01:41
    • 24: Find & Replace 01:31
    • 25: Pivot Table & chart 06:00
    • 26: Three dimensional worksheet 06:17
    • 27: Formatting data as table 04:37
    • 28: Lookup tables 06:50
    • 29: Data Table What if analysis 08:20
    • 30: Scenarios 03:43
    • 31: Goal Seek Preview 01:53
    • 32: Combination of charts 05:15
    • 33: Circular reference 04:14
    • 34: Trace precedents & dependents Preview 01:09
    • 35: Rounding 06:16
    • 36: Error checking 02:53
    • 37: Test your learning 01:53
    • 38: Keyboard short cut 01:00

    • 39: E-Book 01:00
    • 40: Illustration downloadable excel files (Basic excel 26 files) 01:00
    • 41: Illustration downloadable excel files (Advanced excel 33 files) 01:00

    • 42: Learn double entry to Financial Statements 01:00

Course media

Description

You Specifically gonna learn:

1: Excel interface

2: Copy paste insert delete

3: How to put date & time , header & footer

4: Construction of real life accounting in spreadsheet

5: Commission, Variance analysis & budgets

6: If function, Count if, counta, compound if

7: Conditional formatting

8: Ranking

9: Charts & Graphs (Pie,Bar, Column, Line)

10: Data manipulation

11: Printing of Excel files

12: Data security

13: Data validation

14: Subtotals

15: Filtering

16: Find & replace

17: Pivot table & Pivot Charts

18: V look up H look up

19: Data table, Goal seek, Scenarios, Circular referencing 20: Combination of charts.

20: Error checking & many more.

Enroll & feel the confidence.

What you’ll learn

  • Total 37 small & medium videos on Excel covering accounting tools
  • Total course covered in 3.5 hours (Basic spreadsheet to advanced).
  • Online access to course materials (Detailed course instruction).
  • Plenty of practice on accounting excel.
  • Excel questions are downloadable.
  • Course book is downloadable.

Sit Back, watch, practice & master your Excel skills.

Who is this course for?

  • Accounting students of any level.
  • Anyone who wants to master Microsoft excel for a career in accounting.
  • Small business owners who want to manage their own books.
  • Job seekers in accounting industry.
  • People who need to use Excel in their work or daily life.

Requirements

  • Having some basic accounting skills are advantageous but not essential.
  • Need a computer devise, tablet or smart phone with Microsoft Excel.

Career path

Spreadsheets for Accounting

After successful completion of this course, you will be able to work smoothly & confidently over Microsoft Excel for your daily accounting activities. Boost your CV and have an extra certificate of achievement in Microsoft Excel use of Accounting.

Questions and answers

No questions or answers found containing ''.

Inspire London College Ltd asked:

Are you providing free courses to take the learners out of REED & sell from your website? As I can see you have put your website link in modules.

Answer:

Dear Inspire London College Ltd, hope my courses (both free and paid) helpful to your students.

This was helpful. Thank you for your feedback.
Rik asked:

Which version of Excel is required ie 2010, 2013, 2016 or higher?

Answer:

The lectures are made on 2013 MS Excel, students can also use 2010-2020 versions of Microsoft Excel. Downloadable files are compatible with all versions.

This was helpful. Thank you for your feedback.
Karen asked:

I can't get the link to work in my browser for the course notes- how can I copy and paste it please

Answer:

Hope you received the mail with all links. Happy learning :)

This was helpful. Thank you for your feedback.
Accounting Fraud asked:

When your courses will be free again? Our full team is eager to enrol.

Answer:

There are many free courses on our website and YouTube

This was helpful. Thank you for your feedback.
nelo asked:

How can I apply to this course

Answer:

Add to your basket and buy.

This was helpful. Thank you for your feedback.
Sandra asked:

Is the course self paced ? And when or start date of the course and what time of the day is the course starting

Answer:

Yes it is self paced. You can start anytime, anywhere on demand.

This was helpful. Thank you for your feedback.
Ask a question

Reviews

4.2
Course rating
87%
Service
82%
Content
85%
Value

Legal information

This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Related searches: Accountancy courses, Microsoft 365 courses, Business administration courses, Online courses