Microsoftï¿½ Excelï¿½ 2010

Name: Microsoftï¿½ Excelï¿½ 2010
Availability: InStock
ISBN: 9780735627277

ISBN-10: 0735627274

ISBN-13: 9780735627277

Edition: 2010

Authors: Curtis D. Frye, Curtis D. Frye

30 day, 100% satisfaction guarantee!

Semester Rental: $19.09 Due date: 8/13/2024

Rental notice: supplementary materials (access codes, CDs, etc.) are not guaranteed with rental orders.

Buy used: $8.04

Marketplace

4 new & used from $4.70

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

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 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…

Book details

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

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;