Microsoft Excel
Description: The Complete Guide to Excel teaches users how to create spreadsheets from simple checkbooks to price sheets, market forecast and scenarios.
Objectives: On completion, users will be able to:

  • Create a spreadsheet.
  • Create formulas with the Function Wizard or manually.
  • Audit equations and troubleshoot errors.
  • Analyze data by Sort, Filter, Subtotal, and PivotTables.
  • Format spreadsheets, graphs and lists for printing

Length: There are three levels of Excel: Beginning, Intermediate and Advanced. Each lesson has 6 modules. Each module can be completed in 30 minutes or less.

Microsoft Word
Description: The Complete Guide to Word teaches users how to create documents from simple letterheads and envelopes to custom web pages.
Objectives: On completion, users will be able to:
  • Create a document.
  • Format fonts, paragraphs, bullets and tables
  • Use tables for on-line forms and webpage designs.
  • Automate mail merges
  • Share documents with a workgroup.

Length: There are three levels of Word: Beginning, Intermediate and Advanced. Each lesson has 6 modules. Each module can be completed in 30 minutes or less.

Microsoft PowerPoint
Description: The Complete Guide to PowerPoint offers examples of colorful, animated slideshows.
Objectives: On completion, users will be able to:
  • Create a slideshow.
  • Format fonts, paragraphs, bullets and text boxes
  • Use custom animation, slide transitions and effects.
  • Use graphics, sound and on-screen navigation.
  • Prepare a slide show for live presentations and kiosk demonstrations.

Length: There are two levels of PowerPoint: Beginning and Advanced. Each lesson has 6 modules. A module can be completed in 30 minutes or less.

Microsoft Outlook
Description: The Complete Guide to Outlook teaches users how to set up and use email, an electronic calendar, contacts, tasks, and journal entries effectively. Security, administration and backups are also demonstrated.
Objectives: On completion, users will be able to:
  • Use email, Contacts, and work with attachments safely.
  • Organize the Inbox and filter junk mail.
  • Schedule meetings, recurring appointments, and tasks
  • Analyze Outlook data in Microsoft Excel or Access.

Length: There are three levels of Outlook: Email, Calendar, and Administration. Each lesson has 6 modules. A module can be completed in 30 minutes or less.

Microsoft Access
Description: The Complete Guide to Access teaches users how to create database tables, forms, queries and reports. The focus is on optimizing the databases for efficient data entry and generating comprehensive reports.
Course Objectives: On completion, users will be able to:
  • Create tables, forms and reports.
  • Use queries to find, filter, update and calculate.
  • Create forms that handle data automatically
  • Optimize the database for easy navigation, and data input.

Length: There are three levels of Access: Beginning, Intermediate and Advanced. Each lesson has 5 modules. Each module can be completed in 30 minutes or less.


    • Course Overview/Description Course Objectives Course Outline Prerequisites/Audience PC Requirements/Materials Included Instructor Bio FAQs See a Demo
  •  
  • Administrative Professional with Microsoft Certified Application Specialist Training
  • Administrative Professional with Microsoft Office Specialist
  • Bookkeeping the Easy Way with Quickbooks
  • Certified Bookkeeper
  • Certified Global Business Professional
  • Certified Wedding Planner
  • Chartered Tax Professional
  • Chartered Tax Professional for California Residents
  • Corporate Governance and Ethics
  • eBusiness Certificate
  • Emergency Management Training
  • English as a Second Language - Global English
  • Entrepreneurship: Start-Up and Business Owner Management
  • Event Management and Design
  • Fitness Business Management
  • Freight Broker/Agent Training
  • Grant Writing
  • Help Desk Analyst: Tier 1 Support Specialist
  • Lean Mastery
  • Management for IT Professionals
  • Management Training
  • Mediation and Dispute Resolution
  • Microsoft Access 2007
  • Microsoft Excel 2007
  • Microsoft Office Specialist 2003 (MOS)
  • Microsoft Outlook 2007
  • Microsoft PowerPoint 2007
  • Microsoft Vista Business
  • Microsoft Word 2007
  • Non-Profit Management
  • Nutrition for Optimal Health, Wellness, and Sports
  • Paralegal
  • Pay Per Click Marketing
  • Payroll Practice and Management
  • Personal Financial Planning
  • Personal Training and Group Exercise Training for Older Adults
  • Principles of Private Investigation
  • Project Management
  • Purchasing & Supply Chain Management
  • Records Management Certificate
  • Search Engine Marketing
  • Search Engine Optimization
  • Seven Steps to Leading High Achieving Teams
  • Six Sigma Black Belt
  • Six Sigma Green Belt
  • Technical Writing
  • Travel Agent Training
  • Understanding Earned Value Management
  • Women's Exercise Training and Wellness

Microsoft Certified Application Specialist Training (MCAS)

GES 804 -- 120 hours

Course Objectives


    Microsoft Excel
    Description: The Complete Guide to Excel teaches users how to create spreadsheets from simple checkbooks to price sheets, market forecast and scenarios.
    Objectives: On completion, users will be able to:

    • Create a spreadsheet.
    • Create formulas with the Function Wizard or manually.
    • Audit equations and troubleshoot errors.
    • Analyze data by Sort, Filter, Subtotal, and PivotTables.
    • Format spreadsheets, graphs and lists for printing

    Length: There are three levels of Excel: Beginning, Intermediate and Advanced. Each lesson has 6 modules. Each module can be completed in 30 minutes or less.

    Microsoft Word
    Description: The Complete Guide to Word teaches users how to create documents from simple letterheads and envelopes to custom web pages.
    Objectives: On completion, users will be able to:
    • Create a document.
    • Format fonts, paragraphs, bullets and tables
    • Use tables for on-line forms and webpage designs.
    • Automate mail merges
    • Share documents with a workgroup.

    Length: There are three levels of Word: Beginning, Intermediate and Advanced. Each lesson has 6 modules. Each module can be completed in 30 minutes or less.

    Microsoft PowerPoint
    Description: The Complete Guide to PowerPoint offers examples of colorful, animated slideshows.
    Objectives: On completion, users will be able to:
    • Create a slideshow.
    • Format fonts, paragraphs, bullets and text boxes
    • Use custom animation, slide transitions and effects.
    • Use graphics, sound and on-screen navigation.
    • Prepare a slide show for live presentations and kiosk demonstrations.

    Length: There are two levels of PowerPoint: Beginning and Advanced. Each lesson has 6 modules. A module can be completed in 30 minutes or less.

    Microsoft Outlook
    Description: The Complete Guide to Outlook teaches users how to set up and use email, an electronic calendar, contacts, tasks, and journal entries effectively. Security, administration and backups are also demonstrated.
    Objectives: On completion, users will be able to:
    • Use email, Contacts, and work with attachments safely.
    • Organize the Inbox and filter junk mail.
    • Schedule meetings, recurring appointments, and tasks
    • Analyze Outlook data in Microsoft Excel or Access.

    Length: There are three levels of Outlook: Email, Calendar, and Administration. Each lesson has 6 modules. A module can be completed in 30 minutes or less.

    Microsoft Access
    Description: The Complete Guide to Access teaches users how to create database tables, forms, queries and reports. The focus is on optimizing the databases for efficient data entry and generating comprehensive reports.
    Course Objectives: On completion, users will be able to:
    • Create tables, forms and reports.
    • Use queries to find, filter, update and calculate.
    • Create forms that handle data automatically
    • Optimize the database for easy navigation, and data input.

    Length: There are three levels of Access: Beginning, Intermediate and Advanced. Each lesson has 5 modules. Each module can be completed in 30 minutes or less.


Find a School