| |
Creating and Editing
a Word document |
Formatting a
document |
More formatting,
Tables and Creating Web Pages with MS Word |
 Starting
and customizing Word, How to enter text, Saving a document. |
Changing
the margins, How to adjust the line spacing, Headers and Footers. |
Selecting
and replacing text, Autoformat as you type. |
| Formatting
paragraphs and characters. |
Shortcuts,
Hyperlinks, Moving text, Smart tags,Finding and Replacing Text. |
Changing
color of text, Setting Tab Stops, Clearing formatting. |
| Inserting
and manipulating Clip Art, Printing a document and Correcting errors. |
Indentation
and Page Breaks, Footnotes and Styles, Sorting paragraphs. |
How
to insert the current date, Creating an Autotext Entry. |
| |
How
to use Word Count and inserting symbols. |
Creating
and inserting data in a Table, Bulleting a list. |
| Hanging
Indentation, Finding and inserting synonyms and How to check the Spelling
and the Grammar. |
Addressing
and printing envelopes and mailing labels. |
Back to Microsoft
Office Short Courses
| |
Advanced
Tables, Charts and Watermarks |
Mail Merge |
Professional
looking Newsletters |
| Inserting
Word documents into a new document, Creating advanced Headers and
Footers. |
Working
with AutoShapes, How to create the Data Source, Adding records to
the Data Source. |
How
to create the nameplate of a Newsletter, WordArts, Formatting a document
into multiple columns. |
| Formatting
and Charting a Table, Drawing an empty Table, Formatting the Table. |
Modifying
Fields, How to insert Merge Fields in the document, The If Merge Field. |
Formatting
a letter as a Drop Cap, How to insert Column Breaks, Adding a vertical
rule between columns. |
| Inserting
and manipulating Clip Art, Printing a document and Correcting errors. |
Displaying
and Printing Field codes, Merging the document and printing the letters,
Merging the labels and printing them. |
How
to create a Pull-Quote, Balancing Columns, Creating a Diagram. |
| Finding
a format, Creating and Applying a Character Style, Customizing Bullets
in a list. |
How
to Merge all data records to a directory. |
The
Format Painter Button, How to add a page Border, Animating Text. |
| Creating
a Watermark and How to reveal a Formatting |
|
How to change a document's background, How to Link an MS Excel Worksheet
and chart its data in MS Word. |
Back to Microsoft Office Short
Courses
| |
How
to create an online form |
Macros |
Working with a Master
Document and XML |
| Designing
the form, creating a template, entering Form instructions. |
Protecting
and unprotecting a document, how to set up the security level. |
How
to create an outline, inserting and creating subdocuments in a Master
Document, How to build an index. |
| Tables
in a Form, Text Form fields, Drop-Down Form fields, Check Boxes. |
Recording
and executing a Macro, Automatic Macros, How to edit an automatic
Macro. |
How
to create a Table of Contents, Bookmarks, Using the Document Map. |
| Inserting
and manipulating Clip Art, Printing a document and Correcting errors. |
Create
a Macro using VBA, How to plan and write a VBA procedure. |
How
to summarize a document, Using Readability Statistics. |
|
How to format the Form fields, how to protect a Form, how to save
data on the Form. |
How
to add Activex Control to a Form, How to attach a digital signature
to a document. |
Password-Protecting
a file, Working with an XML Schema. |
Back to Microsoft Office
Short Courses
| |
How to create a Worksheet
and an embedded chart |
Formulas, Functions
and more Formatting |
The IF Function, What-If
Analysis and Large Worksheets |
| What's
a Worksheet, How to select a cell, Entering Text. |
How
to create Formulas, How to calculate the Average of a range. |
How
to create a Series, The Format Painter Button,Copying a range of cells. |
| Headings,
Column Titles, Row Titles |
How to calculate the Highest Number in a range, How to calculate the
Lowest Number in a range,. |
How
to insert and delete cells, Freezing the worksheet titles, Absolute
and Relative references |
| How
to enter numbers, How to calculate a sum, The Fill handle. |
How
to display and print the formulas version of a Worksheet, changing
the Worksheet names. |
The
IF Function, How to Format a Worksheet III, Creating and manipulating
3-D Pie charts. |
|
How to format a Worksheet I, Creating a Chart, Printing a document
and How to Correct errors. |
How
to format a Worksheet II, checking the spelling of the Worksheet. |
How
to rename and color the tabs of a Worksheet, What-If Analysis, Creating
Static and Dynamic Web pages with MS Excel. |
Back
to Microsoft Office Short Courses
| |
Data Tables and Hyperlinks |
Lists in MS
Excel |
Templates and Multiples
Worksheets and Workbooks |
| Creating
cells names based on row titles, How to create a Data Table. |
How
to create a List, Data Validation, Entering records in a List. |
How
to create a Template, Formatting the template, using Templates to
create Workbooks |
|
Formatting the Data Table, adding hyperlinks, protecting a Worksheet. |
The VLOOKUP Function,Sorting a List, How to display Automatic Subtotals
in a List. |
Creating
3D cylinder charts, Printing the Workbook, Page Breaks. |
| How
to check Formulas, Printing sections of a Worksheet. |
Use
a data Form to find records, Querying a List using AutoFilter,Creating
a Criteria Range. |
The
Find and Replace command, How to consolidate data by linking Workbooks.
|
|
How to format a Worksheet I, Creating a Chart, Printing a document
and How to Correct errors. |
Querying
a List using the Advanced Autofilter, How to Extract Records, Using
Database functions, The SUMIF and COUNTIF Functions. |
How
to create a Workspace, Linking an Excel Worksheet and Chart
to a Word document. |
Back
to Microsoft Office Short Courses
| |
| Macros and VBA in
MS Excel |
Formula Auditing,
Data Validation, Goal Seek, Solver and working with Scenarios |
PivotCharts, PivoTables,
Trendlines and Importing Data to Excel |
| How
to record a macro and assign it to a button and Menu command. |
Formula
Auditing, Data Validation, How to use Trial and Error to solve a Complex
problem. |
How
to import: text files, Access Tables, Data form XML, Data from a Web
Page. |
|
Creating a VBA procedure from scratch. |
Using Goal Seek, How to use Solver to Find the Optimal Solution. |
Creating
a PivotChart, Adding data to the PivotChart, Working with PivotTables. |
| |
Creating and working with Scenarios, Summarizing Scenarios. |
Merging
Workbooks, Trendlines in a chart, How to create a PivotTable List
Web Page in Excel. |
Back
to Microsoft Office Short Courses
Microsoft
PowerPoint Level 1 |
Creating a Presentation
using a Design Template & Text slide Layout |
Create a Slide
Show using Clip Art and the Tab outline. |
Adding Visuals to a
Slide Show |
| What's
PowerPoint?, Choosing a Design Template, How to create a Title slide. |
Working
with the Outline tab, Text Slides with Multi-level bulleted lists. |
How
to import text files, create a custom Background, modify Clip Art. |
|
Changing the Text Attributes, How to add a new slide, how to create
a Text slide with a Single_Level bulleted list. |
The Slide Sorter View,Working with Clip Art, Headers and Footers.
|
Use
graphical customized bullets, Working with Tables, and how to create
and Organizational Chart. |
| Ending
a presentation with a black slide, Slide Show View, Checking the Spelling,
printing a Presentation. |
Animation Schemes,Animating Clip Art Running
and Printing a Presentation created on the Outline Tab. |
Printing
Slides as Handouts, Creating and Presenting a Custom Show. |
Back
to Microsoft Office Short Courses
Microsoft
PowerPoint Level 2 |
| Changing Visual elements
and Presentation Formats. |
Macros and VBA. |
Self Running Presentation
and Shapes |
| Working
with WordArts, Grids, Adding Sound effects, Adding a Chart to a slide. |
Creating
a toolbar, customizing a toolbar by adding buttons,create a Macro
using the Macro recorder. |
Inserting
sides from another presentation, inserting and formatting AutoShapes. |
| How
to insert an Excel Chart, adding a Table from Word, Hyperlinks, Changing
the Presentation color Scheme. |
Customize a Menu, create a Form to customize a presentation, create
a user interface. |
Apply
a motion path animation effect to an AutoShapes, Inserting, sizing,
and formatting a Venn diagram. |
|
Action Buttons, Slide Transition Effects, Timing. |
Adding
controls to a form, assign properties to controls, write VBA code
to create a unique presentation. |
Create
and start a self-running presentation. |
Back
to Microsoft Office Short Courses
| |
| Essentials & the
Windows XP Desktop |
Windows XP Explorer
and Transforming the Desktop |
Control Panel and Advanced
File Searching |
| Launching
Windows XP, the Windows XP Desktop, Keyboard Shortcuts, Windows Help. |
My
computer window, organizing open windows, copying, moving and deleting
files, Windows XP Explorer. |
How
to customize the Keyboard and the Mouse, User Accounts and Privileges. |
| How
to create and save a document, storing documents in the My Documents
folder, Creating folders. |
Copying, moving, renaming,and deleting files with Windows Explorer,
My Pictures Window, Finding files and folders. |
Solving
problems using a troubleshooter, adding and removing programs,given
maintenance to your computer. |
|
Opening and modifying documents within a folder, working with User
Accounts. |
Changing the desktop appearance, customizing the taskbar, working
with toolbars on the Taskbar, the Notification area and the Start
Menu. |
Advanced
file searching, Searching for documents files, The recycle bin. |
Back
to Microsoft Office Short Courses
| |
| Start creating and
using a Database |
Queries |
Giving maintenance
to a Database |
| Creating
a Database, How to create a Table, Adding records to the Table. |
Creating
and Running a Query, Text data in Criteria, Wildcards, Parameter Query. |
Updating
Records, how to Filter records, making changes in the Structure of
the Database. |
| How
to Preview and Print a Table, A basic Query, Creating a Form. |
Using Numeric Data in a Query, using Comparison Operators, Compound
Criteria Query, AND & OR Queries. |
Enhancing
the look of a Datasheet, Update Queries, Delete Queries, Validation
Rules. |
|
Using a Form, Datasheet and Form View, Creating a report. |
Sorting Data in a Query, Joining Tables, Calculated fields in a
Query, How to calculate Statistics, Crosstab Queries |
The
Lookup field, Referential Integrity, Ordering Records, Indexes, Converting
Data from other applications to Access, Copying data from Access to
other applications. |
Back
to Microsoft Office Short Courses
| |
| Creating Reports and
Forms. |
Enhancing Forms,
Subforms. |
PivotTables, PivotCharts
and Switchboards |
| Creating
Reports, Controls, Labels, Adding Totals and Subtotals. |
The
Input Mask Wizard, Date Fields, Memo Fields, Hyperlink Fields |
Creating
a Macro, running and editing a Macro. Creating additional Macros. |
| How
to use multiple tables in a Report, removing unwanted controls, changing
Headings. |
OLE
Fields, Creating a Form with a Subform, Modifying the Form Design. |
Creating
a Switchboard, creating and modifying Switchboard pages. |
| Creating
Forms, Calculated fields, Combo Boxes, Enhancing a Title. |
Moving and resizing Fields, Changing and Aligning the Labels, Tab
Stops, Changing the Tab Order. |
Adding
more Tables,relating several Tables, PivotTables, PivotCharts. |
Back
to Microsoft Office Short Courses
| |
| Advanced
Reports and Forms. |
VBA and Multi-page
Forms |
Administering a Database
System |
| Creating
Queries for Reports, Adding a Subreport, Modifying the Subreport. |
Procedures
in VBA, updating the Controls, creating a Form load event procedure. |
The
Table Analyzer, the Performance Analyzer, the Documenter, checking
errors. |
| Adding
the Date and Page number to a Report, creating and printing mailing
labels. |
Creating
a function to run a Query, creating code to update the Controls. |
SharePoint
services, setting passwords, encoding a Database, removing a password. |
| Formatting
a form with command buttons, modifying the buttons and the combo boxes. |
Using
Tab Controls to create a multi-page form, inserting charts, adding
ActiveX control. |
Creating
a Replica, Splitting the Database, creating and using an MDE file,
the User-Level Security wizard. |
Back
to Microsoft Office Short Courses
| |
| E-mail
|
Contact Management
& Schedule Management |
The
Inbox, Opening and Reading e-mail message, Printing, closing, replying,
forwarding, deleting e-mail messages. |
Creating
a contact list, organizing and finding contacts, Distribution Lists,
Tracking Activities for contacts. |
| E-mail
signatures, composing a new e-mail, formatting an e-mail message,
attaching a file. |
The
Calendar, entering appointments, editing appointments, moving appointments
to a new time, a new date, a new month. |
| Sending
an e-mail message, flagging, sorting, and filtering E-mails, setting
e-mail message importance, sensitivity and delivery options. |
Creating
events, How to create a task list, meeting and task management,
scheduling resources, customizing calendar settings, printing a
calendar |
Back
to Microsoft Office Short Courses
|
