Excel 2003 Top 100 Simplified Tips & TricksExcel 2003 技巧100例
点此进入淘宝搜索页搜索分類: 图书,计算机/网络,家庭与办公室用书,微软Office ,
作者： David Peal著
出 版 社：
出版时间： 2005-4-1字数：版次： 1页数： 229印刷时间： 2005/04/01开本：印次： 1纸张： 铜版纸I S B N ： 9780764597619包装： 平装编辑推荐
Providing timesaving tips, cool secrets, and productivity tricks, this book is completely updated for the newest version of Excel
The task-oriented approach presents adventurous readers with 100 useful and surprising techniques that can be performed with the latest version of Excel, the dominant spreadsheet and data analysis tool that's part of the Microsoft Office suite
Taking readers beyond the basics, the full-color screen shots and numbered, step-by-step instructions show how to save time and boost productivity
内容简介
You already know Excel 2003 basics.Now you'd like to go beyond with shortcuts.tricks,and tips that let you work smarter and faster.And because you lean more easily when someone shows you how,this is the book for you.
Inside,you'll find clear,illustrated instructions for 100 tasks that reveal cool secrets,teach fimesaving fricks,and explain great tips guaranteed to make you more productive with Excel 2003.
目录
1Working with Data
1 Enter Numbers and Fractions
2 Enter Dates and Times
3 Name Cells and Ranges
4 Validate Data Entry Using a Pick List
5 Extend a Series of Dates with Autofill
6 Add a Symbol or Special Character
7 Compare Multiple Spreadsheets Using Freeze Panes
8 Hide Rows to Compare Data with Outlining
9 Access Excel by Keyboard
10 Access Excel by Voice with Speech Recognition
11 Find and Replace Data
12 Generate a Worksheet Using InfoPath
2Working with Formulas and Functions
13 Add Values in Different Ways
14 Make Magic with the Function Wizard
15 Document Formulas with Comments
16 Document Worksheets with OneNote
17 Define a Constant
18 Apply Names in Functions
19 Figure Out the Best Loan Terms
20 Determine the Internal Rate of Return
21 Determine the Nth Largest Value
22 Create a Conditional Function
23 Calculate a Conditional Sum
24 Discover Your Inner Calculator
25 Find Products and Square Roots
26 Calculate the Duration Between Two Times
27 Calculate Days Between Two Dates
28 Change Text to Numbers
3Copying Data, Formats, and More
29 Copy a Range with the Office Clipboard
30 Transpose a Row into a Column
31 Copy Styles to Another Workbook
32 Copy Chart Formatting into Another Chart
33 Copy Formulas with Paste Special
34 Track Changes while Editing
4Using Excel Lists
35 Generate a List Automatically
36 Enter List Data Using a Form
37 Import a Word List into Excel
38 Sort and Filter a List
39 Sort by Multiple Criteria
40 Find Averages in a Sorted Group
41 Filter by Multiple Criteria
42 Remove Duplicate Records from a List
43 Count Filtered Records
44 Filter by Multiple Criteria in the Same Column
45 Chart a Filtered List
46 Look Up Information in a List
5Exploring Patterns in Data
47 Create a PivotTable
48 Modify PivotTable Data and Layout
49 Find the Average of a Field
50 Create a Calculated Field
51 Hide Rows or Columns in a PivotTable
52 AutoFormat a PivotTable
53 Create a PivotChart
54 Describe Data with Statistics
55 Discover Associations within Your Data
56 Explore Outcomes with What-If Analysis
57 Optimize a Result with Goal Seek
6Creating Charts
58 Create a Chart
59 Modify Chart Details
60 Change the Chart Type
61 Add a Trendline to a Chart
62 Add and Remove Chart Data
63 Visually Represent Missing Chart Data
64 Use Error Bars in a Chart
65 Pull a Slice from a Pie Chart
66 Label the Slices of a Pie Chart
67 Create a Histogram
68 Paste a Chart into Word
69 Embed a Chart into Word
7Presenting Worksheets
70 Format Numbers as Percentages
71 Format a Column of Currencies
72 Format Column Headings
73 Format Quickly with Format Painter
74 Group Formats in a Style
75 Insert a Background Image into Your Worksheet
76 Create a Transparent Image
8Saving and Printing Worksheets
77 Save a Workbook as a Template
78 Save a Workbook as an XML Spreadsheet
79 Print Multiple Cell Ranges on One Page
80 Print Multiple Areas of a Workbook
81 Print Multiple Worksheets of a Workbook
82 Repeat Headings of a Row and Column
83 Print Functions to Show Calculations
9Extending Excel
84 Hyperlink a Worksheet to Another Office Document
85 Embed a Chart within PowerPoint
86 Publish an Interactive Workbook
87 Import a Worksheet from the Web
88 Query a Web Site
89 Query an Access Database
90 Reuse a Saved Query
91 Import a Worksheet into Access
92 Use Excel Data to Create Labels in Word
10Customizing Excel
93 Add Features by Installing and Using Add-Ins
94 Launch a Specific Workbook when Excel Opens
95 Create a Custom Workspace
96 Save Time by Creating a Custom View
97 Create a Custom Number Format
98 Create a Macro to Format Numbers
99 Create a Button to Run a Macro
100 Enlarge Screen Elements
