Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365) (Business Skills)
Product ID: 416797010
Buy anything from 5,000+ international stores. One checkout price. No surprise fees. Join 2M+ shoppers on Desertcart.
Desertcart purchases this item on your behalf and handles shipping, customs, and support to Spain.
Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad help you automate Excel tasks to get more done, faster than ever. Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable; capture data from anywhere, and use it anywhere; and automate the best new features in Microsoft Excel. You'll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and complete, easy-to-adapt solutions. By reading this book, you will: Quickly master Excel macro development Work more efficiently with ranges, cells, and formulas Generate automated reports and quickly adapt them for new requirements Learn to automate PivotTables to summarize, analyze, explore, and present data Leverage more of Excel VBA's power with classes, collections, and Advanced Filter Make the most of User-Defined Functions (UDFs), including new LAMBDA functions Build sophisticated UserForm custom dialogs to collect data from other Excel users Integrate data from the Internet, Access and SQL Server databases, and other sources Automatically generate charts, visualizations, sparklines, and Word documents Extend Excel's power by controlling other Office programs and Windows itself Create Office Add-ins to expand worksheet functionality or streamline retrieval of external information Get started creating brand-new TypeScript applications for Excel Online About This Book • For everyone who wants to get more done with Microsoft Excel in less time • For business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data Review: Great buy - Very informative and useful. I liked it better than the vba for dummies Review: Best VBA book - I bought several to learn VBA because, let's face it, the price of several books is more easily absorbed than a $2-3k class. That said, it's Bill Jelen and he knows his stuff. This book is the best of the lot (I bought 5). It's easily understood, and is written from the lens that the reader knows the basics of Excel function. If you're on the ledge, buy this book and leave the others.
| Best Sellers Rank | #321,971 in Books ( See Top 100 in Books ) #42 in Microsoft Office Guides #50 in Microsoft Excel Guides #72 in Spreadsheet Books |
| Customer Reviews | 4.6 out of 5 stars 202 Reviews |
I**S
Great buy
Very informative and useful. I liked it better than the vba for dummies
S**G
Best VBA book
I bought several to learn VBA because, let's face it, the price of several books is more easily absorbed than a $2-3k class. That said, it's Bill Jelen and he knows his stuff. This book is the best of the lot (I bought 5). It's easily understood, and is written from the lens that the reader knows the basics of Excel function. If you're on the ledge, buy this book and leave the others.
D**D
Good VBA resource
Excellent long-term resource for learning how to write Excel macros. I am a beginner, and I have found it useful to combine reading this book for a thorough understanding of VBA, with using an AI tool for help on how to write a snippet of code for a specific application I need now. I am creating a document with tips and coding examples to use as a quick reference. That's the main reason I gave this book 4 stars instead of 5.
C**Z
Broad based relevant material - easy to use and follow
Did not like the fact that there was no CD to provide access examples in the book. Always helps me understand what I am doing wrong. Overall very good book, knowledgeable author, high quality product.
S**G
very good text
I've been reading several books and watching several videos on Excel VBA, and this is probably my favorite. If a friend who already had some programming experience asked me where to go to start learning VBA, I'd point them to this book. (If they were completely new to programming, well, I don't know what I'd recommend. Probably taking an actual course, with homework and someone who will actually grade the homework!)
J**N
Very insightful
I have a bit of VBA experience but use it rarely. I found that this book was very helpful for folks trying to refresh existing knowledge. But it would be a good source for those that are new to VBA.
J**A
Nice reference
While the book does have some good insights it is not complete by itself!
R**N
An essential addition to your professional library for creating Excel VBA macros
This text includes most of what a professional programmer needs to create Excel VBA macros for repetitive tasks that can be automated. Many don't use textbooks nowadays, but for those of us who prefer to research an algorithm solution to a programming challenge, this book will provide you with what you need to get the job done!
P**H
Well Written
Comprehensive and well written reference
A**R
Good book, came damaged
Book is perfect but came damaged, approximately 1cm cut in the spine and some pages along the cut are dented in a bit, still usable :)
S**O
Se ti piace l'informatica
Non puoi non averlo
S**N
Superstar book
If you want to be more productive in office , by this book with little support from YouTube free courses if you didn’t catch the idea of any subject
E**L
Uso com frequencia
Uso sempre que preciso construir um algoritmo em VBA mais complexo
Trustpilot
2 weeks ago
1 month ago