|
Excel 2002 Step By Step
Experience learning made easy - and quickly teach yourself how to use the data-presentation and number-crunching power in Microsoft Excel Version 2002. With STEP BY STEP, you can take just the lessons you need or work from cover to cover. Either way, you drive the instruction - building and practicing the skills you need, just when you need them!
*
Master the tools for organizing, processing, and presenting data in Excel
* Make data come alive with PivotTable and PivotChart reports
* Use data-analysis tools and techniques for better decision-making
* Tap external data sources - including other Microsoft Office applications - and add hyperlinks
* Create your own macros
* Help keep data secure as you share - and collaborate on - Excel documents over the Web
* Prepare for the Microsoft Office User Specialist (MOUS) exam
1 Getting to Know Excel
2 Setting Up a Workbook
3 Performing Calculations on Data
4 Changing Document Appearance
5 Focusing on Specific Data Using Filters
6 Combining Data from Multiple Sources
7 Reordering and Summarizing Data
8 Analyzing Alternative Data Sets
9 Creating Dynamic Lists with PivotTables
10 Creating Charts
11 Printing
12 Automating Repetitive Tasks with Macros
13 Working with Other Microsoft Office Programs
14 Working with Database Data
15 Publishing Information on the Web
16 Collaborating with Colleagues
QUICK REFERENCE
GLOSSARY
INDEX
|
