Book description
Microsoft Excel continues to grow in power, sophistication, and capability, but one thing that has changed very little since the early '90s is its user interface. The once-simple toolbar has been packed with so many features over the years that few users know where to find them all. Microsoft has addressed this problem in Excel 2007 by radically redesigning the user interface with a tabbed toolbar that makes every feature easy to locate and use. Unfortunately, Microsoft's documentation is as scant as ever, so even if users can find advanced features, they probably won't know what to do with them.
Excel 2007: The Missing Manual covers the entire gamut of how to build spreadsheets, add and format information, print reports, create charts and graphics, and use basic formulas and functions. Like its siblings in the Missing Manual series, this book crackles with a fine sense of humor and refreshing objectivity about its subject, guiding readers through the new Excel with clear explanations, step-by-step instructions, lots of illustrations, and friendly, time-saving advice. It's a perfect primer for small businesses with no techie to turn to, as well as those who want to organize household and office information.
Table of contents
- Excel 2007: The Missing Manual
- A Note Regarding Supplemental Files
- The Missing Credits
- Introduction
-
I. Worksheet Basics
- 1. Creating and Navigating Worksheets
- 2. Adding Information to Worksheets
- 3. Moving Data Around a Worksheet
-
4. Managing Worksheets and Workbooks
-
4.1. Worksheets and Workbooks
- 4.1.1. Adding, Removing, and Hiding Worksheets
- 4.1.2. Naming and Rearranging Worksheets
-
4.1.3. Grouping Sheets
- 4.1.3.1. Moving, copying, deleting, or hiding grouped worksheets
- 4.1.3.2. Formatting cells, columns, and rows in grouped worksheets
- 4.1.3.3. Entering data or changing cells in grouped worksheets
- 4.1.3.4. Cutting, copying, and pasting cells in grouped worksheets
- 4.1.3.5. Adjusting printing and display options in grouped worksheets
- 4.1.4. Moving Worksheets from One Workbook to Another
- 4.2. Find and Replace
- 4.3. Spell Check
-
4.1. Worksheets and Workbooks
- 5. Formatting Cells
- 6. Smart Formatting Tricks
- 7. Viewing and Printing Worksheets
-
II. Formulas and Functions
- 8. Building Basic Formulas
-
9. Math and Statistical Functions
- 9.1. Rounding Numbers
-
9.2. Groups of Numbers
- 9.2.1. SUM( ): Summing Up Numbers
- 9.2.2. COUNT( ), COUNTA( ), and COUNTBLANK( ): Counting Items in a List
- 9.2.3. MAX( ) and MIN( ): Finding Maximum and Minimum Values
- 9.2.4. LARGE( ), SMALL( ), and RANK( ): Ranking Your Numbers
- 9.2.5. AVERAGE( ) and MEDIAN( ): Finding Average or Median Values
- 9.2.6. MODE( ): Finding Numbers That Frequently Occur in a List
- 9.2.7. PERCENTILE( ) and PERCENTRANK( ): Advanced Ranking Functions
- 9.2.8. FREQUENCY( ): Identifying to Which Category a Number Belongs
-
9.3. General Math Functions
- 9.3.1. PRODUCT( ), FACT( ), POWER( ), and SQRT( ): Products, Factorials, Powers, and Square Roots
- 9.3.2. QUOTIENT( ) and MOD( ): Higher Division
- 9.3.3. ABS( ) and SIGN( ): Absolute Value and Determining a Numberâs Sign
- 9.3.4. RAND( ) and RANDBETWEEN( ): Generating Random Numbers
- 9.3.5. GCD( ) and LCM( ): Greatest and Least Common Denominator
- 9.3.6. COMBIN( ) and PERMUT( ): Figuring Combinations and Permutations
- 9.4. Trigonometry and Advanced Math
- 9.5. Advanced Statistics
-
10. Financial Functions
- 10.1. The World of Finance
-
10.2. Financial Functions
- 10.2.1. FV( ): Future Value
- 10.2.2. PV( ): Present Value
- 10.2.3. PMT( ), PPMT( ), and IPMT( ): Calculating the Number of Payments You Need to Make
- 10.2.4. NPER( ): Figuring Out How Much Time Youâll Need to Pay Off a Loan or Meet an Investment Target
- 10.2.5. RATE( ): Figuring the Interest Rate You Need to Achieve Future Value
- 10.2.6. NPV( ) and IRR( ): Net Present Value and Internal Rate of Return
- 10.3. Depreciation
- 10.4. Other Financial Functions
-
11. Manipulating Dates, Times, and Text
-
11.1. Manipulating Text
- 11.1.1. CONCATENATE( ): Joining Strings of Text Together
- 11.1.2. LEFT( ), MID( ), and RIGHT( ): Copying Portions of a Text String
- 11.1.3. LEN( ), FIND( ), and SEARCH( ): Counting Characters in a String
- 11.1.4. UPPER( ), LOWER( ), and PROPER( ): Changing Capitalization
- 11.1.5. TRIM( ) and CLEAN( ): Removing Unwanted Spaces and Non-Printing Characters
- 11.1.6. SUBSTITUTE( ): Replacing One Sequence of Characters with Another
- 11.1.7. TEXT( ), VALUE( ), FIXED( ), and DOLLAR( ): Converting Text to Numbers and Vice Versa
- 11.1.8. Other Text Functions
- 11.2. Manipulating Dates and Times
- 11.3. Math with Dates and Times
-
11.4. Date and Time Functions
- 11.4.1. TODAY( ) and NOW( ): Inserting the Current Date and Time
- 11.4.2. DATE( ) and TIME( ): Dates and Times in Calculations
- 11.4.3. DAY( ), MONTH( ), and YEAR( ): More Date Calculations
- 11.4.4. HOUR( ), MINUTE( ), SECOND( ): More Time Calculations
- 11.4.5. WEEKDAY( ): Determining the Day of the Week
- 11.4.6. DATEDIF( ): Calculating the Difference Between Dates
- 11.4.7. DATEVALUE( ) and TIMEVALUE( ): Converting Dates and Times into Serial Numbers
- 11.4.8. DAYS360( ): Finding Out the Number of Days Between Two Dates
- 11.4.9. EDATE( ): Calculating Future Dates
- 11.4.10. YEARFRAC( ): Calculating the Percentage of a Year Between Two Dates
- 11.4.11. EOMONTH( ): Finding the Last Day of Any Month
- 11.4.12. NETWORKDAYS( ): Counting the Number of Business Days
- 11.4.13. WORKDAY( ): Figuring Out When Days Will Fall in the Future
- 11.4.14. WEEKNUM( ): Figuring Out in Which Week a Date Falls
-
11.1. Manipulating Text
-
12. Lookup, Reference, and Information Functions
- 12.1. The Basic Lookup
-
12.2. Advanced Lookups
- 12.2.1. MATCH( ): Finding the Position of Items in a Range
- 12.2.2. INDEX( ): Retrieving the Value from a Cell
- 12.2.3. Performing a âLeft Lookupâ
- 12.2.4. Performing a Double Lookup
- 12.2.5. The Lookup Wizard
- 12.2.6. OFFSET( ): Moving Cell References to a New Location
- 12.2.7. Other Reference and Lookup Functions
- 12.2.8. INDIRECT( ) and ADDRESS( ): Working with Cell References Stored As Text
- 12.2.9. TRANSPOSE( ): Changing Rows into Columns and Vice Versa
- 12.3. Information Functions
- 12.4. Tutorial: Quickly Generating Invoices from a Product Catalog
- 13. Advanced Formula Writing and Troubleshooting
-
III. Organizing Worksheets
- 14. Tables: List Management Made Easy
- 15. Grouping and Outlining Data
- 16. Templates
-
IV. Charts and Graphics
- 17. Creating Basic Charts
- 18. Formatting and Perfecting Charts
- 19. Inserting Graphics
- V. Advanced Data Analysis
-
VI. Sharing Data with the Rest of the World
- 22. Protecting Your Workbooks
- 23. Worksheet Collaboration
- 24. Querying Databases and XML Files
- 25. Exchanging Data with Other Programs
- 26. Connecting Worksheets to the Web
- VII. Programming Excel
- VIII. Appendix
- Index
- About the Author
- Colophon
- Copyright
Product information
- Title: Excel 2007: The Missing Manual
- Author(s):
- Release date: December 2006
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9780596527594
You might also like
book
Designing Data-Intensive Applications
Data is at the center of many challenges in system design today. Difficult issues need to …
audiobook
The Design of Everyday Things
First, businesses discovered quality as a key competitive edge; next came science. Now, Donald A. Norman, …
book
Generative Deep Learning, 2nd Edition
Generative AI is the hottest topic in tech. This practical book teaches machine learning engineers and …
book
Mastering Concurrency in Python
Immerse yourself in the world of Python concurrency and tackle the most complex concurrent programming problems …