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.
Designing Forms and 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.
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.
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…
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.
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.
Revision Features and Information Sharing Explore ways for multiple authors to communicate changes clearly in the same file or in multiple copies of the same document. Users will also explore the easiest ways for multiple authors to easily create documents that conform to corporate standards. .
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.

Working Successfully With Graphics (2 hours) 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.
.


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.
Building a Basic Form (1 hour) Building data-entry forms for large and unwieldy tables will make using the database as easy as possible.
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 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.
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.
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.
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.
 
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.
Security (1 hour) Learn to secure your database objects by preventing unauthorized and accidental changes.
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.
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.
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.
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 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.

Advanced Formulas (1 hour) Excel can function as a database when utilizing DFunctions and extracting information from the data with lookup and compound functions.
Basic Formulas (1 hour) Learn the steps to create basic mathematical functions and formulas.
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.
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.
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 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.
 
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.
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.
Sharing Data (2 hours) Explore the consolidationfrom multiple sources and the safe guards needed when allowing other users to enter data.
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 (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.
Do It Once The Right Way (2 hour) Learn A seven-step process that streamlines the task of developing in MS PowerPoint.  Learn to work in PowerPoint efficiently. Understand the seven-step process to put presentations together with the least amount of rework. .
Editing Presentations (2 hours) New users of PowerPoint will learn the basics of
creating presentations.
On-Screen Shows (2 hours) Animate on-screen presentations with sound and motion files to keep presentations interesting.
Templates (2 hours) Explore the underlying formats and styles within PowerPoint. Customize them to create individualized templates.
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.