Excel 2003 Top 100 Simplified Tips and Tricks

1. Working with Data; No.1 Enter Numbers and Fractions; No.2 Enter Dates and Times; No.3 Name Cells and Ranges; No.4 Validate Data Entry Using a Pick List; No.5 Extend a Series of Dates with Autofill; No.6 Add a Symbol or Special Character; No.7 Compare Multiple Spreadsheets Using Freeze Panes; No.8 Hide Rows to Compare Data with Outlining; No.9 Access Excel by Keyboard; No.10 Access Excel by Voice with Speech Recognition; No.11 Find and Replace Data; No.12 Generate a Worksheet Using InfoPath; 2. Working with Formulas and Functions; No.13 Add Values in Different Ways; No.14 Make Magic with the Function Wizard; No.15 Document Formulas with Comments; No.16 Document Worksheets with OneNote; No.17 Define a Constant; No.18 Apply Names in Functions; No.19 Figure Out the Best Loan Terms; No.20 Determine the Internal Rate of Return; No.21 Determine the Nth Largest Value; No.22 Create a Conditional Function; No.23 Calculate a Conditional Sum; No.24 Discover Your Inner Calculator; No.25 Find Products and Square Roots; No.26 Calculate the Duration Between Two Times; No.27 Calculate Days Between Two Dates; No.28 Change Text to Numbers; 3. Copying Data, Formats, and More; No.29 Copy a Range with the Office Clipboard; No.30 Transpose a Row into a Column; No.31 Copy Styles to Another Workbook; No.32 Copy Chart Formatting into Another Chart; No.33 Copy Formulas with Paste Special; No.34 Track Changes while Editing; 4. Using Excel Lists; No.35 Generate a List Automatically; No.36 Enter List Data Using a Form; No.37 Import a Word List into Excel; No.38 Sort and Filter a List; No.39 Sort by Multiple Criteria; No.40 Find Averages in a Sorted Group; No.41 Filter by Multiple Criteria; No.42 Remove Duplicate Records from a List; No.43 Count Filtered Records; No.44 Filter by Multiple Criteria in the Same Column; No.45 Chart a Filtered List; No.46 Look Up Information in a List; 5. Exploring Patterns in Data; No.47 Create a PivotTable; No.48 Modify PivotTable Data and Layout; No.49 Find the Average of a Field; No.50 Create a Calculated Field; No.51 Hide Rows or Columns in a PivotTable; No.52 AutoFormat a PivotTable; No.53 Create a PivotChart; No.54 Describe Data with Statistics; No.55 Discover Associations within Your Data; No.56 Explore Outcomes with What-If Analysis; No.57 Optimize a Result with Goal Seek; 6. Creating Charts; No.58 Create a Chart; No.59 Modify Chart Details; No.60 Change the Chart Type; No.61 Add a Trendline to a Chart; No.62 Add and Remove Chart Data; No.63 Visually Represent Missing Chart Data; No.64 Use Error Bars in a Chart; No.65 Pull a Slice from a Pie Chart; No.66 Label the Slices of a Pie Chart; No.67 Create a Histogram; No.68 Paste a Chart into Word; No.69 Embed a Chart into Word; 7. Presenting Worksheets; No.70 Format Numbers as Percentages; No.71 Format a Column of Currencies; No.72 Format Column Headings; No.73 Format Quickly with Format Painter; No.74 Group Formats in a Style; No.75 Insert a Background Image into Your Worksheet; No.76 Create a Transparent Image; 8. Saving and Printing Worksheets; No.77 Save a Workbook as a Template; No.78 Save a Workbook as an XML Spreadsheet; No.79 Print Multiple Cell Ranges on One Page; No.80 Print Multiple Areas of a Workbook; No.81 Print Multiple Worksheets of a Workbook; No.82 Repeat Headings of a Row and Column; No.83 Print Functions to Show Calculations; 9. Extending Excel; No.84 Hyperlink a Worksheet to Another Office Document; No.85 Embed a Chart within PowerPoint; No.86 Publish an Interactive Workbook; No.87 Import a Worksheet from the Web; No.88 Query a Web Site; No.89 Query an Access Database; No.90 Reuse a Saved Query; No.91 Import a Worksheet into Access; No.92 Use Excel Data to Create Labels in Word; 10. Customizing Excel; No.93 Add Features by Installing and Using Add-Ins; No.94 Launch a Specific Workbook when Excel Opens; No.95 Create a Custom Workspace; No.96 Save Time by Creating a Custom View; No.97 Create a Custom Number Format; No.98 Create a Macro to Format Numbers; No.99 Create a Button to Run a Macro; No.100 Enlarge Screen Elements