Office Administrator
This program is designed to prepare the graduate for a position as an Office Administrator or Assistant to a Corporate Executive. It incorporates word processing (MS Word), spreadsheets (MS Excel), database (MS Access) and presentation graphics (MS PowerPoint), as well as overviews of Local Area networks and the Internet. In addition, a module is included on common office procedures.
Course Outline
- MS Office Word
- MS Office Excel
- MS Office Access
- MS Office Powerpoint
- MS Office Outlook
Computerized Accounting
This course provides essential information on how to use accounting in businesses. The course has the objective to answer questions such as the following: How do we gather and organize business information? How do we analyze business information? How do managers use accounting information to control cash and other assets as well as liabilities? How do managers use accounting information to do profit planning? How do manager's use accounting for management planning, control and decisions?
Course Outline
- Fundamental Accounting Principles
- Bookkeeping
- Quickbooks
- Simply Accounting
- ACCPAC
MS Word
Course Outline
- Word Essentials
- Document Basics
- Character Formatting
- Paragraph Formatting
- Document Formatting
- Editing Basics
- Creating Tables and Lists
- Additing Pictures and Shapes to Documents
- Creating a Table of Contents and Index
- Performing Mail Merges
MS Excel
Course Outline
- Excel Essentials
- Creating and editing a Workbook
- Formatting Cells and Ranges
- Worksheet Formatting
- Managing Worksheets
- Working with Data
- Using Basic Formulas and Functions
- Using More Advanced Formulas
- Creating Charts from Your Data
- Adding Pictures and Shapes to a Worksheet
MS Access
Course Outline
- Database Essentials
- Create Database Tables
- Work with Tables
- Modify Tables and Fields
- Create Forms
- Create Reports
- Create and Modify Queries
- Advanced Tables
- Advanced Queries
- Import and Export Data
MS Power Point
Course Outline
- PowerPoint Essentials
- Presentation Basics
- Working with Text
- Designing a Presentation
- Adding Tables to Slides
- Using Charts in a Presentation
- Creating SmartArt Graphics
- Adding Graphics and Media Clips to a Presentation
- Delivering a Presentation
MS Outlook
Course Outline
- Getting to know Outlook
- Email Basics
- Advanced Email Tools
- Managing Mail with Folders
- Processing Massages with Rules
- Contact Basics
- Calendar Basics
- Managing Meetings
- Advanced Calendar Management
- Managing Tasks
Bookkeeping & Accounting
Course Outline
- Accounting: The Key to Success
- Financial Statements and Accounting Transactions
- Analyzing and Recording Transactions
- Adjusting Accountings for Financial statements
- Completing the Accounting Cycle and Classifying Accounts
- Accounting for Merchandising Activities
- Merchandise Inventories and Cost of Sales
- Accounting Information Systems
- Internal Control and Cash
- Receivables
- Payroll Liabilities
QuickBooks
Course Outline
- Getting started QuickBooks
- Setting up QuickBooks
- Working with lists
- Working with bank accounts
- Using other accounts in QuickBooks
- Entering sales and invoices
- Receiving payments and making deposits
- Entering and paying bills
- Analyzing financial data
- Setting up inventory
- Tracking and paying sales tax
- Doing payroll with QuickBooks
- Estimating and progress invoicing
- Tracking time
- Customizing forms & writing QuickBooks letters
QuickBooks 2009 Premier
Saturday from 9 a.m. to 3 p.m. - 5 weeks $345.00
Canadian Technology College issues a Certificate after completion of the course.
Co-op Placements are available for successfully graduated students.
Course Outline
- Introduction to QuickBooks software
- Entering Opening Balances
- Operating a Vendor(Payable) Module
- Operating Customer(Receivable) Module
- Operating Inventory and Services Module
- Reconceling the Bank Account
Simply Accounting
Course Outline
- Getting started Simply Accounting
- Getting Started
- The Goods and Services Tax
- Applications for different companies
- Missoni Marbleworks
- Toss for Tots
- Chai Tea Room
- Air Care Services
- Anderson Chiropractic Clinic
- Maple Leaf Rags
- Dorfmann Design
- Lime Light Laundry
- Adrienne Aesthetics
- Truman Tires
- Village Galleries
- Tesses Tresses
- Flabuless Fitness
- Stratford Country Inn
-Maple Leaf Rags Web Store
- Using Simply Accounting Pro
- Using Simply Accounting Pro
- Flabuless Fitness - Time and Billing
- Flabuless Fitness - Departmental Accounting
ACCPAC
Course Outline
- General Ledger
- System Manager
- G/L Setup
- Chart of Accounts
- Opening Balances
- Budget Data
- Daily Transactions
- Displaying Account Information
-Periodic Processing
- Accounts Payable
- Bank Services and Tax Services
- Accounts Payable Setup
- Vendor Maintenance
- Opening Balances and Current Year Transactions
- Adjustments
- Payment Entry
- Accounts Payable Periodic Processing
- Accounts Receivable
- Accounts Receivable Setup
- Customer Maintenance
- Accounts Receivable Invoice Entry
- Adjustment Processing
- Receipt Processing
- Periodic Batch Processing
- Periodic Processing
- Year-End Procedures