|
| 01 | Access | H | Automate Your Access Database | Parameter queries
Interactive user macros
Building a switchboard |
| 02 | Access | D/H | Answers to Your Access Queries | Choose the appropriate database management technique
Sort and filter data using queries
Use wildcards and top values in queries
Apply logic programming to queries |
| 03 | Access & Excel | D | Access vs. Excel | Compares the feature strengths of Excel and Access
Transfer data between the two applications |
| 04 | Excel | D/H | Analyze Excel Data | Pivot Tables and Pivot Charts
Data Tables
Scenarios
Goal Seek Solver |
| 05 | Excel | H | Excel Formulas and Functions | Basics of formulas
Absolute & relative references
Basic functions using the Function Palette (Sum, Avg,
Max, Min)
IF and VLOOKUP |
| 06 | Excel | H | Validate Your Excel Data | Conditional formatting
Data validation
Auditing techniques
Protecting worksheets |
| 07 | Excel | H | Multiple Sheets and Pivot Tables in Excel | Creating and working with worksheet tabs
Grouping & copying
AutoFilter, AutoFill, AutoSum, and AutoFormat
Pivot tables |
| 08 | Excel | D/H | Excel Charting | AutoSum, AutoFormat, AutoFill, and drag & drop
Format Painter
Charting with and without the Wizard
Chart options
Drawing objects on charts |
| 09 | Excel | D | Excel Extras | Converting text to columns
Using conditional formatting and data validation
Working with AutoFormat |
| 10 | Excel | D | Manipulate Lists with Excel | Mathematical and analytical features
List management techniques
Sorting and filtering data |
| 11 | Excel | D | Excel Functions | Using Excel's most popular functions, including:
IF, VLOOKUP, PMT, and DFunctions. |
| 12 | Outlook | H | Organize Your Outlook | Folders
Categories
Rules |
| 13 | Outlook | D | Outlook Shortcuts | Handy shortcuts to save you time and improve
proficiency |
| 14 | Outlook | D | Schedule It with Outlook | Appointments
Events
Meetings
Group Schedules
Time zones |
| 15 | PowerPoint | D/H | Use PowerPoint's Special Effects | Draw & manipulate objects
WordArt
Slide transitions
Animation |
| 16 | PowerPoint | D/H | PowerPoint Made Easy | Focus on more advanced features
Tips and tricks
Shortcuts |
| 17 | PowerPoint | D | Produce Successful Presentations | Proven formula to successfully deliver an effective presentation |
| 18 | Word | H | Bullets and Numbering | Bulleted lists
Numbered lists
Outlined numbered lists
How to customize all lists |
| 19 | Word | H | Generate Forms in Word | Tables
Using controls
Populating data
Protecting the form |
| 20 | Word | H | Mass Mailings Using Word | Form letters
Labels and envelopes
Retrieving data from Outlook, Excel and Access |
| 21 | Word | H | Master Document Using Word | Advantages/disadvantages of Master Documents
Creating and editing Master Documents
Creating and editing Sub Documents |
| 22 | Word | D/H | Word's Tabs and Tables | Converting text to tables
Converting tables to text
Working with Word formulas |
| 23 | Word | D/H | Automate Your Word Work | Automated features to save you time including:
AutoComplete
AutoCorrect
AutoFormat
AutoText
Smart Tags |
| 24 | Word | D/H | Make Styles Work for You using Word | What is a style?
Work with existing styles
Create, modify and apply new styles
Organize your styles |
| 25 | Word | H | Streamline Long Word Documents | Styles and templates
Bookmarks
Headers and footers
Index & Table of Contents
Section breaks |
| 26 | Word | D | Using Drawing Tools to put the Wow in Your Word | Organize, enhance and add excitement to your
documents
Add shapes and lines for more impact |
| 27 | Word | D/H | Document Collaboration | Create multiple versions of a document
Distribute a document for review
Track changes
Review changes |
| 28 | Word | D/H | Layout Techniques Using Word | Insert ClipArt, WordArt, and files
Paragraph spacing, section breaks and column
breaks
Format Painter and page borders |
| 29 | Project | D | Do I need Microsoft Project? | What is a project?
What is project management?
What can Microsoft Project do for you? |
| 30 | Windows | H | Manage Your Files and Folders | File management using Windows Explorer
Folder management using Windows Explorer |
| 31 | Office XP | D | Office XP Overview | Overview of new features (Smart Tags, Task Pane,
Office Clipboard)
Outlook updates
Word's new features
Excel's time-saving enhancements
PowerPoint's new look (with the 3 hour demo)
Access updates (with the 3 hour demo) |
| 32 | Office XP | D/H | Share Information Among Office Applications | Merge Word document with Outlook Contacts folder
Import an Excel spreadsheet into an Access
database
Merge an Access table into a Word mailing label
document
Import and link an Excel chart into PowerPoint
Create PowerPoint handouts in Word |
| 33 | Office XP | D | Office Software Shortcuts | Keyboard shortcuts
Quick highlight techniques
Office Clipboard
Basic search
Media Clip Organizer |
| 34 | Internet Explorer | H | Surf the Internet Effectively | Search engines
Search techniques |
| 35 | Publisher and Visio | D | Graphic Wonders - An Introduction to Publisher and Visio | An overview of how Visio can help you create
business graphics
An overview of how Publisher can help you
create and design newsletters, brochures and other professional publications |
| 36 | Photoshop | H | Photoshop Basics | Overview of Photoshop
Selection tools and shortcuts
Understanding layers
Adding text to your photos
Quick ways to adjust your photo images |
| 37 | E-Mail | D | Understanding E-Mail Etiquette | Guidance for users of e-mail systems
Understand the strengths, limitations and etiquette
of e-mail |
| 38 | Project | H | Project Tips and Tricks | New Interface
Don't Forget about Notes
What is a WBS code
Avoid Start/Finish Fields
Allowing for Overlap and Delays
Create a Custom Report
A Picture Is Worth A Thousand Words
Filtering Views to Gain Perspective
Hyperlink Documents to Tasks
View Task Progress
Share Resources among Projects
Coordinating Multiple Projects |
| 39 | Office XP | H/D | Reducing File Size | Importance of file size
Checking size of graphics
Graphics - Resizing, Change Resolution, Change Type Reducing size of PowerPointPresentations
Using WinZip |
