[Wesleyan University]
Wesleyan University Training
Wesleyan University Training

Class Descriptions


Excel 2007 - Level 1 Topics Basic
Excel 2007 - Level 2 Topics Intermediate
Excel 2007 - Level 3 Topics
Outlook 2007 - Mail and Calendar
PowerPoint 2007
Windows 7 Basics
Word 2007 - Intermediate

 

Excel 2007 - Level 1 Topics Basic

Performing Calculations

  • Create Basic Formulas
  • Calculate with Functions
  • Copy Formulas and Functions

Modifying a Worksheet

  • Manipulate Data
  • Insert and Delete Cells, Columns, and Rows
  • Search for Data in a Worksheet
  • Spell Check a Worksheet

Formatting a Worksheet
  • Modify Fonts
  • Add Borders and Color to Cells
  • Change Column Width and Row Height
  • Apply Number Formats
  • Position Cell Contents
  • Apply Cell Styles

Printing a Workbook Document

  • Set Print Options
  • Set Page Breaks

Managing Large Workbooks

  • Format Worksheet Tabs
  • Manage Worksheets in a Workbook
  • Manage the View of Large
    • Worksheets

Excel 2007 - Level 2 Topics Intermediate

Calculating Data with Advanced Formulas

  • Manage Cell and Range Names
  • Calculate Data Across Worksheets
  • Use Specialized Functions
  • Analyze Data with Logical and Lookup Functions

Organizing Worksheet and Table Data
  • Create and Modify Tables
  • Format Tables
  • Sort or Filter Worksheet or Table Data
  • Calculate Data in a Table or Worksheet
Presenting Data Using Charts
  • Create a Chart
  • Modify Charts
  • Format Charts
Analyzing Data Using PivotTables and PivotCharts
  • Create a PivotTable Report
  • Analyze Data Using PivotCharts

Excel 2007 - Level 3 Topics

(please note: instructor will cover as many of these topics as possible in the time. Class size may impact number of topics covered. Attendees will receive manuals that will have information on all topics.)

Streamlining Workflow

  • Create a Macro
  • Edit a Macro
  • Apply Conditional Formatting
  • Add Data Validation Criteria
  • Update a Workbook's Properties
  • Modify Excel's Default Settings
Collaborating with Others
  • Protect Files
  • Share a Workbook
  • Set Revision Tracking
  • Review Tracked Revisions
  • Merge Workbooks
  • Administer Digital Signatures
  • Restrict Document Access
Auditing Worksheets
  • Trace Cells
  • Troubleshoot Errors in Formulas
  • Troubleshoot Invalid Data and Formulas
  • Watch and Evaluate Formulas
  • Create a Data List Outline
Analyzing Data
  • Create a Trendline
  • Create Scenarios
  • Perform What-If Analysis
  • Perform Statistical Analysis with the Analysis ToolPak
Working with Multiple Workbooks
  • Create a Workspace
    o Consolidate Data
  • Link Cells in Different Workbooks
    o Edit Links
Importing and Exporting Data
  • Export Excel Data
  • Import a Delimited Text File

Outlook 2007 - Mail and Calendar

Scheduling Appointments
  • Explore the Outlook Calendar
  • Schedule an Appointment
  • Assign Categories and Edit Appointments
Scheduling Meetings
  • Schedule a Meeting
  • Reply to a Meeting Request
  • Propose a New Meeting Time
  • Manage Meetings
  • Print the Calendar
Managing Tasks and Notes
  • Create a Task
  • Edit and Update a Task
  • Create a Note
  • Edit a Note
  • Display a Note on the Desktop
Customizing Message Options
  • Modify Message Settings
  • Modify Delivery Options
  • Change the Message Format
  • Notify Others That You will be Out of the Office
  • Create a Distribution List
  • Insert a Hyperlink
Locating Outlook Items
  • Sort Messages Using Multiple Criteria
  • Find Messages
  • Find Outlook Items Using Multiple Criteria
  • Filter Messages
  • Organize Messages
  • Manage Junk Email
Working with Contacts
  • Forward Contacts
  • Edit an Electronic Business Card
  • Export Contacts Perform a Mail Merge Link Items to Business Contact Manager

PowerPoint 2007

Formatting Text
  • Apply Character Format
  • Apply Paragraph Formats
  • Format Text Placeholders

Adding Graphical Objects
  • Insert Clip Art
  • Draw shapes
  • Insert WordArt

Modifying Objects
  • Work with Objects
  • Change Object orientation
  • Format Objects
  • Group and Ungroup Objects
  • Arrange Objects

Adding Tables to a Presentation

  • Create a Table
    o Format Tables
  • Insert a Table from Microsoft Word
  • Inserting Charts in a Presentation
Inserting Charts to a Presentation
  • Edit Chart Data
  • Modify a Chart
  • Paste a Chart from Microsoft Excel
Preparing to Deliver a Presentation
  • Review Content
  • Add Transitions
  • Apply an Animation Effect
  • Create Speaker Notes
  • Print a Presentation

Windows 7 Basics

Exploring Windows 7
  • Explore the Desktop
  • Work with Windows
  • Access the Help and Support Feature
Customizing the Windows 7 Desktop
  • Customize the Start Menu
  • Customize the Taskbar
  • Personalize the Desktop
  • Add Gadgets to the Desktop

Managing Folders and Files

  • Navigate to Folders Using Windows Explorer
  • Work with Folders and Files
  • Secure Folders and Files
  • Organize Folders and Files
  • Search for Folders and Files

Word 2007 - Intermediate

Course assumes functional knowledge of Word and builds on that foundation.
 

Formatting Paragraphs

  • Set Tabs to Align Text
  • Control Paragraph Layout
  • Add Borders and Shading
  • Apply Styles
  • Create Lists
  • Manage Formatting

Adding Tables
  • Create a Table
  • Modify the Table Structure
  • Format a Table
  • Convert Text to a Table or Tables to Text

Controlling Page Appearance
  • Control Page Layout
  • Apply a Page Border and Color
  • Add Watermarks
  • Add Headers and Footers

Managing Lists

  • Sort a List
  • Renumber a List
  • Customize Lists
Customizing Tables and Charts
  • Sort Table Data
  • Control Cell Layout
  • Perform Calculations in a Table
  • Create Charts
Automating Mail Merges
  • Perform a Mail Merge
  • Mail Merge Envelopes and Labels
  • Use Word to Create a Data Source
  • Using Macros to Automate Tasks
Perform a Task Automatically Using a Macro
  • Create a Macro