Information Technology Services
**Classes are held in CETL.
Excel – Formulas and Functions
Wednesday, December 9th - 8:30 - Noon
Beyond SUM and AVERAGE. Excel has functions to make any job easier.
· Overview of Formulas/Functions
o Categories
o Finding the right function
o Understanding arguments
· Designing Better Formulas
o Spreadsheet Design
o Relative and Absolute Cell References
o Naming Cells and Ranges
o Nesting functions
· Special Functions by Category
o Financial
o Logical
o Text
o Date & Time
o Lookup & Reference
· Protecting the Formulas
o Cell protection
o Hide content
o Protecting the worksheet
Excel 2007 – Data Analysis
Friday, December 11th - 8:30 - Noon
Advanced data tools in Excel allow you to work with data in ways you would never believe.
· Data-Based Documents
o Designing data tables
o Formatting and managing worksheets
o Conditional Formatting
· Using Data analysis tools
o Working with Tables
o Filtering, subtotals, and more
· What-if Analysis
o Goal Seek
o Solver
· PivotTables – Easier than you think
o Creating PivotTables
o Modifying PivotTables
Word 2007 - Tables, Forms, Merges
Friday, December 4th - 8:30 - Noon.
Get more productive using merges and forms in Word. You can duplicate almost any printed form that you use on a regular basis. We’ll use tables to help format the form, and look at how to protect the form from unwanted changes. And if you thought merges were just for envelopes and labels, think again. You can merge anything in Word, and output to paper or individual emails!
· Doing More with Tables
o Advanced Table Formatting
o Using tables for page layout
· Word Forms
o Creating Forms
o Modifying Form Properties
o Protecting Forms
· Working with Advanced Content
o Using Building Blocks
o Working with Objects
· Merging – Not Just for Mailings
o Using the (Mail) Merge Wizard
o Performing a Manual (Mail) Merge
o Sending Merged Documents Electronically
Word 2007 - Building Easy-to-Manage Long Documents
Monday, December 7th - 1:00 - 4:30
If you create documents of more than a few pages, Microsoft Word features advanced tools to make the process easier. This ˝ day course will get you started on designing documents that are easy to navigate, modify and re-use.
· Document Planning and Design
o Formatting levels
§ Text
§ Paragraphs
§ Pages
· Using Styles
o Applying, Creating, Modifying and Managing Styles
o Using Base styles
· Working with Sections
o Landscape and Portrait in the same document
o Sectional headers and footers
· Generating Automatic Content
o Document Maps
o Reference tables (Table of Contents, Table of Tables, etc.)
· Formatting Using Tables
· Managing Graphics