Wiley Microsoft Office Excel 2007: Top 100 Simplified Tips & Tricks 978-0-470-12674-5 Benutzerhandbuch
Produktcode
978-0-470-12674-5
Table of Contents
Work with Formulas and Functions
#10
Enter Formulas Using a Variety of Methods
24
#11
Name Cells and Ranges
26
#12
Define a Constant
28
#13
Create Formulas That Include Names
30
#14
Calculate with the Function Wizard
32
#15
Figure Out Loan Terms
34
#16
Determine the Internal Rate of Return
36
#17
Determine the Nth Largest Value
38
#18
Create a Conditional Formula
40
#19
Calculate a Conditional Sum
42
#20
Add a Calculator
44
#21
Find Products and Square Roots
46
#22
Perform Time Calculations
48
#23
Perform Date Calculations
50
2
vi
Boost Your Efficiency
#1
Validate with a Validation List
4
#2
Validate with Data Entry Rules
6
#3
Extend a Series with AutoFill
8
#4
Insert Symbols or Special Characters
10
#5
Hide Rows by Grouping and Outlining
12
#6
Find and Replace Formats
14
#7
Add Comments to Your Worksheet
16
#8
Let Excel Read Back Your Data
18
#9
Create Your Own Sort or AutoFill
20
1
02_126745 ftoc.qxp 6/5/07 6:59 PM Page vi
COPYRIGHTED MATERIAL