Excel Macros For Dummies

ISBN-13: 9781119844433 / Angielski / Miękka / 2022 / 304 str.

Michael Alexander

Spis treści

Introduction 1Part 1: Holy Macro Batman! 7Chapter 1: Macro Fundamentals 9Chapter 2: Getting Cozy with the Visual Basic Editor 29Chapter 3: The Anatomy of Macros 43Part 2: Making Short Work of Workbook Tasks 57Chapter 4: Working with Workbooks 59Chapter 5: Working with Worksheets 81Part 3: One-Touch Data Manipulation 107Chapter 6: Feeling at Home on the Range 109Chapter 7: Manipulating Data with Macros 129Part 4: Macro-Charging Reports and Emails 163Chapter 8: Automating Common Reporting Tasks 165Chapter 9: Sending Emails from Excel 199Chapter 10: Wrangling External Data with Macros 217Part 5: Part of Tens 235Chapter 11: Ten Handy Visual Basic Editor Tips 237Chapter 12: Ten Places to Turn for Macro Help 247Chapter 13: Ten Ways to Speed Up Your Macros 253Index 263

O autorze

Dick Kusleika has been helping users get the most out of Microsoft Office products for more than 25 years through online forums, blogging, books, and conferences.