This short course aims to take you from a novice to an expert in under 2 hours!
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 ''.
Do I need to be able to listen to complete the course? My computer doesn't have any speakers
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.
Hi, Will I get a Certificate after the course? If so who will it by? Thanks
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.
is there certificate available after completing this course.
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.
How long will I have access to the course?
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.
Rating and reviews
There haven't been any reviews for this course yet.
Please sign in to review this course.
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.