- File Size: 7453 KB
- Print Length: 174 pages
- Simultaneous Device Usage: Unlimited
- Publisher: Abstractive Media; 2 edition (February 15, 2015)
- Publication Date: February 15, 2015
- Sold by: Amazon Digital Services LLC
- Language: English
- ASIN: B00TNYC5P2
- Text-to-Speech: Enabled
- Word Wise: Not Enabled
- Lending: Enabled
- Amazon Best Sellers Rank: #299,448 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
Introduction To Manipulating Data Programmatically In Microsoft Excel With VBA Kindle Edition
Kindle Feature Spotlight
Try Kindle Countdown Deals
Explore limited-time discounted eBooks. Learn more.
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Customers who bought this item also bought
Would you like to tell us about a lower price?
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
Microsoft Excel is arguably the most used computer application program in the corporate world. People use it all the time. Some of the spreadsheet work need to be done routinely.
The book is about writing scripts (called Visual Basic for Applications, or VBA) in Excel so that repetitive tasks can be automated. The author take you through particular example of importing a large list of movie titles and walk you through creating multiple tabs based on movie genre, then create a summary tab and then add a pie chart to the sheet, all with VBA.
The book is written for Excel 2013. However, I have found Excel 2007 version will also work for most part of the book.
The book's approach is to explain the coding workflow, rather than describing each VBA commands in bits and pieces. This works for me. The code starts small, then additional functionality will be added little by little with full explanation of the code.
The movie list example (and solutions) turned out to be very relevant to my actual work. I can easily relate to a couple of excel reports that I get from other department monthly. Sales report from Finance department can be custom tailored with each product. Our Engineering work hour reports can be custom tailored with chart showing actual hours spent on each projects. Pulling expense for particular combination of project code and G/L code from megabyte of raw data dump now seems a trivial task.
I think it is important to note that the author explains early in the book how to save your code in its own .xlam file so that it can be applied to data you receive in coming months.
The book expanded my knowledge of VBA further. I thought I was OK with VBA before. Now I want to use it more.
One last note. The author talks about bonus contents that will be available in his site. That bonus contents are now included in the second release of the book.
In general, the example given might be found with a pivot table, and a pivot chart. But one will soon learn that with a little bit of programming, data manipulation and calculations are powerfully executed in VBA. This will undoubtably make the reader interested in other ways that VBA can be used.