Book Cover

Excel and
Excel VBA Programming
for Beginners

David Rossiter and Gibson Lam

ISBN 978-1-259-01233-4
Copyright 2012

Overview of the Book

This book is designed to help you learn the Microsoft Excel program. After completing this book you should be quite confident in handling a large range of different tasks using Excel. This book takes a very practical approach, with more than 80 examples to help illustrate the concepts and techniques explained. At the end of most chapters there are review questions which you can use to test yourself. In addition, there are four exercises which help you develop interesting projects based on the techniques discussed.

All of the book examples and other supporting material can be accessed below.

Where to Find the Book

You can find the book in the HKUST book shop.

Contents of the Rest of the Page

Book Examples

You can click on the '+' button to show the examples of a particular chapter.

Chapter 1. Introduction to Excel

Chapter 2. Useful Excel Tools

Chapter 3. Getting Started with Excel VBA

Chapter 4. VBA Errors, And What To Do About Them

Chapter 5. Loops and More

Chapter 6. Functions, Events and GUI Handling

Chapter 7. Sorting & Filtering in VBA

Chapter 8. Object Oriented Programming

Chapter 9. Recursion

Chapter 10. Arrays

Chapter 12. Exercises

Book Exercise Videos

Sound Sequences for Exercise 4

Book Improvements

Page Section Description
pg. 19 Chapter 1.4 In the table near the bottom of the page, the last row ">= larger than or equal to" does not belong to this table and should be removed.
pg. 20 Chapter 1.4 In the table at the bottom of the page, the description of the MIN function says "for find the minimum in a group of numbers". It should be "for finding the minimum in a group of numbers".
pg. 28 Chapter 1.5 In the example formula near the bottom of the page there is an extra exclamation mark near the end. It should be "I have enough money to buy chocolate! Yea!" instead of "I have enough money to buy chocolate! Yea!!"
pg. 39 Chapter 1.7 In last bullet point in the middle of the page, the given example =sqrt(-16) does not result in a #VALUE! error. The #VALUE! error will be given by, for example, ="3"/2 because "3" is a string. Or, if cell B1 contains a piece of text, the formula =B1+10 will also result in the #VALUE! error.
pg. 143 Chapter 6.1 The second sentence in the second paragraph says "For example, MsgBox() and InStr() are two functions you have seen before." However, at this stage we haven't looked at InStr(), so the text should read "For example, MsgBox() is a function you have seen before."
pg. 185 Chapter 8.1 The comments in the code of the review question say "we create four people". However, there are only three people instances in the code.

Answers of Review Questions

You can click on the '+' button to show the review question answers of a particular chapter.

Chapter 1. Introduction to Excel

Chapter 3. Getting Started with Excel VBA

Chapter 5. Loops and More

Chapter 6. Functions, Events and GUI Handling

Chapter 7. Sorting & Filtering in VBA

Chapter 8. Object Oriented Programming

Chapter 9. Recursion

Chapter 10. Arrays