5 Best Excel Tools For Accountants

Programme Overview

Microsoft Excel is still business critical. More than 30 years since its launch, it’s more popular than ever: one billion people use it.

A recent survey regarding the use of Excel indicates that workers use Excel for more than an hour every day, with finance and R&D professionals spending 2.5 and 3.0 hours a day respectively.

However, the study of 45,000 office workers revealed that, despite using Excel daily, major, fundamental knowledge gaps are the norm.

For example, these 45,000 workers only got 28 per cent got the Excel questions correct. Accountants, understandably confident at Excel, were only the 3rd most proficient group of professionals. Almost 50 per cent of the questions were answered incorrectly, even by top accountants!

Based on the LLB REPORTER 13TH JULY 17 9:42 AM

Downloadable Resources

This was the reason for The Academy of Finance to arrange the Free Webinar on “Five Best Excel Tools for Accountants”, to celebrate the International Accountants Day. Topics covered include;

1. Presenting data with charts
2. Using pivot tables to summarise data
3. Using formula auditing toolbar
4. Using data validation
5. Understanding what if analysis tools

• Module 5 A – CHARTS
• Module 5 C – Data Validations
• MODULE 8C – Formula Auditing A
• MODULE 8C – Formula Auditing B
• MODULE 8D – Goal Seek
• MODULE 10 A – EXCEL TABLES
• MODULE 10 C – PIVOTS SHIPMENT SCHEDULE
• MODULE 10 D – PIVOTS HR DATA
• MODULE 10 E – PIVOTS SALES DATA
• MODULE 10 F – PIVOTS AGED ANALYSIS
• MODULE 10 G – PIVOTS REC ITEM SALES

Learning and professional development is a life long journey – take the time to invest in your core day to day skills and you’ll reap the benefits in the future.