Microsoft Excel 2010 Inside Out

by Stinson, Craig; Dodge, Mark

• ISBN13: 9780735626881
• ISBN10: 073562688X
• Edition: 1st
• Format: Paperback
• Copyright: 2019-11-21
• Publisher: Microsoft Press

Summary

You're beyond the basics, so dive in and really put your spreadsheet skills to work! This supremely organized reference is packed with hundreds of timesaving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts tackle Excel® 2010-and challenge yourself to new levels of mastery! Learn expert techniques for designing powerful spreadsheets Apply built-in functions-or write your own-and carry out complex calculations Use rich charting and graphic capabilities to visualize data Perform sophisticated data analysis: financial, statistical, and "what-if" Design PivotTable reports to dynamically analyze data Share and collaborate with others-while managing sensitive data Link and embed Excel® data into other documents Create macros with Microsoft® Visual Basic® for Applications Sample spreadsheets from inside the book Add-ins and other resources to help you extend Microsoft Office programs Links to demos, user communities, and product support

Author Biography

Mark Dodge has coauthored several popular books on Excel®, including Microsoft® Office Excel® 2003 Inside Out. He is a former senior technical writer for the Microsoft® Office User Assistance group.

Craig Stinson is a computer journalist and author. He has written or coauthored more than 20 books, including Microsoft® Windows® XP Inside Out, Deluxe Edition.

Table of Contents

Acknowledgments

Questions and Support

Using the Companion Content

Support Information

We Want to Hear from You

Conventions and Features Used in This Book

Text Conventions

Design Conventions

Examining the Excel Environment

What's New in Microsoft Excel 2010

New and Improved for 2010

If You Missed the Last Upgrade

Retired in 2007

If You Missed the Last Two Upgrades

Onward

Exploring Excel Fundamentals

What Happens After You Install Excel?

Examining the Excel 2010 Workspace

Exploring File Management Fundamentals

Importing and Exporting Files

Using the Help System

Recovering from Crashes

Custom-Tailoring the Excel Workspace

Customizing the Ribbon

Customizing the Quick Access Toolbar

Controlling Other Elements of the Excel 2010 Interface

Enhancing Accessibility

Security and Privacy

The Trust Center

File Security

Other Security Features

Building Worksheets

Planning Your Worksheet Design

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

Will You Need to Print the Worksheet?

Who Is the Audience?

Would Your Worksheet Survive Without You?

Does the Worksheet Rely on Imported Data?

Do You Need More Than One Worksheet?

Have You Allowed Room for New Data?

How to Work a Worksheet

Moving Around Regions

Understanding Selection

Techniques for Entering Data

Managing Worksheets

Viewing Worksheets

Protecting Worksheets

How to Work a Workbook

Managing Multiple Workbooks

Opening Multiple Windows for the Same Workbook

Hiding and Protecting Workbooks

Formatting and Editing Worksheets

Worksheet Editing Techniques

Copying, Cutting, and Pasting

Inserting and Deleting

Undoing Previous Actions

Editing Cell Contents

Finding and Replacing Stuff

Getting the Words Right

Editing Multiple Worksheets

Auditing and Documenting Worksheets

Outlining Worksheets

Consolidating Worksheets

Worksheet Formatting Techniques

Formatting Fundamentals

Using Themes and Cell Styles

Formatting Conditionally

Formatting in Depth

Using Template Files to Store Formatting

Adding Graphics and Printing

Creating and Formatting Graphics

Using the Shapes Tools

Creating WordArt

Creating SmartArt

Inserting Other Graphics

Formatting Graphics

Working with Graphic Objects

More Tricks with Graphic Objects

Printing and Presenting

Controlling the Appearance of Your Pages

Controlling What and Where to Print

Adjusting Page Breaks

Using Print Preview

Creating Portable Documents

Creating Formulas and Performing Data Analysis

Building Formulas

Formula Fundamentals

Using Functions: A Preview

Working with Formulas

Worksheet Calculation

Using Arrays

Linking Workbooks

Creating Conditional Tests

Using Functions

Using the Built-In Function Reference in Excel

Exploring the Syntax of Functions

Inserting Functions

Everyday Functions

Understanding Mathematical Functions

Understanding Text Functions

Understanding Logical Functions

Understanding Information Functions

Understanding Lookup and Reference Functions

Formatting and Calculating Date and Time

Understanding How Excel Records Dates and Times

Entering Dates and Times

Formatting Dates and Times

Calculating with Date and Time

Working with Date and Time Functions

Functions for Financial Analysis

Calculating Investments

Calculating Depreciation

Analyzing Securities

Using the Euro Currency Tools Add-In

Functions for Analyzing Statistics

Analyzing Distributions of Data

Understanding Linear and Exponential Regression

Using the Analysis Toolpak Data Analysis Tools

Performing What-If Analysis

Using Data Tables

Using the Scenario Manager

Using the Goal Seek Command

Using the Solver

Creating Charts

Basic Charting Techniques

Selecting Data for Your Chart

Choosing a Chart Type

Changing the Chart Type

Switching Rows and Columns

Choosing a Chart Layout

Choosing a Chart Style

Moving the Charrrrrrt to a Separate Chart Sheet

Adding, Editing, and Removing a Chart Title

Adding, Editing, and Removing a Legend

Adding and Positioning Data Labels

Adding a Data Table

Manipulating Axes

Adding Axis Titles

Changing the Rotation of Chart Text

Displaying Gridlines

Adding Text Annotations

Changing the Font or Size of Chart Text

Applying Shape Styles and WordArt Styles

Adding Glow and Soft Edges to Chart Markers

Saving Templates to Make Chart Formats Reusable

Using Sparklines

Creating Sparklines

Customizing Sparklines

Removing Sparklines

Advanced Charting Techniques

Selecting Chart Elements

Repositioning Chart Elements with the Mouse

Formatting Lines and Borders

Formatting Areas

Formatting Text

Working with Axes

Working with Data Labels

Formatting Data Series and Markers

Modifying the Data Source for Your Chart

Using Multilevel Categories

Adding Moving Averages and Other Trendlines

Adding Error Bars

Adding High-Low Lines and Up and Down Bars

Managing Databases and Tables

Managing Information in Tables

How to Organize a Table

Creating a Table

Adding Totals to a Table

Sorting Tables and Other Ranges

Filtering a List or Table

Using Formulas with Tables

Formatting Tables

Analyzing Data with PivotTable Reports

Introducing PivotTables

Creating a PivotTable

Rearranging PivotTable Fields

Refreshing a PivotTable

Changing the Numeric Format of PivotTable Data

Choosing Report Layout Options

Formatting a PivotTable

Displaying Totals and Subtotals

Sorting PivotTable Fields

Filtering PivotTable Fields

Changing PivotTable Calculations

Grouping and Ungrouping Data

Displaying the Details Behind a Data Value

Creating PivotCharts

Working with External Data

Using and Reusing Data Connections

Opening an Entire Access Table in Excel

Working with Data in Text Files

Working with XML Files

Using Microsoft Query to Import Data

Using a Web Query to Return Internet Data

Collaborating

Collaborating on a Network or by E-Mail

Saving and Retrieving Files on Remote Computers

Sharing Workbooks on a Network

Combining Changes Made to Multiple Workbooks

Distributing Workbooks and Worksheets by E-Mail

Controlling Document Access with Information Rights Management

Collaborating Using the Internet

Using Windows Live SkyDrive

Using Microsoft Office Web Apps

Automating Excel

Recording Macros

Configuring Macro Security

Using the Macro Recorder

Introducing the Visual Basic Editor

Learning the Basics of Visual Basic

Adding Code to or Editing Recorded Macros

Using Subroutines in Macros

Using the Personal Macro Workbook

Going On from Here

Creating Custom Functions

Creating a Simple Custom Function

Using Custom Functions

Understanding Custom Function Rules

Using VBA Keywords in Custom Functions

Documenting Macros and Custom Functions

Creating Custom Functions with Optional Arguments

Making Your Custom Functions Available Anywhere

Debugging Macros and Custom Functions

Using Design-Time Tools

Dealing with Run-Time Errors

Integrating Excel with Other App ication

Using Hyperlinks

Creating a Hyperlink in a Cell

Assigning a Hyperlink to a Shape, Image, or Chart

Selecting a Cell or an Object Without Triggering the Hyperlink

Using Formulas to Create Hyperlinks

Linking and Embedding

Embedding vs. Linking

Embedding vs. Static Pasting

Embedding and Linking from the Clipboard

Embedding and Linking with the Object Command

Managing Links

Linking vs. Hyperlinking

Using Excel Data in Word Documents

Using Excel Tables in Word Documents

Using Excel Charts in Word Documents

Using Excel to Supply Mail-Merge Data to Word

Appendixes

Menu to Ribbon Command Reference

Excel 2003 File Menu

Excel 2003 Edit Menu

Excel 2003 View Menu

Excel 2003 Insert Menu

Excel 2003 Format Menu

Excel 2003 Tools Menu

Excel 2003 Data Menu

Excel 2003 Chart Menu

Excel 2003 Window Menu

Excel 2003 Help Menu

Excel 2003 Standard Toolbar

Excel 2003 Formatting Toolbar

Keyboard Shortcuts

Keyboard Shortcuts by Key

Keyboard Shortcuts by Task

Function Reference;

Table of Contents provided by Publisher. All Rights Reserved.