New Courseware

This course is intended for new Microsoft Excel 2013 users.

Learning Objectives:

• Create, save, open, close and move around in an Excel workbook to learn navigation skills necessary for creating and using Excel worksheets.
• Organize columns and rows to accommodate information and edit the contents of cells to organize the information in your worksheet.
• Calculate values by entering formulas into cells and specify an exact address of a cell by creating an absolute cell reference, create formulas by typing functions or build more complex formulas using the Insert Function dialog box.
• Format worksheets and use view features to more effectively review large worksheets.
• Use views to determine the layout of a worksheet, change the page setup, and preview/print workbooks.

This course is intended for intermediate Microsoft Excel 2013 users.

Learning Objectives:

• Organize, protect, and display data using various tools.
• Use the IF function, create linking formulas, and manage links.
• Manage and arrange multiple workbooks, insert and manage multiple worksheets within a workbook, and consolidate data from multiple sources.
• Create and modify charts to present data effectively; customize charts to enhance their appearance.
• Create, apply and modify styles to format worksheets consistently and quickly; use comments, text boxes to annotate worksheets, and sparklines to highlight and explain data.

This course is intended for new personal computer and Windows 7 users.

Course Objectives:

• Understand the basic components of a personal computer, as well as portable computers, and networks.
• Understand basic system and different application and utility software.
• Recognize the basic interface features of Windows 7 and learn how to use them.
• Use the tools necessary to manage files and folders, including the Desktop, folder windows, views, and search features.
• Use networking features available in Windows 7.
• Print documents, including learning how to manage print queues, and cancel and resume print jobs.
• Customize your Windows 7 interface, Desktop, and working environment.

This course is intended for Microsoft Office 2010 users transitioning from Microsoft Office 2003.

Course Objectives:

• Understand and use the Microsoft Office 2010 user-interface, including its screen components and how to customize the Ribbon, as well as Backstage view commands.
• Understand and use Microsoft Office 2010 shared features.
• Understand and use new and improved Microsoft Word 2010 features.
• Understand and use new and improved Microsoft Excel 2010 features.
• Understand and use new and improved Microsoft PowerPoint 2010 features.
• Understand and use new and improved Microsoft Outlook 2010 features.

This course is intended for new Microsoft Office 2010 users.

Course Objectives:

• Learn about the Microsoft Office 2010 user-interface enhancements and how to use them including, the Ribbon, the Quick Access Toolbar, Galleries and Live Preview, the Mini toolbar and the Status bar.
• Learn about the Microsoft Office 2010 Backstage view and its components.
• Learn about the Microsoft Office 2010 XML file formats and the tools used to help you maintain file formats.
  (supplemental topic)

This course is intended for new Microsoft OneNote 2010 users.

Course Objectives:

• Create, save, open, close and move around in OneNote 2010 notebooks, as well as select different views, and obtain Help.
• Insert and manage sections, pages, edit notebook properties, as well as insert various types of notes, work with page versions, and page spacing.
• Create links, apply and manage note tags, and search notebooks to locate specific notes.
• Create shared notebooks, share existing notebooks, and work with others in shared notebooks simultaneously.
• Apply, create, and use and various types of templates, as well as use various integration features that allow you to work with other programs, such as Office 2010 and Internet Explorer.

This course is intended for new Microsoft Windows 8 users.

Course Objectives:

• Recognize the basic interface features of Windows 8 such as user interface components, and learn how to launch and close programs, manage windows, and obtain Help.
• Use the tools necessary to manage files and folders, including the Desktop, folder windows, views, and search features.
• Use networking features available in Windows 8.
• Print documents, open and manage print queues from the Desktop working environment.
• Customize the Windows 8 Desktop and working environment.

This course is intended for new Microsoft Windows 7 users.

Course Objectives:

• Learn about the Microsoft Windows 7 user-interface enhancements and how to use them including the Aero Desktop, Gadgets, Windows Search, Taskbar Live Preview, as well as window management techniques.
• Learn about the Microsoft Windows 7 file management enhancements including, folder and file navigational components and techniques, libraries, folder views, folder and file icons, file list filtering, and searching for files.