Microsoft Excel for Accountants

Essentials of Excel for Accounting professionals


What this is about
A jump-start Excel workshop designed for Accounting professionals.
Backed with relevant Accounting examples so that you can understand and apply them in your work immediately.
What problems it solve
Generic Excel courses has limited discussions on how to use Excel for practical accounting work. Consequently, accountants still go through a painful trial & error process to figure out which Excel feature is relevant to manage accounting data, calculate payments, analyze and report accounts.
How can I apply it in my work
  • Important Accounting Excel Functions
    • Use VLOOKUP and Sum Wizard to manage various account codes. Accounting applications of SUMIFS, Text functions, Rounding functions and Array formulas. Build checks & controls to eliminate account errors.
  • Essential Excel functions
    • Learn how to import and export accounting data to and from your backend systems. Sort and Filter data to analyse and report accounts. Protect your workbooks and worksheets. Use Data Validations to emilinate account entry errors.
    Our Excel Learning Framework
    Aeternus has designed an organic learning framework for her Professional Excel learning series. The practical outline covers important Excel features with real world examples.

    Prerequisites
    This workshop is designed for Accounting professionals with minimal Excel knowledge. For business analysts who require more advanced training in data management & analysis, please look at the Data Management & Analysis with Excel 2007 workshop.
    Duration
    1 day.
    Why AEternus Training?
    Look at some of positive comments about Aeternus programs.
    We have been consistently rated for great quality in program design & reference materials.
    Sign Up: Essential Excel for Accountants
    1. (required)
    2. (valid email required)
    3. (required)
     

    Choose other Professional Level Excel programs