NEW Training Schedule

UPSKILL YOUR TEAM WITH ELEARNING

Now's the time to embrace the opportunity to upskill your team(s) with virtual instructor-led training. Courses include various training levels for Access, Word, Excel, PowerPoint, Visio, and more! Check out the calendar below + all the course descriptions and learn how your team can level up with eLearning.

25-60%
increase retentation rates with use of eLearning.

18% Boost
in employee engagement for companies using eLearning.

$30 In Productivity
is produced for every dollar invested in online training.

Expecting a PDF?

We created this eBook as a web page for better mobile optimization, accessibility, & maintenance. Remember, you can bookmark this page for future reading, save it to the reading list on your mobile device, or print a hard copy. If you'd still like a PDF version of this eBook, you can download it here:

ACCESS PDF Print This Page

Fall Training Calendar [Sept-Dec]

September 2021

  • Sept 13 | Word Level 1
  • Sept 14 | Excel Level 1
  • Sept 15 | PowerPoint Level 1
  • Sept 27 | Excel Level 2
  • Sept 28 | Access Level - Day 1
  • Sept 29 | Access Level - Day 2

 

October 2021

  • Oct 4 | Word Level 2
  • Oct 6 | Excel Level 3 - Data Management
  • Oct 12 | Project Level 1 - Day 1
  • Oct 13 | Project Level 1 - Day 2
  • Oct 18 | Excel Level 3 - Spreadsheet Analysis
  • Oct 19 | Word Level 3
  • Oct 25 | Excel Level 1
  • Oct 26 | Visio Level 1

November 2021

  • Nov 1 | Access Level 1 - Day 1 
  • Nov 2 | Access Level 1 - Day 2
  • Nov 3 | Word Level 1
  • Nov 8 | Excel Level 2
  • Nov 9 | Word Level 2
  • Nov 15 | Excel Level 3 - Spreadsheet Analysis
  • Nov 16 | Access Level 2
  • Nov 22 | PowerPoint Level 1
  • Nov 23 | Excel Level 3 - Data Management
  • Nov 24 | Word Level 3
  • Nov 29 | Excel Level 3 - VBA Marcos Day 1
  • Nov 30 | Excel Level 3 - VBA Macros Day 2

December 2021 

  • Dec 1 | Excel Level 1
  • Dec 6 | Word Level 1
  • Dec 7 | Excel Level 2
  • Dec 8 | Visio Level 1
  • Dec 13 | Excel Level 3 - Data Management

 

BOOK MY COURSE(S)

Course Descriptions

Microsoft Word - Level 1 | 1-Day Course

Who should attend? This course is intended for new Microsoft Word users.

Prerequisites: Windows XP, Windows Vista, Windows 7, Windows 8, or Windows 10

Learning Takeaways: 

  • Understand the concepts of word processing and learn how to start and exit Microsoft Word, and open, save, and close documents.
  • Insert and delete text to edit a document and print the document and select different views.
  • Change paragraph alignment, and move, copy, and replace text in a document.
  • 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.

Access Full Course Overview

Microsoft Word - Level 2 | 1-Day Course

Who should attend? This course is intended for participants who are familiar with Microsoft Word.

Prerequisites: Microsoft Word - Level 1

Learning Takeaways:

  • Create and modify tables to organize data and enhance the 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

Access Full Course Overview

BOOK MY COURSE(S)

Microsoft Word - Level 3 |  1-Day Course

Who should attend? This course is intended for participants who are familiar with Microsoft Word.

Prerequisites: Microsoft Word - Level 2

Learning Takeaways:

  • 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.

Access Full Course Overview

Microsoft PowerPoint - Level 1 | 1-Day Course

Who should attend? This course is intended for new Microsoft PowerPoint users.

Learning Takeaways:

  • Identify PowerPoint 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 2016 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.

Access Full Course Overview


Microsoft Project - Level 1 | 2-Day Course

Who should attend? This course is intended for new Microsoft Project users.

Prerequisites: Windows XP, Windows Vista, Windows 7, Windows 8, or Windows 10

Learning Takeaways:

  • Understand the basic purpose and operation of the software, and work with windows, Ribbon tabs and buttons, and views.
  • Create a new project and create, edit, and outline a task list, as well as establish dependencies by linking tasks.
  • Add and assign resources to a project, work with project 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 over allocations, 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.

Access Full Course Overview

Microsoft Visio - Level 1 | 1-Day Course

Who should attend? This course is intended for new Microsoft Visio users.

Prerequisites: Windows XP, Windows Vista, Windows 7, Windows 8, or Windows 10

Learning Takeaways:

  • 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; and formatting drawing pages using themes, variants, and Quick Styles.
  • Use the text editing and formatting tools available in Visio.
  • Use shape connectors, and become familiar with methods of connecting shapes and glue types, as well as connecting organization chart shapes.
  • 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.

Access Full Course Overview

BOOK MY COURSE(S)

Microsoft Access - Level 1 | 2-Day Course

Who should attend? This course is intended for new Microsoft Access users.

Learning Takeaways: 

  • 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.

Access Full Course Overview

Microsoft Access - Level 2 - Advanced Database Design | 1-Day Course

Who should attend? This course is intended for participants who are familiar with Microsoft Access.

Prerequisites: Microsoft Access Level 1 - Database Design

Learning Takeaways:

  • Understand the databases that will be used during the course.
  • 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.

Access Full Course Overview


Microsoft Excel - Level 1 | 1-Day Course

Who should attend? This course is intended for new Microsoft Excel users.

Prerequisites: Windows XP, Windows Vista, Windows 7, Windows 8, or Windows 10

Learning Takeaways:

  • 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.

Access Full Course Overview

Microsoft Excel - Level 2 | 1-Day Course

Who should attend? This course is intended for participants who are familiar with Microsoft Excel.

Prerequisites: Microsoft Excel - Level 1

Learning Takeaways:

  • 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.

Access Full Course Overview


Microsoft Excel - Level 3 - Data Management | 1-Day Course

Who should attend?  This course is intended for participants who are familiar with Microsoft Excel.

Prerequisites: Microsoft Excel - Level 2

Learning Takeaways:

  • 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 lookup 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.

Access Full Course Overview

Microsoft Excel - Level 3 – Spreadsheet Analysis | 1-Day Course

Who should attend? This course is intended for participants who are familiar with Microsoft Excel.

Prerequisites: Microsoft Excel - Level 2

Learning Takeaways:

  • 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.

Access Full Course Overview


Microsoft Excel - Level 3 – VBA Macros | 2-Day Course

Who should attend? This course is intended for participants who are familiar with Microsoft Excel.

Prerequisites: Microsoft Excel - Level 2

Learning Takeaways:

  • 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.

Access Full Course Overview


Book Your Course(s)

Call Us

1.866.328.5538