Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

    Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

    Start ReadingShareBuy Print Version
    Microsoft® Excel® 2010 Inside Out

    • Microsoft® Excel® 2010 Inside Out

    • By: ;

    • Publisher: Microsoft Press

    • Pub. Date:

    • Print ISBN-13: 978-0-7356-2688-1

    • Pages in Print Edition: 1152

    • Subscriber Rating: 5 out of 5 rating5 [2 Ratings]

    1ebooken
    Subscriber Reviews • Browse Similar Topics

    Overview

    The ultimate, in-depth reference for conquering Excel 2010-from the inside out! This supremely organized book delivers hundreds of timesaving solutions, troubleshooting tips, and workarounds so you can really put Excel to work.

    Subscriber Reviews

    Average Rating: 5 out of 5 rating Based on 2 Ratings

    No Subscribers have provided a review for this book.

    Table of Contents

     

    View Sample

    Microsoft® Excel® 2010 Inside Out

    View Sample

    Dedication

    View Sample

    A Note Regarding Supplemental Files

    View Sample

    Acknowledgments

    View Sample
    Questions and Support
    View Sample

    Using the Companion Content

    View Sample

    Your Companion eBook

    View Sample

    Support Information

    View Sample

    We Want to Hear from You

    View Sample
    Conventions and Features Used in This Book
    View Sample

    Text Conventions

    View Sample

    Design Conventions

    View Sample

    1. Examining the Excel Environment

    View Sample
    1. What’s New in Microsoft Excel 2010
    View Sample

    New and Improved for 2010

    View Sample

    If You Missed the Last Upgrade

    View Sample

    Retired in 2007

    View Sample

    If You Missed the Last Two Upgrades

    View Sample

    Onward

    View Sample
    2. Exploring Excel Fundamentals
    View Sample

    What Happens After You Install Excel?

    View Sample

    Examining the Excel 2010 Workspace

    View Sample

    Exploring File Management Fundamentals

    View Sample

    Importing and Exporting Files

    View Sample

    Using the Help System

    View Sample

    Recovering from Crashes

    View Sample
    3. Custom-Tailoring the Excel Workspace
    View Sample

    Customizing the Ribbon

    View Sample

    Customizing the Quick Access Toolbar

    View Sample

    Controlling Other Elements of the Excel 2010 Interface

    View Sample

    Enhancing Accessibility

    View Sample
    4. Security and Privacy
    View Sample

    The Trust Center

    View Sample

    File Security

    View Sample

    Other Security Features

    View Sample

    2. Building Worksheets

    View Sample
    5. Planning Your Worksheet Design
    View Sample

    Which Data Should Be in Rows, and Which in Columns?

    View Sample

    Will You Need to Print the Worksheet?

    View Sample

    Who Is the Audience?

    View Sample

    Would Your Worksheet Survive Without You?

    View Sample

    Does the Worksheet Rely on Imported Data?

    View Sample

    Do You Need More Than One Worksheet?

    View Sample

    Have You Allowed Room for New Data?

    View Sample
    6. How to Work a Worksheet
    View Sample

    Moving Around Regions

    View Sample

    Understanding Selection

    View Sample

    Techniques for Entering Data

    View Sample

    Managing Worksheets

    View Sample

    Viewing Worksheets

    View Sample

    Protecting Worksheets

    View Sample
    7. How to Work a Workbook
    View Sample

    Managing Multiple Workbooks

    View Sample

    Opening Multiple Windows for the Same Workbook

    View Sample

    Hiding and Protecting Workbooks

    View Sample

    3. Formatting and Editing Worksheets

    View Sample
    8. Worksheet Editing Techniques
    View Sample

    Copying, Cutting, and Pasting

    View Sample

    Inserting and Deleting

    View Sample

    Undoing Previous Actions

    View Sample

    Editing Cell Contents

    View Sample

    Finding and Replacing Stuff

    View Sample

    Getting the Words Right

    View Sample

    Editing Multiple Worksheets

    View Sample

    Auditing and Documenting Worksheets

    View Sample

    Outlining Worksheets

    View Sample

    Consolidating Worksheets

    View Sample
    9. Worksheet Formatting Techniques
    View Sample

    Formatting Fundamentals

    View Sample

    Using Themes and Cell Styles

    View Sample

    Formatting Conditionally

    View Sample

    Formatting in Depth

    View Sample

    Using Template Files to Store Formatting

    View Sample

    4. Adding Graphics and Printing

    View Sample
    10. Creating and Formatting Graphics
    View Sample

    Using the Shapes Tools

    View Sample

    Creating WordArt

    View Sample

    Creating SmartArt

    View Sample

    Inserting Other Graphics

    View Sample

    Formatting Graphics

    View Sample

    Working with Graphic Objects

    View Sample

    More Tricks with Graphic Objects

    View Sample
    11. Printing and Presenting
    View Sample

    Controlling the Appearance of Your Pages

    View Sample

    Controlling What and Where to Print

    View Sample

    Adjusting Page Breaks

    View Sample

    Using Print Preview

    View Sample

    Creating Portable Documents

    View Sample

    5. Creating Formulas and Performing Data Analysis

    View Sample
    12. Building Formulas
    View Sample

    Formula Fundamentals

    View Sample

    Using Functions: A Preview

    View Sample

    Working with Formulas

    View Sample

    Worksheet Calculation

    View Sample

    Using Arrays

    View Sample

    Linking Workbooks

    View Sample

    Creating Conditional Tests

    View Sample
    13. Using Functions
    View Sample

    Using the Built-In Function Reference in Excel

    View Sample

    Exploring the Syntax of Functions

    View Sample

    Inserting Functions

    View Sample
    14. Everyday Functions
    View Sample

    Understanding Mathematical Functions

    View Sample

    Understanding Text Functions

    View Sample

    Understanding Logical Functions

    View Sample

    Understanding Information Functions

    View Sample

    Understanding Lookup and Reference Functions

    View Sample
    15. Formatting and Calculating Date and Time
    View Sample

    Understanding How Excel Records Dates and Times

    View Sample

    Entering Dates and Times

    View Sample

    Formatting Dates and Times

    View Sample

    Calculating with Date and Time

    View Sample

    Working with Date and Time Functions

    View Sample
    16. Functions for Financial Analysis
    View Sample

    Calculating Investments

    View Sample

    Calculating Depreciation

    View Sample

    Analyzing Securities

    View Sample

    Using the Euro Currency Tools Add-In

    View Sample
    17. Functions for Analyzing Statistics
    View Sample

    Analyzing Distributions of Data

    View Sample

    Understanding Linear and Exponential Regression

    View Sample

    Using the Analysis Toolpak Data Analysis Tools

    View Sample
    18. Performing What-If Analysis
    View Sample

    Using Data Tables

    View Sample

    Using the Scenario Manager

    View Sample

    Using the Goal Seek Command

    View Sample

    Using the Solver

    View Sample

    6. Creating Charts

    View Sample
    19. Basic Charting Techniques
    View Sample

    Selecting Data for Your Chart

    View Sample

    Choosing a Chart Type

    View Sample

    Changing the Chart Type

    View Sample

    Switching Rows and Columns

    View Sample

    Choosing a Chart Layout

    View Sample

    Choosing a Chart Style

    View Sample

    Moving the Chart to a Separate Chart Sheet

    View Sample

    Adding, Editing, and Removing a Chart Title

    View Sample

    Adding, Editing, and Removing a Legend

    View Sample

    Adding and Positioning Data Labels

    View Sample

    Adding a Data Table

    View Sample

    Manipulating Axes

    View Sample

    Adding Axis Titles

    View Sample

    Changing the Rotation of Chart Text

    View Sample

    Displaying Gridlines

    View Sample

    Adding Text Annotations

    View Sample

    Changing the Font or Size of Chart Text

    View Sample

    Applying Shape Styles and WordArt Styles

    View Sample

    Adding Glow and Soft Edges to Chart Markers

    View Sample

    Saving Templates to Make Chart Formats Reusable

    View Sample
    20. Using Sparklines
    View Sample

    Creating Sparklines

    View Sample

    Customizing Sparklines

    View Sample

    Removing Sparklines

    View Sample
    21. Advanced Charting Techniques
    View Sample

    Selecting Chart Elements

    View Sample

    Repositioning Chart Elements with the Mouse

    View Sample

    Formatting Lines and Borders

    View Sample

    Formatting Areas

    View Sample

    Formatting Text

    View Sample

    Working with Axes

    View Sample

    Working with Data Labels

    View Sample

    Formatting Data Series and Markers

    View Sample

    Modifying the Data Source for Your Chart

    View Sample

    Using Multilevel Categories

    View Sample

    Adding Moving Averages and Other Trendlines

    View Sample

    Adding Error Bars

    View Sample

    Adding High-Low Lines and Up and Down Bars

    View Sample

    7. Managing Databases and Tables

    View Sample
    22. Managing Information in Tables
    View Sample

    How to Organize a Table

    View Sample

    Creating a Table

    View Sample

    Adding Totals to a Table

    View Sample

    Sorting Tables and Other Ranges

    View Sample

    Filtering a List or Table

    View Sample

    Using Formulas with Tables

    View Sample

    Formatting Tables

    View Sample
    23. Analyzing Data with PivotTable Reports
    View Sample

    Introducing PivotTables

    View Sample

    Creating a PivotTable

    View Sample

    Rearranging PivotTable Fields

    View Sample

    Refreshing a PivotTable

    View Sample

    Changing the Numeric Format of PivotTable Data

    View Sample

    Choosing Report Layout Options

    View Sample

    Formatting a PivotTable

    View Sample

    Displaying Totals and Subtotals

    View Sample

    Sorting PivotTable Fields

    View Sample

    Filtering PivotTable Fields

    View Sample

    Changing PivotTable Calculations

    View Sample

    Grouping and Ungrouping Data

    View Sample

    Displaying the Details Behind a Data Value

    View Sample

    Creating PivotCharts

    View Sample
    24. Working with External Data
    View Sample

    Using and Reusing Data Connections

    View Sample

    Opening an Entire Access Table in Excel

    View Sample

    Working with Data in Text Files

    View Sample

    Working with XML Files

    View Sample

    Using Microsoft Query to Import Data

    View Sample

    Using a Web Query to Return Internet Data

    View Sample

    8. Collaborating

    View Sample
    25. Collaborating on a Network or by E-Mail
    View Sample

    Saving and Retrieving Files on Remote Computers

    View Sample

    Sharing Workbooks on a Network

    View Sample

    Combining Changes Made to Multiple Workbooks

    View Sample

    Distributing Workbooks and Worksheets by E-Mail

    View Sample

    Controlling Document Access with Information Rights Management

    View Sample
    26. Collaborating Using the Internet
    View Sample

    Using Windows Live SkyDrive

    View Sample

    Using Microsoft Office Web Apps

    View Sample

    9. Automating Excel

    View Sample
    27. Recording Macros
    View Sample

    Configuring Macro Security

    View Sample

    Using the Macro Recorder

    View Sample

    Introducing the Visual Basic Editor

    View Sample

    Learning the Basics of Visual Basic

    View Sample

    Adding Code to or Editing Recorded Macros

    View Sample

    Using Subroutines in Macros

    View Sample

    Using the Personal Macro Workbook

    View Sample

    Going On from Here

    View Sample
    28. Creating Custom Functions
    View Sample

    Creating a Simple Custom Function

    View Sample

    Using Custom Functions

    View Sample

    Understanding Custom Function Rules

    View Sample

    Using VBA Keywords in Custom Functions

    View Sample

    Documenting Macros and Custom Functions

    View Sample

    Creating Custom Functions with Optional Arguments

    View Sample

    Making Your Custom Functions Available Anywhere

    View Sample
    29. Debugging Macros and Custom Functions
    View Sample

    Using Design-Time Tools

    View Sample

    Dealing with Run-Time Errors

    View Sample

    10. Integrating Excel with Other App ication

    View Sample
    30. Using Hyperlinks
    View Sample

    Creating a Hyperlink in a Cell

    View Sample

    Assigning a Hyperlink to a Shape, Image, or Chart

    View Sample

    Selecting a Cell or an Object Without Triggering the Hyperlink

    View Sample

    Using Formulas to Create Hyperlinks

    View Sample
    31. Linking and Embedding
    View Sample

    Embedding vs. Linking

    View Sample

    Embedding vs. Static Pasting

    View Sample

    Embedding and Linking from the Clipboard

    View Sample

    Embedding and Linking with the Object Command

    View Sample

    Managing Links

    View Sample

    Linking vs. Hyperlinking

    View Sample
    32. Using Excel Data in Word Documents
    View Sample

    Using Excel Tables in Word Documents

    View Sample

    Using Excel Charts in Word Documents

    View Sample

    Using Excel to Supply Mail-Merge Data to Word

    View Sample

    11. Appendixes

    View Sample
    A. Menu to Ribbon Command Reference
    View Sample

    Excel 2003 File Menu

    View Sample

    Excel 2003 Edit Menu

    View Sample

    Excel 2003 View Menu

    View Sample

    Excel 2003 Insert Menu

    View Sample

    Excel 2003 Format Menu

    View Sample

    Excel 2003 Tools Menu

    View Sample

    Excel 2003 Data Menu

    View Sample

    Excel 2003 Chart Menu

    View Sample

    Excel 2003 Window Menu

    View Sample

    Excel 2003 Help Menu

    View Sample

    Excel 2003 Standard Toolbar

    View Sample

    Excel 2003 Formatting Toolbar

    View Sample
    B. Keyboard Shortcuts
    View Sample

    Keyboard Shortcuts by Key

    View Sample

    Keyboard Shortcuts by Task

    View Sample
    C. Function Reference
    View Sample

    Alphabetical List of Excel 2010 Functions

    View Sample

    Alphabetical List of Excel 2010 Functions (continued)

    View Sample

    Index

    View Sample

    About the Authors

    View Sample

    Copyright

    Extras

    The publisher has provided additional content related to this title.


    Description
    Content

    Visit the catalog page for Microsoft® Excel® 2010 Inside Out

    • Catalog Page

    Visit the errata page for Microsoft® Excel® 2010 Inside Out

    • Errata

    Download the supplemental electronic content for Microsoft® Excel® 2010 Inside Out

    • Supplemental Content

    Download the complete PDF of this book.

    • Microsoft® Excel® 2010 Inside Out