Microsoft Excel Webinars
● New Features of Microsoft Excel 2007
● Excel Basics: What's a Spreadsheet and What Can I Do With It
● Planning and Creating Spreadsheets in Microsoft Excel
● Worksheet Management and 3-D Formulas in Microsoft Excel
● Graphics and Printing in Microsoft Excel
● Creating and Using Templates in Microsoft Excel
● Sorting and Filtering Data in Microsoft Excel
● Number-Crunching with Formulas and Functions in Excel
● Showcase your Data Visually with Charts in Microsoft Excel
● Using What If Analysis/Scenario Manager to Plan for the Future
● Make Sense of Your Data with PivotTables
● Reviewing and Sharing in Microsoft Excel
● Automating Repetitive Tasks With Macros in Microsoft Excel
● Using Excel as a Database with Lists
● Track and Analyze your Business Data with Excel
● Advanced PivotTables and PivotCharts
New Features of Excel 2007
Product(s): Microsoft Office Excel.
Audience(s): Business Professional.
Duration: 60 Minutes
Start Date: February 11, 2009 11:00 AM EST
Event Overview:
Get up to speed quickly with Excel’s new user interface. This 60 minute
course is a scaled down version of the 3 hour course (What’s New in
Microsoft Excel: An In-Depth Look). Explore Excel’s new user interface,
new graphic enhancements, formulas, sorting, and templates.
*After adding your webinar to the cart and purchasing, KnowledgeWave will send you your unique registration link to attend the webinar event. All sales are final.
Excel Basics: What's a Spreadsheet and What Can I Do With It
Product(s): Microsoft Office Excel 2007.
Audience(s): Business Professional.
Duration: 60 Minutes
Start Date: January 28, 2009 1:00 PM EST
Event Overview:
This workshop provides Excel 2007 novices with a working understanding
of the Excel environment. Each area of the Excel window will be covered.
In addition, you will learn to edit and save an Excel 2007 workbook at
the end of this workshop.
*After adding your webinar to the cart and purchasing, KnowledgeWave will send you your unique registration link to attend the webinar event. All sales are final.
Planning and Creating Spreadsheets in Microsoft Excel
Product(s): Microsoft Office Excel 2007.
Audience(s): Business Professional.
Duration: 60 Minutes
Start Date:
Event Overview:
A great webinar for newcomers to Excel who have
used spreadsheets created by other users but have not yet created many
of their own. The lessons guide you through the steps
of creating a spreadsheet, from planning through formatting.
*After adding your webinar to the cart and purchasing, KnowledgeWave will send you your unique registration link to attend the webinar event. All sales are final.
Worksheet Management and 3-D Formulas in Microsoft Excel
Product(s): Microsoft Office Excel 2007.
Audience(s): Business Professional.
Duration: 60 Minutes
Start Date:
January 29, 2009 10:00 AM EST
Event Overview:
Worksheets provide a logical and intuitive way to organize your data.
Frequently, multiple worksheets are used to further separate data into
categories such as date or product type. The ability to work with data
in multiple worksheets is a necessary skill for Excel users. This course
covers working with multiple worksheets including the creation of
formulas that reference information from several different worksheets.
It also covers viewing and zoom options and the freeze panes function.
*After adding your webinar to the cart and purchasing, KnowledgeWave will send you your unique registration link to attend the webinar event. All sales are final.
Graphics and Printing in Microsoft Excel
Product(s): Microsoft Office Excel 2007.
Audience(s): Business Professional.
Duration: 60 Minutes
Start Date:
Event Overview:
Excel has long been the geek of the Microsoft Office family. In 2007
Excel got a graphic upgrade. However, Excel is still not a “what you see
is what you get” program. This course examines how to insert and manage
graphics in Excel and covers the printing techniques to achieve the
desired look when it comes out on the page.
*After adding your webinar to the cart and purchasing, KnowledgeWave will send you your unique registration link to attend the webinar event. All sales are final.
Creating and Using Templates in Microsoft Excel
Product(s):
Microsoft Office Excel 2007.Audience(s): Business Professional.
Duration: 60 Minutes
Start Date: January 7, 2009 10:00 AM EST
Event Overview:
Templates are a way to take a spreadsheet and reuse it over and over
again without going through the time-consuming steps to make copies of
existing files. Templates are perfect for spreadsheets that are
repeatedly needed, such as on a weekly, monthly or quarterly basis.
*After adding your webinar to the cart and purchasing, KnowledgeWave will send you your unique registration link to attend the webinar event. All sales are final.
Sorting and Filtering Data in Microsoft Excel
Product(s):
Microsoft Office Excel 2007.
Audience(s):
Business Professional.
Duration:
Start Date:
Event Overview:
Data, Data everywhere but what does it all mean.
Data tells a story and sorts and filters help define that story.
This function-packed workshop covers how to sort your data by
multiple criteria, filter data using auto filter and custom filters and
use conditional formatting to make it look good.
*After adding your webinar to the cart and purchasing, KnowledgeWave will send you your unique registration link to attend the webinar event. All sales are final.
Number-Crunching with Formulas and Functions in Excel
Product(s): Microsoft Office Excel 2007.
Audience(s): Business Professional.
Duration: 60 Minutes
Start Date: January 5, 2009 11:00 AM EST, March 10, 2009 11:00 AM
EST
Event Overview:
This course 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.
*After adding your webinar to the cart and purchasing, KnowledgeWave will send you your unique registration link to attend the webinar event. All sales are final.
Showcase your Data Visually with Charts in Microsoft Excel
Product(s): Microsoft Office Excel 2007.
Audience(s): Business Professional.
Duration: 60 Minutes
Start Date: January 8, 2009 1:00 PM EST, March 17, 2009 1:00 PM
EST
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.
*After adding your webinar to the cart and purchasing, KnowledgeWave will send you your unique registration link to attend the webinar event. All sales are final.
Using What If Analysis and Scenario Manager to Plan for the Future
Product(s): Microsoft Office Excel 2007.
Audience(s): Business Professional.
Duration: 60 Minutes
Start Date: February 18, 2009 9:00 AM EST
Event Overview:
What-If analysis allows us to look input data and then ask what-if
questions of our data based on specific criteria and variables. Data
tables allow us to find variations in, for example, loan amounts based
on variations in interest rates. By using the Scenario Manager in
Microsoft Excel, it is possible to model problems that are more
complicated than data tables can handle, involving as many as 32
variables. The Goal Seek command is used to produce a value when some,
but not all variables are known. In other words, if I know I can afford
$400/month on a car, Goal Seek will tell me how much the total car price
can be.
*After adding your webinar to the cart and purchasing, KnowledgeWave will send you your unique registration link to attend the webinar event. All sales are final.
Make Sense of Your Data with PivotTables
Product(s): Microsoft Office Excel 2007.
Audience(s): Business Professional.
Duration: 60 Minutes
Start Date:
December 16, 2008 10:00 AM EST
February 5, 2009 2:00 PM EST
Event Overview:
Once you have created a list in Excel, there are many ways to analyze
the data. A PivotTable is often the most effective way to summarize and
analyze list data. This course explains the ins and outs of PivotTables,
including how to create them, modify their structure, and edit the data
a PivotTable is based on.
*After adding your webinar to the cart and purchasing, KnowledgeWave will send you your unique registration link to attend the webinar event. All sales are final.
Reviewing and Sharing in Microsoft Excel
Product(s): Microsoft Office Excel 2007.
Audience(s): Business Professional.
Duration: 60 Minutes
Start Date:
Event Overview:
If an Excel Spreadsheet is created in a vacuum and no one knows how it
was created, does it make an impact. In this lesson, we look at ways of
sharing Excel files among multiple users and tracking changes made to
said sheet. Topics covered include adding and editing comments, tracking
changes and a review of auditing features.
*After adding your webinar to the cart and purchasing, KnowledgeWave will send you your unique registration link to attend the webinar event. All sales are final.
Automating Repetitive Tasks With Macros in Microsoft Excel
Product(s): Microsoft Office Excel 2007.
Audience(s): Business Professional.
Duration: 60 Minutes
Start Date:
December 4, 2008 1:00 PM EST
February 18, 2009 1:00 PM EST
Event Overview:
Simple, powerful, and easy to customize, Excel macros can save you time
and increase your productivity. Macros called loops are especially
useful for working with ranges of data. Whether you’ve only heard about
macros or already used them in Excel, this course serves as a great
introduction.
*After adding your webinar to the cart and purchasing, KnowledgeWave will send you your unique registration link to attend the webinar event. All sales are final.
Using Excel as a Database with List
Product(s): Microsoft Office Excel 2007.
Audience(s): Business Professional.
Duration: 60 Minutes
Start Date:
December 29, 2008 1:00 PM EST
March 10, 2008 1:00 PM EST
Event Overview
Along with spreadsheet functionality, Excel can also keep track of
information in lists or databases. Some examples of things you might
track in a list include telephone numbers, clients, and employee
rosters. Once you create a list in Excel, you can easily find, organize,
and analyze its information with Excel’s rich set of list-management
features. In this short course, you will learn how to create a list, and
then add, modify, delete, and find information in it. You’ll also learn
how you can use Excel’s filter commands to display specific information.
*After adding your webinar to the cart and purchasing, KnowledgeWave will send you your unique registration link to attend the webinar event. All sales are final.
Track and Analyze Your Business Data with Excel
Product(s): Microsoft Office Excel 2007.
Audience(s): Business Professional.
Duration: 60 Minutes
Start Date:
January 19, 2009 1:00 PM EST
Event Overview
Microsoft Excel is a powerful tool for tracking business data. Whether you’re running a small business or you work in a large corporation, you can use Excel to create worksheets for tracking and projecting sales, determining appropriate service charges, and calculating a wide variety of formulas.
*After adding your webinar to the cart and purchasing, KnowledgeWave will send you your unique registration link to attend the webinar event. All sales are final.
Advanced PivotTables and PivotCharts
Product(s): Microsoft Office Excel 2007.
Audience(s): Business Professional.
Duration: 60 Minutes
Start Date:
February 3, 2009 9:00 AM EST
Event Overview
Discover the advanced features of creating and working with PivotTables and PivotCharts. This course is recommended for those who have attended Make Sense of Your Data with PivotTables and Pivot Charts in Microsoft Excel or have equivalent knowledge. Build PivotTables from external databases, customize PivotTables, work with subtotals, and use advanced PivotCharts features.
*After adding your webinar to the cart and purchasing, KnowledgeWave will send you your unique registration link to attend the webinar event. All sales are final.
©2008 KnowledgeWave Training, INC. All rights reserved. Terms and Conditions


