Excel® 2016 Power Programming with VBA by Michael Alexander, Dick Kusleika.
The book in PDF Format with title Excel® 2016 Power Programming with VBA by Michael Alexander, Dick Kusleika is available to download for free and Download Link is at the end of the article
Part I: Introduction to Excel VBA
Chapter 1: Essentials of Spreadsheet Application Development
Chapter 2: Introducing Visual Basic for Applications
Chapter 3: VBA Programming Fundamentals
Chapter 4: Working with VBA Sub Procedures
Chapter 5: Creating Function Procedures
Chapter 6: Understanding Excel’s Events
Chapter 7: VBA Programming Examples and Techniques
Part II: Advanced VBA Techniques
Chapter 8: Working with Pivot Tables
Chapter 9: Working with Charts
Chapter 10: Interacting with Other Applications
Chapter 11: Working with External Data and Files
Part III: Working with UserForms
Chapter 12: Leveraging Custom Dialog Boxes
Chapter 13: Introducing UserForms
Chapter 14: UserForm Examples
Chapter 15: Advanced UserForm Techniques
Part IV: Developing Excel Applications
Chapter 16: Creating and Using Add-Ins
Chapter 17: Working with the Ribbon
Chapter 18: Working with Shortcut Menus
Chapter 19: Providing Help for Your Applications
Chapter 20: Leveraging Class Modules
Chapter 21: Understanding Compatibility Issues
Part V: Appendix
Appendix A: VBA Statements and Function Reference
Introduction: For most of us, the path to Excel VBA programming starts with the need to perform some task that can’t be done with the standard tools in Excel. That task is different for each of us. Maybe that task is to automatically create separate workbooks for all the rows in a dataset. Maybe that task is to automate the emailing of dozens of reports. Whatever that task is for you, you can bet that someone has started their own journey into Excel VBA with the same need.
The beautiful thing about Excel VBA is that you don’t have to be an expert to start solving problems with it. You can learn just enough to solve a particular problem, or you can go further and discover ways to handle all kinds of automation scenarios.
Whatever your goals may be, Excel 2016 Power Programming with VBA will help you harness the power of the VBA language to automate tasks, work smarter, and be more productive
This book focuses on Visual Basic for Applications (VBA), the programming language built into Excel (and other applications that make up Microsoft Office). More specifically, it shows you how to write programs that automate various tasks in Excel. This book covers everything from recording simple macros through creating sophisticated user-oriented applications and utilities.
You can approach this book in any way that you please. You can read it from cover to cover, or you can skip around, picking up useful tidbits here and there. VBA programming is often a task-oriented endeavor. So if you’re faced with a challenging task, you might try the index first to see where the book might specifically address your problem.
This book does not cover Microsoft Visual Studio Tools for Office (VSTO), a technology that uses Visual Basic .NET and Microsoft Visual C#. VSTO can also be used to control Excel and other Microsoft Office applications.
As you may know, Excel 2016 is available for other platforms. For example, you can use Microsoft’s Excel Web App in your browser and even iPads and tablets. These versions do not support VBA. In other words, this book is for the desktop version of Excel 2016 for Windows.
What You Need to Know
This is not a book for beginning Excel users. If you have no experience with Excel, a better choice might be Excel 2016 Bible (John Walkenbach, Wiley Publishing), which provides comprehensive coverage of all the features of Excel and is meant for users of all levels.
To get the most out of this book, you should be a relatively experienced Excel user who knows how to:
▪️️Create workbooks, insert sheets, save files, and so on
▪️Navigate through a workbook
▪️Use the Excel Ribbon user interface
▪️Use Excel’s worksheet functions
▪️Name cells and ranges
▪️Use basic Windows features, such as file management techniques and the Clipboard
What You Need to Have
It is important to have a full installation of Excel and, if you want to try the more advanced chapters involving communication between Excel and other Office applications, you will need a full installation of Office.
Although most of the material also applies to earlier versions of Excel, we assume that you are using Excel 2016. If you plan to develop applications that will be used in earlier versions of Excel, we strongly suggest that you use the earliest version of Excel that your target audience will be using.
The version of Windows you use is not important. Any computer system that can run Windows will suffice, but you’ll be much better off with a fast machine with plenty of memory. Excel is a large program, and using it on a slower system or a system with minimal memory can be extremely frustrating. This book is not intended for any version of Excel for Mac.
Conventions in This Book
Take a minute to skim this section and learn some of the typographic conventions used throughout this book.
About the Authors:
Michael Alexander is a Microsoft Certified Application Developer (MCAD) and author of several books on advanced business analysis with Microsoft Access and Microsoft Excel. He has more than 15 years of experience consulting and developing Microsoft Office solutions. Mike has been named a Microsoft MVP for his ongoing contributions to the Excel community. In his spare time, he runs a free tutorial site, www.datapigtechnologies.com, where he shares Excel and Access tips.
Dick Kusleika has been awarded as a Microsoft MVP for 12 consecutive years and has been working with Microsoft Office for more than 20. Dick develops Access-and Excel-based solutions for his clients and has conducted training seminars on Office products in the United States and Australia. Dick also writes a popular Excel-related blog at www.dailydoseofexcel.com.
You May Also Like:
Excel® 2016 Power Programming with VBA by Michael Alexander, Dick Kusleika pdf.
⏩Authors: Michael Alexander, Dick Kusleika
⏩Puplisher: John Wiley & Sons, Inc
⏩Puplication Date: 2016
⏩ISBN: 978-1-119-06756-6 (ebk)
⏩ISBN: 978-1-119-06762-7 (ebk)
⏩Size: 29.4 MB
Download Excel® 2016 Power Programming with VBA by Michael Alexander, Dick Kusleika in pdf format for free.