100 Best VBA Books of All Time
We've researched and ranked the best vba books in the world, based on recommendations from world experts, sales data, and millions of reader ratings. Learn more
1
Maximize your Excel experience with VBA Excel 2016 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2016. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA), this comprehensive book presents all of the techniques you need to develop both large and small Excel applications. Over 800 pages of tips, tricks, and best practices shed light on key topics, such as the Excel interface, file formats, enhanced interactivity with other Office applications, and improved... more
2
Master database creation and management Access 2019 Bible is your, comprehensive reference to the world's most popular database management tool. With clear guidance toward everything from the basics to the advanced, this go-to reference helps you take advantage of everything Access 2019 has to offer. Whether you're new to Access or getting started with Access 2019, you'll find everything you need to know to create the database solution perfectly tailored to your needs, with expert guidance every step of the way. The companion website features all examples and databases used in... more
3
Microsoft Excel can be much more than just a spreadsheet. It has become adevelopment platform in it own right. Applications written using Excel are partof many corporations' core suites of business-critical applications. In spite ofthis, Excel is too often thought of as a hobbyist's platform. While there arenumerous titles on Excel and VBA, until now there have been none thatprovide an overall explanation of how to develop professional-quality Excel-basedapplications. All three authors are professional Excel developers who runtheir own companies developing Excel-based apps for clients ranging... more
4
Maximize your Excel 2013 experience using VBA application development
The new Excel 2013 boasts updated features, enhanced power, and new capabilities. Naturally, that means John Walkenbach returns with a new edition of his bestselling VBA Programming book and covers all the methods and tools you need to know in order to program with Excel. With this comprehensive guide, "Mr. Spreadsheet" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf.
Featuring a complete introduction to... more
The new Excel 2013 boasts updated features, enhanced power, and new capabilities. Naturally, that means John Walkenbach returns with a new edition of his bestselling VBA Programming book and covers all the methods and tools you need to know in order to program with Excel. With this comprehensive guide, "Mr. Spreadsheet" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf.
Featuring a complete introduction to... more
5
Take your data analysis and Excel programming skills to new heights In order to take Excel to the next level, you need to understand and implement the power of Visual Basic for Applications (VBA). This 4th edition of "Excel VBA Programming For Dummies" introduces you to a wide array of new Excel options, beginning with the most important tools and operations for the Visual Basic Editor. Inside, you'll get the lowdown on the essential elements and concepts for programming with Excel, discover techniques for handling errors and exterminating bugs, working with range objects, controlling program... more
7
The complete guide to Excel 2016, from Mr. 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. Whether you use Excel at work or at home, you will be guided through the powerful new features and capabilities by expert author and Excel Guru John Walkenbach to take full advantage of what the updated version offers. Learn to incorporate templates, implement formulas, create pivot tables, analyze data, and much more.
Navigate this powerful tool for business, home management,... more
Navigate this powerful tool for business, home management,... more
8
Power Query is one component of the Power BI (Business Intelligence) product from Microsoft, and “M” is the name of the programming language created by it. As more business intelligence pros begin using Power Pivot, they find that they do not have the Excel skills to clean the data in Excel; Power Query solves this problem. This book shows how to use the Power Query tool to get difficult data sets into both Excel and Power Pivot, and is solely devoted to Power Query dashboarding and reporting. less
10
Are you tired of doing repetitive tasks on the excel, want shortcuts? Do you make often get boredof repeating those bug and error fixes? Do you ever wish to automate the work you do on excel?
If yes, then you have found the right bundle. This two book bundle covers everything from thebasics of Excel covering macros and other simple techniques to make your life easier and alsocovers Visual Basics for making work a lot smoother and a lot better on Excel.
The bundle will teach you numerous applications of macros and how you can create them. Learnabout all the key shortcuts... more
If yes, then you have found the right bundle. This two book bundle covers everything from thebasics of Excel covering macros and other simple techniques to make your life easier and alsocovers Visual Basics for making work a lot smoother and a lot better on Excel.
The bundle will teach you numerous applications of macros and how you can create them. Learnabout all the key shortcuts... more
Don't have time to read the top VBA books of all time? Read Shortform summaries.
Shortform summaries help you learn 10x faster by:
- Being comprehensive: you learn the most important points in the book
- Cutting out the fluff: you focus your time on what's important to know
- Interactive exercises: apply the book's ideas to your own life with our educators' guidance.
11
This book is suitable for readers already familiar with the Excel user interface and introduces programming concepts via numerous multi-step, practical exercises. More advanced topics are introduced via custom projects. Covers recording and editing a macro and writing VBA code through working with XML documents and using ASP to display data on the Web."Microsoft Excel 2013 Programming by Example with VBA, XML and ASP" is a practical how-to book on Excel programming, suitable for readers already familiar with the Excel user interface. The book introduces programming concepts via numerous... more
13
This book is very, very different to any other computer book you have ever read. The Smart Method provides an entirely new and better way to learn Excel. Here are just five of the many ways in which this book is unique:
The book will equip you with excellent Excel skills, good enough to impress any employer, but it doesn't confuse by attempting to teach skills that are not common in the workplace. Only users who have advanced requirements need progress to the Expert Skills book.
Instruction is logically structured into sessions and lessons. While this makes the book... more
The book will equip you with excellent Excel skills, good enough to impress any employer, but it doesn't confuse by attempting to teach skills that are not common in the workplace. Only users who have advanced requirements need progress to the Expert Skills book.
Instruction is logically structured into sessions and lessons. While this makes the book... more
14
AUTOMATE REPORTS BUILD FUNCTIONS VISUALIZE DATA WRITE FAST, RELIABLE SCRIPTS Microsoft Excel 2010 VBA AND MACROS: SAVE TIME AND SUPERCHARGE EXCEL 2010 WITH VBA AND MACROS! Use Excel 2010 VBA and macros to automate virtually any routine task, and save yourself hours, days, maybe even weeks. Then learn how to make Excel do things you thought were simply impossible! This book reveals scripting techniques you won't find anywhere else and shows you how to create automated reports that are amazingly powerful and useful. It helps you instantly visualize information so you can understand and act on... more
15
MASTER CORE EXCEL 2016 TOOLS FOR BUILDING POWERFUL, RELIABLE SPREADSHEETS! Use this guide to automate virtually any routine 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, so you can act on it... capture data from anywhere, and use it anywhere... automate Excel 2016's best new features. You'll find simple, step-by-step instructions, real-world case... more
18
Make Excel work for you
Excel 2019 All-In-One For Dummies offers eight books in one!! It is completely updated to reflect the major changes Microsoft is making to Office with the 2019 release. From basic Excel functions, such as creating and editing worksheets, to sharing and reviewing worksheets, to editing macros with Visual Basic, it provides you with a broad scope of the most common Excel applications and functions--including formatting worksheets, setting up formulas, protecting worksheets, importing data, charting data, and performing statistical functions. more
Excel 2019 All-In-One For Dummies offers eight books in one!! It is completely updated to reflect the major changes Microsoft is making to Office with the 2019 release. From basic Excel functions, such as creating and editing worksheets, to sharing and reviewing worksheets, to editing macros with Visual Basic, it provides you with a broad scope of the most common Excel applications and functions--including formatting worksheets, setting up formulas, protecting worksheets, importing data, charting data, and performing statistical functions. more
19
All the methods and tools you need to successfully program with Excel John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf.
Featuring a complete introduction to Visual Basic for Applications and fully updated for the new features of Excel 2010, this essential reference includes an analysis of Excel application development and is... more
Featuring a complete introduction to Visual Basic for Applications and fully updated for the new features of Excel 2010, this essential reference includes an analysis of Excel application development and is... more
Don't have time to read the top VBA books of all time? Read Shortform summaries.
Shortform summaries help you learn 10x faster by:
- Being comprehensive: you learn the most important points in the book
- Cutting out the fluff: you focus your time on what's important to know
- Interactive exercises: apply the book's ideas to your own life with our educators' guidance.
21
Newly updated for Excel 2002, Writing Excel Macros with VBA, 2nd Edition provides Excel power-users, as well as programmers who are unfamiliar with the Excel object model, with a solid introduction to writing Visual Basic for Applications (VBA) macros and programs for Excel. In particular, the book focuses on:
The Visual Basic Editor and the Excel VBA programming environment. Excel features a complete, state-of-the-art integrated development environment for writing, running, testing, and debugging VBA macros. The VBA programming language, the same programming language used... more
The Visual Basic Editor and the Excel VBA programming environment. Excel features a complete, state-of-the-art integrated development environment for writing, running, testing, and debugging VBA macros. The VBA programming language, the same programming language used... more
23
Offers procedures, tips, and ideas for expanding Excel's capabilities with Visual Basic[registered] for Applications. less
25
SAVE TIME AND SUPERCHARGE EXCEL 2013 WITH VBA AND MACROS! Use Excel(R) 2013 VBA and Macros to automate virtually any routine task, and save yourself hours, days, maybe
even weeks. Then, learn how to make Excel do things you thought were simply impossible! You'll discover macro
techniques you won't find anywhere else and learn how to create automated reports that are amazingly powerful
and useful. Bill Jelen and Tracy Syrstad show how to instantly visualize information, so you and your colleagues
can understand and act on it...how to capture data from... more
even weeks. Then, learn how to make Excel do things you thought were simply impossible! You'll discover macro
techniques you won't find anywhere else and learn how to create automated reports that are amazingly powerful
and useful. Bill Jelen and Tracy Syrstad show how to instantly visualize information, so you and your colleagues
can understand and act on it...how to capture data from... more
26
Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad explain how to build more powerful, reliable, and efficient Excel spreadsheets. 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 Excel... more
28
Master database creation and management "Access 2016 Bible" is your, comprehensive reference to the world's most popular database management tool. With clear guidance toward everything from the basics to the advanced, this go-to reference helps you take advantage of everything Access 2016 has to offer. Whether you're new to Access or getting started with Access 2016, you'll find everything you need to know to create the database solution perfectly tailored to your needs, with expert guidance every step of the way. The companion website features all examples and databases used in the book,... more
29
Updated for Access 2016 and based on the bestselling editions from previous versions, Microsoft Access 2016 Programming by Example with VBA, XML and ASP is a practical how-to book on Access programming, suitable for readers already proficient with the Access user interface (UI). If you are looking to automate Access routine tasks, this book will progressively introduce you to programming concepts via numerous illustrated hands-on exercises. More advanced topics are demonstrated via custom projects. Includes a comprehensive disc with source code, supplemental files, and color screen... more
30
Don't have time to read the top VBA books of all time? Read Shortform summaries.
Shortform summaries help you learn 10x faster by:
- Being comprehensive: you learn the most important points in the book
- Cutting out the fluff: you focus your time on what's important to know
- Interactive exercises: apply the book's ideas to your own life with our educators' guidance.
32
Enhance productivity in any Office application with zero programming experience Mastering VBA for Microsoft Office 2016 helps you extend the capabilities of the entire Office suite using Visual Basic for Applications (VBA). Even if you have no programming experience, you'll be automating routine computing processes quickly using the simple, yet powerful VBA programming language. Clear, systematic tutorials walk beginners through the basics, while intermediate and advanced content guides more experienced users toward efficient solutions. This comprehensive guide starts at the... more
34
There's nothing random about it--this is the book on statistical analysis with Excel Stunned by statistics? Exhausted by Excel? Relax! Statistical Analysis with Excel For Dummies, 4th Edition shows you how to use the world's most popular spreadsheet program to crunch numbers and interpret statistics--even if you've never taken a statistics or advanced math course. In no time, you'll learn to use Excel to create and translate statistics in everyday life, understand common statistical terms, and improve your classroom or professional skills.
Statistics has a... more
Statistics has a... more
36
The online documentation of VB/VBA language components seems to follow the 80/20 rule: the basic facts that you need to use a language statement are provided in the documentation. But the additional 20 percent that you need to use it effectively or to apply it to special cases is conspicuously absent. To a professional VB/VBA programmer, though, this missing 20 percent of the language's documentation isn't a luxury, it's a necessity. And in VB & VBA in a Nutshell: The Language, it finally is available.
The bulk of the book consists of an alphabetical reference to the... more
The bulk of the book consists of an alphabetical reference to the... more
37
A follow-up to Excel Outside the Box, More Excel Outside the Box is designed with the Excel guru in mind, introducing advanced, creative solutions and hacks for the software’s most challenging problems. Through a series of more than 30 techniques, tables, formulas, and charts, this guide details processes that may be used in any Excel application and across all disciplines. Creative approaches for building formulas within formulas, pivot tables, conditional formatting, and mastering array formulas are just some of the numerous challenges explained. Other higher-level solutions... more
40
Don't have time to read the top VBA books of all time? Read Shortform summaries.
Shortform summaries help you learn 10x faster by:
- Being comprehensive: you learn the most important points in the book
- Cutting out the fluff: you focus your time on what's important to know
- Interactive exercises: apply the book's ideas to your own life with our educators' guidance.
41
Learn to program and design user interfaces using Excel 2007. KEY TOPICS: This introductory text explains how to develop programs using VBA within the Microsoft Excel environment. The text does not assume any previous programming experience. The new edition has been revised to bring it up-to-date with the Office 2007 environment. MARKET For students and professionals in General Engineering or Computer Science fields. less
42
For any Microsoft Office user familiar with Word, Excel, PowerPoint, Access, or Outlook, this book provides tutorials on the tools and tricks that automate these programs for increased productivity. Each lesson includes instructions and a downloadable file on which to test the VBA macros and procedures provided. Tasks covered include how to run several mail merges at once, removing duplicates from data, and saving email attachments.
less
less
43
Learn to harness the power of Visual Basic for Applications (VBA) in Microsoft Excel to develop interesting, useful, and interactive Excel applications. This book will show you how to manipulate Excel with code, allowing you to unlock extra features, accuracy, and efficiency in working with your data. Programming Excel 2016 with VBA is a complete guide to Excel application development, using step-by-step guidance, example applications, and screenshots in Excel 2016.
In this book, you will learn:
How to interact with key Excel objects, such as the application object,... more
In this book, you will learn:
How to interact with key Excel objects, such as the application object,... more
44
Learning to program in Excel VBA is easy! The Visual Basic programming language is available and waiting in Excel itself - ready to be used. This book will help you utilize the full power of Excel to write and extend macros. It will also allow you to learn to program in Visual Basic - without the expense of buying the Visual Basic software! Its easy, step-by-step, colourful, illustrated approach is ideal for complete beginners or users a little daunted by advanced VBA books. Increase productivity and efficiency with this excellent guide. less
46
This friendly, easy-to-use guide shows experienced Access users how to use VBA (Visual Basic for Applications) to build Access databases and applications, but also covers programming fundamentals for nonprogrammers Includes practical, ready-to-use VBA code examples that readers can type or copy and paste from the Web into their own database projects Explains basic VBA skills and concepts for nonprogrammers, such as procedures, variables, and loops Covers more advanced topics, such as record sets and other programming activities that are unique to Access programming Author has written more... more
47
You're beyond the basics, so dive right in and customize, automate, and extend Access—using Visual Basic® for Applications (VBA). This supremely organized reference is packed with hundreds of time-saving solutions, troubleshooting tips, and workarounds. It's all muscle and no fluff. Discover how the experts use VBA to exploit the power of Access—and challenge yourself to new levels of mastery!
Enhance your application with VBA built-in functions and SQL code Use the Access Object Model to work with data in forms and reports Manipulate data using SQL, queries, and... more
Enhance your application with VBA built-in functions and SQL code Use the Access Object Model to work with data in forms and reports Manipulate data using SQL, queries, and... more
48
Excel VBA in easy steps begins by explaining how to record and edit macro procedures to manipulate Excel worksheet entries, then describes how to create your own macro programs in the Visual Basic Editor (VBE) that is included with the Excel application. This book then demonstrates how to program Excel procedures, provide Excel user forms, and create Excel apps. Each chapter builds your knowledge of Visual Basic for Applications.
Excel VBA in easy steps contains separate chapters on the major features of the VBA language. There are complete example programs that... more
Excel VBA in easy steps contains separate chapters on the major features of the VBA language. There are complete example programs that... more
49
Maximize your Excel experience with VBA Excel 2019 Power Programming with VBA is fully updated to cover all the latest tools and tricks of Excel 2019. Encompassing an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA), this comprehensive book presents all of the techniques you need to develop both large and small Excel applications. Over 800 pages of tips, tricks, and best practices shed light on key topics, such as the Excel interface, file formats, enhanced interactivity with other Office applications, and improved... more
50
In this day and age of too much information and not enough time, the ability to get to the bottom line quickly and in a concise method is what excels companies to the top of their industry. The techniques in this book will allow you to do things you only dreamt of. Jerry Kohl, president of Brighton Collectibles Develop your Excel macro programming skills using VBA instantly with proven techniques Automate Reports Handle Errors Master Pivot Tables Produce Charts Build User-Defined Functions Migrate to Excel 2007 Query Web Data Build Dialog Boxes Use Data Visualizations Automate Word You are an... more
Don't have time to read the top VBA books of all time? Read Shortform summaries.
Shortform summaries help you learn 10x faster by:
- Being comprehensive: you learn the most important points in the book
- Cutting out the fluff: you focus your time on what's important to know
- Interactive exercises: apply the book's ideas to your own life with our educators' guidance.
52
A comprehensive guide to the language used to customize Microsoft Office Visual Basic for Applications (VBA) is the language used for writing macros, automating Office applications, and creating custom applications in Word, Excel, PowerPoint, Outlook, and Access. This complete guide shows both IT professionals and novice developers how to master VBA in order to customize the entire Office suite for specific business needs.
Office 2010 is the leading productivity suite, and the VBA language enables customizations of all the Office programs; this complete guide gives both... more
Office 2010 is the leading productivity suite, and the VBA language enables customizations of all the Office programs; this complete guide gives both... more
53
Step-by-step instructions for creating VBA macros Harness the power of VBA and create custom Excel applications
Make Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and much more.
Discover how to
Grasp essential programming concepts Use the Visual Basic Editor Navigate the new Excel user... more
Make Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and much more.
Discover how to
Grasp essential programming concepts Use the Visual Basic Editor Navigate the new Excel user... more
54
Now you can prepare for the number one job in the tech sector -- app development - as you learn the essentials of Microsoft Visual Basic with the step-by-step, visual approach and professional programming opportunities in MICROSOFT VISUAL BASIC 2015 FOR WINDOWS APPLICATIONS: INTRODUCTORY. This book lays the initial groundwork for a degree in IT programming as it equips you with a fundamental understanding of Windows programming for 2015. The book's innovative step-by-step approach blends video demonstrations of professional-quality programs with in-depth discussions of today's most effective... more
55
Take your Excel programming skills to the next level
To take Excel to the next level, you need to understand and implement the power of Visual Basic for Applications (VBA). Excel VBA Programming For Dummies introduces you to a wide array of new Excel options, beginning with the most important tools and operations for the Visual Basic Editor.
Inside, you'll find an overview of the essential elements and concepts for programming with Excel. In no time, you'll discover techniques for handling errors and exterminating bugs, working with range objects and... more
To take Excel to the next level, you need to understand and implement the power of Visual Basic for Applications (VBA). Excel VBA Programming For Dummies introduces you to a wide array of new Excel options, beginning with the most important tools and operations for the Visual Basic Editor.
Inside, you'll find an overview of the essential elements and concepts for programming with Excel. In no time, you'll discover techniques for handling errors and exterminating bugs, working with range objects and... more
58
Providing programmers and developers of all skill levels with a comprehensive tutorial and reference to Visual Basic (VB) 2008, Microsoft MVP Rod Stephens presents a broad, solid understanding of essential topics on the latest version of VB. He explains the forms, controls, and other objects that VB furnishes for building applications in a modern windows environment. Plus, he examines the powerful development environment that makes VB such a productive language, and he delves into the VB language itself to show you how to use it to perform an array of important development tasks. Note:... more
60
Everyone is looking for ways to save money these days. That can be hard to do for businesses that have complex needs, such as custom software applications. However, VBA and Macros for Microsoft Excel can teach you ways to customize pre-existing software to meet your specific needs. A variety of topics are covered that are sure to give you a solid knowledge of the VBA language. Event programming, user forms, carts, pivot tables, multi-dimensional arrays and Web queries are just a few of the areas you will learn about in this book. Written by the principal behind the leading Excel Web... more
Don't have time to read the top VBA books of all time? Read Shortform summaries.
Shortform summaries help you learn 10x faster by:
- Being comprehensive: you learn the most important points in the book
- Cutting out the fluff: you focus your time on what's important to know
- Interactive exercises: apply the book's ideas to your own life with our educators' guidance.
61
Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place. But programming Excel isn't about adding new features as much as it's about combining existing features to solve particular problems. With a few modifications, you can transform Excel into a task-specific piece of software that will quickly and precisely serve your needs. In other words, Excel is an ideal platform for probably millions of small spreadsheet-based software solutions.
The best part is, you can program Excel with no... more
The best part is, you can program Excel with no... more
62
Master VBA automation quickly and easily to get more out of Excel Excel VBA 24-Hour Trainer, 2nd Edition is the quick-start guide to getting more out of Excel, using Visual Basic for Applications. This unique book/video package has been updated with fifteen new advanced video lessons, providing a total of eleven hours of video training and 45 total lessons to teach you the basics and beyond. This self-paced tutorial explains Excel VBA from the ground up, demonstrating with each advancing lesson how you can increase your productivity. Clear, concise, step-by-step instructions are... more
63
Access 2007 VBA Programmer's Reference covers a wide spectrum of programming topics relevant to Access. Although it assumes the reader has some familiarity with VBA programming language, it begins with a brief introduction to VBA. And to help you leverage the tools that Access provides, a chapter highlights the new features in Microsoft Office Access 2007 -- including new wizards and GUI (graphical user interface) elements that previously required VBA code, as well as new VBA features. The book also discusses how to create and name variables, how to use Data Access Object (DAO) and... more
64
Whether you're moving from Microsoft Office to Google Docs or simply want to learn how to automate Docs with Google Apps Script, this practical guide shows you by example how to work with each of the major Apps Script services.
Office still supports VBA, but it's not likely to do so for much longer. If you're a VBA or .NET developer, you'll learn how to port existing VBA code and structure to their JavaScript-based Apps Script equivalents with minimal effort. Author Bruce Mcpherson introduces JavaScript basics for experienced developers unfamiliar with the language, and... more
Office still supports VBA, but it's not likely to do so for much longer. If you're a VBA or .NET developer, you'll learn how to port existing VBA code and structure to their JavaScript-based Apps Script equivalents with minimal effort. Author Bruce Mcpherson introduces JavaScript basics for experienced developers unfamiliar with the language, and... more
67
PowerPoint for Teachers is written for especially for teachers like you, who want to use PowerPoint in the classroom to enhance your presentations, teach your students how to use the application, and create interactive educational projects. No matter what your level of expertise--just getting started or seasoned pro--PowerPoint for Teachers gives you the step-by-step information you need to introduce PowerPoint into your classroom and offers a great selection of creative projects for your students.
PowerPoint for Teachers includes the dos and don'ts for best... more
PowerPoint for Teachers includes the dos and don'ts for best... more
68
You’re a sophisticated user of Excel—a real pro with spreadsheets—so now dig into its powerful programming capabilities and really put your data to work! From writing code in Microsoft Visual Basic for Applications (VBA) to taking advantage of new XML data-sharing features, this book packs hundreds of timesaving programming solutions, troubleshooting tips, and handy workarounds all in concise, fast-answer format.
Discover the best and fastest ways to build custom business solutions with Excel—and challenge yourself to new levels of mastery!
From automating simple... more
Discover the best and fastest ways to build custom business solutions with Excel—and challenge yourself to new levels of mastery!
From automating simple... more
69
Who is this book for?
If you've never written VBA code before this book will show you how.
This book is for Access developers who:
Are comfortable with all aspects of the interactive use of Access
Are already able to design simple relational databases
Want to learn VBA skills from first principles
Want to learn how to develop professional-grade Access applications
What you will learn
This unique book provides the easiest possible route to mastering professional Microsoft Access... more
If you've never written VBA code before this book will show you how.
This book is for Access developers who:
Are comfortable with all aspects of the interactive use of Access
Are already able to design simple relational databases
Want to learn VBA skills from first principles
Want to learn how to develop professional-grade Access applications
What you will learn
This unique book provides the easiest possible route to mastering professional Microsoft Access... more
70
Even if you're not a programmer, you can quickly learn to write macros, automate tasks, and create custom applications for Office 2007 with Microsoft'sVisual Basic for Applications (VBA) and the in-depth instruction in this comprehensive guide. You'll jump right into the basics of recording and running macros with Office's built-in Macro Recorder, before quickly moving to the essentials of VBA syntax, using loops and functions, building effective code, and programming applications in Word, Excel, PowerPoint, Outlook, and Access. Includes pages of real-world examples and techniques. less
Don't have time to read the top VBA books of all time? Read Shortform summaries.
Shortform summaries help you learn 10x faster by:
- Being comprehensive: you learn the most important points in the book
- Cutting out the fluff: you focus your time on what's important to know
- Interactive exercises: apply the book's ideas to your own life with our educators' guidance.
72
VBA helps you put your computer in its placeWrite programs that automate tasks and make Office 2007 work better for you
If your computer is becoming your boss instead of your servant, start using VBA to tell it what to do Here's the latest on the VBA IDE and program containers, debugging and controlling your programs, working with multiple applications using a single program, and the most exciting stuff -- programming for all the Office 2007 applications.
Discover how toCustomize an application's interfaceQuick-launch a VBA programStore and modify informationUse VBA with... more
If your computer is becoming your boss instead of your servant, start using VBA to tell it what to do Here's the latest on the VBA IDE and program containers, debugging and controlling your programs, working with multiple applications using a single program, and the most exciting stuff -- programming for all the Office 2007 applications.
Discover how toCustomize an application's interfaceQuick-launch a VBA programStore and modify informationUse VBA with... more
74
Now you can prepare for the number one job in the tech sector -- app development - as you master Microsoft Visual Basic with the step-by-step, visual approach and professional programming opportunities in MICROSOFT VISUAL BASIC 2015 FOR WINDOWS, WEB, WINDOWS STORE, AND DATABASE APPLICATIONS: COMPREHENSIVE. This book lays the groundwork for a degree in IT programming as it equips you with a solid understanding of Windows programming for 2015, including Windows Desktop, database and web applications, and Windows Store development. The book's innovative step-by-step approach blends video... more
76
A unique, comprehensive guide to creating custom apps with VBA
Automating computing tasks to increase productivity is a goal for businesses of all sizes. Visual Basic for Applications (VBA) is a version of Visual Basic designed to be easily understandable for novice programmers, but still powerful enough for IT professionals who need to create specialized business applications. With this invaluable book, you'll learn how to extend the capabilities of Office 2013 applications with VBA programming and use it for writing macros, automating Office applications, and creating... more
Automating computing tasks to increase productivity is a goal for businesses of all sizes. Visual Basic for Applications (VBA) is a version of Visual Basic designed to be easily understandable for novice programmers, but still powerful enough for IT professionals who need to create specialized business applications. With this invaluable book, you'll learn how to extend the capabilities of Office 2013 applications with VBA programming and use it for writing macros, automating Office applications, and creating... more
77
"Visual Studio Tools for Office 2007: VSTO for Excel, Word, and Outlook "is the definitive book on VSTO 2008 programming, written by the inventors of the technology. VSTO is a set of tools that allows professional developers to use the full power of Microsoft Visual Studio 2008 and the .NET Framework to program against Microsoft Office 2007. This book delivers in one place all the information you need to succeed using VSTO to program against Word 2007, Excel 2007, and Outlook 2007, and provides the necessary background to customize Visio 2007, Publisher 2007, and PowerPoint 2007. It... more
78
If you have ‘Excel’ on your resume but cannot write VBA macros, then you are at a serious disadvantage in today’s labor market. All of your competitors also know 'Excel' and many of them use sophisticated functions. Whether you are seeking a new job, trying to make yourself indispensible or just up-skilling, we take Excel users from dead-zero in VBA programming to functional VBA skills in one day! VBA programming among new MBAs, corporate staff and investment analysts remains surprisingly scarce. The Little VBA Book teaches macros that: (1) gather data from the Internet, (2) invoke functions,... more
79
This guide to unleashing the power of Microsoft Excel by using Excel's VBA programming language shows nonprogrammers how to solve real-life problems with Excel VBA. Thousands of concise code samples are accompanied by sample workbooks in a question-and-answer format that describes each specific task.
less
less
80
This book teaches you to develop VBA macros for Microsoft Project that are productive, quick to develop, and easy to maintain. The learning examples included in this book give you a great jumpstart for your own Project VBA programming projects. I document an array of useful macros, including routines for viewing all tasks linked to the selected one, automatically creating a consolidated snapshot of multiple project files, a Who Does What When report exported to Excel, and more. In this book, I teach you how to write VBA macros for Microsoft Project by explaining how to design them for easier... more
Don't have time to read the top VBA books of all time? Read Shortform summaries.
Shortform summaries help you learn 10x faster by:
- Being comprehensive: you learn the most important points in the book
- Cutting out the fluff: you focus your time on what's important to know
- Interactive exercises: apply the book's ideas to your own life with our educators' guidance.
81
Ready-made Excel macros that will streamline your workflow Excel Macros For Dummies helps you save time, automate, and be more productive, even with no programming experience at all. Each chapter offers practical macros that you can implement right away, with practical exercises that extend your knowledge and help you understand the mechanics at work. You'll find the most effective Excel macros for solving common problems, and explanations of why and where to use each one, plus invaluable guidance and step-by-step instruction for applying them effectively. Learn how to customize... more
82
Help your students master both basic and advanced skills in Visual Basic for Applications (VBA), the programming language for Microsoft Office, with this essential tool. Chris Albright's VBA FOR MODELERS: DEVELOPING DECISION SUPPORT SYSTEMS WITH MICROSOFT OFFICE EXCEL, 5E provides everything you need to teach students how to automate common spreadsheet tasks as well as create the sophisticated management science applications needed in business today. The first half of the book introduces students to the fundamentals of VBA for Excel. The second half puts knowledge into action as it... more
86
With over 1.3 million developers in North America and 4 million worldwide, Visual Basic is the most popular development tool on the market today. Though the transition from VB 6 to VB .NET has been slow since its release in late 2001, this revolutionary and powerful programming language is moving out of the "early adopter" stage and into general acceptance by the bulk of the developer audience. Teach Yourself VB .NET in 21 Days, 2/E is designed to be the new market leader, written to make VB .NET more accessible than ever before. Currently most books on the market approach VB .NET... more
87
These self-paced courses provide technology users with the training required for proficiency. Presented visually on more than 1,400 slides, and with frequent self-checks to ensure mastery, these tutorials include a convenient navigation system that allows the learners to jump to any specific location.
less
less
88
Prepare for the number one job in today's tech sector -- app development -- as you learn the essentials of Microsoft Visual Basic. The step-by-step, visual approach and professional programming opportunities in MICROSOFT VISUAL BASIC 2017 FOR WINDOWS APPLICATIONS: INTRODUCTORY lay the initial groundwork for a successful degree in IT programming. You gain a fundamental understanding of Windows programming for 2017. This edition's innovative approach blends visual demonstrations of professional-quality programs with in-depth discussions of today's most effective programming concepts and... more
89
Beginning Microsoft Visual Basic 2008 is designed to teach you how to write useful programs in Visual Basic 2008 as quickly and easily as possible.
There are two kinds of beginners for whom this book is ideal:
You're a beginner to programming and you've chosen Visual Basic 2008 as the place to start. That's a great choice! Visual Basic 2008 is not only easy to learn, it's also fun to use and very powerful.
You can program in another language but you're a beginner to .NET programming. Again, you've made a great choice! Whether you've come from... more
There are two kinds of beginners for whom this book is ideal:
You're a beginner to programming and you've chosen Visual Basic 2008 as the place to start. That's a great choice! Visual Basic 2008 is not only easy to learn, it's also fun to use and very powerful.
You can program in another language but you're a beginner to .NET programming. Again, you've made a great choice! Whether you've come from... more
90
Many Microsoft Word users and VBA programmers don't realize the extensive opportunities that exist when Word's Object Model is accessed using Visual Basic for Applications (VBA), which replaced WordBasic in conjunction with the release of Word 97. By creating what is commonly called a "Word Macro" you can automate many features available in Word. Writing Word Macros (previously titled Learning Word Programming is the introduction to Word VBA that allows you to do these things and more, including:
Create custom pop-up menus Automatically create tables from lists... more
Create custom pop-up menus Automatically create tables from lists... more
Don't have time to read the top VBA books of all time? Read Shortform summaries.
Shortform summaries help you learn 10x faster by:
- Being comprehensive: you learn the most important points in the book
- Cutting out the fluff: you focus your time on what's important to know
- Interactive exercises: apply the book's ideas to your own life with our educators' guidance.
91
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
Develop custom Access VBA macrosPerfect for power users, Microsoft Access 2010 VBA Macro Programming reveals how to maximize the features and functionality of Access 2010. You'll get in-depth details on Access VBA programming and application development followed by 20 real-world projects--complete with source code--that show you how to set up specific subroutines and functions. This practical... more
Develop custom Access VBA macrosPerfect for power users, Microsoft Access 2010 VBA Macro Programming reveals how to maximize the features and functionality of Access 2010. You'll get in-depth details on Access VBA programming and application development followed by 20 real-world projects--complete with source code--that show you how to set up specific subroutines and functions. This practical... more
92
If you are new to programming with Microsoft Excel VBA and are looking for a solid introduction, this is the book for you. Developed by computer science professors, books in the "for the absolute beginner" series teach the principles of programming through simple game creation. Microsoft Excel VBA Programming for the Absolute Beginner, Third Edition provides you with the skills that you need for more practical Excel VBA programming applications and shows you how to put these skills to use in real-world scenarios. Best of all, by the time you finish the book, you will be able to apply the... more
95
Microsoft Excel has, over the years, become the greatest software in the field of electronic worksheets. Its strength is that it meets the demands of huge numbers of users worldwide. Nonetheless - despite the advancement and expanding use of this software - there is ever-increasing demand from the end users; much of which can only be solved by VBA programming (Visual Basic for Applications). Therefore, "Excel VBA - In Everyday Language" was written in order to provide a response to the growing demand for the advanced capabilities of Microsoft Excel. This book was written: - For the... more
96
Computers and devices are more connected now than ever before. Why? Because the humans who use those computers need to collaborate. We need to share information, and we need to do it quickly, without regard to the physical distance that separates us. Corporate solution developers now more than ever have the opportunity and responsibility to enable people to communicate in ways never before possible.
CDO and MAPI Programming with Visual Basic: Developing Mail and Messaging Applications dives deep into Microsoft's Collaboration Data Objects (CDO) and the Messaging Application... more
CDO and MAPI Programming with Visual Basic: Developing Mail and Messaging Applications dives deep into Microsoft's Collaboration Data Objects (CDO) and the Messaging Application... more
97
Microsoft Outlook Programming unleashes the power of Microsoft Outlook, allowing administrators and end users to customize Outlook in the same way that they've used macros and templates to customize other programs like Excel and Word. Experienced developers will find the quick-start information they need to begin integrating Outlook into their applications. Microsoft Exchange administrators will get help automating common tasks such as announcing public folders and importing data to custom forms.
Microsoft Outlook is the most widely used email program, and it offers the most... more
Microsoft Outlook is the most widely used email program, and it offers the most... more
98
With more than 275 applied examples and 10 projects, Access users can quickly build database solutions with ActiveX Data Objects (ADO), perform database tasks with Jet/Access Structured Query Language (SQL) and export/import Access data to and from XML both manually and programmatically.The book, which covers the latest release of Access and earlier versions, is divided into five parts: an introduction to VBA programming, manipulating databases with ADO, using DDL, event programming, and using ASP and XML. The text will show you how to write and debug your programming code with the Visual... more
99
Are you hesitant to migrate to Visual Studio(r) 2005? Maybe you're ready to upgrade to Visual Basic 2005 but feel a bit overwhelmed by ADO.NET 2.0 and the Visual Data Tools of this new release. In this hands-on guide, I'll share with you the best practices, the latest features, and advanced data management techniques with Visual Basic 2005 and SQL Server or SQL Server Express 2005. Plus, I'll incorporate simple to moderately complex project examples that feature real-world, database front-end applications with Windows and Web forms. First, I'll begin with ADO.NET 2.0 basics, then I'll move on... more
Don't have time to read the top VBA books of all time? Read Shortform summaries.
Shortform summaries help you learn 10x faster by:
- Being comprehensive: you learn the most important points in the book
- Cutting out the fluff: you focus your time on what's important to know
- Interactive exercises: apply the book's ideas to your own life with our educators' guidance.