|
Which class should I take? Answers to FAQ's. |
Office 2007 Class Descriptions
Access Excel
Outlook
PowerPoint
Publisher
Word
Other Course Descriptions:
Windows XP,
Office 2003,
QuickBooks 2002 |
|
ACCESS
|
Access 2007 New Features
Half Day Class |
Explore the User Interface Work with the Ribbon,
Work with Contextual Tabs, Customize the Access Environment, Create a Table,
Create a Form, Design a Form Layout, Query a Database, Generate Reports, Format
a Report, Import Data, Export Data |
Access
2007
Level 1
Full Day Class |
Examine Database Concepts, Explore the User Interface,
Use an Existing Access Database, Customize the Access Environment, Obtain Help,
Database Design Considerations, Create a New Database, Create a Table, Manage
Tables, Create a Table Relationship, Save a Database as a Previous Version,
Modify Table Data, Sort Records, Work with Subdatasheets, Filter Records, Create
a Query, Add Criteria to a Query, Add a Calculated Field to a Query, Perform
Calculations on a Record Grouping, View Data Using an Access Form, Create a
Form, Modify the Design of a Form, View an Access Report, Create a Report, Add a
Custom Calculated Field to a Report, Format the Controls in a Report, Apply an
AutoFormat Style to a Report, Prepare a Report for Print |
Access 2007 Level 2
Full Day Class |
Working with Field Properties, Create Lookup and
Values Lists, Create Query Joins, Join Unrelated Tables, Relate Data Within a
Table, Setting Query Properties, Create Parameter Queries, Create Action
Queries, Design a Form, Enhance the Appearance of a Form, Restrict Data Entry in
Forms, Add a Command Button to a Form, Create a Subform, Organize Report
Information, Design and Format a Report, Set Report Control Properties, Control
Report Pagination, Summarize Report Information, Add a Subreport to an Existing
Report, Create a Mailing Label Report, Import Data into Access, Analyze Access
Data in Excel, Export Data to a Text File, Merge Access Data with a Word
Document |
Access 2007 Level 3
Full Day Class |
Analyze Tables, Create a Junction
Table, Improve Table Structure, Create Subqueries, Create Unmatched and
Duplicate Queries, Group and Summarize Records Using Criteria, Summarize Data
Using a Crosstab Query, Create a PivotTable and a PivotChart, Create a Macro,
Attach a Macro, Restrict Records Using a Condition, Validate Data Using a Macro,
Automate Data Entry Using a Macro, Display a Calendar on a Form, Organize
Information with Tab Pages, Display a Summary of Data in a Form, Include a Chart
in a Report, Print Data in Column, Cancel Printing of a Blank Report, Create a
Report Snapshot, Link Tables to External Data Sources, Manage a Database,
Determine Object Dependency, Document a Database, Analyze the Performance of a
Database |
|
EXCEL |
Excel 2007 New Features
Half Day Class |
Explore the User Interface,
Work with the Ribbon and Associated Features, Page Layout View, Work with Contextual Tabs, Galleries,
Customize the Excel Interface, The Excel 2007
Spreadsheet, Themes, Tables, Format Tables, Conditional Formatting, Sorting
Data, Filtering Data, Working with Formulas, Create
Charts, Format Charts, Work with Illustrations, Create PivotTables and PivotCharts, Share Excel Charts, Save Data in
Other Formats |
Excel
2007
Level 1
Full Day Class |
Explore the User Interface and the Ribbon, Navigate
and Select in Excel, Obtain Help, Enter Data and Save a Workbook, Customize the
Quick Access Toolbar, Create Basic Formulas, Calculate with Functions, Copy
Formulas and Functions, Manipulate Data, Insert and Delete Cells, Columns, and
Rows, Search for Data in a Worksheet, Spell Check 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, Print Workbook Contents
Using Default Print Options, Set Print Options, Set Page Breaks, Format
Worksheet Tabs, Manage Worksheets in a Workbook, Manage the View of Large
Worksheets |
Excel 2007 Level 2
Full Day Class |
Manage Cell and Range Names,
Calculate Data Across Worksheets, Use Specialized Functions, Analyze Data with
Logical and Lookup Functions, Create and Modify Tables, Format Tables, Sort or
Filter Worksheet or Table Data, Calculate Data in a Table or Worksheet, Create a
Chart, Modify Charts, Format Charts, Create a PivotTable Report, Analyze Data
Using PivotCharts, Insert and Modify Pictures and ClipArt, Draw and Modify
Shapes, Illustrate Workflow Using SmartArt Graphics, Layer and Group Graphic
Objects, Customize the Excel Environment, Customize Workbooks, Manage Themes,
Create and Use Templates |
Excel 2007 Level 3
Full Day Class |
Create a Macro, Edit a Macro, Apply
Conditional Formatting, Add Data Validation Criteria, Update a Workbook's
Properties, Modify Excel's Default Settings, Protect Files, Share a Workbook,
Set Revision Tracking, Review Tracked Revisions, Merge Workbooks, Administer
Digital Signatures, Restrict Document Access, Trace Cells, Troubleshoot Errors
in Formulas, Troubleshoot Invalid Data and Formulas, Watch and Evaluate
Formulas, Create a Data List Outline, Create a Trendline, Create Scenarios,
Perform What-If Analysis, Perform Statistical Analysis with the Analysis
ToolPak, Create a Workspace, Consolidate Data, Link Cells in Different
Workbooks, Edit Links, Export Excel Data, Import a Delimited Text File, Publish
a Worksheet to the Web, Import Data from the Web, Create a Web Query, Develop
XML Maps, Import and Export XML Data |
|
OUTLOOK |
Outlook 2007 New Features
Half Day Class |
Explore the User Interface: The Ribbon
and Associated Features, The To-Do Bar, Contextual Tabs, Customize Calendar View,
Work with Mail Messages, Flagging Items, Manage Tasks in the Calendar, Instant
Search Pane and Query Builder, Attachment Preview, Schedule a Meeting, Sharing Your Calendar Information,
About Out Of Office Reply, Using Electronic Business Cards,
Junk Email, Other Topics |
Outlook 2007 Level 1
Full Day Class |
Explore the Outlook Interface, Send a Simple Message, Read Messages,
Reply to and Forward a Message, Print a Message, Delete a Message, Address a
Message, Format a Message, Check Spelling and Grammar, Attach a File, Open and
Save an Attachment, Flag a Message, Organize Content with Folders, Add a
Contact, Sort and Find Contacts, Find the Geographical Location of a Contact,
Manage Contacts, Explore the Outlook Calendar, Schedule an Appointment, Assign
Categories and Edit Appointments, Schedule a Meeting, Reply to a Meeting
Request, Propose a New Meeting Time, Manage Meetings, Print the Calendar, Create
a Task, Edit and Update a Task, Create a Note, Edit a Note, Display a Note on
the Desktop |
Outlook 2007 Level 2
Full Day Class |
Set Work Days and Times, Display an
Additional Time Zone, Set Availability 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, Automatically
Record a Journal Entry, Manually Record a Journal Entry, Modify a Journal Entry,
Assign a Task, Reply to a Task Request, Send a Task Update, Track Assigned
Tasks, Specify Folder Permissions, Delegate Access to Folders, Access Another
User's Folder, Send Calendar Information in an Email Message, Customize the
Toolbar, Create a New Toolbar, Customize the Menu Bar, Customize the Quick
Access Toolbar, Customize the To-Do Bar, Create a Folder Home Page, Sort
Messages Using Multiple Criteria, Find Messages, Find Outlook Items Using
Multiple Criteria, Filter Messages, Organize Messages, Manage Junk Email, Create
a Public Folder, Add Users to a Public Folder, Post Information in a Public
Folder, Send an Email Message to a Public Folder |
|
POWERPOINT |
PowerPoint 2007
New Features
Half Day Class |
Explore the User Interface,
Work with the Ribbon, Work with Contextual Tabs, Use the PowerPoint Galleries,
Customize the PowerPoint Interface, Create Custom Slide Layouts, Work with
Themes, Apply Rich Text and Typography Effects, Enhance Presentations with
Graphic Effects, Enhance Table Layout, Work with Charts, Customize Slide Shows,
Secure Presentations, Save a Presentation |
PowerPoint 2007
Level 1
Full Day Class |
Explore the User
Interface, Navigate and View a Presentation, Use Microsoft PowerPoint Help,
Enter Text, Save a Presentation, Create a Presentation, Edit Text, Add Slides to
a Presentation, Arrange Slides, Work with Themes, Apply Character Formats, Apply
Paragraph Formats, Format Text Placeholders, Insert Clip Art and Pictures, Draw
Shapes, Insert WordArt, Change Object Orientation, Format Objects, Group and
Ungroup Objects, Arrange Objects, Create a Table, Format Tables, Insert a Table
from Microsoft Word, Create a Chart, Edit Chart Data, Modify a Chart, Paste a
Chart from Microsoft Excel, Review Content, Add Transitions, Apply an Animation
Effect, Create Speaker Notes, Print a Presentation |
PowerPoint 2007
Level 2
Full Day Class |
Customize the Quick
Access Toolbar, Personalize the PowerPoint Interface, Customize Save Options,
Apply Advanced Customization Options, Set Up a Slide Master, Customize Slide
Layouts, Create Custom Themes, Add Headers and Footers, Modify the Notes Master,
Modify the Handout Master, Create Diagrams, Modify Diagrams, Add Multimedia
Elements, Customize Slide Component Animations, Set Up a Custom Show, Annotate a
Presentation, Create a Presenter-Independent Slide Show, Set Up a Slide Show to
Repeat Automatically, Review a Presentation, Publish Slides to a Slide Library,
Share a Presentation, Secure Presentations, Package a Presentation, Publish a
Presentation as a Web Page |
|
PUBLISHER |
Publisher
2007
Level 1
Full Day Class |
Explore the
Microsoft Office Publisher 2007 Environment, Create a Publication from a
Publication Design, Add Design Object Placeholders, Add Content to a
Publication, Save a Publication, Create Business Information Data, Insert Text
in a File, Organize Text Boxes and Picture Frames in the Layout, Connect Text
Boxes, Divide Text Boxes into Columns, Organize Pages in the Publication, Insert
Common Layout Elements, Edit Text in a Publication, Research Information, Find
and Replace Text, Spell Check the Publication, Save Reusable Content, Format
Text, Apply Schemes, Insert Symbols, Format Paragraphs, Create Paragraph Styles,
Format Text Boxes, Format Picture Frames, Customize Picture Appearance, Insert
WordArt, Insert a Design Gallery Object, Check the Design of a Publication,
Manage Pictures in a Publication, Save a Publication for Distribution, Preview
and Print a Publication, Compose a Publication for Email, Create a Website,
Publish a Web Page |
|
WORD |
Word 2007 New Features
Half Day Class |
Explore the User Interface,
Work with the Ribbon and Associated Features, Headers and Working with Contextual Tabs, Word Galleries,
Customize the Word Interface, Styles, Themes, Add Building Blocks, Work
with Illustrations, Build an Equation, Add Citations and a Bibliography, Compare
Reviewed Documents, Inspect Documents, Apply Digital Signatures, Save a Document |
Word 2007 Level 1
Full Day Class |
Explore the User Interface, Open and View a Document,
Customize the Word Environment, Obtain Help, Enter Text, Save a Document,
Preview and Print a Document, Navigate and Select Text in a Document, Insert,
Delete, or Rearrange Text, Undo Changes, Search and Replace Text, Change Font
Appearance, Highlight Text, Set Tabs to Align Text, Control Paragraph Layout,
Add Borders and Shading, Apply Styles, Create Lists, Manage Formatting, Create a
Table, Modify the Table Structure, Format a Table, Convert Text to a Table or
Tables to Text, Add Visual Effects Using Symbols and Special Characters, Insert
Illustrations, Control Page Layout, Apply a Page Border and Color, Add
Watermarks, Add Headers and Footers, Check Spelling, Grammar, and Word Count,
Enhance Textual Meaning Using the Thesaurus, Customize AutoCorrect Options |
Word
2007 Level 2
Full Day Class |
Sort a List, Renumber a
List, Customize Lists, Sort Table Data, Control Cell Layout, Perform
Calculations in a Table, Create Charts, Create or Modify a Text Style, Create a
Custom List or Table Style, Apply Default and Customized Document Themes, Resize
a Picture, Adjust Picture Appearance Settings, Wrap Text Around a Picture,
Create Text Boxes and Pull Quotes, Draw Shapes, Add WordArt and Other Special
Effects to Text, Create Complex Illustrations with SmartArt, Insert Building
Blocks, Create Building Blocks, Modify Building Blocks, Insert Fields Using
Quick Parts, Control Paragraph Flow, Insert Section Breaks, Insert Columns, Link
Text Boxes to Control Text Flow, Create a Document Based on a Template, Create a
Template, Perform a Mail Merge, Mail Merge Envelopes and Labels, Use Word to
Create a Data Source, Perform a Task Automatically Using a Macro, Create a Macro |
Word 2007 Level 3
Full Day Class |
Link to a Microsoft® Office Excel®
2007 Worksheet, Link a Chart to Excel Data, Send a Document Outline to
Microsoft® Office PowerPoint®, Extract Text from a Fax, Send a Document as an
Email Message, Modify User Information, Send a Document for Review, Review a
Document, Compare Document Changes, Merge Document Changes, Review Track Changes
and Comments, Create a New Version of a Document, Compare Document Versions,
Merge Document Versions, Insert Bookmarks, Insert Footnotes and Endnotes, Add
Captions, Add Hyperlinks, Add Cross-References, Add Citations and a
Bibliography, Insert Blank and Cover Pages, Insert an Index, Insert Table of
Figures, Insert Table of Authorities, Insert Table of Contents, Create a Master
Document, Automatically Summarize a Document, Update a Document's Properties,
Hide Text, Remove Personal Information from a Document, Set Formatting and
Editing Restrictions, Add a Digital Signature to a Document, Set a Password for
a Document, Restrict Document Access |
|
Click
Here To Receive Our Schedule by Email Each Month