OverDrive Content Reserve  Your Digital Marketplace
Home
Login
Application
Contact Us
About
Partners
Support
 

101 Ready-To-Use Excel Macros
Click here to see larger image.
101 Ready-To-Use Excel Macros
Creators: Michael Alexander, John Walkenbach
Publisher: Wiley
Imprint: For Dummies
Pub. date: 06/04/2012
Lib. SRP: 39.99 USD
Ret. SRP: 39.99 USD
Format: Adobe PDF eBook
ISBN: 9781118333532
DRM Level: Adobe Content Server 4
Min. Version: Adobe Digital Editions
File size: 9642 KB
Languages:
   English
Subjects:
   Computer Technology, Nonfiction
  null
Short Description:
   

Save time and be more productive with this helpful guide to Excel macros!

While most books about Excel macros offer only minor examples, usually aimed at illustrating a particular topic, this invaluable resource provides you with the tools needed to efficiently and effectively program Excel macros immediately. Step-by-step instructions show you how to create VBA macros and explain how to customize your applications to look and work exactly as you want them to. By the end of the book, you will understand how each featured macro works, be able to reuse the macros included in the book and online, and modify the macro for personal use.

  • Shows you how to solve common problems with the featured macros, even if you lack extensive programming knowledge
  • Outlines a problem that needs to be solved and provides the actual Excel macro, as well as the downloadable code, to...

    The EPUB format of this title may not be compatible for use on all handheld devices.

Full Description:
   

Save time and be more productive with this helpful guide to Excel macros!

While most books about Excel macros offer only minor examples, usually aimed at illustrating a particular topic, this invaluable resource provides you with the tools needed to efficiently and effectively program Excel macros immediately. Step-by-step instructions show you how to create VBA macros and explain how to customize your applications to look and work exactly as you want them to. By the end of the book, you will understand how each featured macro works, be able to reuse the macros included in the book and online, and modify the macro for personal use.

  • Shows you how to solve common problems with the featured macros, even if you lack extensive programming knowledge
  • Outlines a problem that needs to be solved and provides the actual Excel macro, as well as the downloadable code, to solve the problem
  • Provides an explanation of how each macro works and where to use the macro

With 101 Ready-to-Use Excel Macros, Microsoft MVP Michael Alexander helps you save time, automate tasks, and ultimately be more productive.

The EPUB format of this title may not be compatible for use on all handheld devices.

Table of Contents:
   

Introduction 1

Part I: Getting Started with Excel Macros 5

Part II: Working with Workbooks 37

Part III: Automating Worksheet Tasks with Macros 71

Part IV: Selecting and Modifying Ranges 103

Part V: Working with Data 137

Part VI: Working with PivotTables 187

Part VII: Manipulating Charts with Macros 233

Part VIII: E-Mailing from Excel 253

Part IX: Integrating Excel and Other Office Applications 273

Index 302

Creator Marketing:
  John Walkenbach     
      John Walkenbach is author of more than 50 spreadsheet books and lives in southern Arizona.
Visit his website at http://spreadsheetpage.com.
  Michael Alexander     
      Mike Alexander is a Microsoft Certified Application Developer (MCAD) and author of several books on advanced business analysis with Microsoft Access and Excel. He has more than 15 years of experience consulting and developing Office solutions. Michael has been named a Microsoft MVP for his ongoing contributions to the Excel community. In his spare time, he runs a free tutorial site, www.datapigtechnologies.com, where he shares Excel and Access tips.
Adobe PDF eBook Rights:
  Copying allowed, 10 selections every 7 days
  Printing allowed, unlimited pages every unlimited days
  Lending not allowed
  Reading aloud allowed
Geographic Rights:
   World-wide
Retailer(s):
   null
 
Copyright ©2017 -- OverDrive, Inc.
Security and Privacy Policy | Terms and Conditions of Use