Best Spreadsheet Books
Spreadsheet") guides you through every aspect of Excel Delivers essential coverage of all the newest features of Excel 2010 Presents material in a clear, concise, logical format that is ideal for all levels of Excel experience Includes a CD that contains all the templates and worksheets used in the book plus John Walkenbach's award-winning Power Utility Pak. You won't find a more comprehensive book on Excel 2010 than this!" If Excel can do it, John Walkenbach can show you how. Excel guru, Microsoft MVP, and author of all the previous top-selling editions of Excel Bible, John Walkenbach provides more than 1,000 pages packed with techniques, tips, and tricks for beginners as well as Excel power users. Preview how your copied text will look Spot trends in your data with Sparklines Chart your data using Excel's different chart types Master Excel formulas for useful worksheets Create effective charts suitable for the boardroom Analyze and present data with pivot tables.
Reviews
Find Best Price at Amazon"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. 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 !"
"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. 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). 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. 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 reason I did not give it five stars is, with all these types of reference books, the indexes are not perfect."
"I bought this book because of the positive reviews and also because I liked Walkenbach's "Excel 2000 Power Programming with VBA" that I bought many years ago. This book explains nothing more about FFT analysis than the Excel Help."
Spreadsheet" John Walkenbach as he guides you through every aspect of Excel 2013 Provides essential coverage of all the newest features of Excel 2013 Presents material in a clear, concise, logical format that is ideal for all levels of Excel experience Features a website that includes downloadable templates and worksheets from the book. My first spreadsheet experience was using VisiCalc, running on an Apple II computer owned by my employer. But by Version 4 (released in 1992), I was hooked on Excel, and preferred it to the competitors. Among other ways, it puts data in the hands of users, and makes it easy to slice and dice information. People can run their own ad-hoc reports, and not have to rely on others to provide information. It uses pattern recognition to transform a column of data (no formulas required). It also works in the opposite direction, so you can combine multiple columns using Flash Fill. It’s not perfect, and it sometimes fails to identify some patterns so you need to check the results carefully. This formula is entered into a 6-row x 7-column range of cells and displays a monthly calendar.
Reviews
Find Best Price at Amazon"As a matter of fact I have been able to use my Excel knowledge that I learned from Reading Walkenbach books to make around 5K in the last 10 years, and that's not even trying. Earlier I said I had become the Office guru and didn't need this book, and bought it for my Son's. These files are invaluable in saving time when learning, but the examples are in the book, one would just need to type them in, and it's certainly not a deal breaker. With the many areas of Excel training on the market you have to choose wisely which ones to spend your dollars on. When it comes to Excel books the choice is easy - John Walkenbach, no other name is needed."
"This is indeed a reference book."
"The Excel 2013 Bible is an excellent resource for the latest version of Excel."
"So far, I've been able to find the answers to all my questions about using Excel 2013."
"An amazing book."
"I thought I was pretty Excel savvy, but after my initial flip through this book, I realized my knowledge-base stopped at the end of part I."
"I like to have a book in-hand while I'm working on the computer."
"It's got nearly everything you ever wanted to know about Excel 2013."
Spreadsheet himself Whether you are just starting out or an Excel novice, the Excel 2016 Bible is your comprehensive, go-to guide for all your Excel 2016 needs. Create an Excel workbook Work with formulas and functions Make charts and incorporate graphics Visualize data using conditional formatting Use advanced Excel features Customize your Excel user interface Make the most of add-ins in your spreadsheets.
Reviews
Find Best Price at Amazon"Great book with all the tips and details."
"All you need to know about Excel."
"Very good overview of Microsoft excel 2016."
"Good book ti have."
"AMAZING BOOK!"
"In order to understand the whole formula I had to skip several hundred pages forward in the book to find an explanations to those parts."
Best Microsoft VBA
If you're a beginning to intermediate VBA programmer looking to get up to speed on creating customized solutions with Excel applications, Excel VBA Programming For Dummies, 4 th Edition makes it easier. Learn to:
Reviews
Find Best Price at Amazon"I now understand absolute vs. relative references! Understand this is an INTRO book."
"Well written but you need something a little simpler if you're a noob."
"Excellent!"
"This book explains VBA/Macros very simply, and is a definitely worth having as a reference!"
"This book strikes the perfect balance between simplicity and usefulness."
"Excellent for those new to VBA!"
"Starting around Chap 7, Mr. Walkenbach starts giving a lot of examples of code that is setting dimensions; static counters, offsets; cells vs ranges, etc, but he doesn't complete those examples with the actually code that would run some macro after the previously defined dimensions. I recommend this book as a good starting place for someone like me who has some experience using the Macro Record tool in Excel."
Best Office Software
Spreadsheet himself Whether you are just starting out or an Excel novice, the Excel 2016 Bible is your comprehensive, go-to guide for all your Excel 2016 needs. From learning to incorporate templates and implementing formulas to creating pivot tables and analyzing dataand so much morethis authoritative guide will be a trusted reference you'll refer to again and again. Create an Excel workbook Work with formulas and functions Make charts and incorporate graphics Visualize data using conditional formatting Use advanced Excel features Customize your Excel user interface Make the most of add-ins in your spreadsheets.
Reviews
Find Best Price at Amazon"Great book with all the tips and details."
"All you need to know about Excel."
"Good book ti have."
"AMAZING BOOK!"
"If you have been using Excel for years ...this is the book ...If you have never used Excel ... this is the book ...the explanations are just right ..."
"Being someone that already knows excel at a medium to advanced level this book really helped solidify my skills I just skipped a few chapters."
"Great reference book for beginners all the way up to the masters."
"In order to understand the whole formula I had to skip several hundred pages forward in the book to find an explanations to those parts."
Best Microsoft Programming
If you're a beginning to intermediate VBA programmer looking to get up to speed on creating customized solutions with Excel applications, Excel VBA Programming For Dummies, 4 th Edition makes it easier. Learn to:
Reviews
Find Best Price at Amazon"I now understand absolute vs. relative references! Understand this is an INTRO book."
"Well written but you need something a little simpler if you're a noob."
"Excellent!"
"This book explains VBA/Macros very simply, and is a definitely worth having as a reference!"
"This book strikes the perfect balance between simplicity and usefulness."
"Excellent for those new to VBA!"
"Starting around Chap 7, Mr. Walkenbach starts giving a lot of examples of code that is setting dimensions; static counters, offsets; cells vs ranges, etc, but he doesn't complete those examples with the actually code that would run some macro after the previously defined dimensions. I recommend this book as a good starting place for someone like me who has some experience using the Macro Record tool in Excel."
Best Presentation Software Books
No matter where you are on the organizational ladder, the odds are high that you've delivered a high-stakes presentation to your peers, your boss, your customers, or the general public. Connect with specific audiences Turn ideas into informative graphics Use sketching and diagramming techniques effectively Create graphics that enable audiences to process information easily Develop truly influential presentations Utilize presentation technology to your advantage. Principal of Duarte Design since 1990, Nancy Duarte passionately pursues the presentation development and design niche.
Reviews
Find Best Price at Amazon"Phenomenally detailed and useful book on presentation design."
"Targeted towards important presentations,not day to day presentations."
"My Dad recently transition from being Director of Pathology to a Professor at a Medical School for Pathology."
"This book is the gold standard for presentation books."
"In my opinion, the best book on designing presentations."
"This is a great practical guide on developing better presentations."
"I came away with several ideas I used on a current project: drawing storyboards by hand, using the "push" transition, and creating a non-linear presentation."
"Great practical tools to polish up your presentation immediately."
Best Project Management Software Books
A study guide for the Project Management Professional (PMP) certification exam, this book provides all the information project managers need to thoroughly prepare for the test. Andy Crowe is a Project Management Professional (PMP), a Six Sigma Black Belt, a Program Management Professional (PgMP), and the founder of Velociteach, a company that provides project management and certification training.
Reviews
Find Best Price at Amazon"Ordered - 13 October 2013, Amazon chat verified it would be the 2nd printing, and that I should contact them if there was any issue. I saw reviews talking about mistakes in the first printing and I wanted to be certain that I didn't receive the 1st printing, which I saw at a local BN bookstore today for $99.95."
"The most efficient way to study for the test is to read this book, try to understand it, take a three-day bootcamp course with a great instructor and take the exam a week after that. The PMP Exam: Quick Reference Guide, Fifth Edition (Test Prep series) by Andy Crowe was also pretty useful."
"Well I can tell you that those errors did not carry on to the test and the test followed the advice and lessons given in this book. Now I will not argue that the test in this book final and other wise was not in line with the actual test. I equate the tests in this book as being the walk phase in the crawl, walk, run concept of education and training. The system works just like the actual test and the questions are spot on.So if you want to have the real test questions then use the test bank. Memorize the equations in this book and you will have all the math you need to know for the test. In the end for me I looked and what I had marked as important for memorization and items I highlighted thru the book x3 times the week before my test and did the same with my PMBOK but only once."
"In addition, the book comes with a week long free pass to their website."
Best Enterprise Applications
Design for minimum complexity and maximum creativity Reap the benefits of collaborative development Apply defensive programming techniques to reduce and flush out errors Exploit opportunities to refactor—or evolve—code, and do it safely Use construction practices that are right-weight for your project Debug problems quickly and effectively Resolve critical construction issues early and correctly Build quality into the beginning, middle, and end of your project. He is the author of several books, including Code Complete and Rapid Development, both honored with Software Development magazine's Jolt Award.
Reviews
Find Best Price at Amazon"readable encyclopedia of best practices on software quality, covering topics such as how to build classes, use data and control structures, debug, refactor, and code-tune. Yes, it would be nice if the book was updated to include substantive material on languages like Ruby or Python (cf. p. 65, Python "also contains some support for creating larger programs") but, in the words of Gertrude Stein, "Not everything can be about everything" -- though Code Complete does come pretty close. McConnell also sprinkles the text with classic words of wisdom, e.g. "The competent programmer is fully aware of the strictly limited size of his own skull" (Edsger Dijkstra), "Never debug standing up" (Gerald Weinberg), "Copy and paste is a design error" (David Parnas), "Any fool can defend his or her mistakes -- and most fools do." It is important to point out that even though this volume is encyclopedia-like, it does have both a sense of humor (e.g. "the encryption algorithm is so convoluted that it seems like it's been used on itself") and a clear authorial voice (e.g. "Though sometimes tempting, that's dumb."). 33, after quoting Edward Yourdon at length, McConnell adds "This lusty tribute to programming machismo is pure B.S. I found this to be bizarre, given that in the 1995 edition of "The Mythical Man-Month" Brooks states in no uncertain terms that he has changed his mind on this: "This I now perceive to be wrong" (p. 265). On a different note, although some of the on-line accompanying material is fascinating (e.g. the links to the original Dijkstra and Lawrence articles in ch."
"Very readable, excellent real-world examples and case studies, and many valuable insights."
"I'm a self taught programmer going on 5 years now doing it full time, and I have learned a lot of techniques that have filled in some holes in my skills."
"The Microsoft code way."
"Bad humor, takes a long time to convey information, but is useful."
"I'd also recommend the more recent Clean Code, especially for Java programmers, as it goes into more depth, even providing actual case studies in which code is dramatically cleaned up."
"I make all of my new programmers at least read selections from it (in fact that is part of our training program.)."
"Great book on software development."