Excel Course for Accounting Professional

A Training Course by VTeach.


    In-House sessions are available upon request.


    Course Description:

    In today era, Accountants and Finance Professionals place very much reliance on System for data entries and thereafter reports for management decision-making. However, be it Accounting or Logistic ERP System, the platform provides business solution to certain needs which answer to portion of a business/ product life cycle.

    Though Internet of Things and Big data are going to make a significant difference to the way we process our business data, Excel is still going to be the essential tool in our business environment. And it is not surprise that most daily users can only use up to 5% functionality of Excel while they are not aware that 95% of the capabilities can and will improve their working efficiency, which ultimately lead to Work Life Balance and effective reporting deliverables.

    In this hands-on course, participants will go through intensive demonstration, hands-on practical practices and a final exercise to measure individual overall learning objectives.


    Course Objective:

    Upon completion of this workshop, participants will be able to:

    • Create Accounting Template and thereafter applying the connectivity within a Financial Statement (i.e. Balance Sheet, Profit & Loss Statement and the Cash-flow Statement).
    • Set Data validation and specify an accounting error alert.
    • Appreciate and apply Advance Function which will expedite accounting works when processing raw data.
    • Manage Accounting Database such as listing feature toolbar and database functions.
    • Consolidate accounting data by category, position and also creating links from Consolidation.
    • Create Scenario and audit accounting worksheet.
    • Create Macro for the raw accounting data and run it from a toolbar button.
    • Create Pivot Table and customize it.


    Target Audience:

    Inspired individuals from the Accounting field such as the Accountants and the Finance Professionals. Other Non-Financial Professionals who are eager and want to learn these life time skill-sets are also welcome.


    Course Content:

    Lesson 1: Working with Templates focusing on accounting data

    • Creating a Template
    • Applying a Template
    • Editing a Template

    Lesson 2: Data Validation

    • Setting Data Validation
    • Specify Input Message
    • Specify an Error Alert
    • Circle Invalid Data
    • Clear Validation Circles

    Lesson 3: Advanced Functions

    • IF Function
    • IF (AND) AND IF(OR) Functions
    • COUNTIF Function
    • VLookup Function
    • HLookup Function

    Lesson 4: Database

    • Sorting
    • Data Forms
    • Filter Records
    • Advanced Filter
    • Subtotal
    • Outlining a worksheet
    • List Feature
    • List Feature Toolbar
    • Database Functions

    Lesson 5: Data Consolidation

    • Data Consolidation by Category
    • Data Consolidation by Position
    • Adding Source Area,
    • Change a Reference
    • Delete a Reference
    • Creating links from a consolidation

    Lesson 6: Scenario Manager

    • Creating a Scenario
    • Displaying a Scenario
    • Editing a Scenario
    • Deleting a Scenario
    • Merging an Accounting Scenario
    • Generating a Scenario Accounting Report

    Lesson 7: Audit Accounting worksheets

    • Tracing cell precedents
    • Tracing cell dependents
    • Tracing cell errors
    • Removing tracer arrows

    Lesson 8: Create Macro for the Accountants

    • Record a Macro
    • Run a Macro
    • Edit a Macro
    • Run a Macro from a Button
    • Deleting a Macro

    Lesson 9: Pivot Table for the accounting and business data

    • Creating a Pivot Table
    • Editing the Pivot Table
    • Updating a Pivot Table
    • Filtering Data by creating page fields
    • Creating a Chart from the Pivot Table
    • Customize a Pivot Table
    • Grouping items with Numeric labels into Ranges
    • Grouping items by Date or Time Intervals
    • Paging or Filtering a Pivot Table
    • Hiding grand-totals, sub-totals
    • Displaying subtotals for multiples Fields in Row or Column
    • Formatting Numbers

    Course Curriculum

    Excel Course for Accounting Professional 14:00:00

    Course Reviews


    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    • SGD 365
    • 2 days
    • 1 Units
    • 840 Minutes
    • Wishlist

    Enrol With Confidence

    PayPal Acceptance Mark

    Registration Support

    If you require further assistance on registration matters, email to

    In-House Enquiry

    Achieve higher ROI with your training budget with In-House trainings, email to
    VTeach Pte Ltd is a Training Organisation providing high quality and interactive hands-on training delivered by an enviable team of qualified, expert and highly experienced trainers. VTeach has been established to address the training needs of both individuals and corporate companies. We believe good foundation is essential in today’s business world. As a committed training provider, we strive to deliver effective training programmes for a lifelong learning experience to enhance your productivity. We offer a wide variety of programs from Information Technology courses, Finance Courses to Business and Professional Development courses. We also provide in-house lunch time seminars such as Time Management, Stress Management, Motivational Talk, etc. We also have our own team of in-house course developers who liaise directly with our clients to develop training courses which meet their specific needs. Our Training - Regular scheduled public classes - Corporate Training that can be conducted in-house and at the comfort of your own location and time - Customized Training tailored to the organization’s needs and objective.
    More Courses by VTeach Pte Ltd