Beginning Microsoft Excel VBA Programming for Accountants: A Practical and Project Based Approach

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.