My Account
Log in Registration
All
Cart
Highlights
Fiction Books
Non-Fiction Books
Children's Books
Rare Books
Music
DVD & Blu-Ray
Video Games
Category
Wishlists
Cart
All
Free Shipping in Australia
Trustpilot
Proud to be B-Corp

Brilliant Microsoft Excel 2007 VBA & Macros Bill Jelen

Brilliant Microsoft Excel 2007 VBA & Macros By Bill Jelen

Brilliant Microsoft Excel 2007 VBA & Macros by Bill Jelen

Reviews:
$36.99
Condition - Very Good
Only 3 left
Very GoodGood

Summary

There are an estimated 400 million Excel users, very few of whom know how to use Excel VBA effectively. This book is designed to get Excel users up and running with Excel VBA. Users will quickly learn how to automate reports and design applications.

Brilliant Microsoft Excel 2007 VBA & Macros Summary

Brilliant Microsoft Excel 2007 VBA & Macros by Bill Jelen

There are an estimated 400 million Excel users, very few of whom know how to use Excel VBA effectively. This book is designed to get Excel users up and running with Excel VBA. Users will quickly learn how to automate reports and design applications. Brilliant Excel VBA & Macros explains the shortcomings of the macro recorder, but also covers how to take the recorded code and turn it into something really useful. Once the user has mastered the macro recorder, the book explains how to understand the object- oriented Visual Basic for Applications Language.

Throughout the book there are no-nonsense, step-by-step tutorials and lots of practical examples aimed directly at business users.

About Bill Jelen

Bill Jelen "Mr. Excel" is an accomplished Excel author and the principal behind the leading Excel website, MrExcel.com. As an Excel consultant, he has written Excel VBA solutions for hundreds of clients around the English-speaking world. His website hosts over 10 million page views annually. Prior to founding MrExcel.com, Jelen spent twelve years in the trenches, working as a financial analyst for finance, marketing, accounting and operations departments of a $500 million public company.

Tracy Syrstad works as an Excel and Access Consultant. As part of the Mr.Excel.com Consulting team, she has helped develop VBA solutions for clients around the world. She remembers the painful trek up the VBA learning curve while developing applications for co-workers at a former job. She is co-editor of Holy Macro!, it's "600 Excel VBA Examples CD" and editor of Dreamboat On Word.

Table of Contents

Introduction

  1. Unleash the Power of Excel with VBA
  2. This Sounds Like BASIC, So Why Doesn't It Look Familiar
  3. Referring to Ranges
  4. User-Defined Functions
  5. Looping and Flow Control
  6. R1C1-Style Formulas
  7. What's New in Excel 2007 and What's Changed
  8. Create and Manipulate Names in VBA
  9. Event Programming
  10. Userforms - An Introduction
  11. Creating Charts
  12. Data Mining with Advanced Filter
  13. Using VBA to Create Pivot Tables
  14. Excel Power
  15. Data Visualizations and Conditional Formatting
  16. Reading from and Writing to the Web
  17. XML in Excel 2007
  18. Automating Word
  19. Arrays
  20. Text File Processing
  21. Using Access as a Back End to Enhance Multi-User Access to Data
  22. Creating Classes, Records, and Collections
  23. Advanced Userform Techniques
  24. Windows Application Programming Interface (API)
  25. Handling Errors
  26. Customising the Ribbon to Run Macros
  27. Creating Add-Ins

Index

Additional information

GOR003914539
9780273714057
0273714058
Brilliant Microsoft Excel 2007 VBA & Macros by Bill Jelen
Bill Jelen
Used - Very Good
Paperback
Pearson Education Limited
2007-12-14
624
N/A
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in very good condition, but if you are not entirely satisfied please get in touch with us

Customer Reviews - Brilliant Microsoft Excel 2007 VBA & Macros