Test Mode
BUSINESS COMPUTING FOR FINANCIAL PROFESSIONALS
1. COURSE OUTLINE
MODULE 1
- Introduction to Computing
- Introduction to Word Processing – (MS Word)
- Intermediate Word Processing
- Introduction to Spreadsheet – (MS Excel)
- Intermediate Excel
MODULE 2
- Advance Excel for Accountants
- Computerized Accounting
- QuickBooks Accounting Software
. COURSE SYLLABUS – MODULE 1
a. Introduction to Computing
- Breaking the phobia with computers
- Understanding the way the computer works
- Know your computer (You think you do? No you don’t)
- Computer Devices (input, processing and output devices), and how they talk to each other
- Computer Software and Applications
- Conclusion (the finished product)
b. Introduction to Word Processing – (MS Word)
- The fundamentals of word processing
- Understanding the screen
- The tool bar, menu bar, status bar, title bar etc.
- The short cuts
- Creating New Documents
- You can use templates – “really!”
- New Documents
- Using the word wizards – “makes my life easy”
- Saving and Opening Documents
- Before you start, While you’re working, When you’re done
- Creating a file from document
- Naming or changing a file name
- Editing Your Document – “make it look the way the boss wants it”
- Entering the text – “yes you must type”
- Changing fonts sizes or color
- How to copy, move, delete, insert, and paste text – have glue?
- Printing the Document
- Summary/Conclusion (okay for now!)
c. Intermediate Word Processing
- Working with Documents
- Document Styles
- Proof Reading Documents
- Summary/Conclusion
d. Introduction to Spreadsheet – (MS Excel)
- The Old Accountant Ledger (spreadsheet)
- Introduction
- Creating New Excel Spreadsheet
- Working with Workbook in excel
- Multiple worksheet
- Editing Your Spreadsheet – “Make it look the way you want it”
- Summary/Conclusion
e. Intermediate Excel
- Working with Ranges
- Working with Cells
- Calculations & Formulas
- Working with Notes to Cells
- Formatting the Cells
- Printing Excel worksheet and workbook
- Summary/Conclusion
B. COURSE SYLLABUS – MODULE 2
f. Advance Excel for Accountants
- Performing calculations with functions
- The Numbers outlook
- Creating Charts
- Customizing your charts, Saving the charts, Editing the chart
- Importing excel charts into word processor
- Printing the charts
g. Computerized Accounting
- Using Computer for Accounting Functions
- Accounting Packages
- Overview
-
- Types of accounting packages
- Choosing the right accounting package
- Working with your accounting package
h. QuickBooks Accounting Software
- Setting-up your company/client files
- Navigating within QuickBooks
- Charts of Accounts
- Entering account balances
- Entering Bills and Paying Bills
- Accounting Record/File Management
- Creating Reports
- How to customize your reports
- Summary/Review/Conclusion
