- Tapa blanda: 1056 páginas
- Editor: Wiley; Edición: 1 (1 de abril de 2010)
- Colección: Bible
- Idioma: Inglés
- ISBN-10: 0470474874
- ISBN-13: 978-0470474877
- Valoración media de los clientes: 1 opinión de cliente
- Clasificación en los más vendidos de Amazon: nº193.267 en Libros en idiomas extranjeros (Ver el Top 100 en Libros en idiomas extranjeros)
- Ver el Índice completo
Compara Precios en Amazon
+ Envío GRATIS
Excel 2010 Bible (Inglés) Tapa blanda – abr 2010
|Nuevo desde||Usado desde|
Los clientes que compraron este producto también compraron
Descripción del producto
5/5 stars. comprehensive and authoritative gives a user at any level the confidence to self-teach Excel 2010 thorough and genuinely helpful. (Software Latest.com, December 2010).
Reseña del editor
A comprehensive reference to the newest version of the world s most popular spreadsheet application: Excel 2010 John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. Known as "Mr. Spreadsheet," Walkenbach shows you how to maximize the power of all the new features of Excel 2010. An authoritative reference, this perennial bestseller proves itself indispensable no matter your level of skill, from Excel beginners and intermediate users to power users and potential power users everywhere. Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques you won t find anywhere else. Excel guru and bestselling author John Walkenbach ("Mr. Spreadsheet") guides you through every aspect of ExcelDelivers essential coverage of all the newest features of Excel 2010Presents material in a clear, concise, logical format that is ideal for all levels of Excel experienceIncludes a CD that contains all the templates and worksheets used in the book plus John Walkenbach's award-winning Power Utility Pak Excel 2010 Bible serves as an excellent resource on all things Excel! Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.Ver Descripción del producto
No es necesario ningún dispositivo Kindle. Descárgate una de las apps de Kindle gratuitas para comenzar a leer libros Kindle en tu smartphone, tablet u ordenador.
Obtén la app gratuita:
Detalles del producto
Si eres el vendedor de este producto, ¿te gustaría sugerir ciertos cambios a través del servicio de atención al vendedor?
Opiniones de clientes
Principales opiniones de clientes
Ha surgido un problema al filtrar las opiniones justo en este momento. Vuelva a intentarlo en otro momento.
Opiniones de clientes más útiles en Amazon.com
I have been using Excel for more than 15 years and consider myself a competent intermediate level user (though many in the office think I'm an "advanced user"); however I felt that my knowledge of Excel had become stagnant and I knew that I wasn't really taking advantage of many of the newer analytical functions of Excel. I searched through other books offered on Amazon, and found that they were just too basic to allow me to move to the next level.
The book is well organized into the following Parts, each with many chapters included:
Part I: Getting Started with Excel
Part II: Working with Formulas and Functions
Part III: Creating Charts and Graphics
Part IV: Using Advanced Excel Features
Part V: Analyzing Data with Excel
Part VI: Programming Excel with VBA
For now, I am concentrating my efforts in Part IV and Part V - not sure I'll work long enough (or have need for) Part VI !
I use the book in 2 ways:
1) browse through a section to discover features and functions that I didn't know existed, and
2) go to the index to find sections on a specific topic
I always find what I'm looking for in this "Bible". For instance, I just learned that Excel has a very useful "track changes" feature (which has been available in Word forever...) The book works well for my style of learning, since I am almost entirely self-taught in Microsoft applications. For me, it's easier to learn about applications in smaller bites that I can digest and work into my workflow than to dedicate the time to take a course that might last several days - 50% of which would be forgotten before I got back to the office.
The page layout is very readable, with crisp text, bold subheadings, plenty of included graphics and figures, and helpful notes and tips throughout. Many casual users of Excel will never need a tome of this depth, but it has become indispensable to me, and just having it on my desk makes me look smart !
So - kind of a 50/50 - buy it and have it around for the lesson specific sample spreadsheets, and have the book for reference.
Or, go without and use online searches for what you need.
Cons: The paper is so thin you see text from the other side of the pages. Combined with a very small and thin font, this makes reading the text a real chore. You definitely will need the reading glasses for this one, even if you don't need them for other books. Also, the included CD has a PDF of the entire book. That's nice, but the book's index in the PDF is just text, no links. I work with plenty of technical publications and the indexes normally have clickable links for the entries so you can jump straight to the text locations.
Summary: Author and content are good, but the publisher cut lots of corners and it shows.
As indicated in my original review (and since it's been a while since I browsed the book), the difference in how I used the formula ended in a different result (I hold on to practice workbooks over time to refresh my memory of some of this self-learning). The author mentioned placing a year value in cell A1. Since I didn't work with calendars generally during that time (as I do now, since I use formulas that include full dates in yyyymmdd format to calculate dates for project management schedules), my practice started out as using the full date, rather than year only. Hence, the difference in the results that I encountered. So, with the use of full dates, I adjusted the date so that the formula can properly refer to the year in the value. So, when I followed the examples, I missed the part for entering a simply year. That was the difference that resulted in the #NUM! errors that I had encountered using each formula as shown for each holiday (see the examples that were featured in my my original comment, and the formulas after I adjusted them). Instead of simply entering the value "2011" (the year when I bought the book), I had tested the formulas first by entering the base date as "1/1/2011," and then as "=DATE(2011,1,1). This was the difference in the miscommunication and that was my experience. I had not bothered to open and review the CD, since I had already returned the book. Perhaps this issue should be clarified in future editions in case others also miss this matter when dealing with dates -- especially when one enters a base date as I did.
Other than that, the book does serve as primer for beginners and intermediate Excel 2010 users who want to do more using the program for adding and subtracting values (I tend to bend a little of an intermediate user to advanced user who is trying to learn how to create dashboards).
For the most part, the book includes helpful information for beginners and intermediate users of Excel. However, the print version included errors in the formulas for calculating dates of the U.S. holidays -- especially for those holidays that do not fall on the same day each year. These errors appear on pages 269 through 272 of the print version of the book, and using these formulas as printed in the book generate errors.
For example, the date formula for Independence Day (a holiday that falls on the same date each year) was shown in the book as =DATE(A1,7,4) instead of =DATE(YEAR(A1),7,4).
The same error was also repeated for holidays that fall on different days each year. For example, the formula for Presidents Day (third Monday in January of each year):
* INCORRECT (as printed in the book)
* CORRECT FORMULA (adding the correct reference to the year in the start date)
I haven't checked the publisher's website myself, but I recommend checking publisher's site to find out whether an errata sheet has been posted for this book.