|
Windows 7 Introduction.
A must for users who are new to the Windows 7 environment. Learn to
utilize the applications included with Windows such as Computer, the
Recycle Bin, and various accessories. Learn to use Shortcut Menus, Pin
programs to the Start Menu or Taskbar, and use Jump lists. Learn quick
navigation techniques to start applications, multitask between them,
close windows and exit programs. Learn to create Shortcuts on the
desktop for quick access to applications and files, and arrange data
files into an organized directory structure using Windows Explorer.
Learn to use Control Panel to customize the desktop, add Gadgets to the
desktop, get Help, and use the Notification Area. Learn to Search for
files, folders, and web pages, Zip files and folders, and Burn files and
folders to CD’s and DVD’s. [Back
to Form] |
|
Office 2010 New Features.
This class introduces the new Office 2010 user interface and is the
recommended prerequisite for all of the Office 2010 training classes.
The class provides an overview of the new features that Word, Excel, and
PowerPoint share such as Quick Styles, SmartArt, and Themes. In
addition, the class introduces new features that are specific to each
application such as Styles, Track Changes, and Building Blocks in Word,
Formula AutoComplete, Enhanced Filtering, and New Conditional Formats,
and Tables in Excel, and the Slide Master and the Selection Pane in
PowerPoint. Participants will learn to use the contextual Ribbons and
Tabs to access commands that were previously organized into pull down
menus and dialogue boxes in earlier versions of Office. Participants
will learn about the new XML file formats, compatibility with previous
versions of Office, and how to save files as PDF’s.
[Back
to Form] |
|
Word 2010 Introduction. This
is our most popular class and is loaded with tips and shortcuts that
will significantly increase your level of productivity in Word. You will learn to
use several quick keystrokes and text selection techniques to format and
edit text, use the Ruler to set Indents and change Margin Settings, set
Line Spacing, and use the enhanced Undo, Redo, and
Repeat commands. You will learn shortcuts to move and copy text, switch between Draft, Print Layout
and Reading views, and use Thumbnails to navigate between pages. You
will learn to use the new Mini Toolbar; insert Headers and Footers; and
format lists with Automatic Bullets and Numbering. You will learn to
create and insert AutoCorrect entries and the new Quick Parts building
blocks.
[Back to Form] |
|
Excel 2010 Introduction.
You will learn to create worksheets with basic Formulas in addition to Function formulas
such as SUM, MIN, MAX, and AVERAGE. You will learn to copy text and
formulas to other worksheets and quickly copy text and formulas to
adjacent cells using AutoFill.
You will learn to use the new Page Layout view to paginate worksheets, add
headers and footers, and incorporate Print Titles. You will learn to
Sort and Filter data, use Freeze Panes and Split Screen, create
multi-sheet
workbooks, and Group worksheets for consistent
formatting. Additional topics include navigation techniques, several
time-saving quick keystrokes, and tips to print
worksheets and workbooks.
[Back
to Form] |
|
Excel 2010 Intermediate.
You will learn to
create Range Names and reference them in Function formulas such
as SUM, MAX, MIN, AVERAGE, IF, and COUNT. You will learn to use
Absolute and Mixed references to prevent cell addresses in formulas
from adjusting when you copy them. You will learn to use the new Formula AutoComplete feature, the new Calculated
Columns feature, and the new Table feature. You will learn to use
Advanced Sorting and Filtering techniques and query a database
using Database Function formulas such as DSUM, DMAX, DMIN,
DAVERAGE. You will learn to use Date
and Time functions to perform calculations with dates and times. You will
learn to create multi-sheet workbooks that include three-dimensional formulas,
duplicate worksheets in a workbook, and copy and move worksheets
between workbooks.
Additional topics include Auditing worksheets and Integrating data from
other applications. Excel 2010 Introduction is the recommended
prerequisite.
[Back
to Form] |
|
PowerPoint 2010 Introduction.
You will
learn to create a presentation, insert new slides, change slide size and
orientation, and apply design themes.
You will learn to create slides with Bar, Column, and Pie Charts,
and create slides with Tables and Organization Charts. You will learn to
insert Clip Art and other pictures and draw, resize, group, duplicate,
and move objects. You will learn to use the Slide Master to modify
several slides simultaneously, and suppress Slide Master Elements on
specific slides. You will learn to add transition and animation effects
when you run a slide show, and add your own Speaker's Notes to the
presentation. Presentation guidelines are included along with printing
tips and tricks.
[Back
to Form] |
|
