Excel 2003 Visual Quick Tips
1st Edition
Published on 1. January 2006
Book
Paperback/Softback
224 pages
978-0-470-00926-0 (ISBN)
Description
* Straight-forward task descriptions
* Succinct explanations
* Full-color screen shots
* Numbered steps
Learn How To:
* Create PivotTables and PivotCharts
* Create a Button to Run a Macro
* Publish an Interactive Workbook
* Succinct explanations
* Full-color screen shots
* Numbered steps
Learn How To:
* Create PivotTables and PivotCharts
* Create a Button to Run a Macro
* Publish an Interactive Workbook
More details
Edition
1., Auflage
Language
English
Place of publication
New York
United States
Publishing group
John Wiley and Sons Ltd
Target group
Professional and scholarly
Illustrations
col. Illustrations
Dimensions
Height: 18.2 cm
Width: 13 cm
Weight
233 gr
ISBN-13
978-0-470-00926-0 (9780470009260)
Schweitzer Classification
Person
David Peal teaches educational technology at the George Washington University. He is author of seven computer books, including Access the Internet, The Official AOL Guide to the Internet, and the Official AOL Guide to You've Got Pictures. He is also the author of the first Edition of Excel 2003: Top 100 Simplified Tips & Tricks published by Wiley. David has worked as product manager at a large computer book publisher and as Internet editorial manager at American Online.
Content
Chapter 1: Working with Data.
Enter Numbers and Fractions.
Enter Dates and Times.
Name Cells and Ranges.
Validate Data Entry Using a Pick List.
Extend a Series of Dates with Autofill.
Add a Symbol or Special Character.
Compare Multiple Spreadsheets Using Freeze Panes.
Hide Rows to Compare Data with Outlining.
Access Excel by Keyboard.
Find and Replace Data.
Generate a Worksheet with InfoPath.
Chapter 2: Working with Formulas and Functions.
Add Values in Different Ways.
Make Magic with the Function Wizard.
Document Formulas with Comments.
Document Worksheets with OneNote.
Define a Constant.
Apply Names in Functions.
Figure Out the Best Loan Terms.
Determine the Internal Rate of Return.
Determine the Nth Largest Value.
Create a Conditional Function.
Discover Your Inner Calculator.
Find Products and Square Roots.
Calculate the Duration Between Two Times.
Calculate Days Between Two Dates.
Change Text to Numbers.
Chapter 3: Copying Data, Formats, and More.
Copy a Range with the Office Clipboard.
Transpose a Row into a Column.
Copy Styles to Another Workbook.
Copy Chart Formatting into Another Chart.
Copy Formulas with Paste Special.
Track Changes while Editing.
Chapter 4: Using Excel Lists.
Generate a List Automatically.
Enter List Data Using a Form.
Import a Word List into Excel.
Sort and Filter a List.
Sort by Multiple Criteria.
Find Averages in a Sorted Group.
Filter by Multiple Criteria.
Remove Duplicate Records from a List.
Filter by Multiple Criteria in the Same Column.
Chart a Filtered List.
Chapter 5: Exploring Patterns in Data.
Create a PivotTable.
Modify PivotTable Data and Layout.
Find the Average of a Field.
Create a Calculated Field.
Hide Rows or Columns in a PivotTable.
AutoFormat a PivotTable.
Create a PivotChart.
Describe Data with Statistics.
Discover Associations within Your Data.
Explore Outcomes with What-If Analysis.
Chapter 6: Creating Charts.
Create a Chart.
Modify Chart Details.
Change the Chart Type.
Add a Trendline to a Chart.
Add and Remove Chart Data.
Visually Represent Missing Chart Data.
Use Error Bars in a Chart.
Pull a Slice from a Pie Chart.
Label the Slices of a Pie Chart.
Create a Histogram.
Paste a Chart into Word.
Paste-Link a Chart into Word.
Chapter 7: Presenting Worksheets.
Format Numbers as Percentages.
Format a Column of Currencies.
Format Column Headings.
Format Quickly with Format Painter.
Group Formats in a Style.
Insert a Background Image into Your Worksheet.
Create a Transparent Image.
Chapter 8: Saving and Printing Worksheets.
Save a Workbook as a Template.
Print Multiple Cell Ranges on One Page.
Print Multiple Areas of a Workbook.
Print Multiple Worksheets of a Workbook.
Repeat Headings of a Row and Column.
Print Functions to Show Calculations.
Chapter 9: Extending Excel.
Hyperlink a Worksheet to Another Office Document.
Embed a Chart within PowerPoint.
Publish an Interactive Workbook.
Import a Worksheet from the Web.
Query a Web Site.
Query an Access Database.
Reuse a Saved Query.
Import a Worksheet into Access.
Chapter 10: Customizing Excel.
Add Features by Installing and Using Add-Ins.
Launch a Specific Workbook when Excel Opens.
Create a Custom Workspace.
Save Time by Creating a Custom View.
Create a Custom Number Format.
Create a Macro to Format Numbers.
Create a Button to Run a Macro.
Enter Numbers and Fractions.
Enter Dates and Times.
Name Cells and Ranges.
Validate Data Entry Using a Pick List.
Extend a Series of Dates with Autofill.
Add a Symbol or Special Character.
Compare Multiple Spreadsheets Using Freeze Panes.
Hide Rows to Compare Data with Outlining.
Access Excel by Keyboard.
Find and Replace Data.
Generate a Worksheet with InfoPath.
Chapter 2: Working with Formulas and Functions.
Add Values in Different Ways.
Make Magic with the Function Wizard.
Document Formulas with Comments.
Document Worksheets with OneNote.
Define a Constant.
Apply Names in Functions.
Figure Out the Best Loan Terms.
Determine the Internal Rate of Return.
Determine the Nth Largest Value.
Create a Conditional Function.
Discover Your Inner Calculator.
Find Products and Square Roots.
Calculate the Duration Between Two Times.
Calculate Days Between Two Dates.
Change Text to Numbers.
Chapter 3: Copying Data, Formats, and More.
Copy a Range with the Office Clipboard.
Transpose a Row into a Column.
Copy Styles to Another Workbook.
Copy Chart Formatting into Another Chart.
Copy Formulas with Paste Special.
Track Changes while Editing.
Chapter 4: Using Excel Lists.
Generate a List Automatically.
Enter List Data Using a Form.
Import a Word List into Excel.
Sort and Filter a List.
Sort by Multiple Criteria.
Find Averages in a Sorted Group.
Filter by Multiple Criteria.
Remove Duplicate Records from a List.
Filter by Multiple Criteria in the Same Column.
Chart a Filtered List.
Chapter 5: Exploring Patterns in Data.
Create a PivotTable.
Modify PivotTable Data and Layout.
Find the Average of a Field.
Create a Calculated Field.
Hide Rows or Columns in a PivotTable.
AutoFormat a PivotTable.
Create a PivotChart.
Describe Data with Statistics.
Discover Associations within Your Data.
Explore Outcomes with What-If Analysis.
Chapter 6: Creating Charts.
Create a Chart.
Modify Chart Details.
Change the Chart Type.
Add a Trendline to a Chart.
Add and Remove Chart Data.
Visually Represent Missing Chart Data.
Use Error Bars in a Chart.
Pull a Slice from a Pie Chart.
Label the Slices of a Pie Chart.
Create a Histogram.
Paste a Chart into Word.
Paste-Link a Chart into Word.
Chapter 7: Presenting Worksheets.
Format Numbers as Percentages.
Format a Column of Currencies.
Format Column Headings.
Format Quickly with Format Painter.
Group Formats in a Style.
Insert a Background Image into Your Worksheet.
Create a Transparent Image.
Chapter 8: Saving and Printing Worksheets.
Save a Workbook as a Template.
Print Multiple Cell Ranges on One Page.
Print Multiple Areas of a Workbook.
Print Multiple Worksheets of a Workbook.
Repeat Headings of a Row and Column.
Print Functions to Show Calculations.
Chapter 9: Extending Excel.
Hyperlink a Worksheet to Another Office Document.
Embed a Chart within PowerPoint.
Publish an Interactive Workbook.
Import a Worksheet from the Web.
Query a Web Site.
Query an Access Database.
Reuse a Saved Query.
Import a Worksheet into Access.
Chapter 10: Customizing Excel.
Add Features by Installing and Using Add-Ins.
Launch a Specific Workbook when Excel Opens.
Create a Custom Workspace.
Save Time by Creating a Custom View.
Create a Custom Number Format.
Create a Macro to Format Numbers.
Create a Button to Run a Macro.