TARGETED to your individual needs You already know how to use Microsoft Office. You know how to open documents, use basic formatting tools, check spelling and save your work. So don't waste time and money in training sessions covering topics already second nature to you. Attend the TARGET SERIES, new lecture/demo modules focused on the specific subjects you need and none that you don't.
Canterbury Corporate University now offers a modular training series for Microsoft Office. Choose from a wide variety of topics and create a day of training that suits specific, individual needs.

WORD I OUTLOOK I ACCESS I EXCEL I POWERPOINT


Basic Styles (1 hour) Create professional, consistent documents in less time by using Microsoft Word’s style features.
Document Design (1 hour) Working with large documents can be easy when effectively using bookmarks, cross-references, custom styles and a host of other key Word features effectively.
Tabs and Tables (1 hour) Create documents that are interesting and easier to read using tabs and tables.
Section Breaks (1 hour) Section breaks enable multi-page formatting within a document. Combine portrait and landscape pages, add different headers and footers and change the style of page numbering.
Advanced Document Editing (1 hour) Explore time-saving Word features most useful when editing large documents. Topics include: creating and inserting a spike, finding and replacing formats and special characters, the use of bookmarks, versioning, comments, the reviewing toolbar, revision marks to track changes, and more…
Mail Merge and File Management (1 hour) Whether a large or small mailing, reduce errors and time spent by learning how to set up mailing lists so the data to be merged will be automatically added to the letter.
Graphics and Embedded Objects (1 hour) Learn to bring in data from Excel, which will automatically update from the source. Use graphics and get them to stay "put" and have text flow around them.
Document Design and Styles (2 hours) It can be easy to create and update professional looking documents when you utilize styles, bookmarks, cross-references and a host of other key features.
Custom Templates (2 hours) To consistently format your documents the same way, learn to design individualized custom templates. Learn how to automate repetitive steps to save even more time.
Graphics, Embedded Objects and Linking (2 hours) Learn to work efficiently with graphics and tables, share information between Word documents and other Microsoft Office software. Fit large graphics and tables into a document.


Managing Messages (1 hour) Automate the management of your incoming messages and your inbox. Learn the features that will enable you to function more efficiently and effectively.


Mail Merge and File Management (1 hour) Communicating, scheduling meetings, managing tasks is simplified by using the calendar, contacts, task list, reminders and notes features. Enhance inbox management and set tracking mechanisms.

 


Basics of Relational Database Design (1 hour) For users of tables/queries in databases, learn to design one of your own by understanding the basics of relational database design theory.
Using Tables (1 hour) For users who input/edit data to an existing Access database, take the next step to learn how to navigate, sort, filter, add, edit and delete information at the table level.
Designing Tables (1 hour) Data tables are the foundation on which a database is built. It’s important to design and create tables that will help to ensure "good" data entry. This course also touches very briefly on database design concepts.
Building a Basic Query (1 hour) Writing queries enables data to be extracted from a database. Learn how to build and run basic queries from a single data table and how to pull information from multiple tables simultaneously.
Building a Basic Report (1 hour) Learn how to build reports and create them from a query. Use time-saving formatting and grouping tools to print reports in an easily readable format.
Building a Basic Form (1 hour) Building data-entry forms for large and unwieldy tables will make using the database as easy as possible.
Table Relationships and Query Joins (1 hour) Building in safeguards to insure data integrity is integral to the design of databases. Understand and create relationships between tables and utilize the flexibility offered by differing join types in queries.
Parameter, Summary and Action Queries (1 hour) Go beyond basic queries used for selecting data. Learn parameter queries to allow user input of criteria, along with summary and cross tab queries, to get summaries of data (without detail levels). Learn action queries to enable deleting, updating and adding data to tables in bulk.
Using Calculations and Built-In Functions in Queries (1 hour) Querying/pulling information out of a database for
further analysis requires learning how to create
calculations in queries using built-in functions.
Creating a Main Form/Sub Form Data Entry Structure (1 hour) Basic form design is taken to the next level by including sub forms and automation.
Using Macros to Automate a Form (1 hour) Go beyond building and using queries and forms; learn how to use macros to automate databases.
Using Forms and Macros to Set Criteria in a Report/Query (1 hour) Gain the flexibility to use a form for the purpose of selecting or entering criteria for a query or report.
Creating Switchboard and Using the Startup Tool (1 hour) Switchboards make it possible to add straight-forward, easy-to-use buttons designed so users can search for data without entering and changing the database design area.
Security (1 hour) Learn to secure your database objects by preventing unauthorized and accidental changes.

Excel Basics (2 hours) New users learn how to create a worksheet using simple calculations and searching for help topics. Understand how to edit and proof, modify, format and print a worksheet.
Basic Formula Writing (2 hours) Beginner through intermediate level users will learn how to use Excel’s mathematical capabilities: basic formula writing, absolute reference, function syntax and categories, lookup and reference functions, data validation, IF, IS and SUMIF functions, nested IF statements and range names.
Data Consolidation and Sharing (2 hours) Explore the consolidation of data from multiple sheets within a file or from multiple files, including the creation of links for automatic updates.
Basic Formulas (1 hour) Learn the steps to create basic mathematical functions and formulas.
Intermediate Formulas (1 hour) Build upon basic formula knowledge to utilize nested and compound functions. Learn basic function syntax to write lookup and reference functions to get requested data from a table. Achieve different results based on specific conditions with IF, IS and SUMIF functions and nested IF statements.
Advanced Formulas (1 hour) Excel can function as a database when utilizing DFunctions and extracting information from the data with lookup and compound functions.
Working with Functions (2 hours) Expand basic formula knowledge to the next level with the use of range names, lookup and reference functions, data validation, IF and IS functions, rounding, the SUMIF function, nested IF statements, DFunctions (database) and compound functions.
Charting (1 hour) Create basic charts for analyzing data. Hide data, use graphics to represent columns in a chart, combine chart types and create 3-D charts.
Data Consolidation (1 hour) Learn to consolidate data statically and dynamically using data combined and tracked on a quarterly or yearly basis or data requiring one overall comprehensive worksheet from several data sources.
Excel Databases (1 hour) Excel can be used as a simple database. Learn about database usage, how to import data from an external database, autofilters, advanced filters, subtotals and using Microsoft Query to obtain external data.
Data Analysis and Tables (2 hours) A pivot table is a helpful tool to quickly combine and compare large amounts of data. Rotate data in rows and columns to view different summaries of the source data and display the details in areas of interest. Explore some of the other analysis tools that come with the Excel Toolpak and single and double variable data tables.
Financial Functions (2 hours) Explore all of the financial functions available, including: VLookup, compound, PV (Present Value), FV (Future Value), Rate, PMT (Payment), SumProduct, IPMT (Interest Payment), data tables and Text functions.

PowerPoint Efficiencies (1 hour) Learn to work in PowerPoint efficiently. Understand the seven-step process to put presentations together with the least amount of rework.
Creating and Editing Presentations (2 hours) New users of PowerPoint will learn the basics of
creating presentations.
Working with Text (2 hours) Create and customize text boxes in PowerPoint. Learn how to transfer files easily and quickly between PowerPoint and Word to eliminate copying and pasting.
Working with Graphics (2 hours) Liven up text presentations using graphics to attract audience attention.
On-Screen Shows (2 hours) Animate on-screen presentations with sound and motion files to keep presentations interesting.
Charting (2 hours) Use data in Excel to create charts in either Excel or PowerPoint. Link the files together so charts automatically update with the latest Excel data.
Templates (2 hours) Explore the underlying formats and styles within PowerPoint. Customize them to create individualized templates.