EXCEL

/Excel 101 - Sample Files/

Macro 64 Create A PivotTable Inventory Summary.xlsm

Macro 63 Refresh All Pivot Tables Workbook.xlsm

Macro 65 Make All Pivot Tables use the Same Pivot Cache.xlsm

Macro 69 Apply Number Formatting for All Data Items.xlsm

Macro 72 Apply Pivot Table Restrictions.xlsm

Macro 62 Create a Backwards Compatible PivotTable.xlsm

Macro 66 Hide All Subtotals in a Pivot Table.xlsm

Macro 73 Apply Pivot Field Restrictions.xlsm

Macro 75 Print Pivot Table for Each Report Filter.xlsm

Macro 71 Apply Custom Sort to Data Items.xlsm

Macro 70 Sort All Fields in Alphabetical Order.xlsm

Macro 67 Adjust All Pivot Data Field Titles.xlsm

Macro 68 Set All Data Items to Sums.xlsm

Macro 74 Automatically Delete Pivot Table Drilldown Sheets.xlsm

Macro 76 Create New Workbook Fore Each Report Filter.xlsm

Macro 101 Convert a Workbook into a PowerPoint Presentation.xlsm

Macro 77 Transpose Entire Data Range With a PivotTable.xlsm

Macro 100 Sending All Excel Charts to a PowerPoint Presentation.xlsm

Macro 99 Sending Excel Data to a PowerPoint Presentation.xlsm

Macro 80 Create a Set of Disconnected Charts.xlsm

Macro 79 Align Chart to a Specific Range.xlsm

Macro 20 Moving Worksheets Around.xlsm

Macro 78 Resize All Charts on a Worksheet.xlsm

Macro 81 Print All Charts on a Worksheet.xlsm

Macro 28 Create a Table of Contents for your Worksheets.xlsm

Macro 22 Group Worksheets by Color.xlsm

Macro 60 Create New Sheet for Each Item in an AutoFilter.xlsm

Macro 98 Simulating Mail Merge with a Word Document.xlsm

Macro 82 Automatically Label First and Last Chart Points.xlsm

Macro 21 Sort Worksheets by Name.xlsm

Macro 39 Select and Format all Formulas in a Workbook.xlsm

Macro 54 Create a Super Data Cleanup Macro.xlsm

Macro 24 Create a New Workbook for Each Worksheet.xlsm

Macro 18 Hide all but the Active Worksheet.xlsm

Macro 17 Delete all but the Active Worksheet.xlsm

Macro 83 Color Chart Series to Match Source Cell Colors.xlsm

Macro 40 Find and Select the First Blank Row or Column.xlsm

Macro 87 Mailing a Single Sheet as an Attachment.xlsm

Macro 52 Replace Blanks Cells with a Value.xlsm

Macro 48 Convert Trailing Minus Signs.xlsm

Macro 46 Convert All Formulas in a Range to Values.xlsm

Macro 59 Copy Filtered Rows to a New Workbook.xlsm

Macro 27 Unprotect all Worksheets.xlsm

Macro 25 Print Specified Worksheets.xlsm

Macro 57 Hide all but Duplicate Rows.xlsm

Macro 97 Sending Excel Data to a Word Document.xlsm

Macro 56 Highlight Duplicates in a Range of Data.xlsm

Macro 47 Perform Text to Columns on all Columns.xlsm

Macro 41 Apply Color Banding on Double-Click.xlsm

Macro 84 Color Chart Data Points to Match Source Cell Colors.xlsm

Macro 8 Determine if a Workbook is Already Open.xlsm

Macro 49 Trim Spaces from all Cells.xlsm

Macro 53 Append Text to the Left or Right of your Cells.xlsm

Macro 51 Padding Cells with Zeros.xlsm

Macro 50 Truncate Postal Codes to the Left Five.xlsm

Macro 89 Mailing All Email Addresses in Your Contact List.xlsm

Macro 45 Copy and Paste a Range.xlsm

Macro 38 Deleting Blank Columns.xlsm

Macro 37 Deleting Blank Rows.xlsm

Macro 35 Inserting Blank Rows in a Range.xlsm

Macro 91 Saving Certain Attachments to a Folder.xlsm

Macro 23 Copy a Worksheet to a new Workbook.xlsm

Macro 58 Selectively Hide AutoFilter Dropdowns.xlsm

Macro 90 Saving All Attachments to a Folder.xlsm

Macro 36 Unhide All Rows and Columns.xlsm

Macro 55 Clean up Non-Printing Characters.xlsm

Macro 33 Enumerating Through a Range of Cells.xlsm

Macro 34 Select and Format all Named Ranges.xlsm

Macro 44 Dynamically Set the Print Area of a Worksheet.xlsm

Macro 30 Highlight the Active Row and Column.xlsm

Macro 19 Unhide all Worksheets in a Workbook.xlsm

Macro 31 Selecting and Formatting a Range.xlsm

Macro 61 Show Filtered Columns in Status Bar.xlsm

Macro 86 Mailing a Specific Range as Attachment.xlsm

Macro 88 Send Mail with a link to Your Workbook.xlsm

PasteTable.docx

Macro 42 Sort a Range on Double-Click.xlsm

Macro 26 Protect all Worksheets.xlsm

Macro 43 Limit Range Movement to a Particular Area.xlsm

Macro 29 Zooming in and Out of a Worksheet with Double-Click.xlsm

Macro 1 Creating a New Workbook From Scratch.xlsm

Macro 7 Opening a Specific Workbook Defined by the User.xlsm

Macro 85 Mailing the Active Workbook as Attachment.xlsm

Macro 32 Creating and Selecting a Named Range.xlsm

Macro 6 Open a Workbook to a Specific Tab.xlsm

Macro 96 Compacting an Access Database from Excel.xlsm

Macro 93 Running an Access Macro from Excel.xlsm

MailMerge.docx

Macro 2 Saving a Workbook when a Particular Cell is changed.xlsm

Macro 14 Preventing the Workbook from Closing until a Cell is Populated.xlsm

Macro 9 Determine if a Workbook Exists in a Directory.xlsm

Macro 12 Open all Workbooks in a Directory.xlsm

Macro 15 Create a Backup of Current Workbook with Todays Date.xlsm

Macro 16 Adding and Naming a New Worksheet.xlsm

Macro 4 Protect an Existing Workbook on Close.xlsm

Macro 5 Unprotect an Existing Workbook on Open.xlsm

Macro 94 Running an Access Reprot from Excel.xlsm

Macro 95 Opening an Access Form from Excel.xlsm

Macro 92 Running an Access Query from Excel.xlsm

Macro 10 Refresh All Data Connections in Workbook on Open.xlsm

Macro 3 Saving a Workbook Before Closing.xlsm

Macro 13 Print all Workbooks in a Directory.xlsm

Macro 11 Close all Workbooks in One Go.xlsm

Chapter 1 Sample File.xlsx

/101 Ready-to-Use Excel Formulas - Michael Alexander/

101 Ready-to-Use Excel Formulas - Michael Alexander.pdf

101 Ready-to-Use Excel Formulas - Michael Alexander.lrf

101 Ready-to-Use Excel Formulas - Michael Alexander.mobi

101 Ready-to-Use Excel Formulas - Michael Alexander.azw3

101 Ready-to-Use Excel Formulas - Michael Alexander.epub

Total files 109