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

Product(s): Microsoft Excel 2007
Audience(s): Business Professional.
Date(s): Tuesday, September 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!

To Register: Click Here. Fee: $99.00

Tell Your Story Visually with Eye Catching Charts in Microsoft Excel 2007

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

Event Overview:
Almost everyone has seen or worked with a chart at one time or another–charts illustrate data, relationships, or trends, graphically. Like the saying “a picture is worth a thousand words” charts are often a better tool for presenting information than hard-to-read numbers. This Webinar covers just about everything there is to know about charts. The dazzling charts you will be able to create after you finish this course will impress both you and your colleagues.

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

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

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

Product(s): Excel 2007.
Audience(s): Business Professional.
Date(s): Wednesday, December 2, 2009, 11:00AM (EDT) 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!

To register: Click here.  Fee: $79.00

Mastering Excel – Advanced Formulas and Functions

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

Event Overview:
Excel has well over 300 functions – surely you don’t need to know them all, but you might easily be overlooking significant analytical tools that give you tremendous capabilities to tackle a myriad of statistical, mathematical, and financial challenges.

This 60 minutes webinar gives you exposure to those “buried” functions and gives you new and powerful tools, such as array formulas, that will make your usage of Excel even more powerful and efficient.

Also included are some of those valuable formula and function tips that you may have picked up in the Excel Power Tips and Shortcuts webinar – quick formula copying methods, creative use of Ctrl to create formulas in multiple locations simultaneously, and a host of others.

Specific functions that will be covered include: IF, AND, OR, MATCH, INDEX, , FREQUENCY, TREND, GROWTH, TRANSPOSE,  PROPER, UPPER, TRIM, LEFT, RIGHT, INDIRECT, OFFSET, MOD, WEEKDAY, NETWORKDAYS, and DATEDIF.

Power Tips
* Quick cell value changes without formulas
* Displaying Formulas and selecting formula cells
* Multiple cell formulas with the Ctrl key
* Debugging tools and 3-D formulas

Power Functions
* Extended uses of the IF and VLOOKUP Functions using AND, OR, NOT
* MATCH and INDEX functions for complex 2-way lookups

Array Formulas
* Simple applications
* Counting unique entries in a range
* Condense long IF functions substantially
* MATCH and VLOOKUP array formulas

Special Array Functions
* FREQUENCY
* TEND and GROWTH
* TRANSPOSE

COUNTIF, SUMIF, AVERAGEIF and new 2007 functions

Specialized Text Functions
* PROPER, UPPER
* TRIM, LEFT, RIGHT
* Concatenation without CONCATENATE

The INDIRECT Function
* Used with Data Validation for multi-layered pick list scenario

The OFFSET  and MOD Functions

Date Functions
* WEEKDAY – extract day of the week
* NETWORKDAYS – Calculate working days in a time frame
* DATEDIF – Excel’s powerful (but undocumented) date calculator

To Register: Click Here.    Fee: $99.00

Microsoft Excel Power Tips and Shortcuts

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

Event Overview:

Proficient users in Excel can still discover new features and tools to accomplish more each day. In this 60-minute webinar, Excel expert Dennis Taylor will demonstrate numerous little-known features, and shortcuts that will save you time in your busy day. These must have Excel Skills for today’s highly effective worker will help you stay more organized and on task with Excel. You will learn new shortcuts that will impress even the most experienced Excel users. This webinar will give you tips on mastering formats, commands, functions and formulas. You will learn new ways to make your spreadsheets communicate your message and look professional. You will feel more confident with how to develop clean presentations and you will learn navigation tips so you can effortlessly move through worksheets & workbooks. Join us to discover these essential Excel tips and techniques that will save you time, which will save you money.

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.

Tell Your Story Visually with Eye-Catching Charts in Microsoft Excel 2007

Date: Wednesday, September 23, 2009
Time: 1:00PM (EST) U.S.
Duration: 60 minutes  

Description: Almost everyone has seen or worked with a chart at one time or another–charts illustrate data, relationships, or trends, graphically. Like the saying “a picture is worth a thousand words” charts are often a better tool for presenting information than hard-to-read numbers. This Webinar covers just about everything there is to know about charts. The dazzling charts you will be able to create after you finish this course will impress both you and your colleagues.

Click here to register.  Fee: $79.00.