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,08
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 7/4/2010 (2010)
ISBN 10: 1449382355 ISBN 13: 9781449382353
Nuevos Paperback or Softback Cantidad: 5
Librería
BargainBookStores
(Grand Rapids, MI, Estados Unidos de America)
Valoración
[?]

Descripción O'Reilly Media 7/4/2010, 2010. Paperback or Softback. Estado de conservación: New. Excel 2010: The Missing Manual. Book. Nº de ref. de la librería BBS-9781449382353

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

Comprar nuevo
EUR 23,19
Convertir moneda

Añadir al carrito

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

3.

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 SWATI2132584269

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

Comprar nuevo
EUR 20,61
Convertir moneda

Añadir al carrito

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

4.

Matthew MacDonald
Editorial: O Reilly Media, Inc, USA, United States (2010)
ISBN 10: 1449382355 ISBN 13: 9781449382353
Nuevos Paperback Cantidad: 1
Librería
The Book Depository
(London, Reino Unido)
Valoración
[?]

Descripción O Reilly Media, Inc, USA, United States, 2010. Paperback. Estado de conservación: New. Language: English . Brand New Book. Fast-paced and easy to use, this guide shows you how to get the most out of Excel 2010 - everything from building your first spreadsheet to working with Pivot tables. You ll learn how to develop a spreadsheet from scratch, create formulas, add data, and analyze and graph data so you can make informed business decisions. With clear jargon-free explanations, step-by-step instructions, tons of illustrations, and lots of undocumented workarounds, tips, and shortcuts, you ll get hands-on guided tours and explanations of Excel s new features, including: the Excel Web App - for the first time, Excel lets you view, edit, and share your worksheets in a web browser; sparklines - these miniature graphs are the hottest innovation in data display since the pie chart - they re ideal for viewing trends and summaries at a glance; backstage view - now Excel has a single go-to place for managing files, such as opening an existing spreadsheet, creating a new one, printing, or setting options; and, slicers - Excel s pivot tables are powerful but complicated - slicers give you a visual way to slice and dice pivot table data so you can see details that interest you most. Nº de ref. de la librería AAH9781449382353

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

Comprar nuevo
EUR 25,53
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío
Edición internacional
Edición internacional

5.

Matthew MacDonald
ISBN 10: 1449382355 ISBN 13: 9781449382353
Nuevos Cantidad: 10
Edición internacional
Librería
Unique Bookseller
(Delhi, India)
Valoración
[?]

Descripción Estado de conservación: Brand New. .. Black & White or color International Edition. ISBN and front cover may be different, but contents are same as the US edition. Book printed in English. Territorial restrictions may be printed on the book. GET IT FAST within 3-5 business days by DHL/FedEx/Aramex and tracking number will be uploaded into your order page within 24-48 hours. Kindly provide day time phone number in order to ensure smooth delivery. No shipping to PO BOX, APO, FPO addresses. 100% Customer satisfaction guaranteed!. . Nº de ref. de la librería UBS10199

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

Comprar nuevo
EUR 26,18
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
De India a Estados Unidos de America
Destinos, gastos y plazos de envío

6.

MacDonald, Matthew
Editorial: O'Reilly Media (2017)
ISBN 10: 1449382355 ISBN 13: 9781449382353
Nuevos Paperback Cantidad: > 20
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 25,46
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
Edición internacional
Edición internacional

7.

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 Paperback- Same Title Author and Edition as listed. ISBN and Cover design differs. Similar Contents as U.S Edition. 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 25,43
Convertir moneda

Añadir al carrito

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

8.

MacDonald, Matthew
Editorial: O'Reilly Media
ISBN 10: 1449382355 ISBN 13: 9781449382353
Nuevos PAPERBACK Cantidad: 10
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,15
Convertir moneda

Añadir al carrito

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

9.

MacDonald, Matthew
Editorial: Oand#8242;Reilly (2010)
ISBN 10: 1449382355 ISBN 13: 9781449382353
Nuevos Cantidad: 1
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,75
Convertir moneda

Añadir al carrito

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

10.

Matthew MacDonald
Editorial: O Reilly Media, Inc, USA, United States (2010)
ISBN 10: 1449382355 ISBN 13: 9781449382353
Nuevos Paperback Cantidad: 1
Librería
The Book Depository US
(London, Reino Unido)
Valoración
[?]

Descripción O Reilly Media, Inc, USA, United States, 2010. Paperback. Estado de conservación: New. Language: English . Brand New Book. Fast-paced and easy to use, this guide shows you how to get the most out of Excel 2010 - everything from building your first spreadsheet to working with Pivot tables. You ll learn how to develop a spreadsheet from scratch, create formulas, add data, and analyze and graph data so you can make informed business decisions. With clear jargon-free explanations, step-by-step instructions, tons of illustrations, and lots of undocumented workarounds, tips, and shortcuts, you ll get hands-on guided tours and explanations of Excel s new features, including: the Excel Web App - for the first time, Excel lets you view, edit, and share your worksheets in a web browser; sparklines - these miniature graphs are the hottest innovation in data display since the pie chart - they re ideal for viewing trends and summaries at a glance; backstage view - now Excel has a single go-to place for managing files, such as opening an existing spreadsheet, creating a new one, printing, or setting options; and, slicers - Excel s pivot tables are powerful but complicated - slicers give you a visual way to slice and dice pivot table data so you can see details that interest you most. Nº de ref. de la librería AAH9781449382353

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

Comprar nuevo
EUR 29,80
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
De Reino Unido 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