|
Accounting Workflow
Using Microsoft Excel
Course Objective
The
urgency of the need to solve the imbalanced problem of manual
method of data processing as against the increasingly voluminous
accounting data/transactions has brought about the need for Microsoft
Excel in Computing. This training will teach the Accountants,
Auditors, Finance Executives on how to translate their manual
in-house accounting data into computer using Microsoft Excel.
It is completely practical with real-life issues.
Course
Outline
Introduction to Microsoft Excel (know it inside out)
- Workbook, Worksheets, Cells, Bars, Menus,
Workspace, etc.
- Data Entry
Methods and Formatting Incidence
- Copying,
Moving, Deleting, Pasting, etc.
- Saving,
Retrieving, Charting, Printing, etc.
- List/Database,
Sorting, Finding & Working Tutorials
Formulas and Functions
- Creating,
Modifying, Copying and Deleting Formulas
- Relative versus
Partial & Complete Absolute cell references
- Working with
Functions (Financial and otherwise)
- Linking
& Managing Worksheet/Workbook
- Work Tutorials
Accounting Workflow (Real Life Issues)
** Microsoft
Excel for Cashbook (What you do manually now with computer)
- Scope of your Cashbook (The planning session)
- Enter the Data, Apply the Formulas, Format & Link
the Worksheet, etc.
- Hands-on sessions on real life Cashbook
** Micro. Excel for
Purchases/Creditors, Sales/ Debtors, General Ledger
- Translating
from Manual to Computer (do it yourself)
- Hands-on
sessions for participants with real life issues
** Data Relations, Connection,
Linking for Trial Balance, etc.
- Hands-on
Sessions Through out
Who Should Attend?
Although,
this workshop is specifically designed for Accountants, Auditors
and Finance Executives, Officers in similar
profession may also benefit from the program.
Dates
Duration
Venue
Cost (N)
Mar. 26-30
5 Days Ultimate
Systems Solutions Training Center
38, 500
110b Awolowo Way, Ikeja, Lagos, Nigeria
Apr. 23-27
5 Days
"
38,
500
May 21- 25 5 Days
Ultimate Systems Solutions Training Center
38, 500
110b Awolowo Way, Ikeja, Lagos, Nigeria
Provision
Executive
Leather Bag, Lunch, Tea Break, Various Accounting Modules as stated
above on diskette, One Computer Per Participant, Group Photograph,
Workshop Materials
Note
Depending
on your choice, we can also run the above course for you in either
your office or your training center. But the number of participants
would not be less than 5.
| 