Unlock the Power and Potential of Formulas and Functions in Microsoft Excel 2007

Product(s): Microsoft Excel 2007
Audience(s): Business Professional.
Date(s): Wednesday, June 23 2010, 3:00PM (EST) U.S.
Duration: 60 Minutes 

Event Overview:
Don’t spend another day manually filtering information from your spreadsheets in order to find the answers to your most pertinent business questions. Utilize the built-in formulas that Excel has to offer and get accurate results in a snap! This Webinar focuses on how to work with formulas and functions in Excel worksheets. Formulas are equations that perform calculations on values in your Excel worksheet. Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. Functions can be used to perform simple or complex calculations.

Learn formulas that will help you with specific business tasks, such as:

* Calculating loan repayment
* Creating amortization tables
* Identifying the potential future value of investments
* Using Excel’s discounting functions to analyze cash flow values and rates of return

To Register: Click Here. Fee: $99.00

Save Time, Work Less: The Power of Using Macros to Complete Repetitive Tasks in Microsoft Excel 2007

Product(s): Microsoft Office Excel 2007
Audience(s): Business Professional.
Date(s): Wednesday, April 21, 2010, 3:00PM (EST) U.S.
Duration: 60 Minutes

Event Overview:
Do you wish you could find a way to increase your accuracy in data manipulation and get it all done faster? These days, it seems there’s more to do and less time in which to do it, so it’s crucial to find ways to automate your every day tasks. Efficiency will help eliminate your daily grind. With so much information on your hands, it can be painstaking and time-consuming to sift through data and manipulate it to present exactly what you’re looking for.

Macros are one of Microsoft Excel’s most powerful, yet most underused, tools. Many users are familiar with the term but have never learned how to take advantage of all macros have to offer. They might sound complicated; within this one hour Webinar we will show you how to become a more proficient user with automating your tasks. You will be working smarter and faster than ever before!

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 delivering 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

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, April 21, 2010, 1:00PM (EST) 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.

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 delivering 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

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