New Courseware

English

Access 2013 - Level 1 - Data Entry and Reports course
Access 2013 - Level 1 - Data Entry and Reports (1 day)

This course is intended for new Microsoft Access 2013 users.

Learning 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
 
Access 2013 - Level 1 - Database Design course
Access 2013 - Level 1 - Database Design (2 day)

This course is intended for new Microsoft Access 2013 users.

Learning Objectives:

  • Identify the components of a database, and work with those components.
  • 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: $26.00
 
Excel 2013 - Level 1 course
Excel 2013 - Level 1 (1 day)

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.
Price: $17.50
 
Excel 2013 - Level 2 course
Excel 2013 - Level 2 (1 day)

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.
Price: $17.50
 
Excel 2013 - Level 3 - Data Management course
Excel 2013 - Level 3 - Data Management (1 day)

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

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
 
Excel 2013 - Level 3 - Spreadsheet Analysis course
Excel 2013 - Level 3 - Spreadsheet Analysis (1 day)

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

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
 

 

Excel 2013 - Level 3 - VBA Macros course
Excel 2013 - Level 3 - VBA Macros (2 days)

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

Course Objectives:

  • Understand key concepts that will be used to build custom solutions using Microsoft Excel VBA Macros.
  • Become familiar with basic macro techniques for recording, writing, running, and maintaining macros.
  • Understand how Visual Basic for Applications is incorporated, used, and modified in Microsoft Excel.
  • Learn how to design and layout a user form and controls to create a customized dialog box to simplify data entry.
  • Understand how to prepare an Excel workbook containing macros and toolbars for deployment to other users and machines.
  • 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 the three types of errors that can be generated when working with source code.
  • Learn to access external data by using ActiveX Data Objects.
  • Learn how to use Excel as an automation server to control Excel objects externally outside of the application.
Price: $30.00
 
introduction to microcomputers and windows 7
Introduction to Microcomputers and Windows 7 (1-day)

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.
Price: $17.50
quick reference guide and lab guide cover of the office 2010 migration course
Office 2003 to 2010 - Migration (2 days)

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.
Price: $34.50
microsoft-office-2010-user-interface
Office 2010 - User Interface (.5 day)

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)
Price: $14.00
Office 2010 to 2016 - New Features course
Office 2010 to 2016 - New Features (1 day)

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

Learning Objectives:

  • Understand and use new and improved features that are shared across various Microsoft Office applications.
  • Understand and use new and improved features of Microsoft Word.
  • Understand and use new and improved features of Microsoft Excel.
  • Understand and use new and improved features of Microsoft PowerPoint.
  • Understand and use new and improved features of Microsoft Outlook.
  • Understand and use new and improved features of Microsoft OneNote.
Price: $17.50
 
Office 2013 - New Features course
Office 2013 - New Features (1 day)

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

Learning Objectives:

  • Understand and use new and improved features that are shared across various Microsoft Office 2013 applications.
  • Understand and use new and improved features of Microsoft Word 2013.
  • Understand and use new and improved features of Microsoft Excel 2013.
  • Understand and use new and improved features of Microsoft PowerPoint 2013.
  • Understand and use new and improved features of Microsoft Outlook 2013.
  • Understand and use new and improved features of Microsoft OneNote 2013.
Price: $17.50
 
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
Outlook 2013 - Level 1 course
Outlook 2013 - Level 1 (1 day)

This course is intended for new Microsoft Outlook 2013 users.

Learning Objectives:

  • Explore the Outlook 2013 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
 
Outlook 2013 - Level 2 course
Outlook 2013 - Level 2 (1 day)

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

Learning Objectives:

  • View Web Pages and Favorites, and work with Office 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 for mobile use and synchronize mail.
Price: $17.50
 
Powerpoint 2013 - Level 1 course
PowerPoint 2013 - Level 1 (1 day)

This course is intended for new Microsoft PowerPoint 2013 users.

Learning Objectives:

  • Identify PowerPoint 2013 screen elements and terms in preparation for making efficient use of the program.
  • Start 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, and learn how to preview and print your presentations.
  • Enhance your presentations by using PowerPoint 2013 slide layouts and text formatting tools.
  • Use PowerPoint’s 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
 
PowerPoint 2013 - Level 2 course
PowerPoint 2013 - Level 2 (1 day)

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

Learning 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
 
Project 2013 - Level 1 course
Project 2013 - Level 1 (2 days)

This course is intended for new Microsoft Project 2013 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
Project 2013 - Level 2 course
Project 2013 - Level 2 (1 day)

This course is intended for participants familiar with Microsoft Project 2013.

Course Objectives:

  • Customize Microsoft Project 2013 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
microsoft-windows-8-level 1
Windows 8 - Level 1 (1-day)

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.
Price: $17.50
microsoft-windows-xp-to-7-migration
Windows XP to 7 Migration (.5 day)

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.
Price: $14.00
Word 2013 - Level 1 Course
Word 2013 - Level 1 (1 day)

This course is intended for new Microsoft Word 2013 users.

Learning Objectives:

  • Understand the concepts of word processing and learn how to start and exit Microsoft Word 2013, and open, save, and close documents.
  • Learn how to insert and delete text to edit a document, then print the document and select different views.
  • Learn how to change paragraph alignment, and how to move, copy, and replace text in a document.
  • Modify and enhance text appearance by changing character and paragraph formatting, and using Quick Styles.
  • Use tab stops, change indents, apply bullets and numbering, and change line spacing to enhance document appearance.
  • Use margins, page breaks, and headers and footers to enhance the page layout.
  • Simplify proofreading of documents by checking spelling, enhance productivity by using AutoCorrect and AutoText, and streamline document creation by using templates.
Price: $17.50
 
Word 2013 Level 2 Course
Word 2013 - Level 2 (1 day)

This course is intended for users familiar Microsoft Word 2013 users.

Learning 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
 
Word 2013 Level 3 Course
Word 2013 - Level 3 (1 day)

This course is intended for users familiar Microsoft Word 2013 users.

Learning Objectives:

  • Assign themes and insert graphics to add visual appeal to documents and Web pages created in Word, including the use of clip art, WordArt, SmartArt, charts, and shapes.
  • Divide documents into separate sections, add headers and footers, and divide pages into multiple text columns.
  • Use Outline view and the Navigation pane 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 Word tables.
  • Track document changes, insert comments, protect documents from being changed, and compare and merge documents.
  • Record and edit macros to automate repetitive actions, assign keyboard shortcuts to macros, and customize the Quick Access Toolbar to quickly access macros and commands.
Price: $17.50
 
Word 2016 - Level 1 Course
Word 2016 - Level 1 (1 day)

This course is intended for new Microsoft Word 2016 users.

Learning Objectives:

  • Understand the concepts of word processing and learn how to launch and close Microsoft Word 2016, as well as open, save, and close documents.
  • Learn how to insert and delete text to edit a document, then print the document and select different views.
  • Learn how to change paragraph alignment, and how to move, copy, and replace text in a document.
  • Modify and enhance text appearance by changing character and paragraph formatting, and using Quick Styles.
  • Use tab stops, change indents, apply bullets and numbering, and change line spacing to enhance document appearance.
  • Use margins, page breaks, and headers and footers to enhance the page layout.
  • Simplify proofreading of documents by checking spelling, enhance productivity by using AutoCorrect and AutoText, and streamline document creation by using templates.
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.