|
Automating
Accounting Functions Using Microsoft .Excel
Course
Objective
As
accounting data continue to be voluminous, the elementary or intermediate
knowledge of Microsoft Excel can no longer guarantee the need
for timely and accurate information processing requirements of
today's businesses. To be effective, Accountants, Auditors
and Finance Executive need to explore the use of Microsoft Excel
to an advance stage of information automation and be able to apply
the same for timeliness and competitive advantages
Course
Outline
.
Overview: Practical overview of Microsoft Excel using prepared
Questions (What do you know in Excel?)
.
Recording Business Transaction:
-
Three-dimensional Worksheets, File Linking,
-
Using the Double-Entry Process, Applying Basic Accounting Equations
.
Data Management and Analysis:
- The Database Environment, Data Analysis: What-if and
predicative
-
Organizing and Maintaining your files
-
Developing and Adjusting Trial Balance
-
Using the Worksheet to prepare Financial Statements
.
Analyzing Inventory: Completing Perpetual Inventory,
Evaluating Investments in Inventory
- Accounting
for property, Plant and Equipment
-
Applying Basic Accounting Equations
.
Computing Depreciation: Using @ SYD to calculate depreciation
-
Changing Depreciation Assumptions
-
Examining Bonds Payable and the Time Value of
Money, Using the @PV Function
.
Capital Budgeting: Evaluating Performance
-
Understanding Cost-Volume-Profit Relationships
-
Capital Budgeting, Study Questions
.
Microsoft Excel Macros: Macro Basics
-
Automating the Spreadsheet with Macros
-
Business Application using Macros, Study Questions
.
Case Studies: Salaries & Wages, Loan & Advances, Bank
Balances
Personnel Details,
Budgeting, etc.
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)
Apr. 16-20
5 Days Ultimate
Systems Solutions Training Center
39, 500
110b Awolowo Way, Ikeja, Lagos, Nigeria
May 07-11
5 Days
"
39,
500
Jun. 18- 22
5 Days
Ultimate Systems Solutions Training Center
39, 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.
| 