Book description
Whether you are an Excel neophyte, a sophisticate who knows the program inside out, or an intermediate-level plodder eager to hone your skills, Excel: The Missing Manual is sure to become your go-to resource for all things Excel. Covering all the features of Excel 2002 and 2003, the most recent versions for Windows, Excel: The Missing Manual is an easy-to-read, thorough and downright enjoyable guide to one of the world's most popular, (and annoyingly complicated!) computer programs.Never a candidate for "the most user-friendly of Microsoft programs," Excel demands study, practice and dedication to gain even a working knowledge of the basics. Excel 2003 is probably even tougher to use than any previous version of Excel. However, despite its fairly steep learning curve, this marvelously rich program enables users of every stripe to turn data into information using tools to analyze, communicate, and share knowledge. Excel can help you to collaborate effectively, and protect and control access to your work. Power users can take advantage of industry-standard Extensible Markup Language (XML) data to connect to business processes.To unleash the power of the program and mine the full potential of their database talents, users need an authorative and friendly resource. None is more authoritative or friendlier than Excel: The Missing Manual. Not only does the book provide exhaustive coverage of the basics, it provides numerous tips and tricks, as well as advanced data analysis, programming and Web interface knowledge that pros can adopt for their latest project. Neophytes will find everything they need to create professional spreadsheets and become confident users.Excel: The Missing Manual covers: worksheet basics, formulas and functions, organizing worksheets, charts and graphics, advanced data analysis, sharing data with the rest of the world, and programming.If you buy just one book about using Excel, this has GOT to be it. This book has all you need to help you excel at Excel.
Publisher resources
Table of contents
- Excel: 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. Formatting Worksheets
-
5. Managing Worksheets and Workbooks
-
5.1. Worksheets and Workbooks
- 5.1.1. Adding, Removing, and Hiding Worksheets
- 5.1.2. Naming and Rearranging Worksheets
-
5.1.3. Grouping Sheets
- 5.1.3.1. Moving, copying, deleting, or hiding grouped worksheets
- 5.1.3.2. Formatting cells, columns, and rows in grouped worksheets
- 5.1.3.3. Entering data or changing cells in grouped worksheets
- 5.1.3.4. Cutting, copying, and pasting cells in grouped worksheets
- 5.1.3.5. Adjusting printing and display options in grouped worksheets
- 5.1.4. Moving Worksheets from One Workbook to Another
- 5.2. Find and Replace
- 5.3. Spell Check
-
5.1. Worksheets and Workbooks
- 6. Viewing and Printing Worksheets
-
II. Formulas and Functions
- 7. Building Basic Formulas
-
8. Math and Statistical Functions
- 8.1. Rounding Numbers
-
8.2. Groups of Numbers
- 8.2.1. SUM( ): Summing Up Numbers
- 8.2.2. COUNT( ), COUNTA( ), and COUNTBLANK( ): Counting Items in a List
- 8.2.3. MAX( ) and MIN( ): Finding Maximum and Minimum Values
- 8.2.4. LARGE( ), SMALL( ), and RANK( ): Ranking Your Numbers
- 8.2.5. AVERAGE( ) and MEDIAN( ): Finding Average or Median Values
- 8.2.6. MODE( ): Finding Numbers that Frequently Occur in a List
- 8.2.7. PERCENTILE( ) and PERCENTRANK( ): Advanced Ranking Functions
- 8.2.8. FREQUENCY( ): Identifying to Which Category a Number Belongs
-
8.3. General Math Functions
- 8.3.1. PRODUCT( ), FACT( ), POWER( ), and SQRT( ): Products, Factorials, Powers, and Square Roots
- 8.3.2. QUOTIENT( ) and MOD( ): Higher Division
- 8.3.3. ABS( ) and SIGN( ): Absolute Value and Determining a Number’s Sign
- 8.3.4. RAND( ) and RANDBETWEEN( ): Generating Random Numbers
- 8.3.5. GCD( ) and LCM( ): Greatest and Least Common Denominator
- 8.3.6. COMBIN( ) and PERMUT( ): Figuring Combinations and Permutations
- 8.4. Trigonometry and Advanced Math
- 8.5. Advanced Statistics
-
9. Financial Functions
- 9.1. The World of Finance
-
9.2. Financial Functions
- 9.2.1. FV( ): Future Value
- 9.2.2. PV( ): Present Value
- 9.2.3. PMT( ), PPMT( ), and IPMT( ): Calculating the Number of Payments You Need to Make
- 9.2.4. NPER( ): Figuring Out How Much Time You’ll Need to Pay Off a Loan or Meet an Investment Target
- 9.2.5. RATE( ): Figuring the Interest Rate You Need to Achieve Future Value
- 9.2.6. NPV( ) and IRR( ): Net Present Value and Internal Rate of Return
- 9.3. Depreciation
- 9.4. Other Financial Functions
-
10. Manipulating Dates, Times, and Text
-
10.1. Manipulating Text
- 10.1.1. CONCATENATE( ): Joining Strings of Text Together
- 10.1.2. LEFT( ), MID( ), and RIGHT( ): Copying Portions of a Text String
- 10.1.3. LEN( ), FIND( ), and SEARCH( ): Counting Characters in a String
- 10.1.4. UPPER( ), LOWER( ), and PROPER( ): Changing Capitalization
- 10.1.5. TRIM( ) and CLEAN( ): Removing Unwanted Spaces and Non-Printing Characters
- 10.1.6. SUBSTITUTE( ): Replacing One Sequence of Characters with Another
- 10.1.7. TEXT( ), VALUE( ), FIXED( ), and DOLLAR( ): Converting Text to Numbers and Vice Versa
- 10.1.8. Other Text Functions
- 10.2. Manipulating Dates and Times
- 10.3. Math with Dates and Times
-
10.4. Date and Time Functions
- 10.4.1. TODAY( ) and NOW( ): Inserting the Current Date and Time
- 10.4.2. DATE( ) and TIME( ): Dates and Times in Calculations
- 10.4.3. DAY( ), MONTH( ), and YEAR( ): More Date Calculations
- 10.4.4. HOUR( ), MINUTE( ), SECOND( ): More Time Calculations
- 10.4.5. WEEKDAY( ): Determining the Day of the Week
- 10.4.6. DATEDIF( ): Calculating the Difference Between Dates
- 10.4.7. DATEVALUE( ) and TIMEVALUE( ): Converting Dates and Times into Serial Numbers
- 10.4.8. DAYS360( ): Finding Out the Number of Days Between Two Dates
-
10.5. Analysis ToolPak Date Functions
- 10.5.1. EDATE( ): Calculating Future Dates
- 10.5.2. YEARFRAC( ): Calculating the Percentage of a Year Between Two Dates
- 10.5.3. EOMONTH( )
- 10.5.4. NETWORKDAYS( ): Counting the Number of Business Days
- 10.5.5. WORKDAY( ): Figuring Out When Days Will Fall in the Future
- 10.5.6. WEEKNUM( ): Figuring Out in Which Week a Date Falls
-
10.1. Manipulating Text
-
11. Lookup, Reference, and Information Functions
- 11.1. The Basic Lookup
-
11.2. Advanced Lookups
- 11.2.1. MATCH( ): Finding the Position of Items in a Range
- 11.2.2. INDEX( ): Retrieving the Value from a Cell
- 11.2.3. Performing a “Left Lookup”
- 11.2.4. Performing a Double Lookup
- 11.2.5. The Lookup Wizard
- 11.2.6. OFFSET( ): Moving Cell References to a New Location
- 11.2.7. Other Reference and Lookup Functions
- 11.2.8. INDIRECT( ) and ADDRESS( ): Working with Cell References Stored as Text
- 11.2.9. TRANSPOSE( ): Changing Rows into Columns and Vice Versa
- 11.3. Information Functions
- 11.4. Tutorial: Quickly Generating Invoices from a Product Catalog
- 12. Advanced Formula Writing
- III. Organizing Worksheets
-
IV. Charts and Graphics
- 16. Creating Basic Charts
-
17. Formatting and Perfecting Charts
-
17.1. Formatting Chart Elements
- 17.1.1. Manipulating Chart Elements
- 17.1.2. The Chart Toolbar
- 17.1.3. Coloring the Background
- 17.1.4. Fancy Fills
- 17.1.5. Adding Titles
- 17.1.6. Adding a Legend
- 17.1.7. Adding Data Labels to a Series
- 17.1.8. Adding Individual Data Labels
- 17.1.9. Formatting Data Series and Data Points
- 17.1.10. Controlling a Chart’s Scale
- 17.2. Improving Your Charts
- 17.3. Advanced Charting
-
17.1. Formatting Chart Elements
- 18. Inserting Graphics
- V. Advanced Data Analysis
-
VI. Sharing Data with the Rest of the World
- 21. Worksheet Collaboration
- 22. Exchanging Data with Other Programs
- 23. XML
- 24. Connecting Worksheets to the Web
- VII. Programming Excel
-
VII. Appendixes
- A. Getting Help in Excel
- B. Customizing Excel
-
C. Quick Menu Reference
- C.1. File Menu
- C.2. Edit Menu
- C.3. View Menu
- C.4. Insert Menu
- C.5. Format Menu
-
C.6. Tools Menu
- C.6.1. Spelling
- C.6.2. Research
- C.6.3. Error Checking
- C.6.4. Speech
- C.6.5. Shared Workspace
- C.6.6. Share Workbook
- C.6.7. Track Changes
- C.6.8. Compare and Merge Workbooks
- C.6.9. Protection
- C.6.10. Online Collaboration
- C.6.11. Goal Seek
- C.6.12. Scenarios
- C.6.13. Formula Auditing
- C.6.14. Solver
- C.6.15. Macro
- C.6.16. Add-Ins
- C.6.17. AutoCorrect Options
- C.6.18. Customize
- C.6.19. Options
- C.6.20. Data Analysis
- C.7. Data Menu
- C.8. Chart Menu
- C.9. Window Menu
- C.10. Help Menu
- Index
- About the Author
- Colophon
- Copyright
Product information
- Title: Excel 2003: The Missing Manual
- Author(s):
- Release date: December 2004
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9780596006648
You might also like
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 with Microsoft® Excel 2003
The world of mathematical formulas and jargon in Microsoft Excel is complex and can be intimidating …
book
Excel 2010: The Missing Manual
Excel, the world's most popular spreadsheet program, has the muscle to analyze heaps of data. Beyond …
book
Microsoft® Office Excel 2003 Inside Out
Take your Microsoft Excel experience to the next level! This supremely organized reference packs hundreds of …