Word Level 1 | Managing Your Environment On-screen tools Shortcut menus Smart tags Task panes Selecting and editing Nonprinting characters Defaults Working with Files Opening and saving documents Moving, copying, renaming and organizing files Windows Search feature AutoRecover File security Character (Font) Formatting Structure of character formatting Copying character formatting Removing character formatting Paragraph Formatting Structure of paragraph formatting Copying paragraph formatting | Removing paragraph formatting Alignment, indents, tabs Line spacing, space between paragraphs Keeping paragraphs together on a page Borders and shading AutoFormatting changes Page Formatting Structure of page formatting Margins, sections, columns Headers/footers, page numbering, odd/even pages Other Basic Tools Miscellaneous formatting Spell-check Find and Replace Word Shortcut Keys Diacriticals & Function Keys Keyboard Templates |
| To top | | |
Word Level 2 | Text Entry Shortcuts AutoCorrect AutoText Spike Styles Advantages of styles Creating and modifying styles Displaying the Style Area Copying and managing styles Using built-in Heading styles Document Map Outline View Autonumbering Bulleted lists Numbered lists Multi-level numbering Linking styles and numbering Templates Advantages of using templates | Wizards Normal.dot template Creating and modifying templates Sharing template tools Global templates Template Tools Advantages of macros Creating and running a macro Editing macros Creating toolbars and buttons Editing a toolbar button Menus Shortcut keystrokes Tables Creating a table Selecting and sizing columns, rows, and cells Moving parts of a table Formatting a table Other table features |
| To top | | |
Word Level 3 | Workgroup Computing Document security Highlighter tool Inserting comments Redlining (Track Changes) Versions Table of Contents Marking text Updating a table of contents Formatting a table of contents Other Document References Table of Authorities Cross-references Table of Figures Bookmarks Master Documents | Drawing Drawing objects and text layers Drawing tools, formatting options Pictures and graphics Other drawing options Linking and embedding objects Mail Merge and Databases Setting up the data source Setting up the main document Merging Using Word fields with merging Form Fields Creating and using a form Protecting forms Printing and saving form field data Macrobuttons |
| To top | | |
Excel Level 1 | Excel Shortcut Keys Managing Your Environment On-screen tools Shortcut menus Smart tags Task panes Selecting objects in a spreadsheet Data Entry Basics Typing and editing in a cell Navigating within a worksheet Copying/pasting/moving data The Fill Handle Freezing panes Formulas and Functions Creating formulas AutoCalculate AutoSum function Using functions Circular references Absolute references | Formatting Worksheets Formatting toolbar Format Cells dialog box Colors and borders Formatting part of a cell Preparing for Printing Page Setup Naming a range Print Preview and Page Break Preview Managing Sheets Inserting, deleting, moving sheets Renaming sheets Formatting sheet tabs Copying sheets between files Creating Simple Charts Chart Wizard Charts as objects on a worksheet Chart sheets Formatting a chart |
| To top | | |
Excel Level 2 | Managing Formulas Finding data in a worksheet Conditional formatting The IF function The Formula Auditing toolbar Goal Seek Scenarios Managing Worksheets Protecting worksheets Inserting comments Linking worksheets and workbooks Creating custom workspaces Creating custom views Working with Data Lists Excel data lists Sorting data | Subtotals Filtering data Using the Data Form Advanced charting Chart types Objects in a chart Adding data to a chart Enhancing a chart Multiple chart lines Modifying source data Adding graphics objects Working with Pivot Tables Creating a pivot table Manipulating a pivot table Pivot table options Creating PivotChart reports |
| To top | | |
PowerPoint Level 1 | PowerPoint Shortcut Keys Managing Your Environment On-screen tools Shortcut menus Smart tags Task panes Creating a Presentation Guidelines for slide shows AutoContent Wizard Design templates Starting from a blank background Developing Content PowerPoint views Outline and Slides tabs Rearranging text in an outline | Managing Slides with Views Slide Sorter view Slide transitions Animation schemes Notes Page View Presenting the Slide Show Slide Show view Drawing on a slide Printing slide show components Modifying Masters Changing the underlying template Background objects and colors Placeholders Fonts and paragraph formatting |
| To top | | |
PowerPoint Level 2 | Tables and Pictures Graphics objects Table Clip Art Media Clip Picture Org. Charts and Diagrams Diagram Gallery Org. charts Diagrams | Other Charts and Objects Embedded objects Microsoft Graph charts Other embedded objects Microsoft Office Interactions Choosing the application Word document to PowerPoint Excel document to PowerPoint PowerPoint document to Word |
| To top | | |
Access Level 1 | Creating a Database Access database objects Planning the design Naming objects Managing your environment Tables Working in Design View Creating fields Creating a primary key Deleting and copying records and values Finding, spell-checking, sorting, and filtering records Queries Creating a Select Query Working with query criteria Creating user prompts in queries | Using queries to calculate Concatenating fields Forms Creating a form Managing controls on a form Working with properties Formatting a form Reports Creating a report Modifying a report Working with properties Page formatting and printing Maintaining a Database Compacting a database Making backups Importing and exporting |
| To top | | |
Access Level 2 | Normalizing a Database Normal form database standards Analyzing table relationships Establishing table relationships and referential integrity Advanced Table Techniques Data validation techniques Indexing techniques Using hyperlink fields Advanced Queries Creating multiple-table queries Top Values queries Unique Values property Crosstab queries Action queries Advanced Forms Creating a form with a subform | Adding calculations to a form Using functions in forms Command buttons Combo boxes Option groups Advanced Reports Hiding duplicate data Using functions in reports Creating subreports Creating charts Working with Macros Using macros to control form properties Using macros to provide user interaction Using macros to automate tasks |
| To top | | |
Outlook | Outlook Shortcut Keys Managing Your Environment On-screen tools Shortcut menus Using Mail Sending mail and attached files Saving a draft message Setting properties for a message Including an email signature Working with sent messages Viewing incoming mail messages Receiving mail Assigning Categories to messages Getting Organized Organizing folders Managing the Navigation pane Setting defaults Copying an Outlook item Creating a Distribution List Managing Views Controlling columns and sorting Grouping by column headings | Switching to other views Creating and modifying views Using search folders Organizing with Flags Organizing with Categories Using Contacts Navigating in Contacts Adding a contact Using other views Printing a Contacts list Creating multiple Contacts lists Exporting contacts Merging contacts with a Word document Using the Calendar Navigating in the Calendar Changing the Calendar view Personal and public items Creating appointments and meeting invitations Creating tasks and assignments Responding to appointment and task requests |
| To top | | |
Crystal Reports | Overview Setting up defaults Managing a data source Menus, toolbars, and Status Bar Getting Help Working with Views Design View Preview View Searching for text Working with Objects Inserting fields Using rulers and guidelines Inserting text boxes Inserting parameter prompts Inserting graphics lines and boxes Working with graphics objects Inserting Special Fields Repository Explorer Report Explorer Formatting Formatting fields Formatting text boxes Formatting pages Formatting report sections | Creating templates Printing and exporting Manipulating Report Data Selecting records Grouping and sorting records Summaries and grand totals Working with group sections Creating Formulas Using the Formula Editor Examples of formulas If-Then formulas Troubleshooting formulas Custom functions Advanced Objects Creating running totals Using parameter prompts to customize reports Custom groups Using group selection criteria Special-purpose Objects Cross-tab objects Chart objects Subreports |
| To top | | |
HotDocs | The HotDocs Environment On-screen tools Shortcut Keys File names and locations Default settings Assembling a Document Setting Up Your HotDocs Creating libraries Designing templates Using answer files Organizing document assembly Template Development Inserting text, date, and number variables Creating true/false, multiple choice, and computation variables Modifying inserted variables | Advanced Tools IF fields and expressions REPEAT fields Building custom dialogs Using models Clause Libraries Creating a clause library Adding a clause library to your library Inserting clauses into templates Component Manager Creating and managing components Copying components between templates Specifying properties for component files |
