Details

Excel Macros For Dummies


Excel Macros For Dummies


3. Aufl.

von: Dick Kusleika

25,99 €

Verlag: Wiley
Format: EPUB
Veröffentl.: 17.02.2022
ISBN/EAN: 9781119844457
Sprache: englisch
Anzahl Seiten: 304

DRM-geschütztes eBook, Sie benötigen z.B. Adobe Digital Editions und eine Adobe ID zum Lesen.

Beschreibungen

<p><b>Save time and become an Excel wizard with the world’s leading Excel macro guide</b> <p>Do you love Excel and all the things you can do with it, but wish you could just work…faster? Excel macros—automated workflows that save you time and energy—might be just what you need. In <i>Excel Macros For Dummies</i>, you’ll learn over 70 of the most productive, time-saving macros in less time than it takes to back up the files on your computer! <p>Every chapter in the book gives you practical info and exercises you can put to work immediately, alongside step-by-step instructions and guidance on how to customize Excel to fit your every need. Inside, you’ll find: <ul> <li>Automations that take your Excel productivity to the next level, and beyond</li> <li>Fully updated macros compatible with the newest version of Excel included in Microsoft 365</li> <li>Careful explanations of the basics as well as tips for the advanced user</li> </ul> <p>With something for everyone, <i>Excel Macros For Dummies</i> is the productivity supercharger you’ve been waiting for. Grab a copy today!
<p>Introduction 1</p> <p><b>Part 1: Holy Macro Batman! 7</b></p> <p>Chapter 1: Macro Fundamentals 9</p> <p>Chapter 2: Getting Cozy with the Visual Basic Editor 29</p> <p>Chapter 3: The Anatomy of Macros 43</p> <p><b>Part 2: Making Short Work of Workbook Tasks 57</b></p> <p>Chapter 4: Working with Workbooks 59</p> <p>Chapter 5: Working with Worksheets 81</p> <p><b>Part 3: One-Touch Data Manipulation 107</b></p> <p>Chapter 6: Feeling at Home on the Range 109</p> <p>Chapter 7: Manipulating Data with Macros 129</p> <p><b>Part 4: Macro-Charging Reports and Emails 163</b></p> <p>Chapter 8: Automating Common Reporting Tasks 165</p> <p>Chapter 9: Sending Emails from Excel 199</p> <p>Chapter 10: Wrangling External Data with Macros 217</p> <p><b>Part 5: Part of Tens 235</b></p> <p>Chapter 11: Ten Handy Visual Basic Editor Tips 237</p> <p>Chapter 12: Ten Places to Turn for Macro Help 247</p> <p>Chapter 13: Ten Ways to Speed Up Your Macros 253</p> <p>Index 263</p>
<p> <b>Dick Kusleika</b> has been helping users get the most out of Microsoft Office products for more than 25 years through online forums, blogging, books, and conferences.</p>
<p><b>Make Excel<sup>®</sup> do your routine work</b></p> <p>Macros are those little snippets of wizardry that can turn your Excel files from boring old spreadsheets into do-anything super files. <i>Excel<sup>®</sup> Macros For Dummies</i> shows you how to get started. Learn how to manipulate data, automate reporting tasks, send emails directly from Excel, assign macros to buttons (fun!), and keep your macros running smoothly. Find over 70 automations you can use right away, plus step-by-step guides and go-to reference material you’ll use again and again. <p><b>Inside… <ul><li>The what and why of macros</li> <li>All about PivotTables</li> <li>Using the Visual Basic Editor</li> <li>Cleaning up messy data</li> <li>Making macros run faster</li> <li>Automating all the busywork</li> <li>Keeping macros secure</li> <li>Fixing errors in your macros</b></li></ul>

Diese Produkte könnten Sie auch interessieren:

AutoCAD 2013 For Dummies
AutoCAD 2013 For Dummies
von: Bill Fane, David Byrnes
PDF ebook
23,99 €
IBM Workplace Services Express For Dummies
IBM Workplace Services Express For Dummies
von: Stephen R. Londergan, Michael Loria
PDF ebook
16,99 €
Building Flash Web Sites For Dummies
Building Flash Web Sites For Dummies
von: Doug Sahlin
PDF ebook
18,99 €