If you need training on a specific software program that you do not see here, or our schedule doesn’t fit yours, contact us and we will try to accommodate your needs.

Click Here And Join Our FREE "Technotes" Email Mailing List

Access– Level One (Full Day)

Back to Top

Please note that Microsoft Access is a very powerful and complex application. These classes will give you a solid start on creating basic databases, but you may need further training to become truly proficient.

Performance-based Objectives

Upon successful completion of this course, students will be able to:

Examine the Microsoft® Office Access 2003 database application.
Manage the data in a database.
Examine existing table relationships.
Query the database.
Design simple forms.
Create and modify Access reports.

Course Content

An Overview of Access 2003

Understand Relational Databases
Examine the Access Environment
Open the Database Environment
Examine an Access Table

Managing Data

Examine an Access Form
Add and Delete Records
Sort Records
Display Recordsets
Update Records
Run a Report

Establishing Table Relationships

Identify Table Relationships
Identify Primary and Foreign Keys in the Relationships Window
Work with Subdatasheets

Querying the Database

Create a Select Query
Add Criteria to a Query
Add a Calculated Field to a Query
Perform a Calculation on a Record Grouping

Designing Forms

Examine Form Design Guidelines
Create a Form Using AutoForm
Create a Form Using the Form Wizard
Modify the Design of a Form

Producing Reports

Create an AutoReport
Create a Report by Using the Wizard
Examine a Report in Design View
Add a Calculated Field to a Report
Modify the Format Properties of a Control
AutoFormat a Report
Adjust the Width of a Report

Access– Level Two (Full Day)

Back to Top

(Prerequisites: Access Level One or equivalent experience.)

Let’s move on and explore Access further!

Course content

Principles of table design

Normalizing data
Normalizing data for fourth and fifth normal forms

Principles of table relationships

Analyzing table relationships
Establishing and testing referential integrity

Table design techniques

Data validation techniques
Indexing techniques

Designing select queries

Using calculated fields in queries
Creating multiple-table queries

Customizing form designs

Customizing the form design
Performing calculations on a form
Adding combo boxes to a form
Adding unbound controls

Working with data access pages

Creating data access pages

Customizing reports

Customizing a report created by the Report Wizard
Working with subreports

Access– Level Three (Full Day)

Back to Top

This one day course provides an overview of several advanced skills that are important to customizing and maintaining Access databases. The course shows how to take a simple existing database and customize it so that it is easier to use, can return more useful data, and is integrated with other applications and the Web. To start, students will be shown how to customize field properties to aid data entry, as well as how to establish different types of relationships between tables. Later, the course shows how to work with queries, forms, reports, and data access pages to make them more advanced. Students will also learn how to apply basic security measures to protect database data, as well as how to use Access tools to make database files more flexible and efficient.

Prerequisites: Microsoft Access Level Two

Course content

Parameter and action queries

Creating parameter queries
Creating action queries

Query joins and crosstab queries

Joining tables and working with join properties
Creating crosstab queries
Editing limitations in query datasheets

Using advanced form techniques

Organizing field placement
Using functions to control data entry
Adding an option group to a form
Using a form as the user interface
Creating a form that contains a subform

Creating basic macros to automate forms

Macro basics
Attaching a macro to a command button
Revising a macro
Attaching a macro to an event in a form

Using macros to provide user interaction and automate tasks

Using a macro to provide user interaction
Using macros to automate data entry
AutoKeys and AutoExec macros

Using advanced report techniques

Customizing the appearance and functionality of a report
Mailing and other types of labels

Access 2000 and the Internet

Using hyperlinks
Access tools for working on the Internet

Excel - Level One (Full Day)

Back to Top

We strongly recommend that all clients interested in Excel start with this class. It is so important to really understand cell referencing in order to make spreadsheets work for you and not the other way around!

Course Description

You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft® Office Excel 2003 to manage, edit, and print data.

Course Objective: You will create and edit basic Microsoft® Office Excel 2003 worksheets and workbooks.

Target Student: This course is designed for persons preparing for certification as a Microsoft® Office Specialist in Excel, who already have knowledge of the Microsoft® Office Windows 98 (or above) operating system, and who desire to gain the skills necessary to create, edit, format, and print basic Microsoft® Excel 2003 worksheets.

Prerequisites: To ensure your success, we recommend you first take the following Element K course or have equivalent knowledge:

Microsoft Office Windows XP: Introduction

If you have taken an introductory course for an earlier version of the Windows operating system, this will also meet the prerequisite.

Delivery Method: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Certification

This course is one of a series of Element K courseware titles that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Office Specialist certification.

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

create a basic worksheet.
modify a worksheet.
perform calculations.
format a worksheet.
develop a workbook.
print the contents of a workbook.
customize the layout of the Excel window.

Course Content

Getting Started with Excel

An Overview of Excel
Navigate in Excel
Select Data
Enter Data
Save a Workbook
Obtain Help

Modifying a Worksheet

Move and Copy Data Between Cells
Fill Cells with Series of Data
Edit Cell Data
Insert and Delete Cells, Columns, and Rows
Find, Replace, and Go To Cell Data
Spell Check a Worksheet

Performing Calculations

Create Basic Formulas
Calculate with Functions
Copy Formulas and Functions
Create an Absolute Reference

Formatting a Worksheet

Change Font Size and Type
Add Borders and Color to Cells
Change Column Width and Row Height
Merge Cells
Apply Number Formats
Create a Custom Number Format
Align Cell Contents
Find and Replace Formats
Apply an AutoFormat
Apply Styles

Developing a Workbook

Format Worksheet Tabs
Reposition Worksheets in a Workbook
Insert and Delete Worksheets
Copy and Paste Worksheets
Copy a Workbook

Printing Workbook Contents

Set a Print Title
Create a Header and a Footer
Set Page Margins
Change Page Orientation
Insert and Remove Page Breaks
Print a Range

Customizing Layout

Split a Worksheet
Arrange Worksheets
Freeze and Unfreeze Rows and Columns
Hide and Unhide Worksheets

Excel - Level Two (Full Day)

Back to Top

Course Description

In Microsoft® Office Excel 2003: Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft® Excel 2003 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.

Course Objective: You will apply visual elements and advanced formulas to a worksheet to display data in various formats.

Target Student: The target students for this course are students who desire to gain the skills necessary to create templates, sort and filter data, import and export data, analyze data, and work with Excel on the Web. In addition, this course helps prepare students who desire to prepare for the Microsoft Office Specialist exam in Excel or Module 2 and who already have knowledge of the basics of Excel, including how to create, edit, format, and print basic worksheets.

Prerequisites: To ensure your success, we recommend that you have experience with creating, editing, formatting, saving, and printing basic spreadsheets in Microsoft® Excel 2003. Students can obtain this level of skill by taking the following Element K course:

Microsoft Excel 2003: Level 1

In addition, Web browsing experience is strongly recommended.

Delivery Method: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Certification

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

create and apply templates.
create and modify charts.
work with graphic objects.
calculate with advanced formulas.
sort and filter data.
use Excel with the Web.

Course Content

Creating and Applying Templates

Create a Workbook from a Template
Create a Custom Template
Working with Comments
Create a Hyperlink
Use Web-based Research Tools

Creating and Modifying Charts

Create a Chart
Format Chart Items
Change the Chart Type
Create a Diagram

Working with Graphic Objects

Insert Graphics
Create AutoShapes
Format Graphic Objects
Change the Order of Graphic Objects
Group Graphic Objects
Move, Copy, and Resize Graphic Objects

Calculating with Advanced Formulas

Create and Apply a Name for a Range of Cells
Calculate Across Worksheets
Calculate with Date and Time Functions
Calculate with Financial Functions
Calculate with Statistical Functions
Calculate with Lookup and Reference Functions
Calculate with Logical Functions

Sorting and Filtering Data

Sort Data Lists
Filter Data Lists
Create and Apply Advanced Filters
Calculate with Database Functions
Add Subtotals to a Worksheet

Using Excel with the Web

Export Excel Data
Publish a Worksheet to the Web
Import Data from the Web
Create a Web Query

Excel - Level Three (Full Day)

Back to Top

Course Description

You have used Microsoft® Office Excel 2003 to perform tasks such as running calculations on data and sorting and filtering numeric data. You would now like to automate some common tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications. In this course, you will do all of these things.

Course Objective: You will automate some common Excel tasks, apply advanced analysis techniques to more complex data sets, collaborate on worksheets with others, and share Excel data with other applications.

Target Student: This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create PivotTables and PivotCharts, incorporate multiple data sources, and import and export data. In addition, the course is also for students desiring to prepare for the Microsoft Office Specialist exam in Excel 2003 or Module 2-Key Applications of the Internet and Computing Core Certification (IC3) exam, and who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.

Prerequisites: To ensure your success, we recommend you first take the following Element K courses or have equivalent knowledge:

Microsoft® Office Excel 2003: Level 1
Microsoft® Office Excel 2003: Level 2

Delivery Method: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Performance-based Objectives

Upon successful completion of this course, students will be able to:

Customize workbooks.
Collaborate with others using workbooks.
Audit worksheets.
Analyze data.
Work with multiple workbooks.
Import and export data.
Structure workbooks with XML.

Streamlining Workflow

Create a Macro
Edit a Macro
Customize Access to Excel Commands
Apply Conditional Formatting
Add Data Validation Criteria
Update a Workbook's Properties
Modify Excel's Default Settings

Collaborating with Others

Protect Files
Share a Workbook
Set Revision Tracking
Review Tracked Revisions
Merge Workbooks
Adjust Macro Settings
Administer Digital Signatures

Auditing Worksheets

Trace Cell Precedents
Trace Cell Dependents
Locate Errors in Formulas
Locate Invalid Data and Formulas
Watch and Evaluate Formulas
Group and Outline Data

Analyzing Data

Create a Trendline
Create Scenarios
Perform What-If Analysis
Perform Statistical Analysis with the Analysis ToolPak

Working with Multiple Workbooks

Create a Workspace
Consolidate Data
Link Cells in Different Workbooks
Edit Links

Importing and Exporting Data

Export to Microsoft Word
Import a Word Table
Import Text Files

Structuring XML Workbooks

Develop XML Maps
Import, Add, and Export XML Data
Manage XML Workbooks
Apply XML View Options

Excel Busters (Half Day)

Back to Top

This class is designed to learn methods that help you quickly get your work done with this powerful and versatile program. With a good understanding of formula syntax, AutoFill, format painter and database features, you will be able to use some of Excel’s great tools.

It’s been our experience that people who have used Excel for many years are not using it near its full potential. To become a true Excel user we recommend further training in Excel. We offer seven classes in Excel instruction. Call us at 651-291-4540 for more information on Excel training.

This class is designed for the student with beginning to intermediate skill level in Microsoft Excel and wants to improve their skill level with this wonderful application in a timely manner.

Use the “Hidden Quick Answers” Tool
Using AutoFill
Proper Formula syntax
Inserting Comments
Format Painter
Formatting your financial work sheet according to Generally Accepted Accounting Practices (G.A.A.P.)
Using lists and other database features in Excel
Freeze and unfreeze rows and columns and learn how to do both at the same time!

Outlook – Introductory (Full Day)

Back to Top

Microsoft Outlook allows you to do much more than just read your email. There are simple and powerful contact management and scheduling features that will help you get organized and be on time!You will also learn how to manage and safeguard your information.

Understanding Outlook
Working with the Outlook Bar
Working with E-mail
Creating messages
Receiving, replying, forwarding and recalling messages
Working with attachments
Using mail management tools
Sorting mail messages
Managing junk mail messages
Filtering and formatting a view

Working with Contacts
Creating Contacts
Using Contacts with E-mail
Managing time with Calendar
Printing Calendars
Using “Tasks”
Using “Notes”

Outlook – Intermediate (Full Day)

Back to Top

Preparing E-mail messages
Understanding stationery and themes
Create and format signatures
Using address books
Using other mail features
Flag messages
Find messages
Set message importance options

Organizing and sorting Contacts
Understanding categories
Using the Calendar to schedule events
Using Calendar coloring
Post Web Calendars
Exploring Contacts and the Journal
Record activities with the Journal
View Contact activities

Time Management Using Outlook

Back to Top

This course will cover items for Time Management Using Outlook. You will learn how to manage and track your time, identify priorities, set goals, and much more.

Topics covered in this class:

Getting started
Examining the projects
Examining perceptions of time
Choosing the tools
Stopping time wasters
Recording activities
Analyzing time
Managing stress
Organizing your inbox
Working efficiently
Staying organized
Tracking time with the Journal

Publisher Introductory (Full Day)

Back to Top

Learn to use the various components of Microsoft Publisher. Once you have a complete understanding of the basic features, you can begin to design your own publications.

Overview of features – object-oriented documents
Working with layout guides
Working with text frames
Enhancing text
Formatting objects and frames
Drawing and filling shapes
Changing borders
Rotating and moving objects
Working with pictures
Layering objects
Grouping objects
Laying out a flyer
Changing page layout
Creating vertical headlines
Copying and modifying text
Importing text files
Changing frame margins
Using the “Format Painter”
Working with graphics
Working with text wrap
Drawing tools
Creating tables
Entering text into a table
Working with rows and columns
Merging cells
Adding gridlines
WordArt
Using graphics
Design concepts and using the Design Gallery

Microsoft PowerPoint – Introductory (Full Day)

Back to Top

This presentation software aids the presenter in developing organized and professional-looking overhead transparencies, presentations for on-screen display, handouts for participants, and speaker notes. With the use of a video projector and laptop computer, you are ready to take your show on the road!

Develop your presentation within the outline feature of PowerPoint or import your text from a Word file. Learn to use the professionally- designed templates and other features to customize your presentation. Once the text for your presentation is prepared and ready to go, learn how to add the “wow” to your presentation. Learn to use the Slide Sorter to organize and add special effects and transitions.

Exploring PowerPoint
Creating presentations
Navigating through presentations
Understanding slide types
Modifying existing presentations
Using number lists and bullets
Creating PowerPoint tables
Working with “The Slide Master”
Understanding “Title” and “Slide Masters”
Incorporation of visual elements
Creating basic shapes
Changing object colors
Reorganizing slides and text
Rearranging, adding and deleting slides in slide sorter view
Editing a presentation
Viewing and presenting the slide show
Using on-screen navigation tools

Microsoft PowerPoint – Intermediate (Full Day)

Back to Top

Setting PowerPoint Options
Combining and modifying presentations
Import outlines from Word
Use “Slide Finder” to insert slides
Replace fonts for all slides
Use “Format Painter” to format text
Use multiple “Slide Masters”
Insert Clip Art on “Slide Master”
Working with WordArt and AutoShapes
Customizing Clip Art
Import Clip Art
Crop pictures
Apply animation effects
Apply animation effects to WordArt
Add animation effects to text and graphics
Preparing presentation for delivery
Hide and show slides
Explore speaker notes and handouts
Design and format audience Handouts
Using PowerPoint on the Web
Understanding PowerPoint hyperlinks
Insert hyperlinks
Publish and save presentations as Web pages

Microsoft PowerPoint – Advanced

Back to Top

Customizing Toolbars
Create new Toolbars
Create custom color schemes
Understanding Tabs
Import Word Tables and Excel Charts
Add video and sound clips
Add animated GIF’s
Export Outlines to Word
Working with Excel Charts and Tables
Organizational Charts
Apply advanced visual effects
Set and view animation timings
Create action buttons
Customizing presentations
Setting up presentations for delivery
Set rehearsal timing
Run Pack and Go presentations
Collaborating presentations
Set-up review cycles
Send presentations via E-mail
Set-up and schedule online broadcasts

Introduction to Computers, Introductory
Fundamental Features and Tools (Half Day)

Back to Top

Microsoft Windows is the most widely used operating system and can be very confusing to newcomers. Learn the basics of using this powerful system. Even if you are currently using Windows, you can benefit from the basics taught in this class.

Understand Microsoft Windows Operating System
Using all three parts of the Mouse
Primary Mouse Key
The Right Click
The Scroll Wheel
Overview of the Keyboard
Using the Ctrl and Alt Keys
Working with the “The Desktop”
Terminology
Explore the Start Menu
Navigate Toolbars
Understand Window Controls with Microsoft Word
Explore Menus
Examine the Taskbar
Manipulate Windows with The Taskbar
Using “Save” and “Save As”
Basic File Management

Introduction to Computers, Level 2
File Management (Half Day)

Back to Top

The minute you start to create documents, you start a filing system. It is one thing to create documents, yet another to be able to organize and find them! Learn how to use Windows folders to your advantage.

Managing Files And Folders
Examine The Files System
Create Folders
Change Folder Names
Understand Search Companion
Use Search Companion
Move Files To Folders
Copy Files To Folders
Understand Shortcuts
Create Shortcuts
Understand The Recycle Bin
Delete Files And Folders
Empty The Recycle Bin
Examine Accessories, e.g., the Calculator
Scroll and Zoom in Documents
Copy And Paste Text
Proper Shut down of a P.C.

10 Great Tips to Maintain Your Computer (Half Day)

Back to Top

In this class we look at ways to maintain your P.C. and keep it running at optimal performance.

Running a “P.C. Audit” to quickly discover exactly what you have
Backing-up Data
Looking at Anti-Virus and Firewall Software
R.A.M. vs. R.O.M.
Keeping your programs updated
Using the “Defragmenter”
And other additional tips to maintain your P.C. and its files!

Microsoft Word - Introductory (Full Day)

Back to Top

Learn the basics of Microsoft Word. This powerful word-processing application is easy to use and fun to learn!

Getting acquainted with Microsoft Word
Examining the working screen
Navigate documents
Working with text
Selecting techniques
Examine Cut, Copy and Paste
Understand Smart Tags
Formatting text
Aligning text
Add shading
Insert bullets
Apply automatic numbering
Working with Headers and Footers
Being your own Editor
Use Find And Replace effectively
Understanding the Spelling and Grammar Features
Use the Thesaurus
Using “Undo” and “Redo”
Managing your documents
Create folders
Understanding “Save As”
Printing documents

Microsoft Word - Intermediate (Full Day)

Back to Top

Working with paragraphs
Set left and right indents
Add hanging and first line indents
Understanding tab stops
Working with sections
Change margins
Experiment with page orientation
Insert page breaks
Insert newspaper-style columns
Insert symbols
Add watermarks
Insert graphics
Use the drawing toolbar
Understand and insert a table
Format tables
Create charts