SINGAPORE
Law
Welcome Guest | Login
SEARCH
Advanced
Microsoft Excel 2010 in Depth (In Depth): Jelen, Bill: BOOKS KINOKUNIYA
Book Details
Microsoft Excel 2010 in Depth (In Depth)
Microsoft Excel 2010 in Depth (In Depth)
Publisher : Que Pub
Published Date : 2010/06
Binding : Paperback
ISBN : 9780789743084

BookWeb Price : S$ 67.27
Kinokuniya Privilege Card member price : S$ 60.55

Availability Status : Available for order from suppliers.
Usually dispatches within 3 weeks.
Language : English

Book Description
Source: ENG
Academic Descriptors: A93905800 A48401631
Place of Publication: United States
Continuations: Monograph Series,any number
Textual Format: Computer Applications
Academic Level: Extracurricular
Review:
School Core - Secondary - Level 3 Nonfiction
School Core - Secondary - Level 4 Nonfiction
Phoenix Public Library Holdings (Internal Code for CLS)
Table of Contents
 
Introduction                                       1   (6)
  I Changes in User Interface
    1 The File Menu Becomes the Backstage View     7   (16)
      Understanding "In" Versus "Out" Commands     7   (1)
      Using Backstage View                         8   (1)
        Pressing the Esc Key to Close Backstage    8   (1)
        View
        Using the Four Quick Commands in the       8   (1)
        Left Navigation
      Opening Recent Files                         9   (5)
        One-Click Access to Recent Files           11  (2)
        Recovering Unsaved Workbooks               13  (1)
        Clearing the Recent Workbooks List         14  (1)
      Getting Information About the Current        14  (4)
      Workbook
        Correcting Special States Such as          15  (1)
        Disabled Macros and Links
        Excel's Automatic Trusting of a Document   16  (1)
        Opening a File in the Protected View       16  (1)
        Sandbox
        Marking a Workbook as Final to Prevent     16  (1)
        Editing
        Finding Hidden Content Using the           17  (1)
        Document Inspector
      Creating a New Workbook from a Template      18  (1)
      Printing and Print Preview                   18  (2)
      Sharing Your Workbook Using Save & Send      20  (1)
      Getting Updates and Help                     21  (2)
    2 The Ribbon Interface and Quick Access        23  (16)
    Toolbar
      Using the Ribbon                             23  (4)
        Using Dialog Launchers and the 80/20       24  (1)
        Rule
        Using Flyout Menus and Galleries           25  (2)
      The Ribbon Is Constantly Changing            27  (3)
        Harnessing Contextual Ribbon Tabs          27  (2)
        Resizing Excel Changes the Ribbon          29  (1)
      Solving Common Ribbon Problems               30  (2)
        You Cannot Find a Particular Command on    30  (1)
        the Ribbon
        You Still Cannot Find the Command on       30  (1)
        the Ribbon
        The Ribbon Takes Up Too Many Rows          31  (1)
        You Do Not Like Where Something Is         32  (1)
        Located on the Ribbon
        You Cannot See All Your Favorite           32  (1)
        Commands at Once
      Using the Quick Access Toolbar               32  (2)
        Changing the Location of the Quick         33  (1)
        Access Toolbar
      Adding Favorite Commands to the Quick        34  (1)
      Access Toolbar
        Knowing Which Commands Can Be on the       34  (1)
        Quick Access Toolbar
        Removing Commands from the Quick Access    34  (1)
        Toolbar
      Customizing the Quick Access Toolbar         35  (4)
        Using the Excel Options to Customize       36  (1)
        the Quick Access Toolbar for All
        Workbooks
        Customizing Icons for the Current          36  (1)
        Workbook Only
        Filling Up the Quick Access Toolbar        37  (1)
        Rearranging Icons on the Quick Access      37  (1)
        Toolbar
        Resetting the Quick Access Toolbar         37  (1)
        Assigning VBA Macros to Quick Access       37  (2)
        Toolbar Buttons
    3 Using Other Excel Interface Improvements     39  (18)
      Using Live Preview                           40  (1)
      Previewing Paste Using the Paste Options     41  (6)
      Gallery
        Accessing the Gallery After Doing a        42  (2)
        Paste
        Accessing the Paste Options Gallery        44  (3)
        from the Right-Click Menu
        Accessing the Paste Options Gallery        47  (1)
        from the Paste Drop-Down
      Using the Mini Toolbar to Format Selected    47  (3)
      Text
        Getting the Mini Toolbar Back              49  (1)
        Disabling the Mini Toolbar                 49  (1)
      Expanding the Formula Bar                    50  (1)
      Zooming In and Out on a Worksheet            51  (1)
      Using the Status Bar to Add Numbers          52  (1)
      Switching Between Normal View, Page Break    52  (2)
      Preview, and Page Layout View Modes
      Using the New Sheet Icon to Add Worksheets   54  (3)
        Dragging a Worksheet to a New Location     54  (1)
        Inserting a Worksheet in the Middle of     55  (2)
        a Workbook
    4 Customizing the Ribbon                       57  (8)
      Performing a Simple Ribbon Modification      57  (2)
      Using a More Complex Ribbon Modification     59  (3)
      Hiding/Showing Ribbon Tabs                   62  (1)
      Adding a New Ribbon Tab                      62  (1)
      Sharing Customizations with Others           63  (1)
        Resetting Customizations                   63  (1)
      Questions About Ribbon Customization         63  (2)
    5 Keyboard Shortcuts                           65  (22)
      Using New Keyboard Accelerators              65  (4)
        Selecting Icons on the Ribbon              67  (1)
        Selecting Options from a Gallery           67  (1)
        Navigating Within Drop-Down Lists          68  (1)
        Backing Up One Level Through a Menu        68  (1)
        Dealing with Keyboard Accelerator          68  (1)
        Confusion
        Selecting from Legacy Dialog Boxes         68  (1)
      Using the Shortcut Keys                      69  (7)
      Using Excel 2003 Keyboard Accelerators       76  (11)
        Invoking an Excel 2003 Alt Shortcut        77  (1)
        Determining Which Commands Work in         78  (9)
        Legacy Mode
    6 The Excel Options Dialog                     87  (22)
      Introducing the Excel Options Dialog         87  (10)
        Getting Help with a Setting                90  (1)
        Using AutoRecover Options                  91  (1)
        New Excel 2010 Options for                 91  (1)
        Internationalization
        New Excel 2010 Options for Performance     92  (2)
        New Excel 2010 Options for Security        94  (3)
      Ten Options to Consider                      97  (2)
        Five Excel Oddities                        98  (1)
      Guide to Excel Options                       99  (10)
    7 The Big Grid and File Formats                109 (14)
      Excel Grid Limits                            109 (2)
        Why Are There Only 65,536 Rows in My       110 (1)
        Excel 2007 Spreadsheet?
      Other Limits in Excel 2010                   111 (2)
      Tips for Navigating the Big Grid             113 (1)
        Using Shortcut Keys to Move Around         113 (1)
        Using the End Key to Navigate              113 (1)
        Using the Current Range to Navigate        114 (1)
        Using Go To to Navigate                    114 (1)
      Understanding the New File Formats           114 (4)
        A Brief History of File Formats            115 (1)
        Using the New Binary File Format: BIFF12   116 (1)
        Using the New XML File Formats: XLSX       116 (2)
        and XLSM
      Version Compatibility                        118 (2)
      Opening Excel 2010 Files in Excel 2002 or    120 (1)
      2003
        Minor Loss of Fidelity                     120 (1)
        Significant Loss of Functionality          121 (1)
      Creating Excel 2010 File Formats in Excel    121 (1)
      2003
      Opening Excel 2010 Files in Excel 2007       122 (1)
  II Calculating with Excel
    8 Understanding Formulas                       123 (20)
      Getting the Most from This Chapter           123 (1)
      Introduction to Formulas                     124 (1)
        Formulas Versus Values                     124 (1)
      Entering Your First Formula                  125 (7)
        Building a Formula                         125 (1)
        The Relative Nature of Formulas            126 (1)
        Overriding Relative Behavior: Absolute     127 (1)
        Cell References
        Using Mixed References to Combine          128 (1)
        Features of Relative and Absolute
        References
        Using the F4 Key to Simplify Dollar        129 (3)
        Sign Entry
      Three Methods of Entering Formulas           132 (3)
        Enter Formulas Using the Mouse Method      133 (1)
        Entering Formulas Using the Arrow-Key      133 (2)
        Method
      Entering the Same Formula in Many Cells      135 (3)
        Copying a Formula by Using Ctrl+Enter      135 (1)
        Copying a Formula by Dragging the Fill     136 (1)
        Handle
        Double-Click the Fill Handle to Copy a     137 (1)
        Formula
      Use the Table Tool to Copy a Formula         138 (5)
    9 Controlling Formulas                         143 (22)
      Formula Operators                            143 (4)
        Order of Operations                        144 (2)
        Stacking Multiple Parentheses              146 (1)
      Understanding Error Messages in Formulas     147 (2)
      Using Formulas to Join Text                  149 (2)
        Joining Text and a Number                  150 (1)
      Copying Versus Cutting a Formula             151 (3)
      Automatically Formatting Formula Cells       154 (1)
      Using Date Math                              155 (2)
      Troubleshooting Formulas                     157 (7)
        Highlighting All Formula Cells             157 (1)
        Seeing All Formulas                        158 (2)
        Editing a Single Formula to Show Direct    160 (1)
        Precedents
        Using Formula Auditing Arrows              160 (2)
        Tracing Dependents                         162 (1)
        Using the Watch Window                     162 (1)
        Evaluate a Formula in Slow Motion          162 (1)
        Evaluating Part of a Formula               163 (1)
      Excel in Practice: Moving the Formula        164 (1)
      ToolTip
    10 Understanding Functions                     165 (24)
      Working with Functions                       167 (3)
        The Formulas Tab in Excel 2010             167 (1)
        Finding the Function You Need              168 (1)
        Using AutoComplete to Find Functions       169 (1)
        Using the Function Wizard to Find          169 (1)
        Functions
      Getting Help with Excel Functions            170 (2)
        Using In-Cell ToolTips                     170 (1)
        Using the Function Arguments Dialog        171 (1)
        Using Excel Help                           172 (1)
      Using AutoSum                                172 (4)
        Potential Problems with AutoSum            173 (1)
        Special Tricks with AutoSum                174 (1)
        Using the AutoSum Drop-Down                175 (1)
      Using the New General-Purpose Functions      176 (2)
      in Excel
        Like SUBTOTAL, but Better: AGGREGATE ()    176 (1)
        Added in Excel 2007: IFERROR()             177 (1)
        Using Conditional Formulas with            178 (1)
        Multiple Conditions: SUMIFS(),
        AVERAGEIFS(), and COUNTIFS()
      Functions with New Variations in Excel       178 (2)
      2010
        Calculating Multiple MODE Values           178 (1)
        Calculating Workdays                       179 (1)
        Handling Ties in the RANK Function         179 (1)
        Calculating Percentiles and Quartiles      179 (1)
        Calculating CEILING and FLOOR for          179 (1)
        Negative Values
      Functions That Have Been Renamed             180 (3)
        Using Worksheets with Legacy Function      181 (2)
        Names
      Cube Functions Introduced in Excel 2007      183 (6)
        Using the Former ATP Functions             184 (2)
        Function Reference Chapters                186 (3)
    11 Using Everyday Functions: Math, Date and    189 (88)
    Time, and Text FFunctions
      Examples of Math Functions                   197 (36)
        Using SUM to Add Numbers                   198 (1)
        Using AGGREGATE to Ignore Error Cells      199 (4)
        or Filtered Rows
        Using COUNT or COUNTA to Count Numbers     203 (1)
        or Nonblank Cells
        Using ROUND, ROUNDDOWN, ROUNDUP, INT,      204 (7)
        TRUNC, FLOOR, FLOOR.PRECISE, CEILING,
        CEILING.PRECISE, EVEN, ODD, or MROUND
        to Remove Decimals or Round Numbers
        Using SUBTOTAL Instead of SUM with         211 (4)
        Multiple Levels of Totals
        Using RAND and RANDBETWEEN to Generate     215 (3)
        Random Numbers and Data
        Using ABS() to Figure Out the Magnitude    218 (2)
        of ERROR
        Using PI to Calculate Cake or Pizza        220 (1)
        Pricing
        Using =COMBIN to Figure Out Lottery        221 (1)
        Probability
        Using FACT to Calculate the Permutation    221 (1)
        of a Number
        Using GCD and LCM to Perform               222 (1)
        Seventh-Grade Math
        Using MULTINOMIAL to Solve a Coin          223 (1)
        Problem
        Using MOD to Find the Remainder Portion    224 (1)
        of a Division Problem
        Using QUOTIENT to Isolate the Integer      225 (1)
        Portion in a Division Problem
        Using PRODUCT to Multiply Numbers          226 (1)
        Using SORT and POWER to Calculate          227 (1)
        Square Roots and Exponents
        Using SIGN to Determine the Sign of a      228 (1)
        Number
        Using COUNTIF, AVERAGEIF, and SUMIF to     229 (2)
        Conditionally Count, Average, or Sum
        Data
        Using Conditional Formulas with            231 (2)
        Multiple Conditions: SUMIFS(),
        AVERAGEIFS(), and COUNTIFS()
      Dates and Times in Excel                     233 (6)
        Understanding Excel Date and Time          236 (3)
        Formats
      Examples of Date and Time Functions          239 (17)
        Using NOW and TODAY to Calculate the       239 (1)
        Current Data and Time or Current Date
        Using YEAR, MONTH, DAY, HOUR, MINUTE,      240 (1)
        and SECOND to Break a Date/Time Apart
        Using DATE to Calculate a Date from        240 (2)
        Year, Month, and Day
        Using TIME to Calculate a Time             242 (1)
        Using DATEVALUE to Convert Text Dates      243 (1)
        to Real Dates
        Using TIMEVALUE to Convert Text Times      244 (1)
        to Real Times
        Using WEEKDAY to Group Dates by Day of     245 (1)
        the Week
        Using WEEKNUM to Group Dates into Weeks    246 (1)
        Alternative Calendar Systems and DAYS360   246 (2)
        Using YEARFRAC or DATEDIF to Calculate     248 (3)
        Elapsed Time
        Using EDATE to Calculate Loan or           251 (1)
        Investment Maturity Dates
        Using EOMONTH to Calculate the End of      252 (1)
        the Month
        Using WORKDAY or NETWORKDAYS to            253 (2)
        Calculate Workdays
        Using International Versions of WORKDAY    255 (1)
        or NETWORKDAYS
      Examples of Text Functions                   256 (21)
        Joining Text with the Ampersand (&)        256 (1)
        Operator
        Using LOWER, UPPER, or PROPER to           257 (1)
        Convert Text Case
        Using TRIM to Remove Trailing Spaces       258 (2)
        Using CLEAN to Remove Nonprintable         260 (2)
        Characters from Text
        Using the CHAR Function to Generate Any    262 (1)
        Character
        Using the CODE Function to Learn the       262 (2)
        Character Number for Any Character
        Using LEFT, MID, or RIGHT to Split Text    264 (2)
        Using LEN to Find the Number of            266 (1)
        Characters in a Text Cell
        Using SEARCH or FIND to Locate             267 (3)
        Characters in a Particular Cell
        Using SUBSTITUTE and REPLACE to Replace    270 (2)
        Characters
        Using REPT to Repeat Text Multiple Times   272 (1)
        Using EXACT to Test Case                   272 (3)
        Using the T and VALUE Functions            275 (1)
        Using Functions for Non-English            275 (2)
        Character Sets
    12 Using Powerful Functions: Logical,          277 (66)
    Lookup, and Database Functions
      Examples of Logical Functions                283 (8)
        Using the IF Function to Make a Decision   283 (1)
        Using the AND Function to Check for Two    284 (2)
        or More Conditions
        Using OR to Check Whether Any              286 (2)
        Conditions Are Met
        Using the TRUE and FALSE Functions         288 (1)
        Using the NOT Function to Simplify the     288 (1)
        Use of AND and OR
        Using the IFERROR Function to Simplify     289 (2)
        Error Checking
      Examples of Information Functions            291 (11)
        Using the IS Functions to Test for         291 (3)
        Errors
        Using the ISREF Function                   294 (1)
        Using the N Function to Add a Comment      294 (2)
        to a Formula
        Using the NA Function to Force Charts      296 (1)
        to Not Plot Missing Data
        Using the INFO Function to Print           297 (1)
        Information About a Computer
        Using the CELL Function                    298 (4)
        Using TYPE to Determine Type of Cell       302 (1)
        Value
      Examples of Lookup and Reference Functions   302 (32)
        Using the CHOOSE Function for Simple       303 (1)
        Lookups
        Using VLOOKUP with TRUE to Find a Value    304 (4)
        Based on a Range
        Using COLUMN to Assist with VLOOKUP        308 (2)
        When Filling a Wide Table
        Using HLOOKUP for Horizontal Lookup        310 (2)
        Tables
        Using the MATCH Function to Locate the     312 (2)
        Position of a Matching Value
        Using INDEX and MATCH for a Left Lookup    314 (2)
        Using MATCH and INDEX to Fill a Wide       316 (1)
        Table
        Performing Many Lookups with LOOKUP        317 (1)
        Using Functions to Describe the Shape      318 (2)
        of a Contiguous Reference
        Using AREAS and INDEX to Describe a        320 (2)
        Range with More Than One Area
        Using Numbers with OFFSET to Describe a    322 (3)
        Range
        Using ADDRESS to Find the Address for      325 (1)
        Any Cell
        Using INDIRECT to Build and Evaluate       326 (3)
        Cell References On-the-Fly
        Using the HYPERLINK Function to Quickly    329 (1)
        Add Hyperlinks
        Using the TRANSPOSE Function to            330 (2)
        Formulaically Turn Data
        Using the RTD Function and COM Add-ins     332 (1)
        to Retrieve Real-Time Data
        Using GETPIVOTDATA to Retrieve One Cell    332 (2)
        from a Pivot Table
      Examples of Database Functions               334 (9)
        Using DSUM to Conditionally Sum Records    335 (4)
        from a Database
        Using the DGET Function                    339 (4)
    13 Using Financial Functions                   343 (46)
      Examples of Common Household Loan and        348 (6)
      Investment Functions
        Using PMT to Calculate the Monthly         348 (1)
        Payment on an Automobile Loan
        Using RATE to Determine an Interest Rate   349 (1)
        Using PV to Figure Out How Much House      350 (2)
        You Can Afford
        Using NPER to Estimate How Long a Nest     352 (1)
        Egg Will Last
        Using FV to Estimate the Future Value      352 (2)
        of a Regular Savings Plan
      Examples of Functions for Financial          354 (5)
      Professionals
        Using PPMT to Calculate the Principal      354 (1)
        Payment for Any Month
        Using IPMT to Calculate the Interest       355 (1)
        Portion of a Loan Payment for Any Month
        Using CUMIPMT to Calculate Total           356 (1)
        Interest Payments During a Time Frame
        Using CUMPRINC to Calculate Total          357 (1)
        Principal Paid in Any Range of Periods
        Using EFFECT to Calculate the Effect of    358 (1)
        Compounding Period on Interest Rates
        Using NOMINAL to Convert the Effective     359 (1)
        Interest Rate to a Nominal Rate
      Examples of Depreciation Functions           359 (7)
        Using SLN to Calculate Straight-Line       360 (1)
        Depreciation
        Using DB to Calculate Declining-Balance    361 (1)
        Depreciation
        Using DDB to Calculate                     362 (2)
        Double-Declining-Balance Depreciation
        Using SYD to Calculate                     364 (2)
        Sum-of-Years'-Digits Depreciation
      Functions for Investment Analysis            366 (6)
        Using the NPV Function to Determine Net    366 (2)
        Present Value
        Using IRR to Calculate the Return of a     368 (1)
        Series of Cash Flows
        Using MIRR to Calculate Internal Rate      369 (1)
        of Return, Including Interest Rates
        Using XNPV to Calculate the Net Present    369 (2)
        Value When the Payments Are Not Periodic
        Using XIRR to Calculate a Return Rate      371 (1)
        When Cash Flow Dates Are Not Periodic
      Examples of Functions for Bond Investors     372 (14)
        Using YIELD to Calculate a Bond's Yield    373 (1)
        Using PRICE to Back into a Bond Price      374 (2)
        Using RECEIVED to Calculate Total Cash     376 (1)
        Generated from a Bond Investment
        Using INTRATE to Back into the Coupon      377 (1)
        Interest Rate
        Using DISC to Back into the Discount       378 (2)
        Rate
        Handling Bonds with an Odd Number of       380 (1)
        Days in the First or Last Period
        Using PRICEMAT and YIELDMAT to             380 (1)
        Calculate Price and Yield for
        Zero-Coupon Bonds
        Using PRICEDISC and YIELDDISC to           381 (1)
        Calculate Discount Bonds
        Calculating T-Bills                        382 (2)
        Using ACCRINT or ACCINTM to Calculate      384 (1)
        Accrued Interest
        Using DURATION to Understand Price         384 (2)
        Volatility
      Examples of Miscellaneous Financial          386 (3)
      Functions
        Using DOLLARDE to Convert to Decimals      386 (1)
        Using FVSCHEDULE to Calculate the          387 (2)
        Future Value for a Variable Scheduled
        Interest Rate
    14 Using Statistical Functions                 389 (114)
      Examples of Functions for Descriptive        401 (20)
      Statistics
        Using MIN or MAX to Find the Smallest      402 (1)
        or Largest Numeric Value
        Using LARGE to Find the Top N Values in    403 (2)
        a List of Values
        Using SMALL to Sequence a List in Date     405 (1)
        Sequence
        Using MEDIAN, MODE.SNGL, MODE.MULT, and    406 (3)
        AVERAGE to Find the Central Tendency of
        a Data Set
        Using TRIMMEAN to Exclude Outliers from    409 (1)
        the Mean
        Using GEOMEAN to Calculate Average         410 (1)
        Growth Rate
        Using HARMEAN to Find Average Speeds       411 (1)
        Using AVERAGEIF or AVERAGEIFS              411 (1)
        Using RANK to Calculate the Position       412 (3)
        Within a List
        Using PERCENTILE.INC. to Calculate         415 (2)
        Percentile
        Using PERCENTRANK.INC. to Assign a         417 (1)
        Percentile to Every Record
        Using AVEDEV, DEVSQ, VAR.S., and           418 (3)
        STDEV.S. to Calculate Dispersion
      Examples of Functions for Regression and     421 (24)
      Forecasting
        Considerations When Using Regression       421 (2)
        Analysis
        Regression Function Arguments              423 (1)
        Functions for Simple Straight-Line         424 (1)
        Regression: SLOPE and INTERCEPT
        Using LINEST to Calculate Straight-Line    425 (2)
        Regression with Complete Statistics
        Case Study: Application of Regression      427 (3)
        Analysis
        Using FORECAST to Calculate Prediction     430 (1)
        for Any One Data Point
        Using TREND to Calculate Many Future       431 (1)
        Data Points at Once
        Case Study: Forecasting Using              432 (1)
        Regression Analysis
        Using LOGEST to Perform Exponential        433 (2)
        Regression
        Using GROWTH to Predict Many Data          435 (2)
        Points from an Exponential Regression
        Exponential Regression Used to Predict     437 (1)
        Future Generations
        Using PEARSON to Determine Whether a       437 (1)
        Linear Relationship Exists
        Using RSQ to Determine the Strength of     438 (1)
        a Linear Relationship
        Using STEYX to Calculate Standard          439 (2)
        Regression Error
        Using CORREL to Calculate Positive or      441 (2)
        Negative Correlation
        Using FISHER to Perform Hypothesis         443 (1)
        Testing on Correlations
        Using SKEW and KURTOSIS                    443 (2)
      Examples of Functions for Inferential        445 (34)
      Statistics
        Understanding the Language of              445 (3)
        Inferential Statistics
        Using BINOM.DIST to Determine              448 (1)
        Probability
        Using BINOM.INV to Cover Most of the       449 (1)
        Possible Binomial Events
        Using NEGBINOM.DIST to Calculate           450 (1)
        Probability
        Using POISSON.DIST to Predict a Number     451 (1)
        of Discrete Events Over Time
        Using FREQUENCY to Categorize              452 (3)
        Continuous Data
        Using NORM.DIST to Calculate the           455 (1)
        Probability in a Normal Distribution
        Using NORM.INV to Calculate the Value      456 (1)
        for a Certain Probability
        Using NORM.S.DIST to Calculate             457 (1)
        Probability
        Using NORM.S.INV to Calculate a z Score    458 (1)
        for a Given Probability
        Using STANDARDIZE to Calculate the         459 (4)
        Distance from the Mean
        Using CHISQ.TEST to Perform                463 (1)
        Goodness-of-Fit Testing
        The Sum of Squares Functions               464 (3)
        Testing Probability on Logarithmic         467 (2)
        Distributions
        Using GAMMA.DIST and GAMMA.INV to          469 (1)
        Analyze Queuing Times
        Calculating Probability of Beta            470 (2)
        Distributions
        Using F.TEST to Measure Differences in     472 (1)
        Variability
        Other Distributions: Exponential,          473 (3)
        Hypergeometric, and Weibull
        Using Z.TEST, CONFIDENCE.NORM, and         476 (1)
        CONFIDENCE.T to Calculate Confidence
        Intervals
        Using Z. TEST to Accept or Reject a        477 (1)
        Hypothesis
        Using PERMUT to Calculate the Number of    478 (1)
        Possible Arrangements
      Using the Analysis ToolPak to Perform        479 (24)
      Statistical Analysis
        Installing the Analysis ToolPak in         479 (1)
        Excel 2010
        Generating Random Numbers Based on         480 (1)
        Various Distributions
        Generating a Histogram                     481 (2)
        Generating Descriptive Statistics of a     483 (1)
        Population
        Ranking Results                            484 (1)
        Using Regression to Predict Future         485 (2)
        Results
        Using a Moving Average to Forecast Sales   487 (1)
        Using Exponential Smoothing to Forecast    488 (2)
        Sales
        Using Correlation or Covariance to         490 (1)
        Calculate the Relationship Between Many
        Variables
        Using Sampling to Create Random Samples    491 (2)
        Using ANOVA to Perform Analysis of         493 (4)
        Variance Testing
        Using the F-Test to Measure Variability    497 (1)
        Between Methods
        Performing a z-Test to Determine           498 (1)
        Whether Two Samples Have Equal Means
        Performing Student's t-Testing to Test     499 (2)
        Population Means
        Using Functions Versus the Analysis        501 (2)
        ToolPak Tools
    15 Using Trig, Matrix, and Engineering         503 (68)
    Functions
      A Brief Review of Trigonometry Basics        507 (12)
        Radians Versus Degrees                     507 (1)
        Pythagoras and Right Triangles             508 (1)
        One Side Plus One Angle = Trigonometry     509 (1)
        Using TAN to Find the Height of a Tall     510 (1)
        Building from the Ground
        Using SIN to Find the Height of a Kite     511 (1)
        in a Tree
        Using COS to Figure Out a Ladder's         512 (2)
        Length
        Using the ARC Functions to Find the        514 (2)
        Measure of an Angle
        Using ATAN2 to Calculate Angles in a       516 (1)
        Circle
        Emulating Gravity Using Hyperbolic         517 (2)
        Trigonometry Functions
      Examples of Logarithm Functions              519 (7)
        Common Logarithms on a Base-10 Scale       520 (2)
        Using LOG to Calculate Logarithms for      522 (1)
        Any Base
        Using LN and EXP to Calculate Natural      523 (3)
        Logarithms
      Working with Imaginary Numbers               526 (8)
        Using COMPLEX to Convert a and b into a    527 (1)
        Complex Number
        Using IMREAL and IMAGINARY to Break        528 (1)
        Apart Complex Numbers
        Using IMSUM to Add Complex Numbers         529 (1)
        Using IMSUB, IMPRODUCT, and IMDIV to       530 (1)
        Perform Basic Math on Complex Numbers
        Using IMABS to Find the Distance from      531 (1)
        the Origin to a Complex Number
        Using IMARGUMENT to Calculate the Angle    532 (1)
        to a Complex Number
        Using IMCONJUGATE to Reverse the Sign      533 (1)
        of an Imaginary Component
        Calculating Powers, Logarithms, and        533 (1)
        Trigonometry Functions with Complex
        Numbers
      Solving Simultaneous Linear Equations        534 (9)
      with Matrix Functions
        Using MDETERM to Determine Whether a       538 (1)
        Simultaneous Equation Has a Solution
        Using SERIESSUM to Approximate a           539 (1)
        Function with a Power Series
        Using SQRTPI to Find the Square Root of    540 (1)
        a Number Multiplied by Pi
        Using SUMPRODUCT to Sum Based on           541 (2)
        Multiple Conditions
      Examples of Engineering Functions            543 (25)
        Converting from Decimal to Hexadecimal     544 (1)
        and Back
        Converting from Decimal to Octal and       545 (1)
        Back
        Converting from Decimal to Binary and      546 (1)
        Back
        Explaining the Two's Complement for        547 (1)
        Negative Numbers
        Converting from Binary to Hex to Octal     548 (1)
        and Back
        Using CONVERT to Convert English to        549 (15)
        Metric
        Using DELTA or GESTEP to Filter a Set      564 (2)
        of Values
        Using ERF and ERFC to Calculate the        566 (1)
        Error Function and Its Complement
        Calculating the BESSEL Functions           567 (1)
      Using the Analysis Toolpack to Perform       568 (3)
      Fast Fourier Transforms (FFTs)
    16 Connecting Worksheets, Workbooks, and       571 (28)
    External Data
      Connecting Two Worksheets                    571 (10)
        Creating Links Using Paste Options Menu    573 (2)
        Creating Links Using Right-Drag Menu       575 (1)
        Building a Link by Using the Mouse         576 (1)
        Links to External Workbooks Default to     577 (1)
        Absolute References
        Building a Formula by Typing               577 (1)
        Creating Links to Unsaved Workbooks        578 (1)
        Using the Links Tab on the Trust Center    578 (1)
        Opening Workbooks with Links to Closed     579 (1)
        Workbooks
        Dealing with Missing Linked Workbooks      579 (1)
        Preventing the Update Links Dialog from    580 (1)
        Appearing
      Connecting to Data on a Web Page             581 (3)
        Setting Up a Connection to a Web Page      581 (3)
        Managing Properties for Web Queries        584 (1)
      Setting Up a Connection to a Text File       584 (4)
      Setting Up a Connection to an Access         588 (1)
      Database
      Setting Up SQL Server, XML, OLE DB, and      589 (6)
      ODBC Connections
        Connecting to XML Data                     590 (2)
        Connecting Using Microsoft Query           592 (3)
      Managing Connections                         595 (4)
    17 Using Super Formulas in Excel               599 (20)
      Using 3D Formulas to Spear Through Many      599 (4)
      Worksheets
        Referring to the Previous Worksheet        600 (3)
      Combining Multiple Formulas into One         603 (3)
      Formula
      Calculating a Cell Reference in the          606 (3)
      Formula by Using the INDIRECT Function
        Using Offset to Refer to a Range That      608 (1)
        Dynamically Resizes
      Assigning a Formula to a Name                609 (4)
        Turning a Range of Formulas on Its Side    611 (2)
      Replacing Multiple Formulas with One         613 (6)
      Array Formula
        Setting Up an Array Formula                615 (1)
        Understanding an Array Formula             616 (1)
        Coercing a Range of Dates Using an         616 (3)
        Array Formula
    18 Using Names in Excel                        619 (24)
      Use the Name Box to Define a Name for a      619 (2)
      Cell
      Naming a Cell by Using the Name Dialog       621 (1)
      Using the Name Box for Quick Navigation      622 (1)
      Using Scope to Allow Duplicate Names in a    622 (2)
      Workbook
      Using Named Ranges to Simplify Formulas      624 (7)
        Retroactively Applying Names to Formulas   625 (2)
        Using Names to Refer to Multiple-Cell      627 (1)
        Ranges
        Dealing with Invalid Legacy Naming         627 (1)
        Adding Many Names at Once from Existing    628 (3)
        Labels and Headings
      Managing Names                               631 (2)
        Filtering the Name Manager Dialog          632 (1)
      Using a Name to Simplify an Absolute         633 (1)
      Reference
      Using a Name to Hold a Value                 634 (1)
      Assigning a Formula to a Name                635 (8)
        Using Basic Named Formulas                 636 (1)
        Using Dynamic Named Formulas               636 (2)
        Using a Named Formula to Point to the      638 (5)
        Cell Above
    19 Fabulous Table Intelligence                 643 (24)
      Defining Suitable Data for Excel Tables      644 (5)
        Defining a Table                           644 (1)
        Keeping Headers in View                    645 (1)
        Freezing Worksheet Panes                   646 (1)
        Clearing Freeze Panes                      647 (1)
        Using the Old Version of Freeze Panes      647 (2)
        for Absolute Control
      Adding a Total Row to a Table                649 (1)
      Toggling Totals                              649 (1)
      Expanding a Table                            650 (2)
        Adding Rows to a Table Automatically       651 (1)
        Manually Resizing a Table                  651 (1)
        Adding New Columns to a Table              651 (1)
      Adding New Formulas to Tables                652 (2)
        Stopping the Automatic Copying of          653 (1)
        Formulas
        Formatting the Results of a New Formula    654 (1)
      Selecting Only the Data in the Column        654 (4)
        Selecting by Right-Clicking                655 (1)
        Selecting by Using Shortcuts               655 (1)
        Selecting by Using the Arrow Mouse         656 (2)
        Pointers
      Using Table Data for Charts to Ensure        658 (1)
      Stickiness
      Replacing Named Ranges with Table            659 (4)
      References
        Referencing an Entire Table from           659 (1)
        Outside the Table
        Referencing Table Columns from Outside     660 (2)
        a Table
        Using Structured References to Refer to    662 (1)
        Tables in Formulas
      Creating Banded Rows and Columns with        663 (2)
      Table Styles
        Customizing a Table Style: Creating        663 (2)
        Double-Height Banded Rows
        Creating Banded Rows Outside a Table       665 (1)
      Dealing with the AutoFilter Drop-Downs       665 (2)
  III Business Intelligence
    20 Sorting Data                                667 (12)
      Introducing the Sort Dialog                  668 (1)
      Using Specialized Sorting                    669 (5)
        Sorting by Color or Icon                   669 (1)
        Factoring Case into a Sort                 670 (1)
        Reordering Columns with a Left-to-Right    671 (1)
        Sort
        Sorting into a Unique Sequence by Using    672 (2)
        Custom Lists
      One-Click Sorting                            674 (1)
        Sorting by Several Columns Using           674 (1)
        One-Click Sorting
      Sorting Randomly                             675 (4)
    21 Removing Duplicates and Filtering           679 (18)
      Filtering Records                            679 (10)
        Using a Filter                             680 (1)
        Selecting One or Multiple Items from       681 (1)
        the Filter Drop-Down
        Identifying Columns With Filters           682 (1)
        Combining Filters                          683 (1)
        Clearing Filters                           683 (1)
        Refreshing Filters                         683 (1)
        Resizing the Filter Drop-Down              683 (1)
        Filtering by Selection---Hard Way          684 (1)
        Filtering by Selection---Easy Way          684 (1)
        Filtering by Color or Icon                 685 (2)
        Handling Date Filters                      687 (1)
        Using Special Filters for Dates, Text,     688 (1)
        and Numbers
      Sorting Filtered Results                     689 (2)
        Totaling Filtered Results                  690 (1)
        Formatting and Copying Filtered Results    690 (1)
      Using the Advanced Filter Command            691 (2)
      Using Remove Duplicates to Find Unique       693 (4)
      Values
        Removing Duplicates Based on Several       694 (1)
        Columns
        Handling Duplicates Other Ways             695 (1)
        Combining Duplicates and Adding Values     695 (2)
    22 Using Automatic Subtotals                   697 (14)
      Adding Automatic Subtotals                   697 (2)
      Working with the Subtotals                   699 (6)
        Showing a One-Page Summary with Only       699 (1)
        the Subtotals
        Sorting the Collapsed Subtotal View So     699 (2)
        the Largest Customers Are on Top
        Copying Only the Subtotal Rows             701 (2)
        Formatting the Subtotal Rows               703 (2)
        Removing Subtotals                         705 (1)
      Using Specialty Subtotal Techniques          705 (6)
        Summing Some Columns While Counting        705 (2)
        Another Column
        Adding a Blank Row After Each Subtotal     707 (2)
        Add Subtotals by Two Fields                709 (2)
    23 Using Pivot Tables to Analyze Data          711 (20)
      Creating Your First Pivot Table              713 (1)
      When you have your data in the correct       713 (2)
      format, creating and changing a pivot
      table is easy
      Dealing with the Compact Layout              715 (1)
      Rearranging a Pivot Table                    716 (2)
      Finishing Touches: Numeric Formatting and    718 (2)
      Removing Blanks
      Four Things You Have to Know When Using      720 (1)
      Pivot Tables
        Your Pivot Table Is in Manual              720 (1)
        Calculation Mode Until You Click
        Refresh!
        One Blank Cell in a Value Column Causes    720 (1)
        Excel to Count Instead of Sum
        If You Click Outside of the Pivot          721 (1)
        Table, All the Pivot Table Tools
        Disappear
        You Cannot Change, Move a Part of, or      721 (1)
        Insert Cells in a Pivot Table
      Calculating and Roll-Ups with Pivot Tables   721 (8)
        Grouping Daily Dates to Months and Years   721 (3)
        Adding Calculations Outside the Pivot      724 (1)
        Table
        Showing Percentage of Total                725 (1)
        Showing Running Totals and Rank            726 (1)
        Using a Formula to Add a Field to a        726 (3)
        Pivot Table
      Formatting a Pivot Table                     729 (1)
        Using the PivotTable Styles                729 (1)
      Finding More Information on Pivot Tables     730 (1)
    24 Using Slicers and Filtering a Pivot Table   731 (22)
      Filtering Using the Row Label Filter         731 (11)
        Filtering Using the Search Box             733 (2)
        Clearing a Filter                          735 (1)
        Filtering Using the Check Boxes            735 (1)
        Filtering Using the Label Filter Flyout    735 (2)
        Filtering Using the Date Filters           737 (1)
        Filtering Using Value Filters              737 (2)
        Filtering to the Top 10                    739 (3)
      Filtering Using Report Filter Fields         742 (3)
        Arranging the Filters                      743 (1)
        Selecting Multiple Items                   743 (2)
      Filtering Using Slicers                      745 (4)
        Adding Slicers                             745 (1)
        Arranging the Slicers                      746 (1)
        Formatting the Slicers                     747 (1)
        Using the Slicers                          747 (2)
      Filtering Oddities                           749 (1)
        AutoFiltering a Pivot Table                749 (1)
        Applying Row Label Filters to Fields       749 (1)
        Not in the Pivot Table Report
        Replicating a Pivot Table for Every        750 (1)
        Customer
      Sorting a Pivot Table                        750 (3)
        Why Not Sort Using the Data Tab?           752 (1)
    25 Mashing Up Data with PowerPivot             753 (38)
      Benefits and Drawbacks to PowerPivot         753 (3)
        Mega-Benefits of PowerPivot                753 (1)
        Moderate Benefits of PowerPivot            754 (1)
        Why Is This Free?                          754 (1)
        Benefits of the Server Version of          755 (1)
        PowerPivot
        Drawbacks to Using PowerPivot              756 (1)
      Installing PowerPivot                        756 (1)
      Case Study: Building a PowerPivot Report     757 (13)
        Import a Text File                         757 (4)
        Add Excel Data by Copying and Pasting      761 (2)
        Add Excel Data by Linking                  763 (1)
        Define Relationships                       764 (1)
        Add Calculated Columns Using DAX           764 (2)
        Build a Pivot Table                        766 (2)
        Slicers in PowerPivot                      768 (2)
      Some Things Are Different                    770 (1)
      Two Kinds of DAX Calculations                771 (6)
        DAX Calculations for Calculated Columns    771 (3)
        Using RELATED () to Base a Column          774 (3)
        Calculation on Another Table
      Using DAX to Create New Measures             777 (10)
        Count Distinct Using DAX                   777 (4)
        When "Filter, Then Calculate" Doesn't      781 (3)
        Work in DAX Measures
        Mix In Those Amazing Time Intelligence     784 (3)
        Functions
      Other Notes                                  787 (4)
        Combination Layouts                        787 (1)
        Report Formatting                          788 (1)
        Refreshing PowerPivot Versus Refreshing    789 (1)
        Pivot Table
        Getting Your Data into PowerPivot with     789 (1)
        SQL Server
        Other Issues                               790 (1)
    26 Using What-If, Scenario Manager, Goal       791 (26)
    Seek, and Solver
      Using What-If                                791 (4)
        Creating a Two-Variable What-If Table      792 (3)
      Using Scenario Manager                       795 (7)
        Creating a Scenario Summary Report         798 (2)
        Adding Multiple Scenarios                  800 (2)
      Using Goal Seek                              802 (5)
      Using Solver                                 807 (10)
        Installing Solver                          807 (1)
        Solving a Model Using Solver               808 (9)
    27 Automating Repetitive Functions Using       817 (40)
    VBA Macros
      Checking Security Settings Before Using      817 (1)
      Macros
        Enabling VBA Security                      818 (1)
      Recording a Macro                            818 (1)
      Case Study: Macro for Formatting for a       819 (8)
      Mail Merge
        How Not to Record a Macro: The Default     822 (2)
        State of the Macro Recorder
        Relative References in Macro Recording     824 (1)
        Starting the Macro Recorder                824 (2)
        Running a Macro                            826 (1)
      Everyday-Use Macro Example: Formatting an    827 (4)
      Invoice Register
        Using the End Key to Handle a Variable     827 (3)
        Number of Rows
        Editing a Macro                            830 (1)
      Understanding VBA Code---An Analogy          831 (6)
        Comparing Object.Method to Nouns and       832 (1)
        Verbs
        Comparing Collections to Plural Nouns      832 (1)
        Comparing Parameters to Adverbs            832 (4)
        Comparing Adjectives                       836 (1)
        Using the Analogy While Examining          836 (1)
        Recorded Code
      Using Simple Variables and Object            837 (3)
      Variables
        Using R1C1-Style Formulas                  838 (2)
        Fixing Calculation Errors in Macros        840 (1)
      Customizing the Everyday-Use Macro           840 (2)
      Example: GETOPENFILENAME and
      GETSAVEASFILENAME
      From-Scratch Macro Example: Loops, Flow      842 (7)
      Control, and Referring to Ranges
        Finding the Last Row with Data             842 (1)
        Looping Through All Rows                   843 (1)
        Referring to Ranges                        844 (1)
        Combining a Loop with FinalRow             844 (1)
        Making Decisions by Using Flow Control     845 (1)
        Putting Together the From-Scratch          846 (1)
        Example: Testing Each Record in a Loop
        A Special Case: Deleting Some Records      847 (2)
      Combination Macro Example: Creating a        849 (8)
      Report for Each Customer
        Using the Advanced Filter for Unique       851 (2)
        Records
        Using AutoFilter                           853 (1)
        Selecting Visible Cells Only               854 (1)
        Combination Macro Example: Putting It      855 (2)
        All Together
    28 More Tips and Tricks for Excel 2010         857 (14)
      Speeding Up Calculation by Using             857 (1)
      Multithreaded Calculation
      Watching the Results of a Distant Cell       858 (1)
      Opening the Same Files Every Day             859 (1)
      Comparing Documents Side by Side with        860 (1)
      Synchronous Scrolling
      Calculating a Formula in Slow Motion         861 (1)
      Inserting a Symbol in a Cell                 862 (1)
      Edit an Equation                             863 (1)
      Adding a Digital Signature Line to a         864 (1)
      Workbook
      Protecting a Worksheet                       865 (1)
      Sharing a Workbook                           866 (1)
      Separating Text Based on a Delimiter         867 (1)
      Translating Text                             868 (3)
    29 Tour of the Best Add-Ins for Excel          871 (4)
      Charting Utilities from Jon Peltier          871 (1)
      Creating Dashboards by Using Speedometer     872 (1)
      Chart Creator
      Add Labels to XY Charts                      872 (1)
      Loading PDF Data to Excel by Using           873 (1)
      Able2Extract
      Customizing the Ribbon Using                 873 (1)
      CustomizeRibbon
      Accessing More Functions by Using            873 (1)
      MOREFUNC. DLL
      General Purpose Utility Suites               874 (1)
        Utilities for Data Analysis Tasks          874 (1)
  IV Visual Presentation of Data
    30 Formatting Worksheets                       875 (50)
      Why Format Worksheets?                       875 (2)
      Using Traditional Formatting                 877 (24)
        Changing Numeric Formats by Using the      879 (2)
        Home Tab
        Changing Numeric Formats by Using          881 (4)
        Built-in Formats in the Format Cells
        Dialog
        Changing Numeric Formats Using Custom      885 (4)
        Formats
        Aligning Cells                             889 (1)
        Changing Font Size                         890 (1)
        Changing Font Typeface                     890 (1)
        Applying Bold, Italic, and Underline       891 (1)
        Using Borders                              892 (2)
        Coloring Cells                             894 (2)
        Adjusting Column Widths and Row Heights    896 (1)
        Using Merge and Center                     897 (2)
        Rotating Text                              899 (2)
      Formatting with Styles                       901 (2)
      Understanding Themes                         903 (10)
        Choosing a New Theme                       903 (2)
        Creating a New Theme                       905 (8)
      Other Formatting Techniques                  913 (6)
        Formatting Individual Characters           913 (1)
        Changing the Default Font                  914 (1)
        Wrapping Text in a Cell                    915 (1)
        Justifying Text in a Range                 916 (1)
        Adding Cell Comments                       917 (2)
      Copying Formats                              919 (6)
        Pasting Formats                            919 (2)
        Pasting Conditional Formats                921 (1)
        Using the Format Painter                   921 (1)
        Copying Formats to a New Worksheet         921 (4)
    31 Using Data Visualizations and               925 (28)
    Conditional Formatting
      Using Data Bars to Create In-Cell Bar        926 (5)
      Charts
        Creating Data Bars                         928 (1)
        Customizing Data Bars                      928 (2)
        Showing Data Bars for a Subset of Cells    930 (1)
      Using Color Scales to Highlight Extremes     931 (1)
        Customizing Color Scales                   931 (1)
      Using Icon Sets to Segregate Data            932 (3)
        Setting Up an Icon Set                     933 (1)
        Moving Numbers Closer to Icons             934 (1)
      Using the Top/Bottom Rules                   935 (2)
        Setting Up Conditional Formatting Rules    935 (2)
      Using the Highlight Cells Rules              937 (5)
        Highlighting Cells by Using Greater        937 (2)
        Than and Similar Rules
        Comparing Dates by Using Conditional       939 (1)
        Formatting
        Identifying Duplicate or Unique Values     940 (1)
        by Using Conditional Formatting
        Using Conditional Formatting for Text      941 (1)
        Containing a Value
      Tweaking Rules with Advanced Formatting      942 (5)
        Using a Formula for Rules                  944 (1)
        Finding Cells Within Three Days of Today   945 (1)
        Finding Cells Containing Data from the     945 (1)
        Past 30 Days
        Highlighting Data from Specific Days of    946 (1)
        the Week
        Highlighting an Entire Row                 946 (1)
        Highlighting Every Other Row Without       947 (1)
        Using a Table
      Combining Rules                              947 (2)
      Clearing Conditional Formats                 949 (1)
      Extending the Reach of Conditional Formats   950 (1)
      Special Considerations for Pivot Tables      950 (3)
    32 Using Excel Charts                          953 (30)
      Understanding the Components of a Chart      954 (1)
      Setting Up Data for Charting                 955 (1)
      Inserting a Chart by Choosing a Chart Type   956 (5)
        Using the Create Chart Dialog              957 (3)
        Changing a Chart's Type                    960 (1)
        Moving or Resizing a Chart                 960 (1)
      Choosing a Chart Layout to Further           961 (1)
      Customize the Chart Type
      Customizing a Chart Using the Chart Tools    962 (5)
      Tabs
        Customizing a Chart by Using the Design    963 (1)
        Tab
        Changing Chart Settings Using the          964 (2)
        Layout Tab
        Micromanaging Using the Format Tab         966 (1)
      Charting Tips and Tricks                     967 (12)
        Showing Numbers of Different Scale on a    967 (3)
        Chart
        Creating a Chart with One Keystroke        970 (1)
        Adding New Data to a Chart by Pasting      970 (1)
        Adding New Data to a Chart by Using a      971 (1)
        Table
        Adding Drop Lines to a Surface Chart       972 (1)
        Predicting the Future by Using a           973 (1)
        Trendline
        Creating Stock Charts                      974 (2)
        Dealing with Small Pie Slices              976 (2)
        Displaying Three Variables by Using a      978 (1)
        Bubble Chart
        Changing the Location of a Chart           978 (1)
        Saving a Favorite Chart Style As a         978 (1)
        Template
      Using Pivot Charts                           979 (4)
    33 Using Sparklines                            983 (14)
      Fitting a Chart into the Size of a Cell      983 (1)
      with Sparklines
      Understanding How Excel Maps Data to         984 (13)
      Sparklines
        Creating a Group of Sparklines             986 (2)
        Built-In Choices for Customizing           988 (2)
        Sparklines
        Controlling Axis Values for Sparklines     990 (2)
        Setting Up Win/Loss Sparklines             992 (1)
        Showing Detail by Enlarging the            993 (2)
        Sparkline and Adding Labels
        Other Sparkline Options                    995 (2)
    34 Using SmartArt, Shapes, WordArt, and        997 (26)
    Text Boxes
      Using SmartArt                               998 (17)
        Elements Common in Most SmartArt           998 (1)
        Tour of the SmartArt Categories            999 (1)
        Inserting SmartArt                         1000(5)
        Micromanaging SmartArt Elements            1005(1)
        Controlling SmartArt Shapes from the       1006(3)
        Text Pane
        Adding Images to SmartArt                  1009(1)
        Special Considerations for                 1010(3)
        Organizational Charts and Hierarchical
        SmartArt
        Using Limited SmartArt                     1013(1)
        Deciphering the Labeled Hierarchy          1014(1)
        Layouts
      Using Shapes to Display Cell Contents        1015(3)
        Working with Shapes                        1016(1)
        Using the Freeform Shape to Create a       1017(1)
        Custom Shape
      Using WordArt for Interesting Titles and     1018(5)
      Headlines
    35 Using Pictures and Clip Art                 1023(16)
      Using Pictures on Worksheets                 1023(12)
        Formatting with Picture Styles             1024(1)
        Resizing and Cropping Pictures             1024(2)
        Reducing a Picture's File Size             1026(1)
        Adjusting a Picture                        1027(3)
        Adding Borders                             1030(1)
        Removing the Background                    1030(2)
        Arranging Pictures                         1032(2)
        Displaying the Selection Pane              1034(1)
        Adding Captions to Images                  1034(1)
      Inserting Screen Clippings                   1035(1)
      Using Clip Art                               1036(3)
  V Sharing
    36 Printing                                    1039(20)
      Printing from Backstage View                 1039(5)
        Choosing a Printer                         1041(1)
        Choosing What to Print                     1041(1)
        Changing Printer Properties                1042(1)
        Changing Some of the Page Setup Settings   1042(1)
        Using Print Preview Controls               1043(1)
        Closing Backstage View                     1044(1)
        Printing Using Quick Print                 1044(1)
      Using Page Layout View                       1044(2)
      Using the Improved Headers and Footers       1046(4)
        Adding an Automatic Header                 1046(1)
        Adding a Custom Header                     1047(1)
        Inserting a Picture in a Header            1048(1)
        Using Different Headers and Footers in     1048(2)
        the Same Document
        Scaling Headers and Footers                1050(1)
      Using the Page Setup and Sheet Options       1050(5)
        Adjusting Worksheet Margins                1050(2)
        Adjusting Worksheet Orientation            1052(1)
        Setting Worksheet Paper Size               1052(1)
        Setting the Print Area                     1052(1)
        Adding Print Titles                        1053(1)
        Scaling Options                            1053(1)
        Printing Gridlines and Headings            1054(1)
      Working with Page Breaks                     1055(4)
        Manually Adding Page Breaks                1055(1)
        Manual Versus Automatic Page Breaks        1056(1)
        Using Page Break Preview to Make Changes   1056(1)
        Removing Manual Page Breaks                1057(2)
    37 Excel Web App and Other Ways to Share       1059(20)
    Workbooks
      Sharing Workbooks with Others                1059(7)
        Using the Excel Web Application            1059(6)
        Advantages of Creating a Client Version    1065(1)
        of Your Workbook
      Sending a Workbook via Email                 1066(3)
        Creating a PDF from a Worksheet            1066(3)
      Publishing to Excel Services on SharePoint   1069(1)
      Interacting with Other Office Applications   1070(9)
        Pasting Excel Data to Microsoft OneNote    1071(1)
        Using Excel Charts in PowerPoint           1072(1)
        Creating Tables in Excel and Pasting to    1073(1)
        Word
        Pasting Word Data to an Excel Text Box     1073(1)
        Using Excel Data in a Word Mail Merge      1074(2)
        Building a Pivot Table from Access         1076(3)
        Queries
    38 Saving Time Using the Easy-XL Program       1079(18)
      Downloading and Installing Easy-XL           1079(1)
        Easy-XL Works Best with Tabular Data       1080(1)
      Doing Away with VLOOKUP                      1080(6)
        Using a Fuzzy Match                        1082(4)
      Text to Columns on Steroids                  1086(2)
      Sorting Columns Left to Right                1088(1)
      Summarizing Data                             1088(3)
        Adding Statistics to the Report            1089(1)
        Getting Quick Statistics                   1090(1)
      Transforming Data Instead of TRIM(),         1091(2)
      PROPER(), CLEAN()
        Adding Text to Cells                       1091(2)
        Filling in the Annoying Outline View       1093(1)
      There's More                                 1093(4)
        Deal with Fiscal Years                     1095(1)
        Record Easy-XL Commands into VBA Macros    1095(2)
Index                                              1097
 

Excel 2010 In Depth is the beyond-the-basics, beneath-the-surface guide for everyone who wants to streamline their work with Excel 2010, and get more done in less time. Legendary Excel expert Bill Jelen provides specific, tested, proven solutions to the problems Excel users run into every day: challenges other books ignore or oversimplify. Jelen thoroughly covers all facets of working with Excel 2010, and adds new chapters on Excel Web App which allows multiple users to edit a spreadsheet simultaneously. New coverage also includes: Slicer, which offers dynamic filtering of PivotTables; Sparklines, which add data visualization to any cell; Calculation engine which improves the speed and accuracy of math, financial, and statistical functions; and the new version of Solver. As with all In Depth books, Excel 2010 In Depth presents comprehensive coverage, breakthrough techniques, exclusive shortcuts, quick access to information, troubleshooting help for tough problems, and real-world examples with nothing glossed over or left out.Step-by-step instructions with icons guide readers through essential tasks such as designing tables, entering data, importing external data, designing and executing queries, and designing data entry forms and printed reports. Additional chapters on advanced form and report design emphasize data entry efficiency and presentation clarity. * By Bill Jelen, aka MrExcel, an Excel MVP and the principal behind the leading Excel website, MrExcel.com * Covers all aspects of working with Excel 2010, from its updated Ribbon interface to its breakthrough collaboration and improved business intelligence * For everyone who wants to get the most out of Excel 2010, from casual users to corporate professionals

Contents
I. Changes in User Interface 1 Out vs In actionsRibbon, QAT, Galleries 3 Customizing Ribbon 4 Mini Toolbar, Normal vs Page Layout, Zoom, Live Preview 5 Keyboard Shortcuts 6 Excel Options 7 Compatibility Mode (Big Grid, File Formats) II. Calculating with Excel 8 Formulas 9 Controlling Formulas 10 Understanding Functions 11 Everyday Functions 12 Logical, Lookup, Database 13 Financial 14 Statistical 15 Trig, Matrix, Engineering 16 Connecting Worksheets and External Data 17 Super Formulas 18 Names 19 Tables III. Business Intelligence 20 Sorting 21 Filtering 22 Subtotals 23 Pivot Tables 24 Gemini 25 Slicers 26 What-If Analysis 27 VBA Macros 28 Tips and Tricks 29 Add-Ins IV. Visual Presentation of Data 30 Formatting, Themes, Cell Styles 31 Data Visualizations 32 Charting 33 Sparklines 34 Using SmartArt, Shapes, WordArt and TextBoxes 35 Pictures and ClipArt V. Sharing 36 Printing 37 Sharing 38 Excel Services