Training and Certification

Rubel Khan's Blog

Book Excerpts: Microsoft Office Excel 2007 Visual Basic for Applications Step by Step

Posted by Rubel Khan on August 4, 2009

Read book excerpts from the Microsoft Press book, Microsoft Office Excel 2007 Visual Basic for Applications Step by Step.

Book CoverBuy this book

The following chapters are excerpts from Microsoft Office Excel 2007 Visual Basic for Applications Step by Step from Microsoft Press (ISBN c, copyright Microsoft Press 2008, all rights reserved).

Chapter 1: Make a Macro Do Simple Tasks

Chapter 4: Explore Range Objects

About the Book

The smart way to learn Microsoft Office Excel 2007 VBA—one step at a time!

Quickly teach yourself how to automate tasks and create custom spreadsheet solutions with Excel 2007 Visual Basic for Applications (VBA). With Step By Step, you set the pace—building and practicing the skills you need, just when you need them!

  • Create macros to automate repetitive tasks
  • Automatically format charts, shapes, and text
  • Manipulate tables and other objects—even build PivotTable reports
  • Write your own functions and procedures
  • Use loops and conditions to add decision logic to macros
  • Build custom command buttons, dialog boxes, and user formsYour all-in-one learning experience includes:
  • Files for building skills and practicing the book’s lessons
  • Fully searchable eBook
  • Windows Vista Product Guide eReference—plus other resources on CD

About the Author

Reed Jacobson is an expert in Excel and a popular author. In addition to writing about Excel Visual Basic since its inception, other authoring credits include Microsoft SQL Server™ 2005 Analysis Services STEP BY STEP, Microsoft Excel 97 STEP BY STEP, Advanced Topics, and Microsoft Office 2000 Expert Companion. He has created several training courses on Microsoft Office and Visual Basic, and is a regular presenter at SQL PASS, Tech Ed, and other Microsoft conferences and seminars. He is a senior architect for Hitachi Consulting, specializing in Business Intelligence solutions. Prior to joining Hitachi Consulting, Reed worked as a software application specialist for Hewlett Packard for 10 years and ran his own consulting firm for eight years. Reed received a BA in Japanese and Linguistics, an MBA from Brigham Young University, and he studied linguistics under a graduate fellowship at Cornell University.

Other Books by Reed Jacobson


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: