Excel 2007 Macros Made Easy

Gail Perry

ISBN 10: 0071599584 / ISBN 13: 9780071599580

Verlag: Mcgraw Hill LLC Nov 2008, 2008

Beschreibung

Neuware - Get beyond the basics with Excel 2007 macrosHere is the perfect solution for the spreadsheet user who wants to learn powerful shortcuts and time-saving methods for expediting and remembering tasks. This inexpensive guide explains how to use Excel macros to simplify repetitive tasks, store the instructions for complicated tasks, and make standard commands available to other users. You will create your first macro in just one minute and learn to produce interactive macros that ask the user for input and add macros to the Excel toolbar.

Bestandsnummer des Verkäufers 9780071599580

Bibliografische Details

• Titel: Excel 2007 Macros Made Easy
• Verlag: Mcgraw Hill LLC Nov 2008
• Erscheinungsjahr: 2008
• Sprache: Englisch
• ISBN-10: 0071599584
• ISBN-13: 9780071599580
• Einband: Taschenbuch
• Zustand: Neu

Über diesen Titel

Inhaltsangabe

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality,  authenticity, or access to any online entitlements included with the product.

Get beyond the basics with Excel 2007 macros

Now you can take your Excel skills to the next level with help from this hands-on guide. Excel 2007 Macros Made Easy shows you how to create, run, and revise macros to simplify repetitive tasks and store the instructions for complicated ones. You'll learn to use Visual Basic for Applications (VBA), add macros to the Excel toolbar, and share your macros with other users. Discover how easy it is to develop custom macros, save time, and boost productivity.

• Record and edit macros
  
• Create and debug macros in VBA
  
• Save macros to the Personal Macro Workbook or other workbooks
  
• Create VBA subroutines and functions
  
• Develop interactive macros
  
• Format cells using macros
  
• Create variables and arrays
  
• Apply logic to macros with If/Then/Else routines
  
• Use loops to process data
  
• Add controls to your worksheets
  

 

Über die Autorin bzw. den Autor

Gail Perry (Indianapolis, IN) is a CPA, author and software trainer from Indianapolis, IN. She has been editing the TurboTax product documentation for Intuit for the past several years. In addition, she's written several books on Excel, including Excel Answers 2000! for Osborne.