Signed Edition Sweepstakes
 
 

Recently Viewed clear list


Original Essays | September 18, 2014

Lin Enger: IMG Knowing vs. Knowing



On a hot July evening years ago, my Toyota Tercel overheated on a flat stretch of highway north of Cedar Rapids, Iowa. A steam geyser shot up from... Continue »

spacer
Qualifying orders ship free.
$39.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Beaverton Microsoft Windows- Windows 95 General
3 Burnside Microsoft Windows- Applications
25 Remote Warehouse Personal Computers- Desktop Applications- Spreadsheets

Excel 2010: The Missing Manual

by

Excel 2010: The Missing Manual Cover

 

Synopses & Reviews

Publisher Comments:

Excel, the world's most popular spreadsheet program, has the muscle to analyze heaps of data. Beyond basic number-crunching, Excel 2010 has many impressive features that are hard to find, much less master — especially from online help pages. This Missing Manual clearly explains how everything works with a unique and witty style to help you learn quickly.

  • Navigate with ease. Master Excel's tabbed toolbar and its new backstage view
  • Perform a variety of calculations. Write formulas for rounding numbers, calculating mortgage payments, and more
  • Organize your data. Search, sort, and filter huge amounts of information
  • Illustrate trends. Bring your data to life with charts and graphics — including miniature charts called Sparklines
  • Examine your data. Summarize information and find hidden patterns with pivot tables and slicers
  • Share your spreadsheets. Use the Excel Web App to collaborate with colleagues online
  • Rescue lost data. Restore old versions of data and find spreadsheets you forgot to save

Synopsis:

Excel, the world's most popular spreadsheet program, has the muscle to analyze heaps of data. Beyond basic number-crunching, Excel 2010 has many impressive features that are hard to find, much less master — especially from online help pages. This Missing Manual clearly explains how everything works with a unique and witty style to help you learn quickly. Navigate with ease. Master Excel's tabbed toolbar and its new backstage view Perform a variety of calculations. Write formulas for rounding numbers, calculating mortgage payments, and more Organize your data. Search, sort, and filter huge amounts of information Illustrate trends. Bring your data to life with charts and graphics — including miniature charts called Sparklines Examine your data. Summarize information and find hidden patterns with pivot tables and slicers Share your spreadsheets. Use the Excel Web App to collaborate with colleagues online Rescue lost data. Restore old versions of data and find spreadsheets you forgot to save

About the Author

Matthew MacDonald is a developer, author, and educator in all things Visual Basic and .NET. He's worked with Visual Basic and ASP since their initial versions, and written over a dozen books on the subject, including The Book of VB .NET (No Starch Press) and Visual Basic 2005: A Developer's Notebook (O'Reilly).

Table of Contents

The Missing Credits; About the Author; About the Creative Team; Acknowledgements; The Missing Manual Series; Introduction; What You Can Do with Excel; The Modern Face of Excel; Excel's New Features; About This Book; Part One: Worksheet Basics; Chapter 1: Creating Your First Spreadsheet; 1.1 Creating a Basic Worksheet; 1.2 Moving Around the Grid; 1.3 A Tour of the Excel Window; 1.4 Saving Files; 1.5 Opening Files; Chapter 2: Adding Information to Worksheets; 2.1 Adding Different Types of Data; 2.2 Handy Timesavers; 2.3 Dealing with Change: Undo, Redo, and AutoRecover; 2.4 Spell Check; 2.5 Adding Hyperlinks; Chapter 3: Moving Data; 3.1 Selecting Cells; 3.2 Making Continuous Range Selections; 3.3 Making Noncontiguous Selections; 3.4 Automatically Selecting Your Data; 3.5 Making Selections with the Keyboard; 3.6 Moving Cells Around; 3.7 A Simple Cut-and-Paste or Copy-and-Paste; 3.8 A Quicker Cut-and-Paste or Copy-and-Paste; 3.9 Fancy Pasting Tricks; 3.10 Paste Special; 3.11 Copying Multiple Items with the Clipboard; 3.12 Adding and Moving Columns or Rows; 3.13 Inserting Columns and Rows; 3.14 Inserting Rows; 3.15 Inserting Copied or Cut Cells; 3.16 Deleting Columns and Rows; Chapter 4: Managing Worksheets; 4.1 Worksheets and Workbooks; 4.2 Find and Replace; Chapter 5: Formatting Cells; 5.1 Formatting Cell Values; 5.2 Formatting Cell Appearance; Chapter 6: Smart Formatting Tricks; 6.1 The Format Painter; 6.2 Styles and Themes; 6.3 Conditional Formatting; Chapter 7: Viewing and Printing Worksheets; 7.1 Controlling Your View; 7.2 Printing; 7.3 Controlling Pagination; Part Two: Formulas and Functions; Chapter 8: Building Basic Formulas; 8.1 Creating a Basic Formula; 8.2 Functions; 8.3 Formula Errors; 8.4 Logical Operators; 8.5 Formula Shortcuts; 8.6 Copying Formulas; Chapter 9: Math and Statistical Functions; 9.1 Rounding Numbers; 9.2 Groups of Numbers; 9.3 General Math Functions; 9.4 Trigonometry and Advanced Math; 9.5 Advanced Statistics; Chapter 10: Financial Functions; 10.1 The World of Finance; 10.2 Financial Functions; 10.3 Depreciation; 10.4 Other Financial Functions; Chapter 11: Manipulating Dates, Times, and Text; 11.1 Manipulating Text; 11.2 Manipulating Dates and Times; 11.3 Math with Dates and Times; 11.4 Date and Time Functions; Chapter 12: Lookup, Reference, and Information Functions; 12.1 The Basic Lookup; 12.2 Advanced Lookups; 12.3 Information Functions; 12.4 Tutorial: Generating Invoices from a Product Catalog; Chapter 13: Advanced Formula Writing and Troubleshooting; 13.1 Conditions in Formulas; 13.2 Descriptive Names for Cell References; 13.3 Variable Data Tables; 13.4 Controlling Recalculation; 13.5 Solving Formula Errors; Part Three: Organizing Worksheets; Chapter 14: Tables: List Management Made Easy; 14.1 The Basics of Tables; 14.2 Sorting and Filtering a Table; 14.3 Dealing with Duplicate Rows; 14.4 Performing Table Calculations; Chapter 15: Grouping and Outlining Data; 15.1 Basic Data Grouping; 15.2 Grouping Timesavers; Chapter 16: Templates; 16.1 Understanding Templates; 16.2 Creating a New Workbook from a Template; 16.3 Creating Templates; Part Four: Charts and Graphics; Chapter 17: Creating Basic Charts; 17.1 Charting 101; 17.2 Basic Tasks with Charts; 17.3 Practical Charting; 17.4 Chart Types; Chapter 18: Formatting and Perfecting Charts; 18.1 Chart Styles and Layouts; 18.2 Adding Chart Elements; 18.3 Selecting Chart Elements; 18.4 Formatting Chart Elements; 18.5 Improving Your Charts; 18.6 Advanced Charting; Chapter 19: Inserting Graphics; 19.1 Adding Pictures to a Worksheet; 19.2 Excel's Clip Art Library; 19.3 Drawing Shapes; Part Five: Advanced Data Analysis; Chapter 20: Visualizing Your Data; 20.1 Data Bars; 20.2 Color Scales; 20.3 Icon Sets; 20.4 Sparklines; Chapter 21: Scenarios and Goal Seeking; 21.1 Using Scenarios; 21.2 Using Goal Seek; 21.3 Solver; Chapter 22: Pivot Tables; 22.1 Summary Tables Revisited; 22.2 Building Pivot Tables; 22.3 Multi-Layered Pivot Tables; 22.4 Fine-Tuning Pivot Table Calculations; 22.5 Filtering a Pivot Table; 22.6 Pivot Charts; Chapter 23: Analyzing Databases, XML, and Web Pages; 23.1 Excel and Databases; 23.2 Understanding XML; 23.3 Excel and XML; 23.4 Web Queries; Part Six: Sharing Data with the Rest of the World; Chapter 24: Protecting Your Workbooks; 24.1 Understanding Excel's Safeguards; 24.2 Data Validation; 24.3 Locked and Hidden Cells; Chapter 25: Worksheet Collaboration; 25.1 Your Excel Identity; 25.2 Preparing Your Workbook; 25.3 Distributing a Document; 25.4 Adding Comments; 25.5 Tracking Changes; 25.6 Sharing Your Workbook; Chapter 26: Using Excel on the Web; 26.1 Putting Your Files Online; 26.2 Using the Excel Web App; Chapter 27: Exchanging Data with Other Programs; 27.1 Sharing Information in Windows; 27.2 Embedding and Linking Objects; 27.3 Transferring Data; Part Seven: Programming Excel; Chapter 28: Automating Tasks with Macros; 28.1 Macros 101; 28.2 The Macro Recorder; 28.3 Macro Security; 28.4 Creating Practical Macros; Chapter 29: Programming Spreadsheets with VBA; 29.1 The Visual Basic Editor; 29.2 Understanding Macro Code; 29.3 Exploring the VBA Language; Part Eight: Appendix; Customizing the Ribbon; Adding Your Favorites to the QAT; Personalizing the Ribbon;

Product Details

ISBN:
9781449382353
Author:
Macdonald, Matthew
Publisher:
O'Reilly Media
Author:
MacDonald, Matthew
Subject:
Spreadsheets - General
Subject:
Spreadsheets - Excel
Subject:
Electronic spreadsheets
Subject:
Personal Computers-Applications
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Subject:
Excel;Excel 2010;Microsoft Excel;Microsoft Excel 2010;business analysis;business forecasting;business scenario;decision making;forecasting;spread sheet;spreadhsheet scenario;spreadsheet;what if;what if analyses;what if analysis;what-if;what-if analyses;wh
Subject:
Excel;Excel 2010;Microsoft Excel;Microsoft Excel 2010;business analysis;business forecasting;business scenario;decision making;forecasting;spread sheet;spreadhsheet scenario;spreadsheet;what if;what if analyses;what if analysis;what-if;what-if analyses;wh
Subject:
Excel;Excel 2010;Microsoft Excel;Microsoft Excel 2010;business analysis;business forecasting;business scenario;decision making;forecasting;spread sheet;spreadhsheet scenario;spreadsheet;what if;what if analyses;what if analysis;what-if;what-if analyses;wh
Subject:
Excel;Excel 2010;Microsoft Excel;Microsoft Excel 2010;business analysis;business forecasting;business scenario;decision making;forecasting;spread sheet;spreadhsheet scenario;spreadsheet;what if;what if analyses;what if analysis;what-if;what-if analyses;wh
Subject:
Excel;Excel 2010;Microsoft Excel;Microsoft Excel 2010;business analysis;business forecasting;business scenario;decision making;forecasting;spread sheet;spreadhsheet scenario;spreadsheet;what if;what if analyses;what if analysis;what-if;what-if analyses;wh
Subject:
Excel;Excel 2010;Microsoft Excel;Microsoft Excel 2010;business analysis;business forecasting;business scenario;decision making;forecasting;spread sheet;spreadhsheet scenario;spreadsheet;what if;what if analyses;what if analysis;what-if;what-if analyses;wh
Subject:
Excel;Excel 2010;Microsoft Excel;Microsoft Excel 2010;business analysis;business forecasting;business scenario;decision making;forecasting;spread sheet;spreadhsheet scenario;spreadsheet;what if;what if analyses;what if analysis;what-if;what-if analyses;wh
Subject:
Excel;Excel 2010;Microsoft Excel;Microsoft Excel 2010;business analysis;business forecasting;business scenario;decision making;forecasting;spread sheet;spreadhsheet scenario;spreadsheet;what if;what if analyses;what if analysis;what-if;what-if analyses;wh
Subject:
Excel;Excel 2010;Microsoft Excel;Microsoft Excel 2010;business analysis;business forecasting;business scenario;decision making;forecasting;spread sheet;spreadhsheet scenario;spreadsheet;what if;what if analyses;what if analysis;what-if;what-if analyses;wh
Subject:
Excel;Excel 2010;Microsoft Excel;Microsoft Excel 2010;business analysis;business forecasting;business scenario;decision making;forecasting;spread sheet;spreadhsheet scenario;spreadsheet;what if;what if analyses;what if analysis;what-if;what-if analyses;wh
Subject:
Excel;Excel 2010;Microsoft Excel;Microsoft Excel 2010;business analysis;business forecasting;business scenario;decision making;forecasting;spread sheet;spreadhsheet scenario;spreadsheet;what if;what if analyses;what if analysis;what-if;what-if analyses;wh
Subject:
Excel;Excel 2010;Microsoft Excel;Microsoft Excel 2010;business analysis;business forecasting;business scenario;decision making;forecasting;spread sheet;spreadhsheet scenario;spreadsheet;what if;what if analyses;what if analysis;what-if;what-if analyses;wh
Subject:
Excel;Excel 2010;Microsoft Excel;Microsoft Excel 2010;business analysis;business forecasting;business scenario;decision making;forecasting;spread sheet;spreadhsheet scenario;spreadsheet;what if;what if analyses;what if analysis;what-if;what-if analyses;wh
Subject:
Excel;Excel 2010;Microsoft Excel;Microsoft Excel 2010;business analysis;business forecasting;business scenario;decision making;forecasting;spread sheet;spreadhsheet scenario;spreadsheet;what if;what if analyses;what if analysis;what-if;what-if analyses;wh
Subject:
Excel;Excel 2010;Microsoft Excel;Microsoft Excel 2010;business analysis;business forecasting;business scenario;decision making;forecasting;spread sheet;spreadhsheet scenario;spreadsheet;what if;what if analyses;what if analysis;what-if;what-if analyses;wh
Subject:
Excel;Excel 2010;Microsoft Excel;Microsoft Excel 2010;business analysis;business forecasting;business scenario;decision making;forecasting;spread sheet;spreadhsheet scenario;spreadsheet;what if;what if analyses;what if analysis;what-if;what-if analyses;wh
Subject:
Excel;Excel 2010;Microsoft Excel;Microsoft Excel 2010;business analysis;business forecasting;business scenario;decision making;forecasting;spread sheet;spreadhsheet scenario;spreadsheet;what if;what if analyses;what if analysis;what-if;what-if analyses;wh
Subject:
Excel;Excel 2010;Microsoft Excel;Microsoft Excel 2010;business analysis;business forecasting;business scenario;decision making;forecasting;spread sheet;spreadhsheet scenario;spreadsheet;what if;what if analyses;what if analysis;what-if;what-if analyses;wh
Subject:
Excel;Excel 2010;Microsoft Excel;Microsoft Excel 2010;business analysis;business forecasting;business scenario;decision making;forecasting;spread sheet;spreadhsheet scenario;spreadsheet;what if;what if analyses;what if analysis;what-if;what-if analyses;wh
Subject:
Excel;Excel 2010;Microsoft Excel;Microsoft Excel 2010;business analysis;business forecasting;business scenario;decision making;forecasting;spread sheet;spreadhsheet scenario;spreadsheet;what if;what if analyses;what if analysis;what-if;what-if analyses;wh
Subject:
Excel;Excel 2010;Microsoft Excel;Microsoft Excel 2010;business analysis;business forecasting;business scenario;decision making;forecasting;spread sheet;spreadhsheet scenario;spreadsheet;what if;what if analyses;what if analysis;what-if;what-if analyses;wh
Subject:
Excel;Excel 2010;Microsoft Excel;Microsoft Excel 2010;business analysis;business forecasting;business scenario;decision making;forecasting;spread sheet;spreadhsheet scenario;spreadsheet;what if;what if analyses;what if analysis;what-if;what-if analyses;wh
Subject:
CourseSmart Subject Description
Subject:
Excel;Excel 2010;Microsoft Excel;Microsoft Excel 2010;business analysis;business forecasting;business scenario;decision making;forecasting;spread sheet;spreadhsheet scenario;spreadsheet;what if;what if analyses;what if analysis;what-if;what-if analyses;wh
Subject:
Excel;Excel 2010;Microsoft Excel;Microsoft Excel 2010;business analysis;business forecasting;business scenario;decision making;forecasting;spread sheet;spreadhsheet scenario;spreadsheet;what if;what if analyses;what if analysis;what-if;what-if analyses;wh
Copyright:
Edition Description:
Print PDF
Publication Date:
20100731
Binding:
TRADE PAPER
Language:
English
Illustrations:
Y
Pages:
898
Dimensions:
9.19 x 7.00 in

Related Subjects

» Computers and Internet » Operating Systems » Microsoft Windows » Applications
» Computers and Internet » Operating Systems » Microsoft Windows » Windows 95 » General
» Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets
» Science and Mathematics » Featured Titles in Tech » General

Excel 2010: The Missing Manual New Trade Paper
0 stars - 0 reviews
$39.99 In Stock
Product details 898 pages O'Reilly Media - English 9781449382353 Reviews:
"Synopsis" by , Excel, the world's most popular spreadsheet program, has the muscle to analyze heaps of data. Beyond basic number-crunching, Excel 2010 has many impressive features that are hard to find, much less master — especially from online help pages. This Missing Manual clearly explains how everything works with a unique and witty style to help you learn quickly. Navigate with ease. Master Excel's tabbed toolbar and its new backstage view Perform a variety of calculations. Write formulas for rounding numbers, calculating mortgage payments, and more Organize your data. Search, sort, and filter huge amounts of information Illustrate trends. Bring your data to life with charts and graphics — including miniature charts called Sparklines Examine your data. Summarize information and find hidden patterns with pivot tables and slicers Share your spreadsheets. Use the Excel Web App to collaborate with colleagues online Rescue lost data. Restore old versions of data and find spreadsheets you forgot to save
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.