reed.co.uk Courses

Header

Excel For Accountants (Intermediate)

The Leading Global Microsoft Excel Training Platform


Excel with Business

Summary

Price
Save 61%
£15 inc VAT (was £39)
Offer ends 30 September 2020
Study method
Online, self-paced
Duration
2 Hours
Qualification
No formal qualification

124 students purchased this course

Add to basket or enquire

Overview

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

Course media

Description

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.

What you get with this Excel for Accountants (Intermediate) course:

  • 26 brand new demo videos with professional voiceovers
  • 10 modules with text, that is relevant and easy to understand
  • 13 downloadable exercises
  • Quiz questions in every module
  • Specific objectives and condensed accelerators

In this course you’ll learn:

  • 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

More about us:

  • We have nearly 1 million students in total, 500k+ of those have had MS Excel training with us.
  • We teach accountants Excel. Through our partnerships with accountancy bodies, the AAT and ICAEW we have taught 20k+ accountants Excel.
  • Our training is personal. If you have used Excel before you can use the filter to show you which parts of the course to skip.
  • Our platform is award-winning and improving all the time.

About the author:

Deborah Ashby is the in-house IT Trainer here at Excel with Business, specialising in Microsoft Office training courses and content creation. Deborah has been an IT Trainer for nine years and has been supporting Microsoft products for 21 years. Deborah is a Microsoft Office Specialist (MOS) and Microsoft Certified Trainer (MCT).

Who is this course for?

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.

Questions and answers


No questions or answers found containing ''.


Find job asked:

What job can I apply after I finish this course?

Answer:

Good morning. Thank you for contacting us, Please note the course will not guarantee any job placement, This is course is for self-development and self-growth. Let us know if you have further questions. Thank you

This was helpful. Thank you for your feedback.

Lahsen asked:

I'm a beginner....can i take this course please...

Answer:

Good morning. Thank you for contacting us, Of course! Once you purchased through reed, they will send us an email letting us this course was purchased by you. We will then send you your log in details and intrcition on how to access the course. Let me know if you have further questions so we may assist. Thank you.

This was helpful. Thank you for your feedback.

Sagar asked:

Hi is this course CPD accredited as well ?

Answer:

Good afternoon. Correct! At the end of this course, you will receive a certificate of attainment which will be CPD accredited. Please let us know if you have further quetsions so we may assist. Thank you.

This was helpful. Thank you for your feedback.

Wendy asked:

I'm looking for online Excel course options for the firm I work for. Do you offer firm-wide licenses for training please?

Answer:

Good afternoon. Thank you for getting in touch. This course will give you the basics and the necessary of Excel. Maybe you need the full Microsoft Excel course as this will go in-depth and give you much more content/information more tips and tricks to learn within this course. If you are looking to have more than 50 users, please do check our business packges on Excel with Business site as you will find different deals and more courses to offer. Thank you.

This was helpful. Thank you for your feedback.

Lucy asked:

I'm applying for finance positions in the hopes to become an accountant. Excel skills are desirable, would this put me in a good position?

Answer:

Good afternoon. Thank you for getting in touch. This will be a great start on your career path as an accountant. Excel skills are very will be needed, This course will give you the basics and the necessary of Excel. Maybe you need the full Microsoft Excel course as this will go in-depth and give you much more content within this course. Feel free to have a quick look and let us know if you have further questions. Thank you.

This was helpful. Thank you for your feedback.

Suzanne asked:

Do I need to be able to listen to complete the course? My computer doesn't have any speakers

Answer:

Good afternoon. Thank you for contacting us, The course is divided into the readable content, downloadable exercises and also videos you will need to watch and listen to follow instructions. Let me know if you have further questions. Thank you.

This was helpful. Thank you for your feedback.

Liz asked:

Hi, Will I get a Certificate after the course? If so who will it by? Thanks

Answer:

Good morning. Thank you for contacting us. Correct! You will receive a certificate of completion. which will be from Excel with Business. this will have the modules you have completed and the time you have spent on each of them. Please let me know if you have further questions so we may assist. Kind regards.

This was helpful. Thank you for your feedback.

liz asked:

is there certificate available after completing this course.

Answer:

Good morning. Thank you for contacting us, That is correct! At the end of the course, you will receive a certificate of attainment which will be your certificate of completion. Let me know if you have further questions so we may assist. Thank you.

This was helpful. Thank you for your feedback.

Kiki asked:

How long will I have access to the course?

Answer:

Good afternoon! Thank you for contacting us, You will have 12 months to complete the course from the day of redemption. Please let us know if you have further questions so we may assist Thank you.

This was helpful. Thank you for your feedback.

Reviews

5.0
Course rating
100%
Service
100%
Content
100%
Value
Leave a review

{{ getTruncatedSinglePointScore(item.OverallCourseRating) }} Star Review by {{ item.ReviewerName }} for {{ item.Title }}


{{ getLongDate(item.CreatedOn) }}
{{ item.Title }}
Reviewed by {{ item.ReviewerName }}
|Purchased {{ getHumanisedPassageOftime(item.PurchasedOn) }}
{{ item.ProviderName }} responded to this review
{{ getLongDate(item.ProviderResponseDate) }}
{{ results.length }} out of {{ totalResultsCount }} reviews

FAQs

What does study method mean?

Study method describes the format in which the course will be delivered. At reed.co.uk 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.

What are CPD hours/points?

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.co.uk, many of which can be completed online.

What is a ‘regulated qualification’?

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.

What is an ‘endorsed’ course?

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 ABC Awards and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.

Modals

Mobile Navigation