Book description
Excel, the world's most popular spreadsheet program, has the muscle to analyze heaps of data. Beyond basic number-crunching, Excel 2010 has many impressive features that are hard to find, much less master -- especially from online help pages. This Missing Manual clearly explains how everything works with a unique and witty style to help you learn quickly.
- Navigate with ease. Master Excel's tabbed toolbar and its new backstage view
- Perform a variety of calculations. Write formulas for rounding numbers, calculating mortgage payments, and more
- Organize your data. Search, sort, and filter huge amounts of information
- Illustrate trends. Bring your data to life with charts and graphics -- including miniature charts called Sparklines
- Examine your data. Summarize information and find hidden patterns with pivot tables and slicers
- Share your spreadsheets. Use the Excel Web App to collaborate with colleagues online
- Rescue lost data. Restore old versions of data and find spreadsheets you forgot to save
Publisher resources
Table of contents
- Excel 2010: The Missing Manual
- A Note Regarding Supplemental Files
- The Missing Credits
- Introduction
-
One. Worksheet Basics
- 1. Creating Your First Spreadsheet
- 2. Adding Information to Worksheets
-
3. Moving Data
- Selecting Cells
- Making Continuous Range Selections
- Making Noncontiguous Selections
- Automatically Selecting Your Data
- Making Selections with the Keyboard
- Moving Cells Around
- A Simple Cut-and-Paste or Copy-and-Paste
- A Quicker Cut-and-Paste or Copy-and-Paste
- Fancy Pasting Tricks
- Paste Special
- Copying Multiple Items with the Clipboard
- Adding and Moving Columns or Rows
- Inserting Columns and Rows
- Inserting Rows
- Inserting Copied or Cut Cells
- Deleting Columns and Rows
- 4. Managing Worksheets
- 5. Formatting Cells
- 6. Smart Formatting Tricks
- 7. Viewing and Printing Worksheets
-
Two. Formulas and Functions
- 8. Building Basic Formulas
-
9. Math and Statistical Functions
- Rounding Numbers
-
Groups of Numbers
- SUM(): Summing Up Numbers
- COUNT(), COUNTA(), and COUNTBLANK(): Counting Items in a List
- MAX() and MIN(): Finding Maximum and Minimum Values
- LARGE(), SMALL(), and RANK(): Ranking Numbers
- AVERAGE() and MEDIAN(): Finding Average or Median Values
- PERCENTILE() and PERCENTRANK(): Advanced Ranking Functions
- FREQUENCY(): Putting Numbers into Grouped Ranges
- MODE(): Finding Numbers That Frequently Occur in a List
-
General Math Functions
- PRODUCT(), FACT(), POWER(), and SQRT(): Products, Factorials,Powers, and Square Roots
- QUOTIENT() and MOD(): Higher Division
- ABS() and SIGN(): Absolute Value and Determining a Number’s Sign
- RAND() and RANDBETWEEN(): Generating Random Numbers
- GCD() and LCM(): Greatest and Least Common Denominator
- COMBIN() and PERMUT(): Figuring Combinations and Permutations
- Trigonometry and Advanced Math
- Advanced Statistics
-
10. Financial Functions
- The World of Finance
-
Financial Functions
- FV(): Future Value
- PV(): Present Value
- PMT(), PPMT(), and IPMT(): Calculating the Number of Payments You Need to Make
- NPER(): Figuring Out How Much Time You’ll Need to Pay Offa Loan or Meet an Investment Target
- RATE(): Figuring the Interest Rate You Need to Achieve Future Value
- NPV() and IRR(): Net Present Value and Internal Rate of Return
- Depreciation
- Other Financial Functions
-
11. Manipulating Dates, Times, and Text
-
Manipulating Text
- CONCATENATE(): Joining Strings of Text Together
- LEFT(), MID(), and RIGHT(): Copying Portions of a Text String
- LEN(), FIND(), and SEARCH(): Counting Characters in a String
- UPPER(), LOWER(), and PROPER(): Changing Capitalization
- TRIM() and CLEAN(): Removing Unwanted Spaces and Non-Printing Characters
- SUBSTITUTE(): Replacing One Sequence of Characters with Another
- TEXT(), VALUE(), FIXED(), and DOLLAR(): Converting Text to Numbers and Vice Versa
- Other Text Functions
- Manipulating Dates and Times
- Math with Dates and Times
-
Date and Time Functions
- TODAY() and NOW(): Inserting the Current Date and Time
- DATE() and TIME(): Dates and Times in Calculations
- DAY(), MONTH(), and YEAR(): More Date Calculations
- HOUR(), MINUTE(), SECOND(): More Time Calculations
- WEEKDAY(): Determining the Day of the Week
- DATEDIF(): Calculating the Difference Between Dates
- DATEVALUE() and TIMEVALUE(): Converting Dates and Times into Serial Numbers
- DAYS360(): Finding Out the Number of Days Between Two Dates
- EDATE(): Calculating Future Dates
- YEARFRAC(): Calculating the Percentage of a Year Between Two Dates
- EOMONTH(): Finding the Last Day of Any Month
- NETWORKDAYS(): Counting the Number of Business Days
- WORKDAY(): Figuring Out When Days Will Fall in the Future
- WEEKNUM(): Figuring Out in Which Week a Date Falls
-
Manipulating Text
-
12. Lookup, Reference, and Information Functions
- The Basic Lookup
-
Advanced Lookups
- MATCH(): Finding the Position of Items in a Range
- INDEX(): Retrieving the Value from a Cell
- Performing a “Left Lookup”
- Performing a Double Lookup
- OFFSET(): Shifting Cell References
- Other Reference and Lookup Functions
- INDIRECT() and ADDRESS(): Working with Cell References Stored As Text
- TRANSPOSE(): Changing Rows into Columns and Vice Versa
- The HYPERLINK() Function: Creating a Dynamic Link
- Information Functions
- Tutorial: Generating Invoices from a Product Catalog
- 13. Advanced Formula Writing and Troubleshooting
- Three. Organizing Worksheets
-
Four. Charts and Graphics
- 17. Creating Basic Charts
- 18. Formatting and Perfecting Charts
- 19. Inserting Graphics
-
Five. Advanced Data Analysis
- 20. Visualizing Your Data
- 21. Scenarios and Goal Seeking
- 22. Pivot Tables
- 23. Analyzing Databases, XML, and Web Pages
-
Six. Sharing Data with the Rest of the World
- 24. Protecting Your Workbooks
- 25. Worksheet Collaboration
- 26. Using Excel on the Web
- 27. Exchanging Data with Other Programs
- Seven. Programming Excel
- Eight. Appendix
- Index
- About the Author
- Copyright
Product information
- Title: Excel 2010: The Missing Manual
- Author(s):
- Release date: June 2010
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781449394196
You might also like
book
Excel 2003: The Missing Manual
Whether you are an Excel neophyte, a sophisticate who knows the program inside out, or an …
book
Excel 2007: The Missing Manual
Microsoft Excel continues to grow in power, sophistication, and capability, but one thing that has changed …
book
Formulas and Functions: Microsoft® Excel 2010
MASTER CORE EXCEL 2010 TOOLS FOR BUILDING POWERFUL, RELIABLE SPREADSHEETS! Excel expert Paul McFedries shows how …
book
Formulas and Functions with Microsoft® Excel 2003
The world of mathematical formulas and jargon in Microsoft Excel is complex and can be intimidating …