Excel 2010: The Missing Manual

3,86 valoración promedio
( 72 valoraciones por Goodreads )
 
9781449382353: Excel 2010: The Missing Manual

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


Microsoft Excel’s Top 5 Tricks

1. Page break preview -- In page break preview mode (choose View --> Workbook Views --> Page Break Preview) you can see how your printed worksheet will be split across multiple pages. But even more valuable is the ability to drag a page break to a new place. For example, if you spot some data off to the right side that doesn't fit on your page, you can drag the page break to the right so that it does. When you do this, Excel scales down your entire worksheet to fit the information you want.

2. Recovering unsaved work -- Ever start a new workbook, and then forget to save it when you close Excel in a hurry? Now you can get your lost work back. Just choose File --> Info, click the Manage Versions button, and choose Recover Unsaved Workbooks to find the unsaved spreadsheets that Excel stores automatically.

3. Lookup formulas -- If you understand how to use them, lookup formulas give you a powerful way to copy information from one part of a spreadsheet to another. For example, you can use lookup formulas to create an invoice that automatically inserts the correct product and price information when you type in a product code. Ordinarily, you'd expect this sort of solution to need macros or Visual Basic, but it doesn't.

4. Formula tracing -- Sometimes formulas go wrong, and the result is information that doesn't make sense (or an error code). Excel's formula tracing feature is a big help if this happens in a complex spreadsheet. When you use it, Excel adds arrows that point from the source cells to the formula that uses these cells. Essentially, formula tracing gives you a way to graphically "see" how your formula connects to the rest of your data, and it often helps you find the troublemaking cell that's causing the problem.

5. Charting tricks -- Charts tell a story with your data, and there are plenty of tricks that you can use to make them present that story more clearly and conclusively. For example: changing a chart's scale, adding an overlay, changing the fill of a specific series, inserting text and graphics directly on the chart surface, and so on, all have a dramatic effect. They make the difference between a chart that conveys a useful insight, and one that's just a bit of spreadsheet decoration.

"Sinopsis" puede pertenecer a otra edición de este libro.

About the Author:

Matthew MacDonald is a science and technology writer with well over a dozen books to his name. Web novices can tiptoe out onto the Internet with him in Creating a Website: The Missing Manual. HTML fans can learn about the cutting edge of web design in HTML5: The Missing Manual. And human beings of all description can discover just how strange they really are in the quirky handbooks Your Brain: The Missing Manual and Your Body: The Missing Manual.

"Sobre este título" puede pertenecer a otra edición de este libro.

Los mejores resultados en AbeBooks

1.

MacDonald, Matthew
Editorial: Oreilly & Associates Inc (2010)
ISBN 10: 1449382355 ISBN 13: 9781449382353
Nuevos Soft cover Cantidad: 1
Librería
Ashworth Books
(Sidney, NY, Estados Unidos de America)
Valoración
[?]

Descripción Oreilly & Associates Inc, 2010. Soft cover. Estado de conservación: New. NEW. Nº de ref. de la librería 16JUNUNIV0805

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 8,09
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 2,97
A Estados Unidos de America
Destinos, gastos y plazos de envío

2.

MacDonald, Matthew
Editorial: O'Reilly Media
ISBN 10: 1449382355 ISBN 13: 9781449382353
Nuevos PAPERBACK Cantidad: > 20
Librería
Mediaoutlet12345
(Springfield, VA, Estados Unidos de America)
Valoración
[?]

Descripción O'Reilly Media. PAPERBACK. Estado de conservación: New. 1449382355 *BRAND NEW* Ships Same Day or Next!. Nº de ref. de la librería SWATI2122351370

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 19,22
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,39
A Estados Unidos de America
Destinos, gastos y plazos de envío

3.

MacDonald, Matthew
ISBN 10: 1449382355 ISBN 13: 9781449382353
Nuevos Cantidad: 1
Librería
Paperbackshop-US
(Wood Dale, IL, Estados Unidos de America)
Valoración
[?]

Descripción 2010. PAP. Estado de conservación: New. New Book. Shipped from US within 10 to 14 business days. Established seller since 2000. Nº de ref. de la librería KS-9781449382353

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 19,93
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,39
A Estados Unidos de America
Destinos, gastos y plazos de envío

4.

Matthew MacDonald
ISBN 10: 1449382355 ISBN 13: 9781449382353
Nuevos Cantidad: 1
Librería
Castle Rock
(Pittsford, NY, Estados Unidos de America)
Valoración
[?]

Descripción Estado de conservación: Brand New. Book Condition: Brand New. Nº de ref. de la librería 97814493823531.0

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 21,45
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,39
A Estados Unidos de America
Destinos, gastos y plazos de envío
Edición internacional
Edición internacional

5.

MacDonald, Matthew
Editorial: O'Reilly Media
ISBN 10: 1449382355 ISBN 13: 9781449382353
Nuevos Tapa blanda Cantidad: 2
Edición internacional
Librería
Sunshine Book Store
(Wilmington, DE, Estados Unidos de America)
Valoración
[?]

Descripción O'Reilly Media. Estado de conservación: New. 1449382355 This is an International Edition. Brand New, paperback, Delivery within 6-14 business days, Same Contents and cover image as U.S Edition, ISBN may differ. Choose Expedited shipping for delivery within 4-7 business days. We do not ship to PO Box, APO,FPO Address. We may ship the books from multiple warehouses across the globe, including India depending upon the availability of inventory storage. Customer satisfaction guaranteed. Nº de ref. de la librería EU_9781449382353

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 25,48
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
A Estados Unidos de America
Destinos, gastos y plazos de envío
Edición internacional
Edición internacional

6.

Matthew MacDonald
ISBN 10: 1449382355 ISBN 13: 9781449382353
Nuevos Paperback Cantidad: 4
Edición internacional
Librería
Bookstore99
(Wilmington, DE, Estados Unidos de America)
Valoración
[?]

Descripción Paperback. Estado de conservación: New. This is an International Edition Brand New. Same Title Author and Edition as listed. Standard Delivery within 3-7 business days ACROSS THE GLOBE. We can ship to PO Box address in US. International Edition Textbooks may bear a label "Not for sale in the U.S. or Canada" or "For sale in Asia only" or similar restrictions- printed only to discourage students from obtaining an affordable copy. US Court has asserted your right to buy and use International edition. Access code/CD may not provided with these editions. We may ship the books from multiple warehouses across the globe including Asia depending upon the availability of inventory. Printed in English. Customer satisfaction guaranteed. Choose expedited shipping for Express delivery. Tracking number provided for every order. Nº de ref. de la librería RU_9781449382353

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 24,97
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 2,54
A Estados Unidos de America
Destinos, gastos y plazos de envío

7.

Matthew Macdonald
Editorial: Oand#8242;Reilly (2010)
ISBN 10: 1449382355 ISBN 13: 9781449382353
Nuevos Cantidad: 5
Librería
Books2Anywhere
(Fairford, GLOS, Reino Unido)
Valoración
[?]

Descripción Oand#8242;Reilly, 2010. PAP. Estado de conservación: New. New Book. Shipped from UK in 4 to 14 days. Established seller since 2000. Nº de ref. de la librería WO-9781449382353

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 18,33
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 9,85
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

8.

Matthew MacDonald
Editorial: O'Reilly Media
ISBN 10: 1449382355 ISBN 13: 9781449382353
Nuevos Paperback Cantidad: 20
Librería
BuySomeBooks
(Las Vegas, NV, Estados Unidos de America)
Valoración
[?]

Descripción O'Reilly Media. Paperback. Estado de conservación: New. Paperback. 898 pages. Dimensions: 9.2in. x 6.9in. x 2.0in.Excel, the worlds 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 Excels 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 Microsoft Excels Top 5 Tricks 1. Page break preview -- In page break preview mode (choose View -- Workbook Views -- Page Break Preview) you can see how your printed worksheet will be split across multiple pages. But even more valuable is the ability to drag a page break to a new place. For example, if you spot some data off to the right side that doesnt fit on your page, you can drag the page break to the right so that it does. When you do this, Excel scales down your entire worksheet to fit the information you want. 2. Recovering unsaved work -- Ever start a new workbook, and then forget to save it when you close Excel in a hurry Now you can get your lost work back. Just choose File -- Info, click the Manage Versions button, and choose Recover Unsaved Workbooks to find the unsaved spreadsheets that Excel stores automatically. 3. Lookup formulas -- If you understand how to use them, lookup formulas give you a powerful way to copy information from one part of a spreadsheet to another. For example, you can use lookup formulas to create an invoice that automatically inserts the correct product and price information when you type in a product code. Ordinarily, youd expect this sort of solution to need macros or Visual Basic, but it doesnt. 4. Formula tracing -- Sometimes formulas go wrong, and the result is information that doesnt make sense (or an error code). Excels formula tracing feature is a big help if this happens in a complex spreadsheet. When you use it, Excel adds arrows that point from the source cells to the formula that uses these cells. Essentially, formula tracing gives you a way to graphically see how your formula connects to the rest of your data, and it often helps you find the troublemaking cell thats causing the problem. 5. Charting tricks -- Charts tell a story with your data, and there are plenty of tricks that you can use to make them present that story more clearly and conclusively. For example: changing a charts scale, adding an overlay, changing the fill of a specific series, inserting text and graphics directly on the chart surface, and so on, all have a dramatic effect. They make the difference between a chart that conveys a useful insight, and one thats just a bit of spreadsheet decoration. This item ships from multiple locations. Your book may arrive from Roseburg,OR, La Vergne,TN. Paperback. Nº de ref. de la librería 9781449382353

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 24,88
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,35
A Estados Unidos de America
Destinos, gastos y plazos de envío

9.

MacDonald, Matthew
Editorial: O'Reilly Media (2017)
ISBN 10: 1449382355 ISBN 13: 9781449382353
Nuevos Paperback Cantidad: 15
Impresión bajo demanda
Librería
Murray Media
(North Miami Beach, FL, Estados Unidos de America)
Valoración
[?]

Descripción O'Reilly Media, 2017. Paperback. Estado de conservación: New. Never used! This item is printed on demand. Nº de ref. de la librería 1449382355

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 26,86
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 1,69
A Estados Unidos de America
Destinos, gastos y plazos de envío

10.

MacDonald, Matthew
Editorial: O'Reilly Media
ISBN 10: 1449382355 ISBN 13: 9781449382353
Nuevos PAPERBACK Cantidad: 3
Librería
Lakeside Books
(Benton Harbor, MI, Estados Unidos de America)
Valoración
[?]

Descripción O'Reilly Media. PAPERBACK. Estado de conservación: New. 1449382355 WE HAVE THOUSANDS OF SATISFIED CUSTOMERS!|DTH. Nº de ref. de la librería DTH-Y-9781449382353

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 25,73
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,39
A Estados Unidos de America
Destinos, gastos y plazos de envío

Existen otras copia(s) de este libro

Ver todos los resultados de su búsqueda