Perry G. Excel 2007. Made Easy

N.Y., etc.: McGraw-Hill, 2009. - 242 p.Welcome to Excel 2007 Macros Made Easy! This book was written for everyday Excel users, like yourself, who want to free themselves from the drudgery of repeating the same tasks over and over again. In this book, you’ll learn powerful shortcuts and time-saving methods for expediting and remembering tasks. Unlike other books in this series, it is focused on teaching you just the things you need to know to get up and running with spreadsheet macros quickly and easily. You won’t need to have a degree in programming or to set aside hours and hours for study to be able to get through the lessons in this little book and put them to work for you right away. In fact, you should be able to create your first macro in about a minute.
Inside this book, you’ll discover how to teach Excel to do repetitive tasks that take up valuable time and energy that you could spend on more productive endeavors. You’ll also learn how to protect the integrity of your data by creating macros that prevent incorrect information from being entered into your spreadsheets. Using Excel macros, you can even interact with other users, asking them to input specific data. So, get ready to jump in! It’s time to let Excel macros free you from drudgery and make your work life smoother and easier.Recording Macros
Editing Macros
Creating Macros in Visual Basic
Storing Macros
Understanding Macro Commands
Using Visual Basic Subroutines and Creating Functions
Creating Interactive Macros
Using Macros to Format Cells
Using Variables in Macros
Creating If/Then/Else Routines
Exploring Loops
Adding Controls to Your Worksheets