Back cover

BOOK-KEEPING WITH MICROSOFT EXCEL

Microsoft Excel has long been used to help in book-keeping and accounting tasks. This book shows how you can use Microsoft Excel for all your book-keeping tasks in a small or medium-sized business. Book-keeping tasks here include recording of data from various sources, and the preparation of Trial Balance, Balance Sheet, Profit & Loss statement and other reports.

You will see how formulas can be used to automate updating of your Trial Balance, Balance Sheet, Profit & Loss statement and other reports. No programming at all is required. Using Excel's AutoFilter, CustomFilter, AdvanceFilter and Pivot Table operations, you can get the necessary listings, summaries, and totals quickly.

Just follow the steps outlined in this book to build the data file, set the formulas and functions, and you will be ready to enter data. If you do not want to build the file from scratch, you can use the sample file provided with this book.

WHO WOULD BENEFIT FROM THIS BOOK?

Book-keepers, Accounts Assistants, Account Executives. Accountants and Accounting students will find this book of interest. In fact, anyone with a basic book-keeping knowledge and some familiarity with Microsoft Excel will be able to understand and use the materials presented in this book.

BONUS

For newbies, there is a beginner's guide on book-keeping at the end of the book. There is also an explanation of Excel's Pivot Table and AdvanceFilter operations.

ABOUT THE AUTHOR

The author has a Bachelor of Accounting degree and clocked up more than 18 years of experience in the accounting line and its related fields. 1 Through the years, he has continuously explored ways of using his computing knowledge to assist him in his work. In this book, he shares with readers his knowledge gained from his hands-on work.

TIMES

The companion CD contains sample data for you to try out the operations mentioned in this book and familiarize yourself with the system.

983-58-0889-9

9 789835 808890