Book Cover

Excel and Excel VBA Programming
for Beginners
Second Edition - for Office 2013

David Rossiter and Gibson Lam

ISBN 978-1-259-07081-5
Copyright 2013

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. Making Decisions and Loops

Chapter 6. Functions, Events and GUI Handling

Chapter 7. Sorting & Filtering in VBA

Chapter 9. Object Oriented Programming

Chapter 10. Recursion

Chapter 11. Arrays

Chapter 13. Exercises

Book Exercise Videos

Sound Sequences for Exercise 4

Book Improvements

Page Section Description
pg. 224 Chapter 10.2 In the review question 2, the code End With in the middle of the DrawCircle function should not be there and should be removed. That part of the code thus should look like this:
Set CircleObj = ActiveSheet.Shapes.AddShape( _
                msoShapeOval, Left, Top, Width, Height) ' Add circle
CircleObj.Line.Visible = msoTrue ' We want border
CircleObj.Fill.Visible = msoFalse ' Don't fill

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 2. Useful Excel Tools

Chapter 3. Getting Started with Excel VBA

Chapter 5. Making Decisions and Loops

Chapter 6. Functions, Events and GUI Handling

Chapter 7. Sorting & Filtering in VBA

Chapter 8. Using Cell Functions in VBA

Chapter 9. Object Oriented Programming

Chapter 10. Recursion

Chapter 11. Arrays