• Home
  • About Us
    • Who we are?
    • Why choose us?
    • What have we achived?
    • What our students says?
    • Alumni Members
  • Programmes
    • CMA Programmes
      • About ICMA
      • Graduate Conversion Program
      • CMA Workshop – Accountancy Qualification
      • CMA Workshop – CGBA
    • Chartered Institute of Securities & Investments
      • About CISI
      • International Introduction to Investment
      • Risk in Financial Services
      • Wealth & Investment Management
      • Global Financial Compliance
    • Institute of Internal Auditors (IIA)
      • About IIA
      • Certified internal auditor (CIA)
  • Training
    • Quantum Leap
      • Finance and Accounting
      • Personal Wealth Management
      • Sales and Marketing Skills
      • Customer Care Training
  • Resources
    • The Climate Reality Project
    • Blog Feed – Academy of Finance
    • Webinars – Academy of Finance
    • Inductions – Academy of Finance
    • General Videos & Announcements
    • CMA – On Target Issues
    • Digital News Feed
  • Gallery
  • Contact
    • Student Portal
Academy of Finance
  • Home
  • About Us
    • Who we are?
    • Why choose us?
    • What have we achived?
    • What our students says?
    • Alumni Members
  • Programmes
    • CMA Programmes
      • About ICMA
      • Graduate Conversion Program
      • CMA Workshop – Accountancy Qualification
      • CMA Workshop – CGBA
    • Chartered Institute of Securities & Investments
      • About CISI
      • International Introduction to Investment
      • Risk in Financial Services
      • Wealth & Investment Management
      • Global Financial Compliance
    • Institute of Internal Auditors (IIA)
      • About IIA
      • Certified internal auditor (CIA)
  • Training
    • Quantum Leap
      • Finance and Accounting
      • Personal Wealth Management
      • Sales and Marketing Skills
      • Customer Care Training
  • Resources
    • The Climate Reality Project
    • Blog Feed – Academy of Finance
    • Webinars – Academy of Finance
    • Inductions – Academy of Finance
    • General Videos & Announcements
    • CMA – On Target Issues
    • Digital News Feed
  • Gallery
  • Contact
  • Student Portal

For World's Accountants Day

  • Home
  • Blog
  • CMA Webinars
  • 5 Best Excel Tools For Accountants

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

View Video on YouTube
View Complete PDF

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.

Facilitated by

Asoka Walpitagama

Asoka Walpitagama is an Experienced Consultant & Trainer with a demonstrated history of working in the IT and apparel industry. Skilled Trainer in Microsoft Excel, Word, Power point, Outlook,Train the Trainer and Soft skills. Strong consulting professional with a B.App.Sc. from RMIT University, Adv. Diploma in Train the Trainer from City & Guilds – UK

  • Share:
author avatar
academy_36a4wv

Previous post

10 Accounting Resume Skills to Impress Employers
November 15, 2020

Next post

Download - AFC Skepticism in Practice (Complete PDF)
November 17, 2020

Leave A Reply Cancel reply

Your email address will not be published. Required fields are marked *

Upcoming Classes

ICMA - Graduate Conversion Programme
CISI - Global Financial Compliance
ACADEMY - BLOG FEED

stay tuned with us

CMA Workshop 2022
11Jan2023
CMA Graduation 2022 – Graduates’ Celebration
13Dec2022
CMA Graduation 2022 – The Welcome
13Dec2022
CMA Graduation 2022 – Inauguration
13Dec2022
View all Articles
ACADEMY - INDUCTIONS

stay tuned with us

ICMA Graduate Conversion Programme: Batch 33
ICMA Graduate Conversion Programme: Batch 33
31Jan2023
CISI Risk in Financial Services: Batch 13
CISI Risk in Financial Services: Batch 13
25Nov2022
CISI International Wealth & Investment Management: Batch 5
CISI International Wealth & Investment Management: Batch 5
05Oct2022
IIA Certified Internal Auditor
IIA Certified Internal Auditor
09Sep2022
View Inductions
ACADEMY - WEBINAR FEED

stay tuned with us

What’s New in Sustainability Reporting Standards
What’s New in Sustainability Reporting Standards
12Jul2022
Circular economy – The role of management accountants
Circular economy – The role of management accountants
24Mar2022
Leveraging LinkedIn as a Professional
Leveraging LinkedIn as a Professional
13Jan2022
Developing a Fraud Risk Management Program during a Prolonged Crisis
Developing a Fraud Risk Management Program during a Prolonged Crisis
25Oct2021
View Webinars/Buzz Talks
quantumleap-programmes (6)

Finance and Accounting

.
VIEW PROGRAMMES
quantumleap-programmes (3)

Personal Wealth Management

.
VIEW PROGRAMMES
quantumleap-programmes (2)

Sales and Marketing Skills

.
VIEW PROGRAMMES
quantumleap-programmes (8)

Customer Care Training

.
VIEW PROGRAMMES
+94 11 259 1122 +94 772 840 850
5th Floor, No.403-5/1, Galle Road, Colombo 03.
info@academy.lkcma@academy.lk
Daily: 9:00 AM – 6:00 PMSunday & Holidays: Closed

All Rights Reserved by Academy. Designed by Pawara Concepst.