|
Excel 2003 Visual Quick Tips
* 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
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.
|
