|
Creative Information Systems is an information technology consulting and training organization providing technical
solutions in the areas of needs analysis, desktop productivity, database design,
and Web development. CIS
has helped to design multimedia presentation facilities, created custom databases,
produced web sites, and developed numerous applications
requiring a broad understanding of state-of-the-art information tools.
Click here to view a list
of sample projects
Click here to read what others
have to say about Susan's training and consulting
Following is a list of
desktop productivity workshops available from Creative Information Systems.
All workshops can be offered on-site as project-based clinics where participants
select real projects to complete during the clinic.
Is your organization planning to upgrade to Microsoft Office 2007?
Minimize downtime and the frustration associated with an upgrade of this
magnitude. Learn to work with the new Office 2007 Ribbon interface.
Find out about shortcuts and tips for making the transition easier.
Learn where to find the Menus and Toolbars you were familiar with in
Office XP or 2003 for Word, PowerPoint and Excel. Explore new features
available only in Office 2007. Designed for individuals who
currently use Microsoft Word, Excel and PowerPoint and need an overview
of what’s changed in Office 2007. Click for
more information
Microsoft Access is a powerful relational database program.
This workshop will teach you the skills necessary for creating databases with
Access. Topics include: getting started; creating, editing, and working with
tables; and setting field properties. You will also learn how to find, filter,
and print data and use the Office Assistant and online Help. This workshop also introduces the skills necessary for using the
querying, analyzing, and reporting capabilities of Access. Topics include:
creating and printing reports; creating relationships; using simple queries;
modifying query results; and creating and using forms.
This workshop is designed to introduce you to the more
advanced features of Microsoft Access. You
will learn to add a combo box, a list box, and an option group to forms; set the
tab order on a form; and add a header and footer to a form. Topics include:
creating multi-table forms, queries, and reports; reducing errors and ensuring
accurate data entry; using related tables to reduce data redundancy; special
features for working with forms; creating labels; creating calculated fields in
reports; using Access macros to automate repetitive tasks; managing your
database including making backup copies, compacting and repairing databases and
creating queries for archiving, appending, and deleting data.
Microsoft Excel is a popular spreadsheet, database, and
graphics program that can be purchased separately or as part of Microsoft Office
or Microsoft Office Professional. This workshop is designed to provide the
essential information for using Excel. You
will learn to create a budget and contact database during this workshop.
You will also learn to format, edit, and print worksheets.
Topics include: creating a worksheet, entering formulas, using functions,
formatting your worksheet, setting up a database, and charting worksheet
information. No previous experience
with Excel is required.
This workshop is designed to take Microsoft Excel users
beyond the basics. You will learn
to work in a multiple-worksheet environment, including techniques for entering
formulas that calculate between worksheets and workbooks.
You will gain a better understanding of how to use complex formulas and
functions critical to the development of advanced spreadsheets such as the
database functions and the IF and SumIf functions.
Topics include: working with multiple worksheets; creating
more complex formulas and functions; personalizing
the Excel workspace; creating summary reports; creating
reports with pivot tables; and using macros to automate tasks.
Microsoft Excel Tips and Tricks
This program is ideal for those who need to further develop their
abilities with complex spreadsheets.
Learn little-known Excel tips and tricks. Examples include: Converting
Color to Black and White; Creating Instant Range Names; Working with
Crowded Worksheets; Using Data Validation; Defining Constant Values;
Flipping Data in a Worksheet; Linking Cells to a Textbox or Object;
Shortcuts for Using Names in Formulas; Tracking Revisions; Using Goal
Seek; Using Names to simplify Formulas; Using Conditional Formatting;
and more.
This workshop will teach you to create, edit, save, and
print documents. You will learn to
work efficiently in a point-and-click graphical environment.
Many of Word's editing and formatting features are covered.
This introductory workshop covers understanding the screen, keyboard, and
mouse; getting Help; formatting text; inserting, deleting, undeleting, and
typing over text; copying, moving, searching and replacing text; adding bold and
underline; printing; page numbering and headers and footers; using the
spell-check, grammar, and thesaurus; and an introduction to tables.
This workshop takes beginners beyond a basic understanding
of Microsoft Word. Learn how to set
up a data file for managing information including how to sort records and how to
select records based on specific criteria, such as zip code or department.
Using mail merge to print form letters, envelopes, labels, and lists will
be covered. Methods for using other
data, such as Excel worksheets and Access databases, with the Word mail merge
program will be discussed. Other
topics include: advanced table features such as sorting and calculations;
newspaper columns; styles and templates for improving the appearance of
documents and making document creation easier; and the use of macros for
automating repetitive tasks. This workshop concludes with a discussion of the
use of graphics in documents such as pictures, charts and graphs, and diagrams.
This workshop was designed specifically to help experienced
WordPerfect users become proficient in Microsoft Word in one day of
instructor-led training and includes a list of tips for moving from Word to WordPerfect.
It will teach you to create, edit, save, and print documents using
Microsoft Word for Windows. Workshop topics include understanding the screen,
keyboard, and mouse; getting help; formatting text; inserting, deleting,
copying, moving, searching and replacing text; adding bold, italic, and
underline; printing; page numbering and headers and footers; using the
spell-check, grammar, and thesaurus.
Using mail merge to print form letters, envelopes, labels, and lists will
be covered. Other topics include:
advanced table features such as sorting and calculations; and styles and
templates for improving the appearance of documents and making document creation
easier.
Microsoft Publisher is a desktop publishing program that
makes it easy to create professional publications that can be published on your
desktop printer, at commercial printing services or on the World Wide Web.
Publisher is exceptionally easy to use, providing flexible wizards, color
schemes and a Design Gallery. Workshop
topics include: creating a pre-designed publication; editing your publication;
using layout tools, understanding frames; creating tables; changing the look of
publications; selecting design gallery objects; changing color schemes; adding
pictures; adding shapes; using color; layering objects; printing a publication;
proofing your publication; running a mail merge; preparing for commercial
printing; understanding professional features; publishing a Web-ready
publication; using Web tools; adding Web features; and publishing to the Web.
This workshop was designed for users of Microsoft Word or
Excel who are interested in learning how all the programs included with
Microsoft Office Professional work together.
You will be introduced to the integration features of Microsoft Office
Professional that enable you to share information among Word, Excel, PowerPoint,
Access, and Outlook. Techniques for
combining text, data and graphics will be explored.
Topics to be covered include: copying and linking data, embedding
objects, merging an access table or an Excel worksheet with a Word letter,
creating an Access report from an Excel list, creating a PowerPoint presentation
from a Word outline, and creating a Word handout from a PowerPoint presentation.
You will learn how Office allows you to open documents on the Internet
and easily share information on the World Wide Web using only Office
Professional.
Microsoft PowerPoint is a presentation graphics program
that you can use to create overheads, slides and computer-based multimedia
presentations. Topics include
beginning a presentation; working with Wizards; getting help; working with slide
layouts; rearranging slides using Slide Sorter View; understanding and using
design templates; using the Slide Master; inserting clip art, pictures, sound,
and other objects; creating speaker notes; printing audience handouts; running a
manual and automatic slide show; and adding transitions and animation.
Microsoft Outlook is a desktop information management
program that you can use to manage meetings, to-do lists, contacts, and
appointments. Outlook is an
exciting new application because it integrates capabilities that previously
existed in separate programs. Outlook
includes features that work together with Microsoft Excel, Access, and Word.
This workshop covers the following topics:
sending mail; managing to-do lists; scheduling meetings, events, and
appointments; creating contact lists; maintaining task lists; and tracking
activities.
This workshop is designed to
provide the essential information for using Microsoft Windows to its fullest.
You will learn the basics of how to work with and understand the Windows
interface. Techniques for
managing files are covered. Leave
with an understanding of hardware-support features such as Plug and Play. Find out about networking and Internet features.
Topics include: using the contents, index, and search features in the
online help system; creating, using, renaming, and deleting a shortcut; using My
Computer and the Windows Explorer to manage files, techniques for selecting
files; copying, moving, renaming, and deleting files; and using the Recycle Bin.
Database, List Processing, Mail Merge: Developing a
Contact Database
Did you know you could use Word, Excel, Access or Outlook
to keep track of contact databases? This
workshop covers the basic concepts necessary to decide which of these software
packages is best suited to your needs. Learn
how Word’s mail merge program can be used to print envelopes, labels, letters,
lists or reports. Find out how to
use an Excel worksheet as the data source for a Word mail merge.
Examine how records in Outlook can be used as a data source for a Word
mail merge. Learn the difference
between a “flat” and “relational” database.
Develop an understanding of when to use a relational database.
Experiment with using Access for relational database applications and
reports generation.
Web Publishing with Microsoft FrontPage
This workshop will show you how easy it is to use Microsoft
FrontPage to get a new Web site up and running. You will learn how to use the FrontPage Explorer to create a
multiple-page Web site with graphics and navigation bars. You will also
learn how to edit the pages by adding text, images, formatted lists, and
hyperlinks using the FrontPage Editor. Topics
include: inserting files on pages; making image maps from pictures; adding
tables; inserting a list; adding a scrolling marquee using the FrontPage Editor;
testing your hyperlinks; checking spelling across all Web pages; finding and
replacing text on pages; viewing and completing Web tasks; and publishing your
FrontPage Web on the World Wide Web.
|
