Cantitate/Preț
Produs

Excel Macros For Dummies

De (autor)
Notă GoodReads:
en Limba Engleză Carte Paperback – 14 Jul 2015
Learn to:
  • Save time, automate, and be more productive with Excel macros
  • Immediately implement and use over 70 Excel macros
  • Understand how each macro works and how to customize it
  • Reuse the macros in other workbooks or with other macros
Maximize these ready–made Excel macros to make your workflow smarter and faster
Macros automate aspects of Excel so you can streamline your workflow and minimize errors. Even if you′re not a VBA guru and don′t have time to become one, take heart! This book includes some of the most commonly used Excel macros and shows you exactly how to put them to work solving problems you encounter on the job.
  • Macros 101 get an overview of macro fundamentals, meet VBA and Visual Basic Editor, and learn how macros are constructed
  • Workbook workshop explore macros that can automate a series of tasks from creating workbooks and backing them up to printing all worksheets at once
  • Navigation and manipulation discover macros that work together to help you navigate your spreadsheets and manipulate, scrub, and shape data
  • Macro report magic find macros to help you automate pivot table and chart tasks and automatically email reports as attachments
Visit the companion website at www.dummies.com/extras/excelmacros to download the sample files for each macro in the book. These enable you to see the macro at work and to copy and paste the code.
Open the book and find:
  • Macro solutions for many Excel tasks
  • An overview of VBA basics
  • Ways to customize macros for your needs
  • Tips for streamlining your workflow
  • Troubleshooting advice
  • Methods for automating reports
  • Visual Basic Editor tricks
  • Where to get help with your macros
Citește tot Restrânge

Preț: 9496 lei

Preț vechi: 11870 lei
-20%

Puncte Express: 142

Preț estimativ în valută:
1937 $ 1698£

Cartea nu se mai tipărește

Doresc să fiu notificat când acest titlu va fi disponibil:

Preluare comenzi: 021 569.72.76

Specificații

ISBN-13: 9781119089346
ISBN-10: 1119089344
Pagini: 288
Ilustrații: illustrations
Dimensiuni: 188 x 235 x 14 mm
Greutate: 0.36 kg
Editura: Wiley
Locul publicării: Hoboken, United States

Public țintă

This book is for any professional whose daily operations foster a data intensive environment. Some examples are: Sales Managers, Operations Analysts, Administrative Assistants, Office Managers, Government Employees, Manufacturing Managers, Engineers, and Scientists.
 

Textul de pe ultima copertă

Learn to:
  • Save time, automate, and be more productive with Excel macros
  • Immediately implement and use over 70 Excel macros
  • Understand how each macro works and how to customize it
  • Reuse the macros in other workbooks or with other macros
Maximize these ready–made Excel macros to make your workflow smarter and faster
Macros automate aspects of Excel so you can streamline your workflow and minimize errors. Even if you′re not a VBA guru and don′t have time to become one, take heart! This book includes some of the most commonly used Excel macros and shows you exactly how to put them to work solving problems you encounter on the job.
  • Macros 101 get an overview of macro fundamentals, meet VBA and Visual Basic Editor, and learn how macros are constructed
  • Workbook workshop explore macros that can automate a series of tasks from creating workbooks and backing them up to printing all worksheets at once
  • Navigation and manipulation discover macros that work together to help you navigate your spreadsheets and manipulate, scrub, and shape data
  • Macro report magic find macros to help you automate pivot table and chart tasks and automatically email reports as attachments
Visit the companion website at www.dummies.com/extras/excelmacros to download the sample files for each macro in the book. These enable you to see the macro at work and to copy and paste the code.
Open the book and find:
  • Macro solutions for many Excel tasks
  • An overview of VBA basics
  • Ways to customize macros for your needs
  • Tips for streamlining your workflow
  • Troubleshooting advice
  • Methods for automating reports
  • Visual Basic Editor tricks
  • Where to get help with your macros

Cuprins

Introduction 1
Part I: Holy Macro Batman! 7
Chapter 1: Macro Fundamentals 9
Chapter 2: Getting Cozy with Visual Basic Editor 29
Chapter 3: The Anatomy of Macros 43
Part II: Making Short Work of Workbook Tasks 57
Chapter 4: Working with Workbooks 59
Chapter 5: Working with Worksheets 85
Part III: One ]Touch Data Manipulation 113
Chapter 6: Feeling at Home on the Range 115
Chapter 7: Manipulating Data with Macros 137
Part IV: Macro ]Charging Reports and Emails 173
Chapter 8: Automating Common Reporting Tasks 175
Chapter 9: Sending Emails from Excel 213
Part V: The Part of Tens 229
Chapter 10: Ten Handy Visual Basic Editor Tips 231
Chapter 11: Ten Places to Turn for Macro Help 239
Chapter 12: Ten Ways to Speed Up Your Macros 245
Index 255

Notă biografică

Michael Alexander is a Microsoft Certified Application Developer and a Microsoft MVP. He has written numerous books on advanced business analysis with Microsoft Access and Excel. His tutorial website, www.datapigtechnologies.com, provides tips on Excel and Access for the Microsoft Office community.