Office Productivity Skills Course List

Many business owners and corporate executives may not have the time to think about office productivity training and how to arrange an adequate lesson plan for their employees. They understand why it’s needed but have no consistent method of implementing a closed looped system that will accomplish many important aspects of employee development and talent management including:

  • Reducing training costs and improving employee performance,
  • Preserving the value of each employee and their effectiveness in their jobs,
  • Expanding and improving computing skills that the organization needs,
  • Improving the effectiveness of the work accomplished and,
  • Promoting and increasing employee job satisfaction in a meaningful manner.

If you would like to sign-up for a course please contact us at 1-800-686-2098 we will be happy to assist you in the selection of your course and answer any questions you might have. Corporate training plans are also available for all organizations.

We are proud to offer our customers the following office productivity courses:

Course ID Course Title Description
OP5141UACE Excel Advanced Pivot Tables and Charts Learn the advanced tools to dynamically reorganize, summarize and display your data in Excel.
OP5140FWAE Excel Financial and What-If Analysis Learn to use financial functions, iterative calculations, and the Watch Window for better financial decisions and Control What-if Analysis.
OP5139FFIE Excel Advanced Formulas Learn to master the Date and Time, Logical, and Lookup and reference categories that enable you to quickly complete tasks and analyze data.
OP5138AFLE Excel Advanced Layouts Learn advanced features to customize format and layout data.
OP5137RPCE Excel Content Protection Manage review and protect multiple workbooks while creating and sharing content.
OP5136AMIP PowerPoint Media Control Control the PowerPoint animation tools which make slide shows more fluid and interesting.
OP5135EPPP PowerPoint Presentation Control Learn how to improve your presentations and emphasize text and data more professionally.
OP5134MCIO Outlook Management Learn to improve the configuration of Outlook itself to suit the way you work.
OP5133SATO Outlook Scheduling Master the major components of the Calendar and stay organized.
OP5132DTCE Excel Table and Chart Presentations Learn to create attractive and well-organized representations of worksheet and workbook data with tables and charts.
OP5131PCFE Excel Calculations using Functions Learn to use formulas to do complicated calculations reducing the number of errors in tasks.
OP5130CFSE Excel Conditional Formatting Master conditional formatting to highlight trends and exceptions in cells or ranges of cells.
OP5129ATCW Word Table Customization and Tips Learn how to convert table data to text and master table editing.
OP5128CDLW Word Document Layout Control Learn to create easy-to-read documents with a balanced visual appearance.
OP5127AFIW Word Formatting Master your Design Tab Features.
OP5126DSME Excel Macros for Validation and Search Learn to manage and validate data and automate repetitive tasks.
OP5125MDIE Excel Data Manipulation Learn Excel organizing and managing data tips including sorting and filtering tools that are essential to data analysis.
OP5124UMAP PowerPoint Media Control Learn PowerPoint animation tools which make slide shows more fluid and interesting.
OP5123VEPP PowerPoint Presentation Control Learn the features that improve your presentations and emphasize text and data more professionally.
OP5122ULTE Excel Math and Text Functions Learn to use Excel math and text functions and categories to enable you to quickly complete tasks and analyze data.
OP5121STWD Word Document Structuring Master the use of headings to restructure the outline of a document.
OP5120OATW Word Text Organization Improve your skills with the basic paragraph-formatting features.
OP5119FWTW Word Formatting Improve your skills with the various Word formatting options.
OP5118UTFO Outlook Journal Features Improve your Journal skills to help keep you and your information organized.
OP5117IBCE Excel Charting Master the Charts Group on the Insert Tab of the Ribbon to provide an effective visualization of your data.
OP5116UBFE Excel Functions Learn the most used functions that are Excel inbuilt formulas that save you time.
OP5115CFTS Excel Conditional Formatting Master conditional formatting to highlight trends and exceptions in cells or ranges of cells.
OP5114MDMW Excel Worksheet or Workbook Data Move and Modification Techniques Learn how to move and manipulate large amounts of data in worksheets or workbooks quickly and efficiently.
OP5113ECTW Word Chart Embedding Learn how to create Excel workbooks with linked data which can be manipulated and displayed in an attractive and effective manner.
OP5112MTIW Word Table Manipulation Improve your ability to both design tables and manipulate your table data.
OP5111CFTW Word Table Formatting Learn to create, style, and format tables in your documents.
OP5110ATBW Word TOC (Table of Contents) Construction and Bookmarking Learn to insert navigation and reference materials into a document with the proper heading styles applied.
OP5109TPCE Excel Advanced Pivot Tables and Charts Learn the advanced tools to dynamically reorganize, summarize and display your data in Excel.
OP5108EDFR Excel Data and Formula Validation Learn to audit formulas and correct errors that may be found. In addition, improve your Excel data validation tool knowledge.
OP5107OTWA Office Web Apps – Publisher and Mobile Learn to maximize Office Web Apps as online extensions of Word, PowerPoint, Excel, and OneNote.
OP5106NMOT Office Messaging and Collaboration Features Learn the enhanced collaboration and unified messaging features of Office.
OP5105OTNF Core Features of Office Learn the key features and enhancements in the Office suite of products.
OP5010ITUO Office Messaging and Collaboration Features Learn how to configure and implement Information Rights Management (IRM) in Outlook.
OP5097AVDF Word Advanced Document Features Master the use of macros to automate and streamline the way you work with repetitive and complex tasks.
OP5092WTPW Word Text and Paragraph Control Master the Font and Paragraph formatting options, as well as the Mini toolbar and live preview features.
OP5091GSWD Word Getting Started Improve your control over the user interface Ribbon, Quick Access Toolbar and Mini Toolbar. Navigate even faster.
OP5077UTCG Word Table and Chart Control Improve your ability to format, sort and analyze your table and chart data. Enhance your skills in creating, formatting and modifying tables and charts.
OP5076AVDN Word Advanced Document Navigation and Review Enhance your skills on table of contents creation, modification and deletion.
OP5075AVFW Word Advanced Formatting Enhance your skills on the use of theme colors, theme fonts and theme effects.
OP5089ADDG PowerPoint Presentation Graphics Control Improve your ability to create dynamic slide show presentations and incorporate diagrams, tables, and charts to enhance your presentations’ appeal.
OP5088GSPT PowerPoint Getting Started Refresh and enhance your skills on how to use layouts and views and the basic must-know aspects of PowerPoint.
OP5071AVCE Excel Advanced Customization Master custom template, theme, and style features to enhance the look and feel of your spreadsheets and workbooks. Strengthen your macro knowledge.
OP5006EXCD Excel Data Exchange Learn to create database and web queries. Import Excel data into other applications using XML to manage and customize workbooks.
OP5070AVDM Excel Advanced Data Management Master your data validation skills. Learn to use the advanced sort, filter, group and outline features that improve productivity.
OP5069AVFE Excel Advanced Chart Formatting Control Improve your skills in modifying charts and pictures, and creating and editing custom number formats.
OP5007CRSS PowerPoint Custom Slides Enhance your custom slide shows for different audiences.
OP5008DISP PowerPoint Presentation Distribution Setup-up and Secure your presentations for distribution to other audiences.
OP5073CONF Outlook Rule and Alert Configuration. Enhance your skills in predefined or custom rules and alerts and message organization.
OP5009DATS Outlook Working Offline Learn Offline Access and Synchronization Settings for Outlook.