Office 2010 Courseware

The courseware listed below is our Office 2010 standard courseware. These products are designed as half-day, 1-day, or 2-day (as required) training sessions. They maintain a standard structure that aides in adult learning and come complete with sample data files to perform various hands on exercises.

In addition, see our Office 2010 Migration Courseware page if you are transitioning from Office 2003.

 

English

cover of the access 2010 level 1 data entry and reports course
Access 2010 - Level 1 - Data Entry and Reports (1 day)

This course is intended for new Microsoft Access 2010 users.

Course Objectives:

  • Identify the components of a database, and work with those components.
  • Open a table, find information stored there, and enter data.
  • Create several query types, edit and run queries, and use action and calculation queries.
  • Create several report types, enhance reports and print preview reports.
  • Preview and print database objects, and change the page setup options.
Price: $17.50
cover of the access 2010 level 1 database design course
Access 2010 - Level 1 - Database Design (2 days)

This course is intended for new Microsoft Access 2010 users.

Course Objectives:

  • Open a table, find information stored there, and enter data.
  • Create and customize a table design.
  • Enter data into tables, and ensure its accuracy by using input masks and input validation formulas.
  • Create relationships between tables to ensure data accuracy and to deploy referential integrity.
  • Create forms for entering data into tables, and change the design elements that have been placed on those forms.
  • Create several query types, edit and run queries, and use action and calculation queries.
  • Create several report types, enhance reports and print preview reports.
  • Import and export data to and from various sources, including text files and Excel.
  • Preview and print database objects, and change the page setup options.
Price: $24.75
cover of the access 2010 level 2 advanced database design course
Access 2010 - Level 2 - Advanced Database Design (1 day)

This course is intended for participants who are familiar with Microsoft Access 2010.

Course Objectives:

  • Enhance tables by creating lookups.
  • Create various types of advanced queries.
  • Create advanced forms by adding controls, subforms, calculations, and graphic images.
  • Create advanced reports by adding controls, grouping, subforms, calculations, graphic images, and charts.
  • Work with and create web-based objects.
Price: $17.50
 
cover of the access 2010 level 3 advanced topics course
Access 2010 - Level 3 - Advanced Topics (1 day)

This course is intended for participants who are familiar with Microsoft Access 2010.

Course Objectives:

  • Understand macro concepts; create, run, and test Access macros.
  • Create and use switchboard forms.
  • Set Access defaults, apply Startup options, and customize the Navigation Pane.
  • Acquire information about running administrative functions in Access.
  • Establish and maintain security in a database.
Price: $17.50
 
cover of the Excel 2010 level 1 course
Excel 2010 - Level 1 (1 day)

This course is intended for new Microsoft Excel 2010 users.

Course 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.
Price: $17.50
 
cover of the Excel 2010 level 2 course
Excel 2010 - Level 2 (1 day)

This course is intended for participants who are familiar with Microsoft Excel 2010.

Course Objectives:

  • Organize, protect, and display data, using various tools.
  • Create linking formulas and use the IF function.
  • Set up multiple worksheets, using information from other sources through consolidation, and copy and paste links to combine information into one worksheet.
  • Create and modify charts to present data effectively; customize charts to enhance their appearance.
  • Create and apply styles to format worksheets consistently and quickly; use conditional formatting, comments, text boxes, and sparklines to highlight and explain data.
Price: $17.50
 
cover of the Excel 2010 level 3 data management course
Excel 2010 - Level 3 - Data Management (1 day)

This course is intended for participants who are familiar with Microsoft Excel 2010.

Course Objectives:

  • Create and use Excel tables, as well as add, edit, search for, and delete records in a data list using a form, as well as look up data.
  • Sort records in a data list using a variety of methods.
  • Filter data in a list using a variety of methods, as well as work with filtered data.
  • Create and work with subtotalled lists, as well as use various database functions to summarize data.
  • Create, modify, and work with PivotTables, PivotCharts, and Slicers.
  • Import external data from a variety of sources into Excel.
Price: $17.50
 
cover of the Excel 2010 level 3 spreadsheet analysis course
Excel 2010 - Level 3 - Spreadsheet Analysis (1 day)

This course is intended for participants who are familiar with Microsoft Excel 2010.

Course Objectives:

  • Use absolute and mixed references in a formula, as well as using financial functions.
  • Use the Goal Seek feature and data tables.
  • Create and manage scenarios, as well as create scenario reports.
  • Define and solve problems with Solver, as well as create reports.
  • Understand and utilize the various tools used to audit workbooks.
Price: $17.50
 
cover of the Excel 2010 level 3 vba macros course
Excel 2010 - Level 3 - VBA Macros (2 days)

This course is intended for participants who are familiar with Microsoft Excel 2010.

Course Objectives:

  • Understand key concepts that will be used to build custom solutions.
  • Become familiar with basic macro techniques for recording, writing, running, and maintaining macros.
  • Understand how Visual Basic for Applications is incorporated, used, and modified.
  • Learn how to design and layout a user form and controls to create a customized dialog box.
  • Understand how to prepare a workbook containing macros and toolbars for deployment.
  • Learn to customize macros with VBA source code to automate data entry tasks and enable source code protection.
  • Learn to enhance source code with variables, constants, and logical operators.
  • Learn to handle errors that can be generated when working with source code.
  • Learn to access external data by using ActiveX Data Objects.
  • Learn how to control Excel objects externally.
Price: $30.00
 
cover of the OneNote 2010 level 1 course
OneNote 2010 - Level 1 (1 day)

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.
Price: $17.50
cover of the Outlook 2010 level 1 course
Outlook 2010 - Level 1 (1 day)

This course is intended for new Microsoft Outlook 2010 users.

Course Objectives:

  • Explore the Outlook 2010 environment, create customized notes, subscribe to RSS feeds, and learn to use Help.
  • Communicate with electronic mail quickly and easily.
  • Manage contact information and track communications.
  • Address, distribute, file, sort, find, and manage messages efficiently.
  • Record, prioritize, and track tasks.
  • Schedule and manage appointments efficiently.
  • Coordinate and schedule meetings with others.
  • Select print styles and print Outlook items.
Price: $17.50
 
cover of the Outlook 2010 level 2 course
Outlook 2010 - Level 2 (1 day)

This course is intended for participants who are familiar with Microsoft Outlook 2010.

Course Objectives:

  • View Web Pages and Favorites, and work with Office 2010 applications while using Outlook.
  • Organize Outlook folders by assigning categories, creating rules, and applying filters.
  • Manage junk e-mail, use autosignatures and stationery, control messages, and use message notifications.
  • Use the productivity-improvement features of the Calendar, Contacts, Tasks, and Mail folders, as well as create and use Outlook forms.
  • Work with shared folders, delegate folder access, and archive Outlook items.
  • Set up Outlook 2010 for mobile use and synchronize mail.
Price: $17.50
 
cover of the powerpoint 2010 level 1 course
PowerPoint 2010 - Level 1 (1 day)

This course is intended for new Microsoft PowerPoint 2010 users.

Course Objectives:

  • Identify PowerPoint 2010 screen elements and terms.
  • Create a new presentation based on templates or themes, and use outlines to organize the text of a presentation.
  • Create a consistent look throughout your presentations by using and customizing themes and styles.
  • Enhance your presentations by using slide layouts and text formatting tools.
  • Use features for organizing and editing the information in your presentations.
  • Enhance presentations by adding and modifying WordArt, SmartArt, and clip art graphics.
  • Produce on-screen slide shows.
Price: $17.50
cover of the powerpoint 2010 level 2 course
PowerPoint 2010 - Level 2 (1 day)

This course is intended for participants who are familiar with Microsoft PowerPoint 2010.

Course Objectives:

  • Customize slide layouts, create and use multiple themes, add graphics to backgrounds, and share custom themes between presentations.
  • Use copied, imported, linked, and embedded data from other presentations and programs to create presentations.
  • Use charts and tables to present data graphically.
  • Use graphics and animation effects to enhance presentations, and increase the impact of text and graphics in a presentation.
  • Add notes and annotations to slides; and use PowerPoint features to rehearse, package, and prepare slide shows for presentation.
Price: $17.50
 
cover of the project 2010 level 1 course
Project 2010 - Level 1 (2 days)

This course is intended for new Microsoft Project 2010 users.

Course Objectives:

  • Understand the basic purpose and operation of the software.
  • Create a new project and create, edit, and outline a task list, as well as establish dependencies by linking tasks.
  • Add and assign resources, work with calendars, and enter project costs, such as standard, variable, and fixed costs.
  • Apply page setup options, create headers and footers, insert page breaks, and preview and print project information.
  • Apply task type settings, modify fixed tasks, set task constraints, and define and format the critical path.
  • Apply preset and custom contours, edit resource assignments, identify and resolve resource overallocations, and set and modify a baseline.
  • Track the progress of a project, update tasks and the schedule, and compare baseline and actual data.
  • Sort, filter, and group views.
  • Format views and format the Gantt Chart.
Price: $26.00
cover of the project 2010 level 2 course
Project 2010 - Level 2 (1 day)

This course is intended for participants who are familiar with Microsoft Project 2010.

Course Objectives:

  • Customize Microsoft Project elements including tables, views, and reports.
  • Use sample templates, create custom templates, and use the Organizer to manage project elements
  • Work with progress lines, Earned Value tables, and Visual Reports.
  • Use and create Import/Export maps
  • Create master projects, insert and work with subprojects, and create links to external tasks
  • Assign tasks to resources from a resource pool, modify resource information, and update the resource pool
  • Work with rollup task bars, hyperlinks, custom WBS codes, and macros.
Price: $17.50
 
cover of the publisher 2010 level 1 course
Publisher 2010 - Level 1 (1 day)

This course is intended for new Microsoft Publisher 2010 users.

Course Objectives:

  • Navigate with the Publisher window, menus, and commands, as well as open, save, close, and view publications.
  • Set the page layout and use the rulers and guides to add and arrange objects.
  • Work with text boxes and format text.
  • Layer and format objects and work with pictures.
  • Use the Design Checker to check for problems in a publication and pack and unpack publications.
Price: $17.50
cover of the visio 2010 level 1 course
Visio 2010 - Level 1 (1 day)

This course is intended for new Microsoft Visio 2010 users.

Course Objectives:

  • Create, open, close, and save drawing files, and work with stencils and drawing pages.
  • Use the drawing features in Visio, including the drawing tools, master shapes, and formatting tools.
  • Use the text editing and formatting tools available in Visio 2010.
  • Use shape connectors, and become familiar with methods of connecting shapes, glue types, and connecting organization charts.
  • Add headers and footers to a drawing, create and apply background pages, and preview drawing files.
  • Use the Find Shape command to locate shapes on stencils, and use the Spelling dialog box to check for and correct spelling errors.
Price: $17.50
cover of the visio 2010 level 2 course
Visio 2010 - Level 2 (1 day)

This course is intended for participants who are familiar with Microsoft Visio 2010.

Course Objectives:

  • Create custom stencils and templates, and modify master shapes.
  • Create custom layers, manage existing layers, and assign shapes to drawing layers.
  • Create, assign, and edit background pages.
  • Manage options for shape behaviours, apply shape protection, and use hyperlinks.
  • Use the techniques involved in manipulating shapes with the shape operation commands.
  • Enter custom shape data and define custom fields using different methods.
  • Import and export Visio data to and from Excel, create PivotDiagrams, and integrate Visio drawings into PowerPoint, as well as apply document protection features.
Price: $17.50
cover of the word 2010 level 1 course
Word 2010 - Level 1 (1 day)

This course is intended for new Microsoft Word 2010 users.

Course Objectives:

  • Understand the concepts of word processing and learn how to start and exit the application, and how to open, save, and close documents.
  • Insert and delete text, print documents, and select different views.
  • Change paragraph alignment, move, copy, and replace text.
  • Change character and paragraph formatting, and apply Quick Styles.
  • Use tab stops, change indents, apply bullets and numbering, and change line spacing.
  • Use margins, page breaks, and headers and footers.
  • Check spelling, use AutoCorrect and AutoText, and use templates.
Price: $17.50
cover of the word 2010 level 2 course
Word 2010 - Level 2 (1 day)

This course is intended for participants who are familiar with Microsoft Word 2010.

Course Objectives:

  • Create and modify tables to organize data and enhance appearance.
  • Use the Mail Merge task pane with different data sources and main documents to create form letters, envelopes, and mailing labels.
  • Use styles to create consistently formatted documents and to facilitate changing paragraph and character formatting.
  • Create and insert Quick Parts to reuse data and content and create documents with consistent standards.
  • Use existing templates to provide consistent document editing and formatting, and create custom form templates.
Price: $17.50
 
cover of the word 2010 level 3 course
Word 2010 - Level 3 (1 day)

This course is intended for participants who are familiar with Microsoft Word 2010.

Course Objectives:

  • Assign themes and insert graphics to documents and Web pages, including the use of clip art, WordArt, SmartArt, charts, and shapes.
  • Divide documents into sections, add headers and footers, and divide pages into multiple text columns.
  • Use Outline view to organize documents, create tables of contents and indexes, add references to help navigate and display document information, sort lists in regular text and tables, and set up mathematical formulas in tables.
  • Track document changes, insert comments, protect documents from being changed, and compare and merge documents.
  • Use macros to automate repetitive actions.
Price: $17.50
 

DCF offers both printed products for purchase and electronic files by licenses for deployment on your intranet, and/or as an internal customization solution.

DCF offers samples to qualified purchasers and decision makers.

Review our courseware catalogue to purchase products.

Review our quick reference guide product synopsis to learn about our long-standing history of quick reference guide design and development.