SINGAPORE
Law
Welcome Guest | ログイン
検索
詳細検索
Excel 2010 Bible (PAP/CDR): Walkenbach, John: BOOKS KINOKUNIYA
詳細
Excel 2010 Bible (PAP/CDR)
Excel 2010 Bible (PAP/CDR)
著者名 Walkenbach, John
出版社 : John Wiley & Sons Inc
出版年月 : 2010/05
Binding : Paperback
ISBN : 9780470474877

BookWeb価格 : S$ 62.01
会員価格 : S$ 49.61

在庫情報 : 配送センターに在庫があります。
通常、5日以内に発送いたします。
言語 : English
Stock Information
Store Shelf Location Click here Stock
Singapore Main Store G15-06, H02-06, H09-01 Map
Liang Court Store -
Bugis Junction Store -
Important
  • While every attempt has been made to ensure stock availability, occasionally we do run out of stock at our stores.
  • Retail store and online prices may vary.
  • To confirm availability and pricing, please call the store directly.
Retail Store Contact Details and Operating Hours

内容情報
Source: ENG
Academic Descriptors: A93905800 A48401631
Place of Publication: United States
Continuations: Monograph Series,any number
Textual Format: Computer Applications
Academic Level: Extracurricular
Review:
Baker & Taylor Newly Released Computer Titles - January 2002 - Ongoing
Baker & Taylor Best-seller And Forthcoming Computer Titles - January 2000 - Ongoing
Table of Contents
 
Acknowledgments                                    xxxvii
Introduction                                       xxxviii
  Part I Getting Started with Excel                1     (192)
    Chapter 1 Introducing Excel                    3     (26)
      What Is Excel Good For?                      3     (1)
      What's New in Excel 2010?                    4     (1)
      Understanding Workbooks and Worksheets       5     (3)
      Moving around a Worksheet                    8     (3)
        Navigating with your keyboard              9     (1)
        Navigating with your mouse                 10    (1)
      Introducing the Ribbon                       11    (5)
        Ribbon tabs                                11    (2)
        Contextual tabs                            13    (1)
        Types of commands on the Ribbon            13    (2)
        Accessing the Ribbon by using your         15    (1)
        keyboard
      Using Shortcut Menus                         16    (1)
      Customizing Your Quick Access Toolbar        17    (2)
      Working with Dialog Boxes                    19    (3)
        Navigating dialog boxes                    19    (1)
        Using tabbed dialog boxes                  20    (2)
      Using the Task Pane                          22    (1)
      Creating Your First Excel Worksheet          22    (7)
        Getting started on your worksheet          22    (1)
        Filling in the month names                 23    (1)
        Entering the sales data                    23    (1)
        Formatting the numbers                     24    (1)
        Making your worksheet look a bit fancier   25    (1)
        Summing the values                         25    (1)
        Creating a chart                           26    (1)
        Printing your worksheet                    27    (1)
        Saving your workbook                       28    (1)
    Chapter 2 Entering and Editing Worksheet       29    (20)
    Data
      Exploring the Types of Data You Can Use      29    (3)
        About numeric values                       30    (1)
        About text entries                         30    (1)
        About formulas                             30    (2)
      Entering Text and Values into Your           32    (1)
      Worksheets
      Entering Dates and Times into Your           33    (1)
      Worksheets
        Entering date values                       33    (1)
        Entering time values                       34    (1)
      Modifying Cell Contents                      34    (8)
        Erasing the contents of a cell             35    (1)
        Replacing the contents of a cell           35    (1)
        Editing the contents of a cell             35    (2)
        Learning some handy data-entry             37    (1)
        techniques
        Automatically moving the cell pointer      37    (1)
        after entering data
        Using navigation keys instead of           37    (1)
        pressing Enter
        Selecting a range of input cells before    38    (1)
        entering data
        Using Ctrl+Enter to place information      38    (1)
        into multiple cells simultaneously
        Entering decimal points automatically      38    (1)
        Using AutoFill to enter a series of        38    (1)
        values
        Using AutoComplete to automate data        39    (1)
        entry
        Forcing text to appear on a new line       40    (1)
        within a cell
        Using AutoCorrect for shorthand data       40    (1)
        entry
        Entering numbers with fractions            40    (1)
        Simplifying data entry by using a form     40    (2)
        Entering the current date or time into     42    (1)
        a cell
      Applying Number Formatting                   42    (7)
        Using automatic number formatting          43    (1)
        Formatting numbers by using the Ribbon     44    (1)
        Using shortcut keys to format numbers      45    (1)
        Formatting numbers using the Format        45    (2)
        Cells dialog box
        Adding your own custom number formats      47    (2)
    Chapter 3 Essential Worksheet Operations       49    (20)
      Learning the Fundamentals of Excel           49    (9)
      Worksheets
        Working with Excel windows                 49    (2)
        Moving and resizing windows                51    (1)
        Switching among windows                    52    (1)
        Closing windows                            52    (1)
        Activating a worksheet                     53    (1)
        Adding a new worksheet to your workbook    54    (1)
        Deleting a worksheet you no longer need    54    (1)
        Changing the name of a worksheet           55    (1)
        Changing a sheet tab color                 56    (1)
        Rearranging your worksheets                56    (1)
        Hiding and unhiding a worksheet            57    (1)
      Controlling the Worksheet View               58    (7)
        Zooming in or out for a better view        59    (1)
        Viewing a worksheet in multiple windows    60    (1)
        Comparing sheets side by side              61    (1)
        Splitting the worksheet window into        62    (1)
        panes
        Keeping the titles in view by freezing     62    (2)
        panes
        Monitoring cells with a Watch Window       64    (1)
      Working with Rows and Columns                65    (4)
        Inserting rows and columns                 65    (1)
        Deleting rows and columns                  66    (1)
        Hiding rows and columns                    66    (1)
        Changing column widths and row heights     67    (1)
        Changing column widths                     67    (1)
        Changing row heights                       68    (1)
    Chapter 4 Working with Cells and Ranges        69    (30)
      Understanding Cells and Ranges               69    (9)
        Selecting ranges                           70    (1)
        Selecting complete rows and columns        71    (1)
        Selecting noncontiguous ranges             71    (1)
        Selecting multisheet ranges                72    (2)
        Selecting special types of cells           74    (2)
        Selecting cells by searching               76    (2)
      Copying or Moving Ranges                     78    (11)
        Copying by using Ribbon commands           79    (1)
        Copying by using shortcut menu commands    80    (1)
        Copying by using shortcut keys             81    (1)
        Copying or moving by using drag-and-drop   81    (1)
        Copying to adjacent cells                  82    (1)
        Copying a range to other sheets            83    (1)
        Using the Office Clipboard to paste        84    (1)
        Pasting in special ways                    85    (2)
        Using the Paste Special Dialog box         87    (1)
        Performing mathematical operations         88    (1)
        without formulas
        Skipping blanks when pasting               89    (1)
        Transposing a range                        89    (1)
      Using Names to Work with Ranges              89    (5)
        Creating range names in your workbooks     90    (1)
        Using the New Name dialog box              90    (1)
        Using the Name box                         91    (1)
        Using the Create Names from Selection      91    (1)
        dialog box
        Managing names                             92    (2)
      Adding Comments to Cells                     94    (5)
        Formatting comments                        95    (1)
        Changing a comment's shape                 96    (1)
        Reading comments                           96    (1)
        Printing comments                          96    (1)
        Hiding and showing comments                97    (1)
        Selecting comments                         97    (1)
        Editing comments                           98    (1)
        Deleting comments                          98    (1)
    Chapter 5 Introducing Tables                   99    (16)
      What Is a Table?                             99    (3)
      Creating a Table                             102   (1)
      Changing the Look of a Table                 103   (2)
      Working with Tables                          105   (10)
        Navigating in a table                      105   (1)
        Selecting parts of a table                 105   (1)
        Adding new rows or columns                 105   (1)
        Deleting rows or columns                   106   (1)
        Moving a table                             106   (1)
        Setting table options                      107   (1)
        Working with the Total Row                 107   (2)
        Removing duplicate rows from a table       109   (1)
        Sorting and filtering a table              110   (1)
        Sorting a table                            110   (2)
        Filtering a table                          112   (1)
        Converting a table back to a range         113   (2)
    Chapter 6 Worksheet Formatting                 115   (26)
      Getting to Know the Formatting Tools         115   (4)
        Using the formatting tools of the Home     116   (1)
        Tab
        Using the Mini toolbar                     116   (2)
        Using the Format Cells dialog box          118   (1)
      Using Different Fonts to Format Your         119   (3)
      Worksheet
      Changing Text Alignment                      122   (5)
        Choosing horizontal alignment options      122   (2)
        Choosing vertical alignment options        124   (1)
        Wrapping or shrinking text to fit the      124   (1)
        cell
        Merging worksheet cells to create          124   (1)
        additional text space
        Displaying text at an angle                125   (1)
        Controlling the text direction             126   (1)
      Using Colors and Shading                     127   (1)
      Adding Borders and Lines                     128   (2)
      Adding a Background Image to a Worksheet     130   (1)
      Using Named Styles for Easier Formatting     131   (4)
        Applying styles                            132   (1)
        Modifying an existing style                133   (1)
        Creating new styles                        134   (1)
        Merging styles from other workbooks        134   (1)
        Controlling styles with templates          135   (1)
      Understanding Document Themes                135   (6)
        Applying a theme                           137   (1)
        Customizing a theme                        138   (3)
    Chapter 7 Understanding Excel Files            141   (20)
      Creating a New Workbook                      141   (2)
      Opening an Existing Workbook                 143   (4)
        Using the Favorite Links                   146   (1)
        Filtering filenames                        146   (1)
        Choosing your file display preferences     147   (1)
      Saving a Workbook                            147   (2)
      Using AutoRecover                            149   (1)
        Recovering versions of the current         149   (1)
        workbook
        Recovering unsaved work                    149   (1)
      Specifying a Password                        150   (1)
      Organizing Your Files                        151   (2)
      Other Workbook Info Options                  153   (3)
        Security Warning section                   153   (1)
        Compatibility Mode section                 154   (1)
        Permissions section                        154   (1)
        Prepare for Sharing section                155   (1)
        Versions section                           156   (1)
      Closing Workbooks                            156   (1)
      Safeguarding Your Work                       157   (1)
      Excel File Compatibility                     157   (4)
        Checking compatibility                     157   (2)
        Recognizing the Excel 2010 file formats    159   (1)
        Saving a file for use with an older        159   (2)
        version of Excel
    Chapter 8 Using and Creating Templates         161   (10)
      Exploring Excel Templates                    161   (4)
        Viewing templates                          161   (1)
        Creating a workbook from a template        162   (2)
        Modifying a template                       164   (1)
      Understanding Custom Excel Templates         165   (6)
        Working with the default templates         166   (1)
        Using the workbook template to change      166   (1)
        workbook defaults
        Using the worksheet template to change     167   (1)
        worksheet defaults
        Editing your templates                     168   (1)
        Resetting the default workbook and         168   (1)
        worksheet settings
        Creating custom templates                  168   (2)
        Saving your custom templates               170   (1)
        Ideas for creating templates               170   (1)
    Chapter 9 Printing Your Work                   171   (22)
      Printing with One Click                      171   (1)
      Changing Your Page View                      172   (5)
        Normal view                                173   (1)
        Page Layout view                           174   (1)
        Page Break Preview                         175   (2)
      Adjusting Common Page Setup Settings         177   (8)
        Choosing your printer                      178   (1)
        Specifying what you want to print          178   (1)
        Changing page orientation                  179   (1)
        Specifying paper size                      179   (1)
        Printing multiple copies of a report       180   (1)
        Adjusting page margins                     180   (1)
        Understanding page breaks                  181   (1)
        Inserting a page break                     181   (1)
        Removing manual page breaks                182   (1)
        Printing row and column titles             182   (1)
        Scaling printed output                     183   (1)
        Printing cell gridlines                    183   (2)
        Printing row and column headers            185   (1)
        Using a background image                   185   (1)
      Adding a Header or Footer to Your Reports    185   (3)
        Selecting a predefined header or footer    186   (1)
        Understanding header and footer element    186   (1)
        codes
        Other header and footer options            187   (1)
      Copying Page Setup Settings across Sheets    188   (1)
      Preventing Certain Cells from Being          188   (1)
      Printed
      Preventing Objects from Being Printed        189   (1)
      Creating Custom Views of Your Worksheet      190   (3)
  Part II Working with Formulas and Functions      193   (208)
    Chapter 10 Introducing Formulas and            195   (34)
    Functions
      Understanding Formula Basics                 195   (7)
        Using operators in formulas                196   (1)
        Understanding operator precedence in       197   (2)
        formulas
        Using functions in your formulas           199   (1)
        Examples of formulas that use functions    200   (1)
        Function arguments                         201   (1)
        More about functions                       202   (1)
      Entering Formulas into Your Worksheets       202   (7)
        Entering formulas manually                 203   (1)
        Entering formulas by pointing              203   (2)
        Pasting range names into formulas          205   (1)
        Inserting functions into formulas          206   (2)
        Function entry tips                        208   (1)
      Editing Formulas                             209   (1)
      Using Cell References in Formulas            209   (5)
        Using relative, absolute, and mixed        210   (2)
        references
        Changing the types of your references      212   (1)
        Referencing cells outside the worksheet    212   (1)
        Referencing cells in other worksheets      213   (1)
        Referencing cells in other workbooks       213   (1)
      Using Formulas in Tables                     214   (4)
        Summarizing data in a table                214   (2)
        Using formulas within a table              216   (1)
        Referencing data in a table                217   (1)
      Correcting Common Formula Errors             218   (4)
        Handling circular references               219   (1)
        Specifying when formulas are calculated    220   (2)
      Using Advanced Naming Techniques             222   (5)
        Using names for constants                  222   (1)
        Using names for formulas                   223   (1)
        Using range intersections                  224   (2)
        Applying names to existing references      226   (1)
      Tips for Working with Formulas               227   (2)
        Don't hard-code values                     227   (1)
        Using the Formula bar as a calculator      227   (1)
        Making an exact copy of a formula          227   (1)
        Converting formulas to values              228   (1)
    Chapter 11 Creating Formulas That              229   (20)
    Manipulate Text
      A Few Words about Text                       229   (1)
      Text Functions                               230   (13)
        Working with character codes               231   (1)
        The CODE function                          232   (1)
        The CHAR function                          232   (1)
        Determining whether two strings are        233   (1)
        identical
        Joining two or more cells                  234   (1)
        Displaying formatted values as text        235   (1)
        Displaying formatted currency values as    236   (1)
        text
        Repeating a character or string            236   (1)
        Creating a text histogram                  237   (1)
        Padding a number                           238   (1)
        Removing excess spaces and nonprinting     239   (1)
        characters
        Counting characters in a string            239   (1)
        Changing the case of text                  239   (1)
        Extracting characters from a string        240   (1)
        Replacing text with other text             241   (1)
        Finding and searching within a string      242   (1)
        Searching and replacing within a string    242   (1)
      Advanced Text Formulas                       243   (6)
        Counting specific characters in a cell     243   (1)
        Counting the occurrences of a substring    243   (1)
        in a cell
        Extracting a filename from a path          244   (1)
        specification
        Extracting the first word of a string      244   (1)
        Extracting the last word of a string       244   (1)
        Extracting all but the first word of a     245   (1)
        string
        Extracting first names, middle names,      245   (2)
        and last names
        Removing titles from names                 247   (1)
        Creating an ordinal number                 247   (1)
        Counting the number of words in a cell     248   (1)
    Chapter 12 Working with Dates and Times        249   (32)
      How Excel Handles Dates and Times            249   (9)
        Understanding date serial numbers          249   (1)
        Entering dates                             250   (2)
        Understanding time serial numbers          252   (1)
        Entering times                             253   (1)
        Formatting dates and times                 254   (1)
        Problems with dates                        255   (1)
        Excel's leap year bug                      255   (1)
        Pre-1900 dates                             256   (1)
        Inconsistent date entries                  257   (1)
      Date-Related Worksheet Functions             258   (14)
        Displaying the current date                259   (1)
        Displaying any date                        259   (1)
        Generating a series of dates               260   (1)
        Converting a nondate string to a date      261   (1)
        Calculating the number of days between     262   (1)
        two dates
        Calculating the number of work days        263   (1)
        between two dates
        Offsetting a date using only work days     264   (1)
        Calculating the number of years between    265   (1)
        two dates
        Calculating a person's age                 265   (1)
        Determining the day of the year            266   (1)
        Determining the day of the week            267   (1)
        Determining the date of the most recent    267   (1)
        Sunday
        Determining the first day of the week      267   (1)
        after a date
        Determining the nth occurrence of a day    268   (1)
        of the week in a month
        Calculating dates of holidays              268   (1)
        New Year's Day                             269   (1)
        Martin Luther King, Jr. Day                269   (1)
        Presidents' Day                            269   (1)
        Easter                                     270   (1)
        Memorial Day                               270   (1)
        Independence Day                           270   (1)
        Labor Day                                  270   (1)
        Columbus Day                               270   (1)
        Veterans Day                               270   (1)
        Thanksgiving Day                           271   (1)
        Christmas Day                              271   (1)
        Determining the last day of a month        271   (1)
        Determining whether a year is a leap       271   (1)
        year
        Determining a date's quarter               272   (1)
      Time-Related Functions                       272   (9)
        Displaying the current time                272   (1)
        Displaying any time                        273   (1)
        Calculating the difference between two     274   (1)
        times
        Summing times that exceed 24 hours         275   (2)
        Converting from military time              277   (1)
        Converting decimal hours, minutes, or      277   (1)
        seconds to a time
        Adding hours, minutes, or seconds to a     278   (1)
        time
        Rounding time values                       279   (1)
        Working with non-time-of-day values        279   (2)
    Chapter 13 Creating Formulas That Count and    281   (28)
    Sum
      Counting and Summing Worksheet Cells         281   (2)
      Basic Counting Formulas                      283   (3)
        Counting the total number of cells         283   (1)
        Counting blank cells                       284   (1)
        Counting nonblank cells                    285   (1)
        Counting numeric cells                     285   (1)
        Counting text cells                        285   (1)
        Counting nontext cells                     285   (1)
        Counting logical values                    286   (1)
        Counting error values in a range           286   (1)
      Advanced Counting Formulas                   286   (13)
        Counting cells by using the COUNTIF        287   (1)
        function
        Counting cells based on multiple           288   (1)
        criteria
        Using And criteria                         289   (1)
        Using Or criteria                          290   (1)
        Combining And and Or criteria              290   (1)
        Counting the most frequently occurring     291   (1)
        entry
        Counting the occurrences of specific       292   (1)
        text
        Entire cell contents                       292   (1)
        Partial cell contents                      292   (1)
        Total occurrences in a range               293   (1)
        Counting the number of unique values       293   (1)
        Creating a frequency distribution          294   (1)
        The FREQUENCY function                     294   (2)
        Using formulas to create a frequency       296   (1)
        distribution
        Using the Analysis ToolPak to create a     297   (1)
        frequency distribution
        Using a pivot table to create a            298   (1)
        frequency distribution
      Summing Formulas                             299   (4)
        Summing all cells in a range               299   (1)
        Computing a cumulative sum                 300   (2)
        Summing the "top n" values                 302   (1)
      Conditional Sums Using a Single Criterion    303   (2)
        Summing only negative values               304   (1)
        Summing values based on a different        304   (1)
        range
        Summing values based on a text             304   (1)
        comparison
        Summing values based on a date             305   (1)
        comparison
      Conditional Sums Using Multiple Criteria     305   (4)
        Using And criteria                         305   (1)
        Using Or criteria                          306   (1)
        Using And and Or criteria                  307   (2)
    Chapter 14 Creating Formulas That Look Up      309   (20)
    Values
      Introducing Lookup Formulas                  309   (1)
      Functions Relevant to Lookups                310   (2)
      Basic Lookup Formulas                        312   (6)
        The VLOOKUP function                       312   (1)
        The HLOOKUP function                       313   (1)
        The LOOKUP function                        314   (2)
        Combining the MATCH and INDEX functions    316   (2)
      Specialized Lookup Formulas                  318   (11)
        Looking up an exact value                  318   (1)
        Looking up a value to the left             319   (1)
        Performing a case-sensitive lookup         320   (1)
        Looking up a value from multiple lookup    321   (1)
        tables
        Determining letter grades for test         322   (1)
        scores
        Calculating a grade-point average          322   (1)
        Performing a two-way lookup                323   (2)
        Performing a two-column lookup             325   (1)
        Determining the cell address of a value    326   (1)
        within a range
        Looking up a value by using the closest    327   (2)
        match
    Chapter 15 Creating Formulas for Financial     329   (26)
    Applications
      The Time Value of Money                      329   (1)
      Loan Calculations                            330   (13)
        Worksheet functions for calculating        331   (1)
        loan information
        PMT                                        331   (1)
        PPMT                                       331   (1)
        IPMT                                       332   (1)
        RATE                                       332   (1)
        NPER                                       333   (1)
        PV                                         333   (1)
        A loan calculation example                 333   (1)
        Credit card payments                       334   (3)
        Creating a loan amortization schedule      337   (1)
        Summarizing loan options by using a        338   (1)
        data table
        Creating a one-way data table              338   (2)
        Creating a two-way data table              340   (1)
        Calculating a loan with irregular          341   (2)
        payments
      Investment Calculations                      343   (7)
        Future value of a single deposit           343   (1)
        Calculating simple interest                343   (1)
        Calculating compound interest              344   (2)
        Calculating interest with continuous       346   (2)
        compounding
        Future value of a series of deposits       348   (2)
      Depreciation Calculations                    350   (5)
    Chapter 16 Introducing Array Formulas          355   (24)
      Understanding Array Formulas                 355   (5)
        A multicell array formula                  356   (1)
        A single-cell array formula                357   (1)
        Creating an array constant                 358   (2)
        Array constant elements                    360   (1)
      Understanding the Dimensions of an Array     360   (2)
        One-dimensional horizontal arrays          360   (1)
        One-dimensional vertical arrays            361   (1)
        Two-dimensional arrays                     361   (1)
      Naming Array Constants                       362   (2)
      Working with Array Formulas                  364   (2)
        Entering an array formula                  364   (1)
        Selecting an array formula range           364   (1)
        Editing an array formula                   364   (1)
        Expanding or contracting a multicell       365   (1)
        array formula
      Using Multicell Array Formulas               366   (5)
        Creating an array from values in a range   366   (1)
        Creating an array constant from values     367   (1)
        in a range
        Performing operations on an array          368   (1)
        Using functions with an array              369   (1)
        Transposing an array                       369   (1)
        Generating an array of consecutive         370   (1)
        integers
      Using Single-Cell Array Formulas             371   (8)
        Counting characters in a range             371   (1)
        Summing the three smallest values in a     372   (1)
        range
        Counting text cells in a range             373   (1)
        Eliminating intermediate formulas          374   (2)
        Using an array in lieu of a range          376   (3)
        reference
    Chapter 17 Performing Magic with Array         379   (22)
    Formulas
      Working with Single-Cell Array Formulas      379   (15)
        Summing a range that contains errors       379   (1)
        Counting the number of error values in     380   (1)
        a range
        Summing the n largest values in a range    381   (1)
        Computing an average that excludes zeros   381   (2)
        Determining whether a particular value     383   (1)
        appears in a range
        Counting the number of differences in      384   (1)
        two ranges
        Returning the location of the maximum      384   (1)
        value in a range
        Finding the row of a value's nth           385   (1)
        occurrence in a range
        Returning the longest text in a range      385   (1)
        Determining whether a range contains       386   (1)
        valid values
        Summing the digits of an integer           386   (2)
        Summing rounded values                     388   (1)
        Summing every nth value in a range         388   (2)
        Removing non-numeric characters from a     390   (1)
        string
        Determining the closest value in a range   391   (1)
        Returning the last value in a column       391   (1)
        Returning the last value in a row          392   (1)
        Ranking data with an array formula         392   (2)
      Working with Multicell Array Formulas        394   (7)
        Returning only positive values from a      394   (1)
        range
        Returning nonblank cells from a range      394   (1)
        Reversing the order of cells in a range    395   (1)
        Sorting a range of values dynamically      396   (1)
        Returning a list of unique items in a      396   (2)
        range
        Displaying a calendar in a range           398   (3)
  Part III Creating Charts and Graphics            401   (138)
    Chapter 18 Getting Started Making Charts       403   (34)
      What Is a Chart?                             403   (1)
      Understanding How Excel Handles Charts       404   (4)
        Embedded charts                            405   (1)
        Chart sheets                               406   (2)
      Creating a Chart                             408   (1)
      Hands On: Creating and Customizing a Chart   408   (5)
        Selecting the data                         408   (1)
        Choosing a chart type                      409   (1)
        Experimenting with different layouts       409   (2)
        Trying another view of the data            411   (1)
        Trying other chart types                   412   (1)
        Trying other chart styles                  412   (1)
      Working with Charts                          413   (4)
        Resizing a chart                           414   (1)
        Moving a chart                             414   (1)
        Copying a chart                            414   (1)
        Deleting a chart                           414   (1)
        Adding chart elements                      415   (1)
        Moving and deleting chart elements         415   (1)
        Formatting chart elements                  415   (1)
        Printing charts                            416   (1)
      Understanding Chart Types                    417   (19)
        Choosing a chart type                      417   (2)
        Column                                     419   (3)
        Bar                                        422   (1)
        Line                                       423   (1)
        Pie                                        424   (2)
        XY (scatter)                               426   (1)
        Area                                       427   (2)
        Doughnut                                   429   (1)
        Radar                                      430   (2)
        Surface                                    432   (1)
        Bubble                                     433   (1)
        Stock                                      433   (3)
      Learning More                                436   (1)
    Chapter 19 Learning Advanced Charting          437   (44)
      Selecting Chart Elements                     437   (4)
        Selecting with the mouse                   438   (1)
        Selecting with the keyboard                439   (1)
        Selecting with the Chart Element control   439   (2)
      User Interface Choices for Modifying         441   (2)
      Chart Elements
        Using the Format dialog box                441   (1)
        Using the Ribbon                           442   (1)
        Using the Mini toolbar                     442   (1)
      Modifying the Chart Area                     443   (1)
      Modifying the Plot Area                      444   (1)
      Working with Chart Titles                    445   (1)
      Working with a Legend                        446   (2)
      Working with Gridlines                       448   (1)
      Modifying the Axes                           448   (7)
        Value axis                                 448   (4)
        Category axis                              452   (3)
      Working with Data Series                     455   (14)
        Deleting a data series                     456   (1)
        Adding a new data series to a chart        456   (1)
        Changing data used by a series             457   (1)
        Changing the data range by dragging the    457   (1)
        range outline
        Using the Edit Series dialog box           458   (1)
        Editing the Series formula                 459   (1)
        Displaying data labels in a chart          460   (1)
        Handling missing data                      461   (1)
        Adding error bars                          461   (2)
        Adding a trendline                         463   (1)
        Modifying 3-D charts                       464   (1)
        Creating combination charts                465   (3)
        Displaying a data table                    468   (1)
      Creating Chart Templates                     469   (1)
      Learning Some Chart-Making Tricks            470   (11)
        Creating picture charts                    470   (2)
        Creating a thermometer chart               472   (1)
        Creating a gauge chart                     473   (1)
        Displaying conditional colors in a         474   (1)
        column chart
        Creating a comparative histogram           475   (1)
        Creating a Gantt chart                     476   (1)
        Plotting mathematical functions with       477   (2)
        one variable
        Plotting mathematical functions with       479   (2)
        two variables
    Chapter 20 Visualizing Data Using              481   (22)
    Conditional Formatting
      About Conditional Formatting                 481   (2)
      Specifying Conditional Formatting            483   (2)
        Formatting types you can apply             483   (1)
        Making your own rules                      484   (1)
      Conditional Formats That Use Graphics        485   (9)
        Using data bars                            485   (1)
        A simple data bar                          486   (1)
        Using data bars in lieu of a chart         487   (1)
        Using color scales                         487   (1)
        A color scale example                      488   (1)
        An extreme color scale example             489   (1)
        Using icon sets                            490   (1)
        An icon set example                        491   (1)
        Another icon set example                   492   (2)
      Creating Formula-Based Rules                 494   (5)
        Understanding relative and absolute        495   (1)
        references
        Conditional formatting formula examples    496   (1)
        Identifying weekend days                   496   (1)
        Displaying alternate-row shading           497   (1)
        Creating checkerboard shading              497   (1)
        Shading groups of rows                     497   (1)
        Displaying a total only when all values    498   (1)
        are entered
      Working with Conditional Formats             499   (4)
        Managing rules                             499   (1)
        Copying cells that contain conditional     500   (1)
        formatting
        Deleting conditional formatting            500   (1)
        Locating cells that contain conditional    501   (2)
        formatting
    Chapter 21 Creating Sparkline Graphics         503   (14)
      Sparkline Types                              504   (1)
      Creating Sparklines                          505   (2)
      Customizing Sparklines                       507   (5)
        Sizing Sparkline cells                     507   (1)
        Handling hidden or missing data            508   (1)
        Changing the Sparkline type                508   (1)
        Changing Sparkline colors and line width   508   (1)
        Highlighting certain data points           509   (1)
        Adjusting Sparkline axis scaling           509   (1)
        Faking a reference line                    510   (2)
      Specifying a Date Axis                       512   (1)
      Auto-Updating Sparklines                     513   (1)
      Displaying a Sparkline for a Dynamic Range   514   (3)
    Chapter 22 Enhancing Your Work with            517   (22)
    Pictures and Drawings
      Using Shapes                                 517   (8)
        Inserting a Shape                          518   (2)
        Adding text to a Shape                     520   (1)
        Formatting Shapes                          520   (2)
        Grouping objects                           522   (1)
        Aligning and spacing objects               523   (1)
        Reshaping Shapes                           523   (1)
        Printing objects                           524   (1)
      Using SmartArt                               525   (5)
        Inserting SmartArt                         525   (2)
        Customizing SmartArt                       527   (1)
        Changing the layout                        528   (1)
        Changing the style                         528   (1)
        Learning more about SmartArt               529   (1)
      Using WordArt                                530   (1)
      Working with Other Graphic Types             531   (4)
        About graphics files                       531   (1)
        Using the Clip Art task pane               531   (1)
        Inserting graphics files                   532   (1)
        Inserting screenshots                      533   (2)
        Displaying a worksheet background image    535   (1)
      Using the Equation Editor                    535   (4)
  Part IV Using Advanced Excel Features            539   (136)
    Chapter 23 Customizing the Excel User          541   (10)
    Interface
      Customizing the Quick Access Toolbar         541   (5)
        About the Quick Access toolbar             542   (1)
        Adding new commands to the Quick Access    543   (2)
        toolbar
        Other Quick Access toolbar actions         545   (1)
      Customizing the Ribbon                       546   (5)
        Why customize the Ribbon                   546   (1)
        What can be customized                     546   (1)
        How to customize the Ribbon                547   (4)
    Chapter 24 Using Custom Number Formats         551   (18)
      About Number Formatting                      551   (4)
        Automatic number formatting                552   (1)
        Formatting numbers by using the Ribbon     552   (1)
        Using shortcut keys to format numbers      553   (1)
        Using the Format Cells dialog box to       554   (1)
        format numbers
      Creating a Custom Number Format              555   (5)
        Parts of a number format string            557   (1)
        Custom number format codes                 558   (2)
      Custom Number Format Examples                560   (9)
        Scaling values                             560   (1)
        Displaying values in thousands             560   (1)
        Displaying values in hundreds              561   (1)
        Displaying values in millions              562   (1)
        Adding zeros to a value                    563   (1)
        Displaying leading zeros                   564   (1)
        Displaying fractions                       564   (1)
        Displaying a negative sign on the right    565   (1)
        Formatting dates and times                 566   (1)
        Displaying text with numbers               566   (1)
        Suppressing certain types of entries       567   (1)
        Filling a cell with a repeating            568   (1)
        character
    Chapter 25 Using Data Validation               569   (12)
      About Data Validation                        569   (1)
      Specifying Validation Criteria               570   (1)
      Types of Validation Criteria You Can Apply   571   (2)
      Creating a Drop-Down List                    573   (1)
      Using Formulas for Data Validation Rules     574   (1)
      Understanding Cell References                574   (1)
      Data Validation Formula Examples             575   (6)
        Accepting text only                        576   (1)
        Accepting a larger value than the          576   (1)
        previous cell
        Accepting nonduplicate entries only        576   (1)
        Accepting text that begins with a          577   (1)
        specific character
        Accepting dates by the day of the week     577   (1)
        Accepting only values that don't exceed    578   (1)
        a total
        Creating a dependent list                  578   (3)
    Chapter 26 Creating and Using Worksheet        581   (8)
    Outlines
      Introducing Worksheet Outlines               581   (3)
      Creating an Outline                          584   (3)
        Preparing the data                         584   (1)
        Creating an outline automatically          585   (1)
        Creating an outline manually               586   (1)
      Working with Outlines                        587   (2)
        Displaying levels                          587   (1)
        Adding data to an outline                  588   (1)
        Removing an outline                        588   (1)
        Hiding the outline symbols                 588   (1)
    Chapter 27 Linking and Consolidating           589   (16)
    Worksheets
      Linking Workbooks                            589   (1)
      Creating External Reference Formulas         590   (2)
        Understanding link formula syntax          590   (1)
        Creating a link formula by pointing        591   (1)
        Pasting links                              591   (1)
      Working with External Reference Formulas     592   (3)
        Creating links to unsaved workbooks        592   (1)
        Opening a workbook with external           592   (2)
        reference formulas
        Changing the startup prompt                594   (1)
        Updating links                             594   (1)
        Changing the link source                   595   (1)
        Severing links                             595   (1)
      Avoiding Potential Problems with External    595   (2)
      Reference Formulas
        Renaming or moving a source workbook       596   (1)
        Using the Save As command                  596   (1)
        Modifying a source workbook                596   (1)
        Intermediary links                         597   (1)
      Consolidating Worksheets                     597   (8)
        Consolidating worksheets by using          598   (1)
        formulas
        Consolidating worksheets by using Paste    599   (1)
        Special
        Consolidating worksheets by using the      600   (1)
        Consolidate command
        A workbook consolidation example           601   (3)
        Refreshing a consolidation                 604   (1)
        More about consolidation                   604   (1)
    Chapter 28 Excel and the Internet              605   (10)
      Understanding How Excel Uses HTML            605   (1)
      Understanding the Different Web Formats      606   (3)
        Creating an HTML file                      607   (1)
        Creating a single file Web page            607   (2)
      Opening an HTML File                         609   (1)
      Working with Hyperlinks                      610   (2)
        Inserting a hyperlink                      610   (1)
        Using hyperlinks                           611   (1)
      Using Web Queries                            612   (2)
      Other Internet-Related Features              614   (1)
    Chapter 29 Sharing Data with Other Office      615   (12)
    Applications
      Copying and Pasting                          615   (2)
      Copying from Excel to Word                   617   (5)
        Pasting static information                 617   (3)
        Pasting a link                             620   (2)
      Embedding Objects in a Worksheet             622   (2)
        Embedding Word documents                   623   (1)
        Embedding other types of documents         623   (1)
      Embedding an Excel Workbook in a Word        624   (3)
      Document
        Embedding a workbook in Word by copying    624   (2)
        Embedding a saved workbook in Word         626   (1)
        Creating a new Excel object in Word        626   (1)
    Chapter 30 Using Excel in a Workgroup          627   (10)
      Using Excel on a Network                     627   (1)
      Understanding File Reservations              628   (1)
      Sharing Workbooks                            629   (4)
        Understanding shared workbooks             630   (1)
        Designating a workbook as a shared         631   (1)
        workbook
        Controlling the advanced sharing           632   (1)
        settings
        Tracking changes                           632   (1)
        Updating changes                           633   (1)
        Resolving conflicting changes between      633   (1)
        users
        Controlling the Include in Personal        633   (1)
        View settings
      Tracking Workbook Changes                    633   (4)
        Turning Track Changes on and off           633   (2)
        Reviewing the changes                      635   (2)
    Chapter 31 Protecting Your Work                637   (12)
      Types of Protection                          637   (1)
      Protecting a Worksheet                       638   (3)
        Unlocking cells                            639   (1)
        Sheet protection options                   640   (1)
        Assigning user permissions                 641   (1)
      Protecting a Workbook                        641   (3)
        Requiring a password to open a workbook    641   (2)
        Protecting a workbook's structure          643   (1)
        Protecting a workbook's windows            644   (1)
      VB Project Protection                        644   (1)
      Related Topics                               645   (4)
        Saving a worksheet as a PDF file           645   (1)
        Marking a workbook final                   646   (1)
        Inspecting a workbook                      646   (1)
        Using a digital signature                  646   (1)
        Getting a digital ID                       647   (1)
        Signing a workbook                         647   (2)
    Chapter 32 Making Your Worksheets Error-Free   649   (26)
      Finding and Correcting Formula Errors        649   (12)
        Mismatched parentheses                     650   (1)
        Cells are filled with hash marks           651   (1)
        Blank cells are not blank                  651   (1)
        Extra space characters                     652   (1)
        Formulas returning an error                653   (1)
        #DIV/0! errors                             653   (1)
        #N/A errors                                654   (1)
        #NAME? errors                              655   (1)
        #NULL! errors                              655   (1)
        #NUM! errors                               655   (1)
        #REF! errors                               656   (1)
        #VALUE! errors                             656   (1)
        Absolute/relative reference problems       657   (1)
        Operator precedence problems               657   (1)
        Formulas are not calculated                658   (1)
        Actual versus displayed values             658   (1)
        Floating point number errors               659   (1)
        "Phantom link" errors                      660   (1)
      Using Excel Auditing Tools                   661   (7)
        Identifying cells of a particular type     661   (1)
        Viewing formulas                           662   (1)
        Tracing cell relationships                 663   (1)
        Identifying precedents                     664   (1)
        Identifying dependents                     665   (1)
        Tracing error values                       665   (1)
        Fixing circular reference errors           665   (1)
        Using background error-checking feature    665   (2)
        Using the Excel Formula Evaluator          667   (1)
      Searching and Replacing                      668   (3)
        Searching for information                  669   (1)
        Replacing information                      670   (1)
        Searching for formatting                   670   (1)
      Spell Checking Your Worksheets               671   (1)
      Using AutoCorrect                            672   (3)
  Part V Analyzing Data with Excel                 675   (118)
    Chapter 33 Getting Data from External          677   (18)
    Database Files
      Understanding External Database Files        677   (2)
      Importing Access Tables                      679   (1)
      Retrieving Data with Query: An Example       680   (8)
        The database file                          681   (1)
        The task                                   681   (1)
        Selecting a data source                    682   (2)
        Using the Query Wizard                     684   (1)
        Query Wizard: Choosing the columns         684   (1)
        Query Wizard: Filtering data               685   (1)
        Query Wizard: Sort order                   686   (1)
        Query Wizard: Finish                       686   (1)
        Specifying a location for the data         687   (1)
      Working with Data Returned by Query          688   (2)
        Adjusting the external data range          688   (1)
        properties
        Refreshing a query                         689   (1)
        Deleting a query                           690   (1)
        Changing your query                        690   (1)
      Using Query without the Wizard               690   (3)
        Creating a query manually                  690   (2)
        Using multiple database tables             692   (1)
        Adding and editing records in external     693   (1)
        database tables
        Formatting data                            693   (1)
      Learning More about Query                    693   (2)
    Chapter 34 Introducing Pivot Tables            695   (20)
      About Pivot Tables                           695   (6)
        A pivot table example                      696   (2)
        Data appropriate for a pivot table         698   (3)
      Creating a Pivot Table                       701   (7)
        Specifying the data                        701   (1)
        Specifying the location for the pivot      701   (1)
        table
        Laying out the pivot table                 702   (1)
        Formatting the pivot table                 703   (3)
        Modifying the pivot table                  706   (2)
      More Pivot Table Examples                    708   (6)
        Question 1                                 708   (1)
        Question 2                                 709   (1)
        Question 3                                 710   (1)
        Question 4                                 710   (1)
        Question 5                                 711   (1)
        Question 6                                 712   (1)
        Question 7                                 713   (1)
      Learning More                                714   (1)
    Chapter 35 Analyzing Data with Pivot Tables    715   (30)
      Working with Non-Numeric Data                715   (2)
      Grouping Pivot Table Items                   717   (5)
        A manual grouping example                  717   (2)
        Automatic grouping examples                719   (1)
        Grouping by date                           719   (3)
        Grouping by time                           722   (1)
      Creating a Frequency Distribution            722   (2)
      Creating a Calculated Field or Calculated    724   (7)
      Item
        Creating a calculated field                726   (2)
        Inserting a calculated item                728   (3)
      Filtering Pivot Tables with Slicers          731   (2)
      Referencing Cells within a Pivot Table       733   (2)
      Creating Pivot Charts                        735   (4)
        A pivot chart example                      736   (2)
        More about pivot charts                    738   (1)
      Another Pivot Table Example                  739   (3)
      Producing a Report with a Pivot Table        742   (3)
    Chapter 36 Performing Spreadsheet What-If      745   (16)
    Analysis
      A What-If Example                            745   (2)
      Types of What-If Analyses                    747   (1)
      Manual What-If Analysis                      747   (1)
      Creating Data Tables                         747   (6)
        Creating a one-input data table            748   (2)
        Creating a two-input data table            750   (3)
      Using Scenario Manager                       753   (8)
        Defining scenarios                         754   (3)
        Displaying scenarios                       757   (1)
        Modifying scenarios                        758   (1)
        Merging scenarios                          758   (1)
        Generating a scenario report               758   (3)
    Chapter 37 Analyzing Data Using Goal           761   (20)
    Seeking and Solver
      What-If Analysis, in Reverse                 761   (1)
      Single-Cell Goal Seeking                     762   (2)
        A goal-seeking example                     762   (1)
        More about goal seeking                    763   (1)
      Introducing Solver                           764   (7)
        Appropriate problems for Solver            765   (1)
        A simple Solver example                    765   (5)
        More about Solver                          770   (1)
      Solver Examples                              771   (10)
        Solving simultaneous linear equations      771   (2)
        Minimizing shipping costs                  773   (3)
        Allocating resources                       776   (2)
        Optimizing an investment portfolio         778   (3)
    Chapter 38 Analyzing Data with the Analysis    781   (12)
    ToolPak
      The Analysis ToolPak: An Overview            781   (1)
      Installing the Analysis ToolPak Add-in       782   (1)
      Using the Analysis Tools                     783   (1)
      Introducing the Analysis ToolPak Tools       783   (10)
        Analysis of Variance                       784   (1)
        Correlation                                784   (1)
        Covariance                                 785   (1)
        Descriptive Statistics                     785   (1)
        Exponential Smoothing                      786   (1)
        F-Test (two-sample test for variance)      786   (1)
        Fourier Analysis                           787   (1)
        Histogram                                  787   (1)
        Moving Average                             788   (1)
        Random Number Generation                   789   (1)
        Rank and Percentile                        790   (1)
        Regression                                 790   (1)
        Sampling                                   791   (1)
        t-Test                                     792   (1)
        z-Test (two-sample test for means)         792   (1)
  Part VI Programming Excel with VBA               793   (122)
    Chapter 39 Introducing Visual Basic for        795   (28)
    Applications
      Introducing VBA Macros                       795   (1)
      Displaying the Developer Tab                 796   (1)
      About Macro Security                         797   (1)
      Saving Workbooks That Contain Macros         798   (1)
      Two Types of VBA Macros                      799   (3)
        VBA Sub procedures                         799   (1)
        VBA functions                              800   (2)
      Creating VBA Macros                          802   (19)
        Recording VBA macros                       802   (1)
        Recording your actions to create VBA       802   (1)
        code: The basics
        Recording a macro: A simple example        803   (1)
        Examining the macro                        804   (1)
        Testing the macro                          805   (1)
        Editing the macro                          805   (1)
        Another example                            806   (1)
        Running the macro                          806   (1)
        Examining the macro                        806   (1)
        Re-recording the macro                     807   (1)
        Testing the macro                          808   (1)
        More about recording VBA macros            808   (1)
        Absolute versus relative recording         808   (1)
        Storing macros in your Personal Macro      809   (1)
        Workbook
        Assigning a macro to a shortcut key        810   (1)
        Assigning a macro to a button              810   (1)
        Writing VBA code                           811   (1)
        The basics: Entering and editing code      812   (1)
        How VBA works                              812   (2)
        Objects and collections                    814   (1)
        Properties                                 815   (2)
        Methods                                    817   (1)
        Variables                                  817   (1)
        Controlling execution                      818   (1)
        A macro that can't be recorded             819   (2)
      Learning More                                821   (2)
    Chapter 40 Creating Custom Worksheet           823   (14)
    Functions
      Overview of VBA Functions                    823   (1)
      An Introductory Example                      824   (2)
        A custom function                          824   (1)
        Using the function in a worksheet          824   (1)
        Analyzing the custom function              825   (1)
      About Function Procedures                    826   (1)
      Executing Function Procedures                827   (1)
        Calling custom functions from a            827   (1)
        procedure
        Using custom functions in a worksheet      828   (1)
        formula
      Function Procedure Arguments                 828   (5)
        A function with no argument                829   (1)
        A function with one argument               829   (1)
        Another function with one argument         830   (1)
        A function with two arguments              831   (1)
        A function with a range argument           832   (1)
      Debugging Custom Functions                   833   (1)
      Inserting Custom Functions                   834   (2)
      Learning More                                836   (1)
    Chapter 41 Creating UserForms                  837   (22)
      Why Create UserForms?                        837   (1)
      UserForm Alternatives                        838   (4)
        The InputBox function                      838   (1)
        The MsgBox function                        839   (3)
      Creating UserForms: An Overview              842   (4)
        Working with UserForms                     843   (1)
        Adding controls                            843   (1)
        Changing the properties of a control       844   (2)
        Handling events                            846   (1)
        Displaying a UserForm                      846   (1)
      A UserForm Example                           846   (4)
        Creating the UserForm                      847   (1)
        Testing the UserForm                       848   (1)
        Creating an event-handler procedure        849   (1)
      Another UserForm Example                     850   (6)
        Creating the UserForm                      850   (2)
        Testing the UserForm                       852   (1)
        Creating event-handler procedures          853   (1)
        Testing the UserForm                       854   (1)
        Making the macro available from a          855   (1)
        worksheet button
        Making the macro available on your         855   (1)
        Quick Access toolbar
      More on Creating UserForms                   856   (1)
        Adding accelerator keys                    856   (1)
        Controlling tab order                      856   (1)
      Learning More                                857   (2)
    Chapter 42 Using UserForm Controls in a        859   (14)
    Worksheet
      Why Use Controls on a Worksheet?             859   (2)
      Using Controls                               861   (5)
        Adding a control                           862   (1)
        About design mode                          862   (1)
        Adjusting properties                       862   (1)
        Common properties                          863   (1)
        Linking controls to cells                  864   (1)
        Creating macros for controls               864   (2)
      Reviewing the Available ActiveX Controls     866   (7)
        CheckBox                                   866   (1)
        ComboBox                                   867   (1)
        CommandButton                              868   (1)
        Image                                      868   (1)
        Label                                      868   (1)
        ListBox                                    868   (1)
        OptionButton                               869   (1)
        ScrollBar                                  869   (1)
        SpinButton                                 870   (1)
        TextBox                                    871   (1)
        ToggleButton                               872   (1)
    Chapter 43 Working with Excel Events           873   (14)
      Understanding Events                         873   (1)
      Entering Event-Handler VBA Code              874   (1)
      Using Workbook-Level Events                  875   (4)
        Using the Open event                       876   (2)
        Using the SheetActivate event              878   (1)
        Using the NewSheet event                   878   (1)
        Using the BeforeSave event                 878   (1)
        Using the BeforeClose event                879   (1)
      Working with Worksheet Events                879   (4)
        Using the Change event                     880   (1)
        Monitoring a specific range for changes    881   (1)
        Using the SelectionChange event            882   (1)
        Using the BeforeRightClick event           883   (1)
      Using Non-Object Events                      883   (4)
        Using the OnTime event                     883   (1)
        Using the OnKey event                      884   (3)
    Chapter 44 VBA Examples                        887   (16)
      Working with Ranges                          887   (9)
        Copying a range                            888   (1)
        Copying a variable-size range              889   (1)
        Selecting to the end of a row or column    890   (1)
        Selecting a row or column                  890   (1)
        Moving a range                             891   (1)
        Looping through a range efficiently        891   (2)
        Prompting for a cell value                 893   (1)
        Determining the type of selection          893   (2)
        Identifying a multiple selection           895   (1)
        Counting selected cells                    895   (1)
      Working with Workbooks                       896   (1)
        Saving all workbooks                       896   (1)
        Saving and closing all workbooks           896   (1)
      Working with Charts                          897   (2)
        Modifying the chart type                   898   (1)
        Modifying chart properties                 898   (1)
        Applying chart formatting                  899   (1)
      VBA Speed Tips                               899   (4)
        Turning off screen updating                899   (1)
        Preventing alert messages                  900   (1)
        Simplifying object references              900   (1)
        Declaring variable types                   901   (2)
    Chapter 45 Creating Custom Excel Add-Ins       903   (12)
      What Is an Add-In?                           903   (1)
      Working with Add-Ins                         904   (2)
      Why Create Add-Ins?                          906   (1)
      Creating Add-Ins                             907   (1)
      An Add-In Example                            908   (7)
        Setting up the workbook                    908   (1)
        Procedures in Module 1                     909   (1)
        About the UserForm                         909   (1)
        Testing the workbook                       910   (1)
        Adding descriptive information             911   (1)
        Protecting the project                     911   (1)
        Creating the add-in                        912   (1)
        Creating the user interface for your       912   (1)
        add-in macro
        Installing the add-in                      913   (2)
  Part VII Appendixes                              915   (34)
      Appendix A Worksheet Function Reference      917   (16)
      Appendix B What's on the CD-ROM              933   (10)
        System Requirements                        933   (1)
        Using the CD                               933   (1)
        What's on the CD                           934   (1)
        Applications                               934   (1)
        eBook version of Excel 2010 Bible          934   (1)
        Sample files for Excel 2010 Bible          934   (1)
        Chapter 01                                 935   (1)
        Chapter 02                                 935   (1)
        Chapter 04                                 935   (1)
        Chapter 05                                 935   (1)
        Chapter 06                                 935   (1)
        Chapter 10                                 936   (1)
        Chapter 11                                 936   (1)
        Chapter 12                                 936   (1)
        Chapter 13                                 936   (1)
        Chapter 14                                 937   (1)
        Chapter 15                                 937   (1)
        Chapter 16                                 937   (1)
        Chapter 17                                 937   (1)
        Chapter 18                                 938   (1)
        Chapter 19                                 938   (1)
        Chapter 20                                 939   (1)
        Chapter 21                                 939   (1)
        Chapter 22                                 939   (1)
        Chapter 24                                 939   (1)
        Chapter 25                                 939   (1)
        Chapter 26                                 939   (1)
        Chapter 27                                 939   (1)
        Chapter 28                                 940   (1)
        Chapter 33                                 940   (1)
        Chapter 34                                 940   (1)
        Chapter 35                                 940   (1)
        Chapter 36                                 940   (1)
        Chapter 37                                 941   (1)
        Chapter 38                                 941   (1)
        Chapter 39                                 941   (1)
        Chapter 40                                 941   (1)
        Chapter 41                                 941   (1)
        Chapter 42                                 941   (1)
        Chapter 43                                 942   (1)
        Chapter 44                                 942   (1)
        Chapter 45                                 942   (1)
        Troubleshooting                            942   (1)
      Appendix C Additional Excel Resources        943   (6)
        The Excel Help System                      943   (1)
        Microsoft Technical Support                944   (1)
        Support options                            944   (1)
        Microsoft Knowledge Base                   944   (1)
        Microsoft Excel Home Page                  944   (1)
        Microsoft Office Home Page                 944   (1)
        Internet Newsgroups                        945   (1)
        Accessing newsgroups by using a            945   (1)
        newsreader
        Accessing newsgroups by using a Web        945   (1)
        browser
        Searching newsgroups                       946   (1)
        Internet Web sites                         947   (1)
        The Spreadsheet Page                       947   (1)
        Daily Dose of Excel                        948   (1)
        Jon Peltier's Excel Page                   948   (1)
        Pearson Software Consulting                948   (1)
        Contextures                                948   (1)
        David McRitchie's Excel Pages              948   (1)
        Pointy Haired Dilbert                      948   (1)
        Mr. Excel                                  948   (1)
Appendix D Excel Shortcut Keys                     949   (8)
Index                                              957   (50)
End-User License Agreement                         1007
 

A comprehensive reference to the newest version of the world's most popular spreadsheet application: Excel 2010 John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of all the new features of Excel 2010. An authoritative reference, this perennial bestseller proves itself indispensable no matter your level of skill, from Excel beginners and intermediate users to power users and potential power users everywhere. Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques you won't find anywhere else. Excel guru and bestselling author John Walkenbach ("Mr.Spreadsheet") guides you through every aspect of Excel Delivers essential coverage of all the newest features of Excel 2010 Presents material in a clear, concise, logical format that is ideal for all levels of Excel experience Includes a CD that contains all the templates and worksheets used in the book plus John Walkenbach's award-winning Power Utility Pak Excel 2010 Bible serves as an excellent resource on all things Excel! Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Contents
Acknowledgments xxxvii Introduction xxxviii Part IStarted with Excel 1 Chapter 1: Introducing Excel 3 Chapter 2: Entering and Editing Worksheet Data29 Chapter 3: Essential Worksheet Operations 49 Chapter 4: Working with Cells and Ranges 69 Chapter 5: Introducing Tables 99 Chapter 6: Worksheet Formatting 115 Chapter 7: Understanding Excel Files 141 Chapter 8: Using and Creating Templates 161 Chapter 9: Printing Your Work 171 Part II: Working with Formulas and Functions 193 Chapter 10: Introducing Formulas and Functions 195 Chapter 11: Creating Formulas That Manipulate Text 229 Chapter 12: Working with Dates and Times 249 Chapter 13: Creating Formulas That Count and Sum 281 Chapter 14: Creating Formulas That Look Up Values 309 Chapter 15: Creating Formulas for Financial Applications 329 Chapter 16: Introducing Array Formulas 355 Chapter 17: Performing Magic with Array Formulas 379 Part III: Creating Charts and Graphics 401 Chapter 18: Getting Started Making Charts 403 Chapter 19: Learning Advanced Charting 437 Chapter 20: Visualizing Data Using Conditional Formatting 481 Chapter 21: Creating Sparkline Graphics 503 Chapter 22: Enhancing Your Work with Pictures and Drawings 517 Part IV: Using Advanced Excel Features 539 Chapter 23: Customizing the Excel User Interface 541 Chapter 24: Using Custom Number Formats 551 Chapter 25: Using Data Validation 569 Chapter 26: Creating and Using Worksheet Outlines 581 Chapter 27: Linking and Consolidating Worksheets 589 Chapter 28: Excel and the Internet 605 Chapter 29: Sharing Data with Other Office Applications 615 Chapter 30: Using Excel in a Workgroup 627 Chapter 31: Protecting Your Work 637 Chapter 32: Making Your Worksheets Error-Free 649 Part V: Analyzing Data with Excel 675 Chapter Chapter 34: Introducing Pivot Tables 695 Chapter 33: Getting Data from External Database Files 677 Chapter 35: Analyzing Data with Pivot Tables 715 Chapter 36: Performing Spreadsheet What-If Analysis 745 Chapter 37: Analyzing Data Using Goal Seeking and Solver 761 Chapter 38: Analyzing Data with the Analysis ToolPak 781 Part VI: Programming Excel with VBA 793 Chapter 39: Introducing Visual Basic for Applications 795 Chapter 40: Creating Custom Worksheet Functions 823 Chapter 41: Creating UserForms 837 Chapter 42: Using UserForm Controls in a Worksheet 859 Chapter 43: Working with Excel Events 873 Chapter 44: VBA Examples 887 Chapter 45: Creating Custom Excel Add-Ins 903 Part VII: Appendixes 915 Appendix A: Worksheet Function Reference 917 Appendix B: What's on the CD-ROM 933INTRODUCTION TO THE GLOBE: Objectives; Science Table; To Get Ready-Exploring Corn; Tell the Story of People and Corn; Touch Corn Seeds; Plant Corn Seeds; Many Varieties of Corn; The Story's Ending; A Photograph of the Earth; Hold a Model of Our Earth, a Globe; Corn Tastes Good; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Corn and an Introduction to the Globe; WINTER BIRDS: Objectives; Science Table; To Get Ready-Exploring Winter Birds; Bird Food; Bird Shapes and Colours; Bird Shape Rubbings; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Winter Birds; PLANTING PEAS: Objectives; Science Table; To Get Ready-Exploring Planting; Preparing the Peas for Planting; Planting Inside; Measure the Growth; Planting Outside; Fair Test Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Planting Peas; A TREE IS NICE: Objective; Science Table; To Get Ready-Exploring Trees; Where Do Trees Come From?; Hold a Baby Tree; How Big?; Make a Leaf Rubbing; A Tree Poem; Science Investigation; Books to Read; Follow-up Activity; Bringing Science Home! A Note Home To Families About Trees; BUTTERLIES CHANGE AS THEY GROW: Objectives; Science Table; To Get Ready-Exploring Butterflies; Look at Butterflies and Caterpillars While Using Identification Books; Pretend Butterfly Tongues; Ongoing Observation of the Butterflies; Checking the Butterfly Habitat for Eggs; Have the Caterpillars Hatched?; Chart the Growth and Change of the Caterpillars; Caterpillars Changing into Pupas; Emerging Butterflies; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About the Life Cycle of Butterflies; PLANTING A BUTTERFLY GARDEN: Objectives; Science Table; To Get Ready-Exploring a Butterfly Garden; What Do Butterflies Eat?; Plants for Butterflies; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Planting a Butterfly Garden; WHAT IS IT?: Objective; Science Table; To Get Ready-Exploring the Unknown; Seeing and Touching the Choices; Science Investigation; Telling What You Guess; Repeat the Experience; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About What Is It?A"; EATING SUNLIGHT: Objective; Science Table; To Get Ready-Exploring Sunlight; Make a Sun Print Indoors; Explore Sunlight; Make a Sun Print Outdoors; Talk About the Grass Again; Churn Butter; Science Investigation; Books to Read; Bringing Science Home! A Note Home to Families About Eating Sunlight; OUR SENSE OF TOUCH: Objective; Science Table; To Get Ready-Exploring Our Sense of Touch With a Feely BoxA"; Feeling Sensations; A Sensitive Game; Sensitive Plants Feel Our Touch; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Our Sense of Touch; OUR SENSE OF SMELL: Objective; Science Table; To Get Ready-Exploring Our Sense of Smell; Practise Sniffing; Animal Noses; Smell Guessing Games; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Using Our Sense of Smell; MAKING SOLUTIONS: Objective; Science Table; To Get Ready-Exploring Solutions; Identifying Plain Water; Identify the Solids; Mix the Liquid and the Solids; Comparing the Results; Taste the Water to Find the Sugar; Science Investigation; Follow-up Activities; Bringing Science Home! A Note Home to Families About Making Solutions; MEASURING HANDS: Objective; Science Table; To Get Ready-Exploring Measuring; Make a Set of Measuring Hand; Measure With a Hand; Measure With Many Hands; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Measuring Hands; MAGNETS AND TESTING HYPOTHESES: Objectives; Science Table; To Get Ready-Introducing Magnet Play; Feeling Magnetic Force; Magnets Attract Some Objects; Testing Objects and Making a Hypothesis; More Hypothesizing; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Magnets and Making Predictions; WHAT IS MELTING?: Objective; Science Table; To Get Ready-Exploring Melting; Use Body Heat to Melt Chocolate; Ice Melts; Melt Wax; Melted Rock; Melt Chocolate Again!; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Melting; SOIL, WHAT IS IT?: Objectives; Science Table; To Get Ready-Exploring Soil; Use the Senses to Learn about Soil; Separate Soil Into Its Parts, Add Water -; - And Shake; Try to Make Soil; Is it Soil Yet?; Check the Separated Soil Sample for Settling; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home To Families About Soil-What Is It?; ROCKS MADE OF TINY PIECES (SEDIMENTARY ROCKS): Objective; Science Table; To Get Ready-Exploring Sedimentary Rocks; Comparing Rocks; Feel the Ingredients of Rocks; Feel the Difference Between Two Kinds of Rocks; Mixing Up a Pretend Rock; Mixing Plaster of Paris; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Rocks Made of Tiny Pieces (Sedimentary Rocks); ROCKS THAT WERE MELTED (IGNEOUS ROCKS) AND VOLCANOES: Objectives; Science Table; To Get Ready-Exploring Igneous Rocks; Touch Volcanic Rocks; Experiencing Baking Soda and Vinegar Separately; Going to the Pretend Volcano; Erupting the Volcano; Science Investigation; Books to Read; Follow-up Activity; Bringing Science Home! A Note Home to Families About Rocks That Were Melted (Igneous Rocks) and Volcanoes; FOSSIL DISCOVERY: Objectives; Science Table; To Get Ready-Exploring Fossils; Matching Objects to Their Imprints in Playdough; Playdough Recipe; Plaster Casts of Footprints; Make Imprints in Playdough; Preserving the Imprints With Plaster; Handling Real Fossils; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Fossil Discovery; TAKING NOTE OF VOLUME: Objectives; Science Table; To Get Ready-Exploring Volume; Seeing Air as Bubbles; Air Fills the Container and Keeps the Water Out; Shape and Volume; Measuring and Comparing the Volumes; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home To Families About Taking Note of Volume; EVAPORATION AND CONDENSATION: Objective; Science Table; To Get Ready-Exploring Evaporation and Condensation; What Happens to Spilled Water?; Water on a Blackboard; Meanwhile, Look at Condensation; Condensing Water; Feel Water Evaporating from Our Skin; Condensing the Water in Our Breath; Sing About Condensation; Book to Read; Follow-up Activity; Bringing Science Home! A Note Home to Families About Evaporation and Condensation; MAKING A CHEMICAL REACTION TO CREATE SLIME: Objectives; Science Table; To Get Ready-Exploring Mixtures Independently; Examining the Ingredients-Are They Liquids or Solids?; Measuring to Make a Solution; Mixing the Two Liquid Ingredients; Adding the Solution; Feeling the Slime; Science Investigation; Books to Read; Bringing Science Home! A Note Home to Families About Making a Chemical Reaction to Create Slime; BUBBLES: Objective; Science Table; To Get Ready-Exploring Bubbles; Feel Air; Blow Air Into Water to Make Bubbles; What Is the Shape of a Bubble?; Can You Make a Square Bubble?; Science Investigation; Books to Read; Follow-up Activity; Bringing Science Home! A Note Home to Families About Bubbles; RECYCLING PAPER TO USE AGAIN: Objective; Science Table; To Get Ready; Feel Many Kinds of Paper; What Does It Mean to Re-use Something?; What Does It Mean to Recycle Something?; Prepare for Recycling Paper; Recycled Paper, Step 1; Recycled Paper, Step 2; Making Papier-Mache From Newspapers; Make Papier-Mache Worlds; The Resources of the Earth Are Precious; Science Investigation; Books to Read; Bringing Science Home! A Note Home to Families About Recycling Paper; ROCKET SHIPS BLASTING OFF: Objective; Science Table; To Get Ready-Exploring Rocket Ships; How Do Rockets Work?; The Power of Gas; Fuel for the Pretend Rocket; Blast Off!; Science Investigation; Books to Read; Website to Visit; Follow-up Activities; Bringing Science Home! A Note Home to Families About Rocket Ships Blasting Off; SOUND IS VIBRATION: Objective; Science Table; To Get Ready-Exploring Sound; Feel Your Throat Vibrating; Feel a Triangle Vibrate; See and Feel a String Vibrate; Make Music With Vibration; Make a Musical Instrument to Take Home; Science Investigation; Books to Read; Follow-up Activity; Bringing Science Home! A Note Home to Families About Sound Is Vibration; MIRRORS REFLECT: Objectives; Science Table; To Get Ready-Exploring Mirrors; What Do We See in a Mirror?; Predicting Where Light Will Travel; Torches Use Electricity; Exploring How a Mirror Affects the Direction of Light; Where Does the Light Go?; Light Reflects Off Surfaces and on to Others; Use a Mirror to See Around Corners; Use a Periscope; Make a Periscope; Use a Flexible Mirror; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Mirrors; WORKING WITH PUMPS, SIPHONS AND CAPILLARY ACTION: Objectives; Science Table; To Get Ready-Exploring Pumps, Siphons, and Capillary Action; Move the Water; How Do Pumps Work?; Siphons Work With Suction and Gravity; Capillary Action in Paper; Capillary Action in Plants; Science Investigation; Follow-up Activity; Bringing Science Home! A Note Home to Families About Working With Pumps, Siphons and Capillary Action; WHAT CAN THE WIND DO?: Objectives; Science Table; To Get Ready-Exploring What the Wind Can Do; Blow It; Pretend to Be the Wind; Move Like a Wind-blown Object; Wind Socks; Wind Ribbons; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About What Wind Can Do; OBJECTS IN MOTION: Objectives; Science Table; To Get Ready-Exploring Objects in Motion; Tell a Ball to Move; Move the Ball; Put the Attention on Gravity; Relate Gravity to Car Seat Safety; Put on a Seat Belt; Make a Newton's Cradle; Test the Hypothesis; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Objects in Motion; MIXING AND SEPARATING COLOURS: Objectives; Science Table; To Get Ready-Exploring Mixing and Separating Colours; Mix Colours Using Plastic Squares; Spin a Top to Mix Colours; The Colour Black Can Be Separated; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Mixing and Separating Colours; WHEELS ARE TOOLS: Objective; Science Table; To Get Ready-Exploring Wheels; Moving a Variety of Shapes; Rollers and Sliders; Prints of a Roller and a Slider; Move a Heavy Load; What Other Way Can We Move It?; Science Investigation; Books to Read; Follow-up Activity; Bringing Science Home! A Note Home to Families About Wheels Are Tools; INTRODUCING ELECTRICITY: Objectives; Science Table; To Get Ready-Using Electricity; Exploring Torches; Making a Simple Circuit; Using the Components; Switching It On and Off; Science Investigation; Books to Read; Follow-up Activities; Bringing Science Home! A Note Home to Families About Electricity; Writing Additional Lessons; Complete Book List; Index.