We are offering some solid webinars for February.  Our Microsoft Excel session will uncover some great features in Excel and is well worth your time.  Furthermore, Log On to Learn members will be able to access the event on our member site after the event runs.  Check it out, come join us and Happy Leap Year.

Event Overview:

Microsoft Excel is a powerful tool that can be used for a variety of functions. In this session we’re going to focus on using Excel as a tool for managing data. By sorting and filtering our data we can begin to dissect data and get useful information. We’ll also look at subtotals, sparklines and a bit of PivotTables. If you have raw data in Excel, let us show you how to get it to speak to you in a usable way.

Date: Thursday, February 16, 2012
Time: 3:00 PM EST (US)
Price:$99$0* (US) No fee register below!

*Use Code: FEB12 at checkout to attend for zero fee.

Product: Microsoft Excel
Duration: 60 Minutes
Date: December 21, 2011Time: 1:00 PM EST (US)
Price: Free, with code LOB10

Our 60 minute Excel Tips and Tricks Webinar will help you eliminate the anxiety
of data analysis and will help you harness the true power of Excel! In this
Webinar, you will uncover incredible data analysis tools that were created
specifically to help you achieve your information goals. Microsoft Excel can
help you sift through data to find the information you need, but the process can
be time-consuming and frustrating. Let us help you achieve your goals, don’t sit
and stare at row upon row of numbers; join us for 60 minutes and we will show
you how to zip through your tasks and turn data drudgery into data done. In this
session you will learn how to create custom AutoFill list, use Auto Calculate,
add pop-up instructions for correctly entering data in a cell, use the format
painter, create time saving macros, and much more!

After one hour with our expert, you’ll be able to:
• Create time-saving macros
• Customize your Excel environment to match what you do
and how you work.
• Organize a spreadsheet so that you can see the data you
need
• Format cell data so that it appears as it should.
• Generate shared spreadsheets that collect data consistently and correctly.
• Achieve amazing results for yourself and your organization!

Click Here To Register Online Today!

Would you like to enhance your Microsoft Excel 2010 skills? If so, join us October 12 at 3:00pm EDT.  If you missed this date our event is now available on-demand.

Product(s): Microsoft Excel 2010
Duration: 60 Minutes
Start Date: (This event is now available on-Demand!)
Previously held Live on October 12th, 2011

Event Overview: This entire session is
centered on a single notion. Excel is a powerhouse. Many of us have only
scratched the surface of its potential. Formulas and Functions are the gateway
to this functionality. Utilize the built-in formulas that Excel has to offer and
get accurate results in a snap! We’ll discuss the difference between a formula
and a function and unlock the power contained in these tools. This session is a
must for moderate to heavy Excel users and those looking to expand their Excel
IQ.

This Free Live Event, is not availabe on-demand. Access this webinar and 1000′s of other related topics for Microsoft Office applications at Log on to Learn. www.logontolearn.com.
Complete access to all of our content is included in the $59 fee.

Brand new to Excel 2010, Sparklines are tiny little charts located in a single cell that provides a visual representation of data.  This allows you to, in most cases, view your data and the chart at the same time. In this session we will show you how to add and remove Sparklines from an Excel worksheet.

Like this tip? Follow us on Facebook, www.facebook.com/knowledgewave for more great tips.

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

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

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.

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

Product(s): Microsoft Office Excel 2007.
Audience(s): Business Professional.
Duration: 56:43 Minutes
Original Run Date: 05/07/2009

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 course 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.

This 60-minute audio/video seminar is available on-demand. Purchase the session for only $99 and gain access to this along with our entire suite of on-demand webinar sessions for
72 hours/3-days from time of purchase.

CLICK HERE to Purchase and Watch On-Demand.

Learn more by visiting www.logontolearn.com.

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): Tuesday, October 6, 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!

Click Here to register.  Fee: $79.00.

OnDemand: 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.
Duration: 56:16 Minutes
Original Run Date: April 15, 2009

Event Overview:
Grab a comfortable seat and we’ll walk you through a one-hour Webcast 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 use PivotTable Wizard? 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.

This 60-minute audio/video seminar is available on-demand. Purchase the session for only $99 and gain access to this along with our entire suite of on-demand webinar sessions for 72 hours/3-days from time of purchase.

CLICK HERE to Purchase and Watch On-Demand.

Learn more by visiting www.logontolearn.com.