Deliver to your Kindle or other device

 
 
 

Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Sorry, this item is not available in
Image not available for
Colour:
Image not available
 

Microsoft Excel 2013 Programming: By Example with VBA, XML, and ASP [Kindle Edition]

Julitta Korol
5.0 out of 5 stars  See all reviews (1 customer review)

Print List Price: £35.00
Kindle Price: £19.25 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £15.75 (45%)
* Unlike print books, digital books are subject to VAT.

Free Kindle Reading App Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.

To get the free app, enter your e-mail address or mobile phone number.

Formats

Amazon Price New from Used from
Kindle Edition £19.25  
Paperback £35.00  
Kindle Daily Deal
Kindle Daily Deal: Up to 70% off
Each day we unveil a new book deal at a specially discounted price--for that day only. Learn more about the Kindle Daily Deal or sign up for the Kindle Daily Deal Newsletter to receive free e-mail notifications about each day's deal.

Book Description

Updated for Excel 2013 and based on the bestselling editions from previous versions, Microsoft Excel 2013 Programming by Example with VBA, XML and ASP is a practical, how-to book on Excel programming, suitable for readers already proficient with the Excel user interface (UI). If you are looking to automate Excel routine tasks, this book will progressively introduce you to programming concepts via numerous illustrated hands-on exercises. Includes companion CD with programs, 4-color figures, source code, etc. [CD files available from publisher with Amazon Order Number at info@merclearning.com] More advanced topics are demonstrated via custom projects. From recording and editing a macro and writing VBA code to working with XML documents and using Classic ASP pages to access and display data on the Web, this book takes you on a programming journey that will change the way you work with Excel. The book provides information on performing automatic operations on files, folders, and other Microsoft Office applications. It also covers proper use of event procedures, testing and debugging, and guides you through programming advanced Excel features such as PivotTables, PivotCharts, and the Ribbon interface.

FEATURES
+Contains thirty chapters loaded with illustrated "Hands-On" exercises and projects that guide you through the VBA programming language. Each example tells you exactly where to enter code and how to test it and then run it.
+Includes companion CD with programs, 4-color figures, source code, etc. [CD files available from publisher with Amazon Order Number at info@merclearning.com]
+Takes you from introductory topics--including recording and editing macros, using variables, and constants, writing subroutines/functions, conditional statements, and various methods of coding loops to repeat actions--to intermediate and advanced topics that include working with collections, class modules, arrays, file and database access, custom forms, error handling and debugging and conditional compilation.
+Includes comprehensive coverage of native file handling in VBA, Windows Scripting Host (WSH), and low level File Access.
+Demonstrates how to interact with Microsoft Access databases using both ADO and DAO to access data.
+Includes chapters on programming charts, PivotTables, dialog boxes, custom forms, the Ribbon, Backstage View, context/shortcut menu customizations, as well as proper use of event procedures and callbacks.
+Provides a practical coverage of using web queries, HTML, XML, and VBScript in Classic ASP with Excel to retrieve and publish data to the Web.


ON THE CD-ROM! [CD files available from publisher with Amazon Order Number at info@merclearning.com]
+All source code and supplemental files for the Hands-On exercises and custom projects
+All images from the text (including 4-color screenshots)

ABOUT THE AUTHOR
Since 1993, Julitta Korol (Long Island, NY) has published two dozen computer books on using and programming Microsoft Excel and Microsoft Access. In recent years she has been supporting and developing database processes and Web applications for a major New York City municipal agency. Ms. Korol has completed professional certifications by Microsoft Corporation and the Computing Technology Industry Association (CompTIA).



Product Description

Review

Julitta Korol introduces programming concepts via numerous multi-step, illustrated, hands-on exercises. More advanced topics are introduced via custom projects. From recording and editing a macro and writing VBA code to working with XML documents and using classic ASP to access and display data on the Web, this book takes you on a programming journey that will change the way you work with Excel.

Product details

  • Format: Kindle Edition
  • File Size: 30498 KB
  • Publisher: Mercury Learning and Information (2 April 2014)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • ASIN: B00JG1U5J0
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
  • Amazon Bestsellers Rank: #315,377 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?


Customer Reviews

4 star
0
3 star
0
2 star
0
1 star
0
5.0 out of 5 stars
5.0 out of 5 stars
Most Helpful Customer Reviews
5.0 out of 5 stars good book on hard to find subject on excell 20 Sept. 2014
Format:Kindle Edition|Verified Purchase
just the book i was looking for for the contents of the cd you have contact publisher with the reciept attached as proof of purchase they will send a link to download the cd contents i only a third way into the book but it was what i was looking for
Comment | 
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 5.0 out of 5 stars  3 reviews
1 of 1 people found the following review helpful
5.0 out of 5 stars The BEST Excel VBA Book I've Come Across in Many, Many Years 15 Jan. 2015
By Lynette M. Sewell - Published on Amazon.com
Format:Paperback|Verified Purchase
This book is very well written. I've been buying excel vba programming books for years. I've learned more from this book in the first 28 pages than I ever did in all the other books combined. It provides a CD of the hands-on exercises which are well written and well explained. This is the best knowledge transfer excel vba book that I have ever used. Whether you are new to excel vba programming or more advanced. The novice will feel like less than a novice by the 5th chapter. More advanced excel vba programmers can use this as a great reference (it helps refresh forgotten knowledge).
1 of 2 people found the following review helpful
5.0 out of 5 stars The book is one of the best hands-on computer software books I’ve ever bought 10 Nov. 2014
By Fred D. Wan Der - Published on Amazon.com
Format:Paperback
Excel 2013 Programming by Example by Julitta Korol is just what I needed!!! The book is one of the best hands-on computer software books I’ve ever bought!!! It is as good as a textbook and focuses on skill and knowledge transfer. The material is logically organized, understandably arranged, and backs up learning tasks with step-by-step instructions. The Table of Content is the backbone of the book’s logical and learning-friendly organization. My only disappointment is with the marketing practices of this online purchasing experience. First, free shipping was prominently displayed, only to find out that there’s a handling fee nearly as much as delivery. Second, there’s an offer to buy the book and get the kindle version for a nominal fee. This didn’t work at all. The transaction defaulted into buying both version at full price. I bought the Kindle version. I have a huge amount of respect for this online retailer, but disappointed in these kind of intentional or unintentional marketing practices. Fred Wander
0 of 3 people found the following review helpful
5.0 out of 5 stars Five Stars 2 Oct. 2014
By mariana - Published on Amazon.com
Format:Kindle Edition|Verified Purchase
Great tool!!!!
Were these reviews helpful?   Let us know
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