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."
Spreadsheet" himself, bestselling author John Walkenbach, who demonstrates all the techniques you need to create Excel applications, both large and small Covers navigating the Excel interface, formatting worksheets, interacting with other Office applications, working with collaboration tools, and using sample workbooks and John Walkenbach's award-winning Power Utility Pak to help enhance your Excel skills Provides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you wont find anywhere else. Develop VBA subroutines and functions Create custom UserForms and dialog boxes Use VBA to create add-ins, PivotTables, and charts Create procedures that execute automatically when events occur Work with class modules and color.
Reviews
Find Best Price at Amazon"It is a cross between a reference book and one you can read through."
"Excellent, use it everyday at work."
"Great book."
"Bought this book hoping that it would show me how to do everything in vba I could possibly want to do."
"For the Excel VBA programmer, this is indispensable."
"Very detailed and well written."
"Excellent for new learners."
"Great book, very easy to follow."
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. What it's all about start with a complete overview of VBA and learn how it can help you automate routine tasks, create custom commands and add-ins, and develop macro-driven applications A world of objects dig into the Excel object model and see how VBA is implemented in Excel Master basic programming concepts learn the lingo and find out what programming involves Dive a little deeper explore range objects and their properties and create a variety of alternatives to Excel UserForms Get down to business discover how to create custom dialog boxes, customize the Ribbon, and add a button to the Quick Access Toolbar Put it all to work include your own custom buttons in the Excel user interface, design user-oriented applications, and work with other Office applications. Advantages and disadvantages of VBA How the Excel object hierarchy works Step-by-step instructions for creating macros Useful Range object properties and methods Techniques for handling errors How to develop custom solutions to fit your needs Tips for exterminating bugs in your code.
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 .NET
Your hands-on guide to Microsoft Visual C# fundamentals with Visual Studio 2015 Expand your expertise--and teach yourself the fundamentals of programming with the latest version of Visual C# with Visual Studio 2015. John Sharp is a principal technologist at Content Master, part of CM Group Ltd., a technical authoring and consulting company based in Gloucester, in the UK.
Reviews
Find Best Price at Amazon"Awesome examples at the end of each chapter allowing you to put the concepts of the chapter into practice."
"Fantastic book for a .NET programming class."
"I only have 6G of RAM on a Toshiba laptop. The ONLY difficulty I had was with Chapter 27 where the NuGet package manager had difficulties with the fact that I was running out of sample code zip-expanded too far down a directory tree. So I copied the sample code directory to come off the C:\ drive."
"Look no further, if you want to learn C# this is your book."
"Perfect reference book but not for a newbie."
"great book and a lot of information that will help you scale your skills to higher and more proficient."
"very well written with ample examples for those wanting to learn c#."
"Make me feel happy with the reference to "Sorting & Searching by Knuth". I apologize for my English."
Best Microsoft SQL Server
Ace your preparation for Microsoft Certification Exam 70-461 with this 2-in-1 Training Kit from Microsoft Press. He has also developed three courses for SolidQ: Data Modeling Essentials, Data Quality and Master Data Management, and Data Mining.
Reviews
Find Best Price at Amazon"I'll blame it on the editors (or lack thereof) - just make sure you print out the errata page from the O'Reilly site as a reference. The questions bear little resemblance to the real thing in either format or difficulty. Bottom line, I was ready to deduct two stars for the worthless exam (which another reviewer did) but decided to view it as a flawed bonus, like those coupons that print on your grocery receipt for items you just bought. Buy this training kit for the well-written, well organized, occasionally-flawed text and use it as a guide as you also include other sources from other books or the web, especially the MSDN site."
"I passed the exam on the first attempt, but I wouldn't suggest using this book as your sole preparation; in fact I think if you use only this book it will take you 3x longer to be prepared. I would suggest using this book for detailed information about a topic when you need to understand something more deeply, and rely on other sources (practice exams, training, etc) for your exam prep."
"Step by step; Essential terminology: clarified discussion on foundation protocol for T-SQL This has been very useful, along with MS certification training course at Udemy.com CD was included."
"It is not a beginners book, if you already good at a subject you can easily just use this to review it, but if you find something unfamiliar then you need to find other resources to study that specific subject, generally the book gives you a path to study for the exam and it also is good to review and improve your skills."
"However, it is in the SECOND book (for the 70-462 exam) that you have the instructions for installing and configuring SQL 2012, which seems backwards to me."
Best Microsoft C & C++ Windows Programming
If you’ve never read Effective C++ and you think you know everything about C++, think again.”. — Steve Schirripa, Software Engineer, Google. “C++ and the C++ community have grown up in the last fifteen years, and the third edition of Effective C++ reflects this. The clear and precise style of the book is evidence of Scott’s deep insight and distinctive ability to impart knowledge.”. — Gerhard Kreuzer, Research and Development Engineer, Siemens AG The first two editions of Effective C++ were embraced by hundreds of thousands of programmers worldwide. He is consulting editor for Addison Wesley's Effective Software Development Series and is a founding member of the Advisory Board for The C++ Source (http://www.artima.com/cppsource).
Reviews
Find Best Price at Amazon"I used this book as my primary source to transition from programming at College in C (where most programs are several thousand lines at most) to programming professionally in C++ (where you often have to manage anywhere from tens of thousands to millions of lines of code, most of which were not written by you)."
"Give it 4 stars instead of 5 because C++11 will probably make some of the recommendations as strongly applicable as before (actually, I think some of the cases where C++11 works against the advice from Meyers is for the worse, not for the better)."
"However, any developer should know the theory behind those conventions and idioms if she is going to do some serious software development. The book discussed 50 more ways in different items for effective C++ programming."
"I have been programming in C++ for a while so some of the topics Scott Mayers discussed were already familiar but I still picked up a lot from this book. Scott's goal is not to teach the fundamentals but to advice readers on how to use the language effectively - generating good, efficient, re-usable, portable code."
"If you're interested in reading about more highly advanced topics, then check out the next book in the series: More Effective C++: 35 New Ways to Improve Your Programs and Designs."
"A good book that provides explanations and thought processes for improving your coding technique."