• 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

CMA Webinars

  • Home
  • Blog
  • CMA Webinars
  • 5 Best Excel Tools For Business Managers

5 Best Excel Tools For Business Managers

Programme Overview

Microsoft Excel is the spreadsheet and reporting software of choice for today’s busy professional. A recent survey regarding the use of Excel indicates that employees 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, in the study based on a set of simple questions, only 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!
This Webinar is an insight to how you could perform numerous day to day tasks, without using complicated formulae and functions.

View Complete Video on YouTube

Areas Covered

  • Data analysis & forecasting with Excel Charts
  • Creating your own summary reports with Pivot Tables
  • Refining your data with Text to Column feature
  • Conditional Formatting to identify trends, pick out key pieces of information, and track deadlines
  • Understanding what if analysis tools

We had an overwhelming demand for this event with more than 450 participants registering for the event.

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

Are you interested in following a one day course in Excel?

Simply send us your details, we will get back to you with programme information of one day course in Excel.




    Are you interested in following a 60 hour course on Financial Modeling with Excel?

    Simply send us your details, we will get back to you with course information on Financial Modeling with Excel.




      Become a Certified Management Accountant (Australia)

      Simply send us your details, we will get back to you with more information.




        The most sought after financial qualification. For Marketers, Bankers, Engineers Entrepreneurs & Business Leaders, Finance and IT Professionals

        • Share:
        author avatar
        academy_36a4wv

        Previous post

        Jayantha S.B. Rangamuwa Appointed as the Chairman of Pan Asia Bank
        July 7, 2021

        Next post

        ICMA Graduate Conversion Programme: Batch 30
        August 16, 2021

        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.