Articles liés à Excel Macros & VBA For Business Users - A Beginners...

Excel Macros & VBA For Business Users - A Beginners Guide - Couverture souple

Benton, C.J.

 
9781530946549: Excel Macros & VBA For Business Users - A Beginners Guide
Couverture souple
ISBN 10 : 1530946549 ISBN 13 : 9781530946549
Editeur : CreateSpace Independent Publishing Platform, 2016

Synopsis

An Excel® Macros and VBA book developed for business users!

Readers will be able to refer back to this book time and time again. Written with little technical jargon and divided into five easy to follow segments. Business users of all types will learn how to automate tasks, improve productivity, and reduce the occurrence of errors in standardized processes.

The book begins by providing a foundation on how Macros & VBA (Visual Basic for Applications) work, followed by step-by-step examples on recording and troubleshooting macros. Continuing with how to enhance your code with Looping and Decision Structures. From the easy to the more complex, this book has something to offer all business users.

Macro Fundamentals

  • How to record a macro
  • How to modify and test macros
  • How to utilize the Personal Macro Workbook
  • How to use the debugging tools

    Macro Examples Include

  • Report formatting
  • Data analysis - Analyzing test results
  • Importing and parsing text and .CSV files
  • Macro to save each worksheet as a separate workbook file
  • Macros to sort worksheets either alphabetically or numerically
  • Printing all worksheets in a workbook
  • Dynamic Quarterly and Year-To-Date reporting

    Intermediate Topics

  • An introduction to Looping with easy to follow examples
  • How to incorporate If...Then...Else statements
  • How to incorporate Select...Case statements
  • Protecting macro code

    Imagine the time you'll save by not having to search the internet or help files to learn the most practical ways of using one of Microsoft® Excel’s® best features.

    • Les informations fournies dans la section « Synopsis » peuvent faire référence à une autre édition de ce titre.

    Présentation de l'éditeur

    An Excel® Macros and VBA book developed for business users!

    Readers will be able to refer back to this book time and time again. Written with little technical jargon and divided into five easy to follow segments. Business users of all types will learn how to automate tasks, improve productivity, and reduce the occurrence of errors in standardized processes.

    The book begins by providing a foundation on how Macros & VBA (Visual Basic for Applications) work, followed by step-by-step examples on recording and troubleshooting macros. Continuing with how to enhance your code with Looping and Decision Structures. From the easy to the more complex, this book has something to offer all business users.

    Macro Fundamentals

  • How to record a macro
  • How to modify and test macros
  • How to utilize the Personal Macro Workbook
  • How to use the debugging tools

    Macro Examples Include

  • Report formatting
  • Data analysis - Analyzing test results
  • Importing and parsing text and .CSV files
  • Macro to save each worksheet as a separate workbook file
  • Macros to sort worksheets either alphabetically or numerically
  • Printing all worksheets in a workbook
  • Dynamic Quarterly and Year-To-Date reporting

    Intermediate Topics

  • An introduction to Looping with easy to follow examples
  • How to incorporate If...Then...Else statements
  • How to incorporate Select...Case statements
  • Protecting macro code

    Imagine the time you'll save by not having to search the internet or help files to learn the most practical ways of using one of Microsoft® Excel’s® best features.

    • Les informations fournies dans la section « A propos du livre » peuvent faire référence à une autre édition de ce titre.

    Éditeur
    CreateSpace Independent Publishing Platform
    Date d'édition
    2016
    Langue
    anglais
    ISBN 10 
    1530946549
    ISBN 13 
    9781530946549
    Reliure
    Broché
    Nombre de pages
    168
    Coordonnées du fabricant
    Manufactured by Amazon on behalf of the author
    https://www.amazon.fr/hz/contact-us

    c/o Amazon Media EU S.à.r.l., 38 Avenue John F. Kennedy
    Luxembourg
    L-1855
    Luxembourg