Beginning Microsoft Excel VBA Programming for Accountants
Do you want to improve your productivity? Do you want to computerize your most time consuming tasks? Have you ever wanted to create your own applications in Microsoft Excel? In Beginning Microsoft VBA Programming for Accountants you’ll learn the techniques to build applications which will help you in your day to day work. Starting with a foundation in the basics of computer programming you’ll advance to three real life projects which you can use as a starting point for your own endeavors.
An accountant involved in day to day financial reporting, Derek Harlan, teaches you step by step how to build applications that you can use at work to maximize your productivity, you’ll learn:
- The basics of Visual Basic for Applications, including basic program design techniques
- To use VBA to manipulate Excel worksheets and workbooks
- How to build three sample projects including an Journal Entry Template for upload into Intuit QuickBooks, Expense Report generator and an application demonstrating Benford’s Law analysis
Financial reporting is full of mundane tasks that are perfect for automation. Learning VBA will put another arrow in your productivity quiver. If you want to spend less time grinding away the simple tasks then this book is for you.
Table of Contents
Chapter 1 – will introduce you to the basics of programming and familiarize you with the keywords and features of VBA
Chapter 2- will introduce you to the Excel Object Model which will build upon the knowledge learned in chapter 1 and cover specifics features to work with Excel workbooks and worksheets
Chapter 3- will introduce you to design forms so that you can create a user interface consisting of buttons and other elements.
Chapter 4- will teach you basic design and error handling techniques as well as how to use the built in debugging tools to troubleshoot your program.
Chapter 5- You’ll design and create an application to create Expense Reports from a list of expenses.
Chapter 6- You’ll design and create an application that allows a user to write a journal entry in a normal format but will export there entry to the QuickBooks IIF format for importing into QuickBooks accounting software
Derek Harlan is a Certified Public Accountant (CPA) with nearly a decade of experience in the accounting and financial reporting. Prior to this he held various roles in the Information Technology industry ranging from customer desktop support to systems management and began computer programming at the age of 10. He holds both a Bachelors & Masters of Science degrees in Accounting from University of Illinois at Chicago. Derek lives with his wife and son in the suburbs of Chicago, Illinois where he tinkers with an old IBM 5150 and enjoys working on 80’s era computers.
Example files used in the book:
Example Workbooks Zip Archive 177KB Download