Login

Urtis, Tom

Excel VBA 24-Hour Trainer

Urtis, Tom - Excel VBA 24-Hour Trainer, ebook

39,70€

Ebook, ePUB with Adobe DRM
ISBN: 9781118087602
DRM Restrictions

Printing130 pages with an additional page accrued every 6 hours, capped at 130 pages
Copy to clipboard5 excerpts

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®, PowerPoint®, and Outlook®

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.

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.

Keywords: Office Productivity - Microsoft (General & Office suite), Excel and VBA, Excel and Visual Basic for Applications, guide to using Excel VBA, creating macros in Excel, what VBA instructions, instructions on VBA, VBA instructional dvd, VBA dvd, programming with VBA, automating Excel tasks, book-and-DVD on Excel and VBA, how to use VBA, VBA for Excel demonstrations, demonstrations on VBA, book on Excel and VBA, book on Excel and Visual Basic for Applications, how to use VBA for Excel

Author(s)
Publisher
John Wiley and Sons, Inc.
Publication year
2011
Language
en
Edition
1
Page amount
432 pages
Category
Information Technology, Telecommunications
Format
Ebook
eISBN (ePUB)
9781118087602

Similar titles