Buy New

or
Sign in to turn on 1-Click ordering.
Buy Used
Used - Good See details
Price: 14.42

or
 
   
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Colour:
Image not available

 
Tell the Publisher!
Id like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Brilliant Microsoft Excel 2007 VBA and Macros (Brilliant Excel Solutions) [Paperback]

Mr Bill Jelen
2.5 out of 5 stars  See all reviews (2 customer reviews)
RRP: 28.99
Price: 24.94 & FREE Delivery in the UK. Details
You Save: 4.05 (14%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 1 left in stock (more on the way).
Dispatched from and sold by Amazon. Gift-wrap available.
Want it tomorrow, 24 Aug.? Choose Express delivery at checkout. Details

Book Description

14 Dec 2007 Brilliant Excel Solutions

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.


Customers Who Viewed This Item Also Viewed


Product details

  • Paperback: 624 pages
  • Publisher: Prentice Hall; 1 edition (14 Dec 2007)
  • Language: English
  • ISBN-10: 0273714058
  • ISBN-13: 978-0273714057
  • Product Dimensions: 23.2 x 18.2 x 3.6 cm
  • Average Customer Review: 2.5 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon Bestsellers Rank: 639,581 in Books (See Top 100 in Books)
  • See Complete Table of Contents

More About the Author

Discover books, learn about writers, and more.

Product Description

From the Back Cover

Brilliant Excel 2007 VBA & Macros

What you need to know and how to do it

Excel is one of the most powerful office and business productivity tools available – but do you know how to harness its full potential? Do you want to get a better understanding of its full capabilities and potential, and develop the Excel skills that you need to produce solutions to all of your business needs? Brilliant Excel VBA & Macros will deliver increased office productivity and improved results by unleashing your inner Excel expert ! This book is for the savvy Excel user who wants to understand and then use the advanced features of Excel but doesn’t want to dedicate their life to it

Develop your Excel expertise instantly with proven techniques

If you are a regular user of Excel, this book will dramatically increase your productivity and efficiency in producing the reports that you need in a timely manner. If you need to use Excel on a daily basis, importing raw data and performing time-consuming manipulations using Excel's power tools, then this book will teach you how to automate these processes, dramatically saving hours of time.

There are many experienced Excel users, but very few have figured out how to effectively use Excel VBA. Many users are frustrated when they record their own macros with the macro recorder, only to discover that the macros won't work correctly the next day. This book is designed to get you up  and running with Excel VBA, and explains the shortcomings of the macro recorder, but also covers how to take the recorded code and turn it into something really useful. Once you are over that hurdle, the book explains how to understand the object-oriented Visual Basic for Applications Language.
After teaching you those fundamentals, the book then goes on to describe everything you could conceivably need to know to automate reports and design applications in Excel VBA.

Even if you've never programmed before, this book will take you up the learning curve and enable you to automate common tasks in Microsoft Excel. Whether you want to automate reports for your office or design full-blown applications for others, this book will solve all of your problems and save you a huge amount of time and frustration.

Brilliant Excel 2007 VBA & Macros will show you how to ….

  • Understand why the macro recorder doesn’t work!
  • Convert recorded code into something useful
  • Understand VBA syntax from easy-to-understand English explanations
  • Automate Excel’s power tools- Pivot Tables, Charts, Advanced Filters
  • Save hours per week by automating redundant tasks
  • Dramatically increase your efficiency with Excel

About the Authors

Bill Jelen is MrExcel, as well as an Excel MVP. He 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.

Tracy Syrstad works as an Excel and Access Consultant. As part of the MrExcel.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.

Visit us on the web at

www.pearson-books.com

 

 

About the Author

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.


Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

What Other Items Do Customers Buy After Viewing This Item?


Customer Reviews

5 star
0
3 star
0
2 star
0
2.5 out of 5 stars
2.5 out of 5 stars
Most Helpful Customer Reviews
1 of 1 people found the following review helpful
4.0 out of 5 stars Excel VB 30 April 2009
Format:Paperback
This is by far the best reference book I have ever used. The language is simple to understand and the authors are very good at showing practical uses for the code they teach.
Comment | 
Was this review helpful to you?
1 of 2 people found the following review helpful
1.0 out of 5 stars I feel cheated 14 Jan 2010
Format:Paperback|Verified Purchase
I bought this book based on my experience with BRILIANT EXCEL 2007 by Steve Johnson. You would think with BRILLIANT in the title you would be looking at a joined up series of similar books - none of it - where BRILLIANT Excel 2007 was colourful, well laid out and easy to follow and provided you with line by line training - this is just A N OTHER Excel book Boring Black and White and the usual boring style of preaching not teaching trading on someone else's success. Given a choice I would have my money back no matter how "reasonable" people think it is. These are just Mr Excel Books re-badged with the BRILLIANT name. They don't even hide the fact [once you have bought them] as the down-loads for some of them are on Mr Excel Site. Honestly if they were that good in the first place why sell them under a pseudonym - shame on you .
Comment | 
Was this review helpful to you?
Search Customer Reviews
Only search this product's reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category


Feedback