Computer Training for Confidence and
Success
|
|
|
|
Creating a Document: Enter Text;
Save a Document; Use Automatic Text Features; Obtain Online Help Editing Text: Open an Existing Document; Delete Blocks of Text;
Move and Copy Text; Copy Multiple Items Formatting Text: Apply Character Formats; Change the Font and Font Size;
Add Highlighting and Color to Text; Copy Text Formatting; Paste Options Formatting Paragraphs: Change Paragraph Alignment; Change Line Spacing Within a Paragraph;
Add a Border and Shading to a Paragraph; Set a Custom Tab; Add Indents;
Create Numbered and Bulleted Lists; Create an Outline Numbered List Adding Tables:
Create a Table; Change Table Structure; Add Table Borders and Shading; AutoFormat a Table Using Word Timesavers: Create a New Document Using a Template; Create a New Document Using a Wizard;
Insert a Symbol; Insert the Date or Time; Find and Replace Text; Check Spelling and Grammar; Replace a Word Using the Thesaurus Setting Page Display and Printing Options: Preview a Document; Set the Page Orientation; Create Headers and Footers; Change
Margin; Insert a Page Break Creating and Modifying Templates:
Apply Styles; Modify Styles; Create User—Defined Styles; Create a Template from an Existing Document Managing Tables and Table Data in Documents: Convert Tabbed Text into a Table; Merge Cells in a Table; Open an Excel Table in Word; Sort Table Data; Perform Calculations in Tables; Create and Modify a Chart Based on Word
Table Data; Link Excel Data in a Word Table Adding Graphics:
Insert a Clip Art Image; Add an Auto Shape; Insert Word Art; Insert an Organizational Chart Creating a Newsletter:
Create a Document Section; Format Text into Newsletter Columns; Control Column Text Flow; Wrap Text Around a Graphic;
Create Envelopes and Labels Sending Form Letters:
Select the Main Document Type; Select the Data Source
Insert Merge Fields; Merge and Preview Form Letters; Create Mailing Labels Managing Document Changes:
Use Comments in Word Documents; Compare and Merge Documents Creating and Distributing Forms: Create a Form Template; Insert Fields in a Form Template; Protect the Form; Test a Form Automating Tasks: Run Macros; Record a Macro; Edit a Macro; Create Toolbar Buttons; Create Custom Menus Referencing Document Information: Insert Bookmarks; Insert Footnotes and Endnotes; Add Captions; Create Cross-References Preparing a Document for Publication: Set Book Margins; Create Custom Headers and Footers; Compile a Table of
Con Revising Documents: Create Document Versions; Distribute a Document; Track Changes to a Document; Review Document Changes Getting Started: Identify What You Can Do with Excel; Enter Data in a Worksheet; Edit Data; Change Text Appearance; Save a Workbook; Obtain Help. Editing Your Worksheet: Move Data to Other Cells; Copy Data to Other Cells; Fill Cells with a Series of Data;
Insert and Delete Rows and Columns; Undo and Redo an
Entry; Find and Replace Numbers;
Enter Data in a Range; Verify Data in a Range. Performing Calculations: Sum a Range of Data; Use a Built-in Function; Copy a Formula; Create an Absolute Reference. Formatting: Specify Numeric Format; Create a Custom Numeric Format; Change Font Size and Type; Create and Apply Styles; Add Borders to Cells; Find and Replace Formats; Change Column Width and Row Height; Align Cell Contents; Merge and Split Cells; Apply an AutoFormat. Working with Multiple Worksheets: Format Worksheet Tabs; Reposition Worksheets in a Workbook; Copy Worksheets; Change the Number of Worksheets. Creating and Modifying Charts: Create a Chart; Modify Chart Items; Format a Chart; Change the Chart Type. Setting Page Display and Printing Options: Freeze and Unfreeze Rows and Columns; Set Print Titles; Set Page Margins; Create a Header and Footer; Change Page Orientation; Insert and Remove a Page Break; Print a Range. Working with Templates: Create a Workbook from an Excel Template; Create a Template; Create a Graphic; Create a Workbook from a User-Defined Template. Sorting and Filtering Data: Sort Data; Add Subtotals to a Worksheet; Filter Lists; Create and Apply Custom Filters. Importing and Exporting Data: Import Data from the Web; Import Data from an External Source; Export Data; Save a Worksheet as a Web Page; Publish a Worksheet to the Web. Working with Advanced Formulas: Share Data Among Worksheets; Create a Name for a Range of Cells; Use Functions to Create Advanced Formulas; Trace Cell Precedents; Trace Cell Dependents; Locate Errors in Formulas. Analyzing Data: Create a PivotTable Report; Create a PivotChart Report; Create Scenarios; Use Solver; Use Goal Seek. Collaborating: Insert and Edit a Hyperlink; Add and Edit Comments in a Worksheet; Create Discussion Comments; Respond to Discussion Comments. Customizing Your Workbook: Applying Conditional Formatting; Adding Data Validation Criteria; Customizing Menus; Customizing Toolbars; Creating a Macro; Editing a Macro; Grouping and Outlining Structured Data. Working with Multiple Data Sources: Creating a Workspace; Consolidating Data; Linking Cells in Different Workbooks; Editing Links. Collaborating with Others Using Workbooks: Protecting Your Worksheets; Protecting Your Workbook; Sharing Your Workbook; Setting Revision Tracking; Merging Workbooks; Tracking Changes. Enhancing Your Worksheet Using Charts: Charting Non-adjacent Data; Modifying Chart Items; Creating a Trend Line. Using Graphic Objects to Enhance Your Worksheet: Creating Graphic Objects; Resizing, Moving, and Copying Graphic Objects; Changing the Order of Graphic Objects; Grouping Graphic Objects; Formatting Graphic Objects; Inserting Clip Art; Modifying Clip Art. Getting Started: Opening a Presentation; Examining Screen Elements; Exploring PowerPoint Views Starting a New Presentation: Creating a New Presentation; Adding Text to a Title and Bullet Slide;
Working in Outline View; Modifying Text on a Slide; Checking Spelling Drawing and Working with Objects: Using Drawing Tools; Working with Text and Objects; Enhancing Text and Objects;
Working with Text Color and Fills Clip Art, Tables, and WordArt: Using Clip Art; Inserting a Table; Using WordArt Creating Charts: Creating an Organization Chart; Changing the Organization Chart Style;
Creating a Bar Chart; Changing Chart Data and Type Working with Templates and the Slide Master: Selecting a Template; Changing Elements of the Slide Master; Removing Slide Master Objects Slide Shows and Output: Adding Transitions and Animation to a SlideShow; Running Slide Shows;
Working with Notes; Printing Preparing Presentations for the Web: Using the
AutoContent Wizard; Saving Presentations for Internet Delivery and Viewing Creating a Custom Design Template: Change the Background; Insert Graphics; Add a Footer; Formatting Bullets;
Modify the Slide Master Text; Save a Design Template Creating Presentations with Special Effects: Change the Orientation of Objects; Grouping Objects; Ungrouping Objects;
Layer Objects; Add a Sound Object; Animating Objects; Changing the Order of Effects Delivering a Presentation:
Send a Presentation to Word; Add Emphasis During Your Presentation;
Take Meeting Notes; Setting Up a Slide Show to Run Automatically; Recording a Narration;
Take a Presentation on the Road Creating Presentations for the Web: Run the AutoContent Wizard; Add Hyperlinks; Add Objects from Other MS Applications;
Publish to the Web Reviewing and Broadcasting Presentations: Create a Presentation from an Outline; Send a Presentation for Review; Review a Presentation; Applying Reviewer Changes; Set Up and Schedule an Online Broadcast Working with a Relational Database:
Identify Uses of a Relational Database; Define Database Terminology;
Create a New Database Based on a Template; Examine the New Database Planning a Database:
Identify Database Purpose; Review Existing Data; Determine Fields;
Group Fields into Tables; Normalize the Data; Designate Primary and Foreign Keys;
Identify Table Relationships Building the Basic Structure: Create a Blank Database; Create a Table using a Wizard;
Compare Datasheet and Design Views; Create Tables in Design View; Create Relationships between Tables Working with Tables:
Modify a Table Design; Work in Datasheet View; Work with Subdatasheets Creating and Working with Select Queries:
Examine a Query; Create a Query using a Wizard; Work in Query Design View;
Select Records; Edit Values in a Query Datasheet; Add a Calculated Field to a Query;
Perform a Calculation for a Group of Records Creating and Using Forms:
Create AutoForms; Create a Form Using a Wizard; Modify the Design of the Form;
Use Forms to Work with Data Creating and Using Reports:
Create an AutoReport Managing a Database and Data: Import Data; Maintain Record Integrity; Exporting Data; Documenting Table Relationships Controlling Data Entry: Make Data Entry More Accurate; Make Data Entry More Efficient; Facilitate Data Entry Finding and Joining Data: Find Data with Filters; Get the Correct Data with Query Joins; Building Bridges Between the Data;
Relating Data Within a Table Creating Flexible Queries: Summarizing Data with Queries; Enter Criteria on the Fly;
Maintain Data with Queries Improving Your Forms: Enhance the Appearance of a Form; Enhance the Usability of a Form; Make Your Forms More Professional;
Display Form Data from Multiple Tables Customizing Your Reports: Organize Report Information; Enhance Data Layout; Working with Report Pagination;
Summarizing Information; Add a Subreport to an Existing Report; Creating Mailing Labels Making Your Data Available on the Web: Create a Data Access Page; Improving the Look of a Data Access Page;
Editing Data Using a Data Access Page; Group Records in a Data AccessPage Structuring Existing Data: Use the Table Analyzer Wizard for Help; Decide on Your Own Design; Create a Junction Table;
Modifying the Original Tables and Completing the Design; Compact and Repair a Database Summarizing Data: Group and Summarize Records in Different Ways; Summarize with a Crosstab Query;
Pivot Query Results; Displaying a Graphical Summary on a Form Simplifying Tasks with Macros: Create a Macro; Attach a Macro to a Command Button; Restrict Records Adding Interaction and Automation with Macros: Require Data Entry with a Macro; Displaying a Message Box with a Macro;
Automate Data Entry Making Forms More Usable: Change the Display of Data Under Certain Conditions; Display a Calendar on a Form;
Organize Information with Tab Pages Making Reports More Powerful: Cancel Printing of a Blank Report; Including a Chart; Arranging Data in Columns;
Distributing Reports as a Snapshot Expanding the Reach of Your Data: Merge Access Data with a Word Document; Publishing Access Data as a Word Document;
Analyze Access Data in Excel
Creating a Switchboard and Setting the Startup Options: Create a Database Switchboard; Modify a Database Switchboard; Set the Startup Options; Modify the Startup Options Developing a Data Access Page and Including a PivotTable and PivotChart: Create a Data Access Page in Design View; Incorporate a ComboBox Control in the Data Access Page; View Data Access Pages with the Browser; Add Records to a Database Using the Data Access Page; Plan a PivotTable; Develop a PivotTable with the Office PivotTable Tool; Develop a PivotChart from a PivotTable Distributing and Securing the Database: Split a Database; Implement Security; Set Passwords; Encrypt and Decrypt a Database; Convert an Access Database to an MDE File Integrating Access into Your Business: Link Tables to External Data Sources; Import XML Data into an Access Database; Export Access Data to XML Format; Replicate an Access Database Automating a Business Process with VBA: Create a Standard Module; Create and Insert a Procedure; Develop Procedure Code; Call a Procedure from a Form; Run the Procedure Sending Messages: Compose and Send a Message; Change Message Format; Check Spelling and Grammar;
Attach File to Message; Create and Add a Signature To a Message; Send a Message with Voting Buttons Acting On Messages: Open a Message; Open Message Attachment; Save Attachment; Reply to Message;
Print Message; Mark Message Unread; Reply to a Voting Button Message; Recall a Message;
Delete a Message Scheduling Appointments and Events: Add an Appointment to the Calendar; Schedule a Recurring Appointment;
Assign Category to an Appointment; Edit an Appointment; Delete an Appointment; Schedule an Event;
Print Calendar Scheduling Meetings: Schedule a Meeting; Reply to a Meeting Request; Propose a New Meeting Time;
Update Meeting Request; Cancel Meeting Using Contacts:
Add a Contact; Sort Contacts; Find a Contact; Create a Custom Category Creating Tasks: Create a Task; Update a Task; Update Task List; Assigning Task to Contact Managing Messages: Sorth Messages; Create a New Folder; Move Messages Between Folders;
Move Folders; Delete a Subfolder; Search for Messages Using Notes: Create a Note; Move a Note; Resize a Note; Assign Contacts to Notes; Assign Categories to Notes Customizing Your Mail: Use Message Stationery; Create Custom Stationery; Modify Message Formats;
Modify Message Settings; Modify Delivery Options; Notify Others That You Will Be Out Of Office Working With Contacts: Share Contacts With Other Users; Export Contact Lists; Link Items To A Contact;
Forward Note To Contact; Create a Distribution List Managing Your Work: Assign a Task; Reply to a Task Request; Send a Task Update; Specify Default Settings for Tracking
Assigned Tasks; Track Assigned Tasks; Share Task Information With Other Users Organizing Your Mailbox and Calendar:
Ways to Organize Outlook Items; Sort Messages Using Multiple Criteria;
Assign Messages To Categories; Group Messages; Filter Messages; Organize Messages By Using Colors;
Find Specified Messages; Manage Messages with Rules; Apply Conditional Formats to Calendar Appointments Customizing Outlook: Customize the Toolbar; Create a New Toolbar; Customize the Menu; Create Shortcuts;
Create Custom Views; Customize Outlook Today; Specify AutoCorrect Settings; Change the Office Assistant Settings;
Display an Additional Time Zone Sharing Outlook Information: Specify Folder Permissions; Delegate Access to Folders; Access Another User's Folders;
Save a Calendar as a Web Page; Create a Public Folder; Post to a Public Folder Saving and Archiving Mail: Save Messages in Alternate File Formats; Create Office Documents from within Outlook; Archive Messages Manually; Archive Messages Automatically; Protect Personal Folders; Use Mailbox Cleanup Managing Information: Import Information; Use Outlook Contacts for a Microsoft Word MailMerge;
Map a Contact's Address; Create a Custom Form Scheduling: Publish Free/Busy Information over the Internet; Schedule an Online Meeting;
Accept an Online Meeting Request; Use NetMeeting E-mail Alternatives: Add Contacts for MSN Messenger Service; Send and Respond to an Instant Message;
Setting up a News Account; Viewing Newsgroup Messages; Post a Newsgroup Message Tracking Work Activities using the Journal: Automatically Record Items in the Journal; Create and Open a Journal Entry;
Modify a Journal Entry Configuring and Securing Outlook: Configure a Dial-up Connection; Add a Hotmail Account; Digitally Sign Messages;
Encrypt a Message; Set Security Zones Internet Interactions: Create Outlook Items in Internet Explorer 5.0; Add a Web Page
Shortcut from the Outlook Bar; Create a Folder Home Page; Insert a Hyperlink Working Offline and Remotely: Create an Offline Folder; Select Folders to Synchronize as a Group;
Download Messages for Remote Use
|
|
Training for Confidence and Success A non-profit organization licensed by the Commonwealth of Massachusetts, Department of Education Sinnott School Web design by Richard Olsen Last update of this page:: May 22, 2008 |
