Close
Enter your search into one or more of the boxes below:
You can refine your search by selecting from any of the options below:
Search
Excel VBA 24-Hour Trainer
Foyalty 79
Excel VBA 24-Hour Trainer (Paperback)
Order now for Free delivery in the UK for orders over £10 or choose Express Delivery to receive in 2 business days. More on delivery...
Order Options
List Price
Online Price
Save
Availability
Delivery:

To home, business or free to our stores. Click for more info.

List Price: £26.99
Online Price: £19.70
Save: 27%
Availibility: Despatched in 2 business days.
Click & Collect:

Order now to collect from 5pm today. In stock items only. Click for more info.

List Price: £26.99
Online Price: £24.29
Save: 10%
Availibility: In stock in 1 or more stores.

Product Synopsis

Increase your productivity and save time and effort with Excel VBA This unique book-and-DVD package prepares you to get more out of Excel by using Visual Basic for Applications (VBA) to automate your routine or labor-intensive Excel tasks. Microsoft Excel MVP and author Tom Urtis walks through a series of lessons while the accompanying DVD provides demos to complement each lesson. Urtis takes an in-depth look at how manual tasks in Excel can be programmed with VBA for greater speed, efficiency, and accuracy. You'll learn how to use VBA to manipulate Excel in ways you may never have thought possible.

Excel VBA 24-Hour Trainer: Introduces you to VBA and discusses topics including object oriented programming, variable declaration, objects and collections, and arrays Teaches you how to write your own macros for programming loops, events, charts, pivot tables and pivot charts, and user-defined functions Shows you how to customize the look and feel of Excel with User Forms, Input Boxes, Message Boxes, and embedded controls Examines advanced topics including class modules, add-ins, and retrieving external data with ADO and SQL Demonstrates how to interact with other Office Applications from Excel, including Word, Access(r), PowerPoint(r), and Outlook(r) Wrox guides are crafted to make learning programming languages and technologies easier than you think. Written by programmers for programmers, they provide a structured, tutorial format that will guide you through all the techniques involved. On the DVD Don't just learn--do! The lessons within the book are accompanied by an instructional demonstration on the DVD.

Write your own macros Make decisions with VBA Repeat actions with loops Automate procedures with worksheet and workbook events Work with arrays Create class modules Program charts and pivot tables Create add-ins Interact with Office applications Word, Access, PowerPoint, and Outlook Manage external data Debug your code Note: As part of the print version of this title, video lessons are included on DVD. For e-book versions, video lessons can be accessed at wrox.com using a link provided in the interior of the e-book.

Computing & ITBusiness applicationsEnterprise softwareSAP Systems, applications & products in databasesComputing & ITBusiness applicationsMathematical & statistical softwareComputing & ITBusiness applicationsSpreadsheet softwareExcel Publisher: John Wiley & Sons Inc Publication Date: 03/05/2011 ISBN-13: 9780470890691  Details: Type: Paperback Format: Books
Availability: Despatched in 2 business days. Login for Quick Checkout Add to Basket

More books by Tom Urtis

Leave Review

Delivery

Please note for the New & Used Marketplace different terms and conditions apply.

Delivery Options

All delivery times quoted are the average, and cannot be guaranteed. These should be added to the availability message time, to determine when the goods will arrive. During checkout we will give you a cumulative estimated date for delivery.

Location1st BookEach additional bookAverage Delivery Time
UK Second ClassAvailable free for orders over £10* or £2.50Available free for orders over £10* or £1.003-7 Days
UK First Class£4.50£1.001-2 Days
UK Courier£7.00£1.001-2 Days
Western Europe** Courier£17.00£3.002-3 Days
Western Europe** Airmail£5.00£1.504-14 Days
USA / Canada Courier£20.00£3.002-4 Days
USA / Canada Airmail£7.00£3.004-14 Days
Rest of World Courier£22.50£3.003-6 Days
Rest of World Airmail£8.00£3.007-21 Days

* Available free for orders over £10 = When offered a delivery preference choose 'For Cheapest Postage' for our freepost in the UK offer. This is not available on the 'For Faster Delivery' option.

** Includes Austria, Belgium, Denmark, France, Germany, Greece, Iceland, Irish Republic, Italy, Luxembourg, Netherlands, Portugal, Spain, Sweden and Switzerland.

Delivery Help & FAQs

Returns Information

If you are not completely satisfied with your purchase*, you may return it to us in its original condition with in 30 days of receiving your delivery or collection notification email for a refund. Except for damaged items or delivery issues the cost of return postage is borne by the buyer. Your statutory rights are not affected.

* For Exclusions and terms on damaged or delivery issues see Returns Help & FAQs

You might also like

ECDL Advanced Syllabus 2.0 Module AM4...
(Spiral spine)
CiA Training Ltd.
 
£17.50
£14.88
15%
ECDL Advanced Syllabus 2.0 Module AM4...
(Spiral spine)
CiA Training Ltd.
 
£17.50
£14.88
15%
ECDL Syllabus 5.0 Module 4...
(Spiral spine)
CiA Training Ltd.
 
£13.50
£11.48
15%
Latest Blog
The best fiction of 2014
15/12/2014

Many at Foyles feel that 2014 been a very good year for fiction and our customers seem to agree, with big leaps in sales in all our branches. Our web editor, Jonathan Ruppin, looks at why this might be, selects his top titles and explains why Dutch novelist Peter Buwalda's Bonita Avenue is his book of the year.

Making failure into an art
09/12/2014

You've probably heard of the writer Franz Kafka; but what about Hans Kafka? No? Well, there's a reason for that...

The noir prophet returns
01/12/2014

George Hamilton-Jones, from our Charing Cross Road shop, celebrates the return of William Gibson with The Peripheral, which should delight fans of his early futuristic works, such as Neuromancer.

View all Blog Entries
Twitter
Show/Hide Tweets
© W&G Foyle Ltd