Biz Apps- Microsoft Office
Microsoft Word 1:
Covers creating, editing, and formatting text.
Participants will also learn about formatting
documents and paragraphs, tabs and tables, page
appearance, saving, spell-checking and printing
options.
Microsoft Word 2:
Create, modify, perform calculations in, and
import data in tables. Use styles to affect the
appearance of paragraphs and create outlines. Create
and use templates. Merge a document with data to
create multiple variations of a document. Format text
in columns with graphics; use section breaks to format
a document.
Microsoft Word 3:
Use advanced techniques for working with styles.
Create and use templates and forms. Enhance documents
using applets like GraphTool and WordArt. Create a
master document, a table of contents, and an index.
Enhance document layout . Use highlights, comments,
and revision marks to edit and share documents online.
Explore Word’s Internet features including
conversion of documents to HTML.
Microsoft Excel 1:
Create a basic worksheet by entering text, values,
and formulas. Create formulas by using Excels built-in
functions. Move and copy data by using shortcut menus,
drag-and-drop editing, and toolbar buttons. Change and
format the appearance of worksheet data. Prepare a
document for printing . Use spell-checking. Use
multiple worksheets for clear data organization and
presentation.
Microsoft Excel 2:
Create charts that graphically represent worksheet
data. Modify charts. Customize charts by applying
formatting. Enhance worksheets and charts by using the
drawing tools to add graphic objects. Sort information
in a list by using the Data, Sort command. Locate
information quickly in a list that meets specified
conditions by using the Advanced filter feature.
Microsoft Excel 3:
Customize toolbars and create styles and
templates. Create nested and decision making
functions. Analyze worksheet data by creating pivot
tables. Compare and contrast workbook files and file
links. Outline and consolidate worksheets; analyze
work- sheet data by using the Solver and Scenario
Manager. Display and protect worksheet data by locking
cells. Record and modify macros by using the Visual
Basic Editor.
Microsoft Powerpoint 1:
Create and edit bullet slides. Use PowerPoint’s
drawing tools to create a slide. Incorporate clip art
and WordArt objects in a slide. Create and enhance
organization charts, and create and edit charts by
using Microsoft Graph. Change the overall appearance
of a presentation by using design templates and the
Slide Master. Run a slide show, become familiar with
slide show options, and add notes to a slide.
Microsoft Powerpoint 2:
Create a custom template by selecting a color
scheme, background fill, and fonts. Enhance a
presentation by using graphic objects. Enhance a slide
containing a flow chart by using advanced drawing
techniques. Customize the PowerPoint environment by
modifying toolbars and using the Options dialog box.
Enhance a presentation by using animation.
Microsoft Access 1:
Understand database concepts and terminology.
Design and create tables. Enter and manipulate data in
tables. Use Access queries to select and analyze
information in a table. Create data forms for viewing
and inputting data. Create reports that summarize and
group data. Perform database maintenance procedures.
Microsoft Access 2:
Establish relationships between tables by
analyzing table relationships and customize table
designs to maintain data integrity and creating
indexes. Design select queries using multiple tables
to calculate, group, average, and concatenate values.
Customize form and sub-form designs by creating
calculated fields, combo boxes, and unbound controls.
Customize report designs by grouping, sorting,
summarizing and sub-reporting.
Microsoft Access 3:
Refine the information derived from queries by
creating outer joins and using crosstab queries.
Enhance form design by manipulating control object
properties. Automate simple tasks by creating macros.
Make forms more functional and automate tasks by
creating macros. Enhance the design of reports by
hiding repetitive data, grouping data on prefix
values, and using functions in controls. Use Access to
create links to Internet sites, and to save data as
HTML documents.
Microsoft Outlook- Basics
Send and receive mail, schedule appointments,
insert events, organize contacts, create notes, create
and manage tasks.
Mark "Doc" Noel (c) 2002
Contact: 386-446-5522
e-mail:
wicketkeeper@rocketmail.com
