Here are 9
Excel Tutorials, from brainbell.com, that will
teach you several important features of Excel XP. Functionality covered
includes named ranges, pivot tables, charting, formulas, functions,
macros, and exporting excel spreadsheets to Word. \Most of these Excel
tutorials can also be used
for learning how to use Excel 2003.
Build Pivot Tables By Using VBA
In this tutorial you'll learn how to create a Pivot Table, using a
powerful macro language called Visual Basic for Application (VBA)
Reducing
Workbook and Worksheet Frustration
Excel enables you to have multiple workbooks showing simultaneously,
and to have a customized view of your workbooks arranged in different
windows. Then you can save your view workspaces as .xlw files and use
them when it suits you.
Excel's
Built-in Features
Although Excel comes with a wide variety of standard features for
managing and analyzing data, the boundaries of these features are often
frustrating. This tutorial provide numerous ways in which you can
escape these boundaries and make Excel a much more powerful tool.
Named
Ranges
The biggest advantage to using named ranges is that formulas become a
lot easier to read and understand, not only to you but also to others
who need to work with your spreadsheets. Using named ranges, you can
reference a range of cells and give it a specific name.
Pivot
Tables
PivotTables are one of Excel's most powerful attractions, though many
people don't know what they do. PivotTables display and extract a
variety of information from a table of data that resides within either
Microsoft Excel or another compatible database type.
Charting
Charts giving spreadsheets visual power beyond mere calculations.
Excel's chart capabilities are impressive, many times you'll want to go
beyond the basic functionality provided by the software's built-in
Chart Wizard to create charts that are more responsive to changes in
data, or you simply will want to go beyond the range of options Excel
most obviously provides. This chapter enable you to do all of this and
more.
Formulas
and Functions
The formula and function capabilities built into Excel might not always
be what you want, further complicating the situation. Fortunately,
there are a lot of ways you can keep your formulas and functions sane.
Macros
Macros make it wonderfully easy to automate repetitive tasks in Excel,
but the way they're created and the facilities for using them are
sometimes problematic. Fortunately, Excel is flexible enough that you
can fix those problems and create new features with a minimum of
effort.
Connecting
Excel to the World
Excel
has long had connections to other members of the Microsoft Office
family, as well as to databases. With the growth of the Web, Excel
developed HTML export capabilities as well, making it easy to publish
information created in Excel.