Course Overview
The objective of this course is to supply students with the knowledge and skills necessary to compete in today’s ever evolving, computerized office environment. The classroom environment fosters enhanced communication and organizational skills as well as an emphasis on maintaining professionalism in the workplace.
This hands-on, interactive course covers three major components critical to today's office professionals: computer literacy, business computing skills, and business accounting skills with QuickBooks and Excel.
The computer literacy aspect of the course will focus on the history of the personal computer, basic computer hardware and software knowledge, understanding your operating system, file management, internet browsing, and using email. The business computing section of the program will focus on business writing and Microsoft Office 2007 applications which include Microsoft Word, Excel, Access, PowerPoint and Outlook. The business accounting component focuses on using Intuit’s QuickBooks program to perform introductory and intermediate business accounting functions and will also teach students how to apply Microsoft Excel in a business environment.
Graduates will obtain the skill set and gain the knowledge necessary to pass the Microsoft Office Specialist (MOS) Certification exams. The course will also help prepare the student to take the QuickBooks end-user certification exam. In addition students will have the opportunity to study for the Customer Support Specialist (CSS) certification test.
Ideal career tracks for this course: Executive Assistant, Office Administrator, Business Entrepreneur/Consultant, Receptionist, Medical Office Assistant, Accounts Receivable/Accounts Payable Clerk, etc.
Course Outline
Introduction to Computers
20 Hours
Film: Triumph of the Nerds
Introduction to Computers
Using Windows XP
Keyboarding Essentials
Microsoft Office 2007 Basics and the Internet
Business Writing and Communication
20 Hours
Back to the Basics (Spelling, Punctuation and Usage)
Your Writing Style – Choosing Your Words Carefully
Improving Your Business Writing (Memos and Letters)
Writing for Special Circumstances
Knowing Your Audience
Microsoft Word
64 Hours
Word Basics
Basic Editing
Helpful Word Features
Formatting Text
Formatting Paragraphs and Documents
Working with Graphics
Working with Documents
Increasing Efficiency Using Word
Microsoft Excel
64 Hours
Excel Basics
Changing the Appearance of a Worksheet
Organizing the Worksheet
Worksheet Formulas
Function Formulas
Making the Worksheet Useful
Working with Multiple Worksheets
Worksheet Charts
Microsoft Access
68 Hours
Access Basics
Manipulating Data
Creating and Modifying Forms
Finding and Ordering Data
Reports and Macros
Integrating Access
Advanced Database Features
Microsoft PowerPoint
44 Hours
PowerPoint Basics
Creating and Enhancing PowerPoint Presentations
Working with Visual Elements
Expanding on PowerPoint Basics
Microsoft Outlook
40 Hours
Outlook Basics
Calendar
Working with Other Outlook Tools
Customizing and Sharing Outlook Information
Advanced Outlook Features
Introduction to QuickBooks
64 Hours
Introducing QuickBooks
The Sales Process
Tracking Revenue
Managing Expenses
Bank Reconciliation
Reports and Graphs
Company File Setup and Maintenance
Customizing QuickBooks
Walker Graphic Design Business Scenario
QuickBooks Intermediate
24 Hours
Time and Billing
Payroll Setup
Adjustments and Year-End Procedures
Horizon Financial Planning Business Scenario
Career Development
24 Hours
Goal-Setting Techniques
Resume Writing Workshop
Cover Letter Writing Workshop
Interview Strategies
Mock Interview Day
Enrollment Requirements
To be eligible for admission into Network Learning Institute potential students must be at least eighteen years of age or older on the first day of class, and meet or exceed at least one of the following guidelines:
- Possess a high school diploma.
- Possess the recognized equivalency of a high school diploma.
- Score a satisfactory on an Ability-to-Benefit exam.
Course Prerequisites
- A minimal understanding of computers.
- A minimal understanding of the Internet.
Needs Assessment
According to the Bureau of Labor Statistics, employment of secretaries and administrative assistants is expected to grow about as fast as average for all occupations. Secretaries and administrative assistants will have among the largest numbers of new jobs arise, about 362,000 over the 2006-16 period. Additional opportunities will result from the need to replace workers who transfer to other occupations or leave this occupation.
Employment of secretaries and administrative assistants is expected to increase about 9 percent, which is about as fast as average for all occupations, between 2006 and 2016. Projected employment varies by occupational specialty. Employment of executive secretaries and administrative assistants is projected to grow faster than average for all occupations. Growing industries—such as administrative and support services; health care and social assistance; and professional, scientific, and technical services—will continue to generate the most new jobs.
In addition to jobs created from growth, numerous job opportunities will arise from the need to replace secretaries and administrative assistants who transfer to other occupations, especially exceptionally skilled executive secretaries and administrative assistants who often move into professional occupations. Job opportunities should be best for applicants with extensive knowledge of software applications and for experienced secretaries and administrative assistants. Opportunities also should be very good for those with advanced communication and computer skills.
Examples of Related Occupational Areas:
Bookkeeping clerks
Accounting Clerks
Receptionists
Legal Secretary
Medical Secretary
Court Reporter
Human Resource Assistant
Personnel Assistant
Data Entry Clerk
Medical Assistants
Medical Records Clerk
Paralegal
What's the next step?
Contact N.L.I. for a free consultation and evaluation appointment and one of our admissions specialist will be more than happy to assist you.
