Course Catalog – PC & Mac

Computer Basics – Half Day Course

Microsoft Office: 2010/2013 Skills Update – Full Day

Microsoft Office: Mac 2008/2011 Skills Update – Full Day

Microsoft Project: 2010/2013 Skills Update – Full Day

For More Course Offerings or cost of training sessions on any of the Software or Technology we support, please contact us for details.


Computer Basics

New to computers? Learn how to take control and master the basics: startup, mouse use, operating system and program (application) navigation, and computer terminology.

Basic computer interaction: Using the mouse and keyboard* to navigate the computer desktop and file system (menus, hard drives, windows, folders, icons, files).

Basic file and folder manipulation: Learn how to name or rename folders, move folders to new locations and move files into folders. Learn the differences between file types for programs (applications), folders, and documents.

Data Storage: Learn about several different types of data storage commonly available (CDs, DVDs, Flash Drives, floppy discs), how to format drives / discs, how to copy to /from storage devices, and how to properly eject storage devices to not damage the data.

Computer Terminology & Program Types: What is an application or app vs a program? What are bytes, viruses, trojans. What is the difference between a word processor, email client, web browser, database, spreadsheet, or graphics program?

Basic Computer Security: passwords, virus protection, firewall basics and finding free-ware on the internet

*While the keyboard will be used as part of this class, this is not a typing / keyboarding class.

Pre-requisites: keyboarding … Time: 4 hours

Textbook provided:
Easy Computer Basics, Windows 7 Edition by Michael Miller
[QUE Publisher]

[Return to Catalog]


Microsoft Office 2010 or 2013 Skills Update

Upgrading MS Office? This course will familiarize you with the Office’s new Fluent User Interface (a tabbed toolbar, also known as the Ribbon) and productivity features. Training includes both features common to the entire application suite as well as application specific features for Word, Excel, PowerPoint, and Outlook. Learn how Office 2007 or 2010 compares to older versions of Microsoft Office (2000-2003). Enhance your productivity by quickly getting up to speed with the new interface and productivity tools.

User Interface: What’s new? Fluent User Interface (a tabbed toolbar called the ribbon) replaces the menu / toolbar combination; Office button; Quick Access toolbar. Overview of user interface components and changes.

Compatibility Check: How to inspect a document and run the compatibility checker.

Word Update: What’s new with Word?

    • Word Ribbon
    • Document creation and formatting
    • Themes and Quick Styles (style sheets)
    • Spelling and Grammar plus Contextual Spell Check
    • Tables, table styles, graphs, and Quick Tables
    • Graphics in Word: preset format galleries, quick parts, SmartArt Graphics
    • Customize your Word Quick Access Toolbar

Excel Update: What’s new with Excel?

    • Excel Ribbon
    • Tables: creation, sorting, filtering, table attributes
    • Lists, Ranges, and Named Ranges vs. Tables: how to tell the difference
    • Charts / Graphs: changes in Excel, contextual tabs, 3-D formatting and new types
    • Functions / Formulas: understanding the IF ERROR function, stop-if-true condition, formula auto-complete, conditional sum functions, and using the formula ribbon
    • Cell Formatting changes: conditional formatting data bars, color scales, and icon sets; format rules manager; format conditions now only limited by system memory
    • Save and Print: header, footer, and margins galleries plus new page layout view
    • Customize your Excel Quick Access Toolbar

PowerPoint Update: What’s new with PowerPoint?

    • PowerPoint Ribbon and task bar changes
    • Themes and Quick Styles
    • Slides: master slide, slide layouts, and content slides, slide transitions
    • Tables and charts in a slide from Word and Excel
    • Review Ribbon to edit and proof your presentations
    • Live Preview for evaluating themes
    • Other additions: footers, animations, SmartArt, and Ink Annotations
    • Customize your PowerPoint Quick Access Toolbar

Outlook Update: What’s new with Outlook?

    • Outlook Ribbon
    • Navigating Outlook: menus, toolbars, navigation pane, to-do bar, and viewing pane
    • Time Management: calendars, multiple calendar overlay, task interface (create, categorize, prioritize, assign), To-Do bar
    • E-mail Messaging: attachment previews, e-mail problem solving, email calendars, auto-archive
    • Contact Management: contacts, categories, e-business cards, category colors
    • Search: finding Outlook objects, creating search folders, and searching e-mails and contact lists

Pre-requisites: Office 2000-2007 or similar experience … Time: 8 hours

Textbook provided depending on software version:
Step by Step Microsoft Office Home and Student 2010 or 2013 by Joan Preppernau, Joyce Cox, and Curtis Frye
[Microsoft Press
]
Or alternate textbook for O, ffice System version: Step by Step Microsoft Office System 20010 or 2013 by Joyce Cox, Curtis Frye, M. Dow Lambert III, Steve Lambert, John Pierce, and Joan Preppernau
[Microsoft Press]

[Return to Catalog]

Microsoft Office: Mac 2008 or 2011 Skills Update

Upgrading to Office: Mac 2008 or 2011? This course will familiarize you with the Office: Mac 2008’s new common interface elements and productivity features. Enhance your productivity by quickly getting up to speed with the new interface and productivity tools.

Office Basics

    • Explore and Manage the Office Interface
    • Practice Basic Office File Skills
    • Work in Office Programs

Create Basic Office Files

    • Create Word documents
    • Create Excel workbooks
    • Create PowerPoint presentations

Work with Office File Content

    • Work with Word document content
    • Work with Excel sheet content
    • Create Excel formulas
    • Work with PowerPoint slide content

 

Enhance Office File Content

    • Format Office File content
    • Create and insert graphics
    • Review Word documents
    • Add finishing document elements

Stay In Touch and On Time

    • Communicate Online – Entourage
    • Manage Contacts and Schedules

Pre-requisites: Office 97-2004 or similar experience … Time: 8 hours

Textbook provided:
Step by Step Microsoft Office: Mac 2008 by Joan Preppernau
[Microsoft Press]

[Return to Catalog]

Microsoft Project 2010 or 2013 Skills Update

Upgrading MS Project?  This application will keep projects organized and on track with Project Standard 2010 or 2013. The user can take advantage of flexible features that help you get started and make you more efficient and productive. The user can easily create modern reports to measure progress and communicate project details effectively with your team and stakeholders.

What you will learn:

  1. Enhanced tools like Team Planner that can help you see and amend potential problems before they can affect your schedule.
  2. This application has rich, out-of-the-box reporting tools within a familiar Office-like experience help you quickly and easily measure progress and resource allocation.
  3. Set tasks to “Inactive” and quickly analyze “what if” scenarios without recreating your entire project plan.
  4. Task Path highlighting in the Gantt Chart lets you know how your tasks come together and helps you identify which tasks are the most critical to your project’s success.
  5. Timeline view can help you visualize your project to deliver stellar presentations to your team, executives, and stakeholders.
  6. Works well with Office, Office 365, SharePoint, and Lync, to give you a complete collaborative project management system.
  7. Handouts will be the reference Quick Guide Charts that are laminated for many uses so you can quickly look up information.
  8. Customized booklet can be developed, as needed.

Pre-requisites: Project 2007 or similar experience … Time: 8 hours

Textbook provided depending on software version: TBD