Excel Macros For Dummies, 3rd Edition
- Length: 336 pages
- Edition: 3
- Language: English
- Publisher: For Dummies
- Publication Date: 2022-03-22
- ISBN-10: 1119844436
- ISBN-13: 9781119844433
- Sales Rank: #0 (See Top 100 Books)
Save time and become an Excel wizard with the world’s leading Excel macro guide
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 Excel Macros For Dummies, 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!
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:
- Automations that take your Excel productivity to the next level, and beyond
- Fully updated macros compatible with the newest version of Excel included in Microsoft 365
- Careful explanations of the basics as well as tips for the advanced user
With something for everyone, Excel Macros For Dummies is the productivity supercharger you’ve been waiting for. Grab a copy today!
Title Page Copyright Page Table of Contents Introduction About This Book Foolish Assumptions Icons Used in This Book Beyond the Book Where to Go from Here Part 1 Holy Macro Batman! Chapter 1 Macro Fundamentals Choosing to Use a Macro Macro Recording Basics Examining the macro Editing the macro Testing the macro Comparing Absolute and Relative Macro Recording Recording macros with absolute references Recording macros with relative references Understanding Macro Security Macro-enabled file extensions Trusted documents Trusted locations Storing and Running Macros Storing macros in your Personal Macro Workbook Assigning a macro to a button and other form controls Placing a macro on the Quick Access Toolbar Exploring Macro Examples Building navigation buttons Dynamically rearranging PivotTable data Offering one-touch reporting options Chapter 2 Getting Cozy with the Visual Basic Editor Working in the Visual Basic Editor The VBE menu bar The VBE toolbars The Project Explorer The Code pane The Immediate window Working with the Project Explorer Adding a new VBA module Removing a VBA module Working with a Code Pane Minimizing and maximizing windows Getting VBA code into a module Customizing the VBE The Editor tab The Editor Format tab The General tab The Docking tab Chapter 3 The Anatomy of Macros A Brief Overview of the Excel Object Model Understanding objects Understanding collections Understanding properties Understanding methods A Brief Look at Variables The common variable types Understanding Event Procedures Worksheet events Workbook events Error Handling in a Nutshell On Error GoTo SomeLabel On Error Resume Next On Error GoTo Part 2 Making Short Work of Workbook Tasks Chapter 4 Working with Workbooks Installing Macros Event macros Personal Macro Workbook Standard macros Creating a New Workbook from Scratch Saving a Workbook when a Particular Cell Is Changed Saving a Workbook before Closing Protecting a Worksheet on Workbook Close Unprotecting a Worksheet Opening a Workbook to a Specific Tab Opening a Specific Workbook Defined by the User Determining Whether a Workbook Is Already Open Determining Whether a Workbook Exists in a Directory Closing All Workbooks at Once Printing All Workbooks in a Directory Preventing the Workbook from Closing Until a Cell Is Populated Creating a Backup of the Current Workbook with Today’s Date Chapter 5 Working with Worksheets Installing Macros Event macros Personal Macro Workbook Standard macros Adding and Naming a New Worksheet Deleting All but the Active Worksheet Hiding All but the Active Worksheet Unhiding All Worksheets in a Workbook Moving Worksheets Around Sorting Worksheets by Name Grouping Worksheets by Color Copying a Worksheet to a New Workbook Creating a New Workbook for Each Worksheet Printing Specified Worksheets Protecting All Worksheets Unprotecting All Worksheets Creating a Table of Contents for Your Worksheets Zooming In and Out of a Worksheet with Double-Click Highlighting the Active Row and Column Part 3 One-Touch Data Manipulation Chapter 6 Feeling at Home on the Range Installing Macros Event macros Personal Macro Workbook Standard macros Selecting and Formatting a Range Creating and Selecting Named Ranges Looping Through a Range of Cells Inserting Blank Rows in a Range Unhiding All Rows and Columns Deleting Blank Rows Deleting Blank Columns Limiting Range Movement to a Particular Area Selecting and Formatting All Formulas in a Workbook Finding and Selecting the First Blank Row or Column Chapter 7 Manipulating Data with Macros Installing Macros Event macros Personal Macro Workbook Standard macros Copying and Pasting a Range Converting All Formulas in a Range to Values Text to Columns on All Columns Converting Trailing Minus Signs Trimming Spaces from All Cells in a Range Truncating Zip Codes to the Left Five Padding Cells with Zeros Replacing Blanks Cells with a Value Appending Text to the Left or Right of Your Cells Cleaning Up Non-Printing Characters Highlighting Duplicates in a Range of Data Hiding All but Rows Containing Duplicate Data Selectively Hiding AutoFilter Drop-down Arrows Copying Filtered Rows to a New Workbook Showing Filtered Columns in the Status Bar Part 4 Macro-Charging Reports and Emails Chapter 8 Automating Common Reporting Tasks Installing Macros Event macros Personal Macro Workbook Standard macros Refreshing All PivotTables in a Workbook Creating a List of PivotTables Adjusting All Pivot Data Field Titles Setting All Data Items to Sum Applying Number Formatting for All Data Items Sorting All Fields in Alphabetical Order Applying a Custom Sort to Data Items Applying PivotTable Restrictions Applying Pivot Field Restrictions Automatically Deleting PivotTable Drill-Down Sheets Printing a PivotTable for Each Report Filter Item Creating a New Workbook for Each Report Filter Item Resizing All Charts on a Worksheet Aligning a Chart to a Specific Range Creating a Set of Disconnected Charts Printing All Charts on a Worksheet Chapter 9 Sending Emails from Excel Installing Macros Event macros Personal Macro Workbook Standard macros Mailing the Active Workbook as an Attachment Mailing a Specific Range as an Attachment Mailing a Single Sheet as an Attachment Sending Mail with a Link to Your Workbook Mailing All Email Addresses in Your Contact List Saving All Attachments to a Folder Saving Certain Attachments to a Folder Chapter 10 Wrangling External Data with Macros Working with External Data Connections Manually creating a connection Manually editing data connections Using Macros to Create Dynamic Connections Iterating through All Connections in a Workbook Using ADO and VBA to Pull External Data Understanding ADO syntax Using ADO in a macro Working with Text Files Opening a text file Reading the opened text file A practical example: Logging workbook usage in a text file A practical example: Importing a text file to a range Part 5 The Part of Tens Chapter 11 Ten Handy Visual Basic Editor Tips Applying Block Comments Copying Multiple Lines of Code at Once Jumping between Modules and Procedures Teleporting to Your Functions Staying in the Right Procedure Stepping through Your Code Stepping to a Specific Line in Your Code Stopping Your Code at a Predefined Point Seeing the Beginning and End of Variable Values Turning Off Auto Syntax Check Chapter 12 Ten Places to Turn for Macro Help Let Excel Write the Macro for You Use the VBA Help Files Pilfer Code from the Internet Leverage User Forums Visit Expert Blogs Mine YouTube for Video Training Attend Live and Online Training Classes Learn from the Microsoft Office Dev Center Dissect the Other Excel Files in your Organization Ask Your Local Excel Genius Chapter 13 Ten Ways to Speed Up Your Macros Halt Calculations Disable Screen Updating Turn Off Status Bar Updates Tell Excel to Ignore Events Hide Page Breaks Suspend PivotTable Updates Steer Clear of Copy and Paste Use the With Statement Don’t Explicitly Select Objects Avoid Excessive Trips to the Worksheet Index EULA
Donate to keep this site alive
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.