x

Our Privacy Policy has changed. By using this site, you agree to the Privacy Policy.

Microsoft� Excel� 2010

ISBN-10: 0735627274
ISBN-13: 9780735627277
Edition: 2010
List price: $13.99 Buy it from $3.00
eBook available
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Description: 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  More...

New Starting from $20.14
eBooks Starting from $17.99
Buy
what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS PowerPoint® 2010 Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $13.99
Copyright year: 2010
Publisher: Microsoft Press
Publication date: 6/15/2010
Binding: Paperback
Pages: 288
Size: 9.00" wide x 7.25" long x 0.75" tall
Weight: 1.342
Language: English

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: Navigate the user interface with Backstage view and the customizable ribbon Create formulas and functions Use charts and diagrams to display information visually Enhance your spreadsheet with graphic effects Reuse data from other Microsoft Office documents Team up and share spreadsheets with colleaguesAnd here's HOW you'll learn it: Jump in wherever 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 you apply what you learn right away

Curtis Frye is the author of numerous books on Excel and other Office products, most recently Microsoft Excel 2010 Step by Step. He graduated from Syracuse in 1990 with a degree in political science, and then moved to Washington, DC, where he worked as a defense trade analyst for four years and as the director of sales and marketing for an ISP for one year. He moved to Portland, Oregon, in 1995 to launch his freelance writing career. When Curt's not writing, and often while he is writing, he is a keynote speaker, mentalist, and professional improvisational comedian.

Acknowledgments
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);
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;
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;
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;
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;
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;
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;
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;
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;
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;
Sorting and Filtering Worksheet Data
Sorting Worksheet Data
Creatingggggg a Custom Sort List
Filtering Data Quickly with AutoFilter
Creating an Advanced Filter
Validating Data for Correctness During Entry;
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;
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;
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;
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
Retrieving Web Data Using Excel
Modifying Web Queries
Introducing XML
Interacting over the Web Using XML;

×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×