Get the guide that makes learning Microsoft Excel 2010 plain and simple! This full color, no-nonsense book shows you the quickest ways to solve a problem or learn a skill, using easy-to-follow steps and concise, straightforward language. You'll analyze, manage, and share information in more ways than ever before.
Here's WHAT you'll learn:
Manage your financial data and personal expenses
Get started quickly with prebuilt templates
Create formulas and functions to do the hard work
Sort, filter, update, and copy your data
Use charts and graphics to bring data to life
Collaborate with colleagues by sharing spreadsheets online
Here's HOW you'll learn it:
Jump in whenever you need answers
Easy-to-follow STEPS and SCREENSHOTS show exactly what to do
Handy TIPS teach new techniques and shortcuts
Quick TRY THIS! exercises help apply what you learn right away
Chapter 1 Introduction: About This Book
No Computerese!
Useful Tasks…
…And the Easiest Way to Do Them
A Quick Overview
A Few Assumptions
A Final Word (or Two)
Chapter 2 What's New and Improved in Excel 2010
Managing Excel Files and Settings in Backstage View
Previewing Data Using Paste Preview
Customizing the Excel 2010 User Interface
Summarizing Data Using More Accurate Functions
Summarizing Data Using Sparklines
Visualizing Data Using Improved Conditional Formats
Creating and Displaying Math Equations
Editing Pictures Within Excel 2010
Chapter 3 Getting Started with Excel 2010
Surveying the Excel Program Window
Starting Excel
Finding and Opening Existing Workbooks
Using File Properties
Creating a New Workbook
Working with Multiple Workbooks
Sizing and Viewing Windows
Zooming In or Out on a Worksheet
Viewing a Worksheet in Full-Screen Mode
Saving and Closing an Excel Workbook
Using the Excel Help System
Chapter 4 Building a Workbook
Understanding How Excel Interprets Data Entry
Navigating the Worksheet
Selecting Cells
Entering Text in Cells
Entering Numbers in Cells
Entering Dates and Times in Cells
Entering Data Using Fills
Entering Data with Other Shortcuts
Creating an Excel Table
Editing Cell Contents
Inserting a Symbol in a Cell
Creating Hyperlinks
Cutting, Copying, and Pasting Cell Values
Clearing Cell Contents
Using the Office Clipboard
Undoing or Redoing an Action
Finding and Replacing Text
Checking the Spelling of Your Worksheet
Chapter 5 Managing and Viewing Worksheets
Viewing and Selecting Worksheets
Renaming Worksheets
Moving Worksheets
Copying Worksheets
Inserting and Deleting Worksheets
Hiding or Showing a Worksheet
Changing Worksheet Tab Colors
Inserting, Moving, and Deleting Cells
Inserting, Moving, and Deleting Columns and Rows
Hiding and Unhiding Columns and Rows
Entering Data and Formatting Many Worksheets at the Same Time
Changing How You Look at Excel Workbooks
Naming and Using Worksheet Views
Chapter 6 Using Formulas and Functions
Understanding Formulas and Cell References in Excel
Creating Simple Cell Formulas
Assigning Names to Groups of Cells
Using Names in Formulas
Creating a Formula That References Values in an Excel Table
Creating Formulas That Reference Cells in Other Workbooks
Summing a Group of Cells Without Using a Formula
Creating a Summary Formula
Summing with Subtotals and Grand Totals
Exploring the Excel Function Library
Using the IF Function
Checking Formula References
Debugging Your Formulas
Chapter 7 Formatting the Cell
Formatting Cell Contents
Formatting Cells Containing Numbers
Formatting Cells Containing Dates
Adding Cell Backgrounds and Shading
Formatting Cell Borders
Defining Cell Styles
Aligning and Orienting Cell Contents
Formatting a Cell Based on Conditions
Changing How Conditional Formatting Rules Are Applied
Stop When a Condition Is Met
Displaying Data Bars, Icon Sets, or Color Scales Based on Cell Values
Deleting Conditional Formats
Copying Formats with Format Painter
Merging or Splitting Cells or Data
Chapter 8 Formatting the Worksheet
Applying Workbook Themes
Coloring Sheet Tabs
Changing a Worksheet's Gridlines
Changing Row Heights and Column Widths
Inserting Rows or Columns
Moving Rows and Columns
Deleting Rows and Columns
Outlining to Hide and Show Rows and Columns
Hiding Rows and Columns
Protecting Worksheets from Changes
Locking Cells to Prevent Changes
Chapter 9 Printing Worksheets
Previewing Worksheets Before Printing
Printing Worksheets with Current Options
Choosing Whether to Print Gridlines and Headings
Choosing Printers and Paper Options
Printing Part of a Worksheet
Printing Row and Column Headings on Each Page
Setting and Changing Print Margins
Setting Page Orientation and Scale
Creating Headers and Footers
Adding Graphics to a Header or a Footer
Setting and Viewing Page Breaks
Chapter 10 Customizing Excel to the Way You Work
Opening Ready-to-Use Workbook Templates
Adding Commands to the Quick Access Toolbar
Modifying the Ribbon User Interface
Controlling Which Error Messages Appear
Defining AutoCorrect and AutoFormat Entries
Chapter 11 Sorting and Filtering Worksheet Data
Sorting Worksheet Data
Creating a Custom Sort List
Filtering Data Quickly with AutoFilter
Creating an Advanced Filter
Validating Data for Correctness During Entry
Chapter 12 Summarizing Data Visually Using Charts
Displaying Data Graphically
Creating a Chart Quickly
Changing a Chart's Appearance
Formatting Chart Legends and Titles
Changing the Body of a Chart
Customizing Chart Data
Working with Common Charts
Working with Uncommon Charts
Adding a Trendline to a Chart
Summarizing Data Using Sparklines
Chapter 13 Enhancing Your Worksheets with Graphics
Working with Graphics in Your Worksheets
Adding Graphics to Worksheets
Adding Drawing Objects to a Worksheet
Adding Fills to Drawing Objects
Adding Effects to Drawing Objects
Customizing Pictures and Objects
Aligning and Grouping Drawing Objects
Using WordArt to Create Text Effects in Excel
Inserting Clip Art into a Worksheet
Inserting and Changing a Diagram
Creating an Organization Chart
Adding an Equation to a Shape
Chapter 14 Sharing Excel Data with Other Programs
Introducing Linking and Embedding
Linking and Embedding Other Files
Exchanging Table Data Between Excel and Word
Copying Excel Charts and Data into PowerPoint
Exchanging Data Between Access and Excel
Importing a Text File
Chapter 15 Using Excel in a Group Environment
Sharing Workbooks in Excel
Commenting in Cells
Tracking Changes in Workbooks
Accepting or Rejecting Changes
Saving Worksheets to the Web
Dynamically Update Worksheets Published to the Web
Curtis D. Frye is a coauthor of Microsoft Office Excel 2003 Programming Inside Out and the author of Microsoft Office Excel 2007 Step by Step, Microsoft Excel Version 2007 Plain & Simple, Faster Smarter Home Networking, several books on Microsoft Access, and numerous online training courses.
