Excel Database Tools

Product(s): Microsoft Excel 2007
Audience(s): Business Professional.
Date(s): Friday, January 15, 2010, 1:00PM (EST) U.S.
Duration: 60 Minutes

Event Overview:

Although Excel is not typically described as database software, many Excel users maintain large lists of data and they need the tools to manage that data efficiently. This session focuses Excel’s many powerful and easy-to-use database commands and methods critical to anyone who main-tains an Excel database. This session explores many of Excel’s techniques needed to modify, build, and manage an Excel database, including: validating data, using Excel’s Form feature, sorting, adding subtotals, filtering, and advanced filter.

Note: This session will use Excel 2007 as the primary platform for demonstrating these features, but will note the differences from Excel 2003 and will show some features in that version as well.

Topics include:

Data Validation – prevent bad data entry – keep out bad data before it ever gets into a data-base
* Restrict cell content by forcing users to pick entries from a pick list
* Restrict cell content by value, text, or data/time
* Restrict cell content by formula
* Use auditing tools to check the validity of existing data
Sorting
* Use multiple-key sorts from the menu or from button commands
* Sort based on re-arranging rows or re-arranging columns
* Sort based on cell colors or in random order
* Sort data based on customized lists
Creating automatic subtotals with the Subtotals command
* Set up single and multiple-level subtotals
* Expand and collapse displays quickly with grouping and outlining symbols
Data Form – Build and maintain a database with the Form feature
Using the powerful Filter command to view just the data you want to see
* Set up filtering to see and print a subset of data
* Create compound selection criteria for filtering data
* Use Excel 2007 greatly expanded special filtering tools for Text, Number, and Date fields
* Use the Advanced filter for extended filtering needs

About the Presenter: Dennis Taylor is the author of “Teach Yourself Microsoft Excel 2000” and co-author of four other books on spreadsheet software. Dennis has developed and presented specialized Excel courses (Tips and Tricks, Database Features, Advanced Formulas and Functions) to numerous clients over the past 12 years. Dennis has over 20 years of training and consulting experience. As a former employee of Amoco Oil, IBM, Lexmark, Texaco, Levi Strauss, StorageTek, the Federal Government, and the University of Colorado, he has taught over 3,000 seminars and classes attended by over 15,000 students.

To Register: Click Here.  Fee: $99.00

Creating Your First Budget Using Excel 2007

Product(s): Microsoft Excel 2007
Audience(s): Business Professional.
Date(s): Tuesday, January 5, 2010, 11:00AM (EST) U.S.
Duration: 60 Minutes

Event Overview:

Are you wondering where your money is going? Let Excel help you stay on track by creating a budget. Whether it is for home or work Excel has the right tools to keep you on budget. A budget helps you compare your income with your expenses and plan for long range financial goals.

Topics covered include track your income and expenses, create a spreadsheet, build formulas, and test your new budget.
* Budget Overview
* Setup of worksheet
* Build Formulas
* Test Budget

About the Presenter: With 8+ years of experience teaching the Microsoft Office Suite, David Thibault, Director of Education for KnowledgeWave Training in South Burlington, VT uses his upbeat, high energy teaching style in the classroom and online.  David has led corporate implementations of new software and written courseware for all applications in the Office Suite and 3rd party software.  He continues to specialize in classroom instruction as well as delivers corporate and open enrollment webinars.  His years in the field managing consulting projects have ranged from rollouts to upgrades and mentoring services, giving him the “real-world” knowledge that brings so much value to his classroom and online lessons.

To Register: Click Here.  Fee: $99.00

Microsoft Office Visio- Your Computer’s Very Own Multi-Tool

Product(s): Microsoft Visio
Audience(s): Business Professional.
Date(s): Friday, January 8, 2010, 1:00PM (EST) U.S.
Duration: 30 Minutes

Event Overview:

Do you need to create a flow chart? Visio can help. Do you need to create a map to an event? Visio can help. Do you need to create an organization chart? Visio can help. Do you need to create a new office floor plan? I think you get the idea. Visio is a powerful design tool that provides companies with the ability to express multiple business functions with graphical charts and diagrams.

* Application Overview
* Discuss the Visio Functions
* Where do I start?

To Register: Click Here.  To Fee: $0.00

First View of Windows 7: Change is Good!

Product(s): Microsoft Windows 7
Audience(s): Business Professional.
Date(s): Tuesday, January 5, 2010, 3:00PM (EST) U.S.
Duration: 60 Minutes

Event Overview:

Windows 7 is new from the ground up. In this session we will uncover many of the new features that distinguish this version of Microsoft’s operating System from its predecessors. Windows 7 offers new features to view and organize open windows, search for files and programs and even control the number of notifications we see. We’ll demonstrate all this and much more as we reveal the workings of this eagerly awaited upgrade. Whether you’re already using Windows 7 or planning on making the switch, let us guide you on your way.

* Windows Search
* Aero Peek, Snap and Shake
* Notification Control
* Improved Task Bar
* Internet Explorer 8 Web Slices
* User controls

To Register: Click Here.   Fee: $99.00

Adding Shadows in PowerPoint 2007

PowerPoint lets you add shadows to all sorts of objects, including AutoShapes, text, and pictures. Follow these steps to add a shadow to any object:
1) Select the object.
2) Click the Shadow Style button Button imageon the Drawing toolbar to open the Shadow submenu.
* Tip: If you can’t see the Drawing toolbar, on the View menu, point to Toolbars and then click Drawing to make it visible.
3) Choose any of the shadow styles on this menu.
* If you don’t find the exact style you need, click Shadow Settings to spawn a toolbar of the same name.
* Tip: If you want to remove a shadow from an existing object, click No Shadow on the submenu.

Get the Crystal Reports instruction you need now!  KnowledgeWave is pleased to offer two levels of Crystal Reports – each in a 60-minute Webinar that gets right to the point!  See below for complete details and register today!

Getting Started with Crystal Reports

Product(s): Crystal Reports
Audience(s): Business Professional.
Date(s): Thursday, January 7, 2010, 11:00AM (EST) U.S.
Duration: 60 Minutes

Event Overview:

Crystal Reports is a powerful tool for analyzing information. It allows you to design and generate reports from a wide range of data sources with the goal of examining your data in an organized, meaningful way. This Webinar assumes that you have no previous experience with Crystal Reports. You will be introduced to basic database reporting, formatting, as well as grouping & sorting, and much more. “Designing a Basic Report” is your first step on the way to using Crystal Reports to it’s full potential.
What you will learn:
* Crystal Reports Overview
* The Work Area
* Basic Formatting
* Basic Grouping & Sorting
* Summary Functions
* Inserting Objects into Reports
* Previewing & Exporting Reports

To Register: Click Here.   Fee: $119.00

Create a Report Beyond the Basics

Product(s): Crystal Reports
Audience(s): Business Professional.
Date(s): Thursday, January 7, 2010, 3:00PM (EST) U.S.
Duration: 60 Minutes

Event Overview:

Now that you know the basics, it’s time to get into the nitty gritty of reporting. In this 60-minute Webinar you will be introduced to the Report Wizard, custom grouping, fields, and other more advanced features of this dynamic reporting tool.
What you will learn:
* Report Wizard – Multiple Tables
* Grouping Expert
* Create Custom Grouping
* Fields – Dimensions vs. Metrics
* Select Expert
* Export Options

To Register: Click Here.  Fee: $119.00

Microsoft Excel – Cleaning up Excel Data

Product(s): Microsoft Office Excel (all versions).
Audience(s): Business Professional.
Date(s): Friday, December 18, 2009, 1:00PM (EDT) U.S.
Duration: 60 Minutes

Event Overview:

These days, Excel users are doing less data entry and a lot more downloading data from other sources. Whether that data is coming from Access, some other data base software, or a poorly designed Excel worksheet, it isn’t always in the best of shape.
Excel has a variety of functions, commands, and techniques that let you quickly re-structure data, remove unwanted characters, get rid of empty cells, rows, and columns, and prepare data for efficient analysis. This webinar will use Excel 2007, but will demonstrate techniques in Excel 2003 for those features that have been altered.

What you will learn:

The Text to Columns command
* A powerful, yet simple command sequence that lets you quickly split data (improperly grouped into one column) into multiple columns; includes techniques for handling Julian dates another unusual groupings.

How to transpose data
* a simple copy technique to convert data from a row/column into a column/row layout.
How to remove duplicate data
* Use either Excel’s new 2007 command (Remove Duplicates) or the Advanced Filter in Excel 2003 to eliminate duplicate records.

The Find/Replace command sequence, including using special wild cards.

Critical Text functions
* (LEFT, RIGHT, and MID) for character extraction; REPLACE and SUBSTITUTE for character swapping; CLEAN and TRIM functions to remove unwanted characters; PROPER and UPPER for quick uppercase/lowercase conversion.

Concatenation techniques for pulling together data from different locations

Sorting techniques to eliminate blank rows or columns from data

Techniques for learning how to:
* Convert text data to values
* Remove trailing minus signs while converting data into negative values
* Fill in missing title data from columns containing first entries only
* Alter any kind of date data into a more useful computational form

To Register: Click Here.  Fee: $99.00

Microsoft Office Excel: Clear a PivotTable report or PivotChart report

To remove all report filters, labels, values, and formatting from a PivotTable report, and to start designing the layout all over again, use the Clear All command. This command effectively resets the PivotTable report, but it does not delete it. The data connection, placement of the PivotTable report, and PivotTable cache remain. If there is a PivotChart associated with the PivotTable report, the Clear All command also removes related PivotChart fields, chart customizations, and formatting.

Caution: If you are sharing a data connection or if you are using the same data between two or more PivotTable reports, then using the Clear All command on one PivotTable could also remove the grouping, calculated fields or items, and custom items in the other shared PivotTable reports. However, you are warned before Microsoft Office Excel attempts to remove items in the other shared PivotTable reports, and you can cancel the operation.

PivotTable report

1. Click the PivotTable report.
2. On the Options tab, in the Actions group, click Clear, and then click Clear All.

PivotChart report

1. Click the PivotChart report.
2. On the Analyze tab, in the Data group, click Clear, and then click Clear All.

Note: The Clear All command is not visible when the worksheet that contains the PivotTable report is protected. The Clear All command does not work if you protect the worksheet and then select the Use PivotTable Reports check box in the Protect Sheet dialog box because the Clear All command requires a refresh operation.

Look at Your Data in a Whole New Way with PivotTables in Microsoft Excel 2007

Product(s): Microsoft Office Excel 2007.
Audience(s): Business Professional.
Date(s): Wednesday, December 16, 2009, 11:00AM (EDT) U.S.
Duration: 60 Minutes  

Event Overview:

Grab a comfortable seat and we’ll walk you through a one-hour Webinar on the basics of creating PivotTables. Find out what PivotTables are, how they work and how to create your own. Wondering how to change your PivotTable field settings? How to understand the lingo used in PivotTable reports? We’ll cover all that, too, in one mind-expanding hour. The next time you need to see comparisons, reveal patterns or analyze trends, you’ll know exactly what to do.

To Register: Click Here.  Fee: $79.00

Adobe Flash CS4: Take Two! Going Beyond the Basics

Product(s): Adobe Flash CS4.
Audience(s): Business Professional.
Date(s): Thursday, December 10, 2009, 1:00PM (EDT) U.S.
Duration: 60 Minutes  

Event Overview:

Know the basics in Flash already? Need to go more in-depth with animation? How about adding audio to your movies? It’s time to use some of the advanced functionality of Adobe Flash CS4. It is a powerful tool used predominantly on the web. Getting a handle on it may just be easier than you think! Learn how to design and develop more complex Flash projects in this 60-minute Webinar.

This webinar covers the following Flash topics:

* Adding Motion to Flash Animations
* Applying 3-D Transformation to Objects
* Applying Effects to Objects
* Importing Audio
* Controlling Audio

To register: Click Here.  Fee: $89