Scribd Logo
Upload

Welcome to Scribd!

  • 137 views

    101 Ready-To-Use Excel Macros: Class Duration: 2 Days

    Uploaded by

    daut311
    This 2-day course teaches students how to automate tasks in Excel using macros. It covers topics such as recording macros, working with workbooks and worksheets, selecting and modifying cell ranges, manipulating charts and pivot tables, integrating with other Office applications, and more. Prerequisites include basic to intermediate Excel skills along with experience working with and analyzing data in Excel.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    101 Ready-To-Use Excel Macros: Class Duration: 2 Days

    Uploaded by

    daut311
    137 views2 pages
    This 2-day course teaches students how to automate tasks in Excel using macros. It covers topics such as recording macros, working with workbooks and worksheets, selecting and modifying cell ranges, manipulating charts and pivot tables, integrating with other Office applications, and more. Prerequisites include basic to intermediate Excel skills along with experience working with and analyzing data in Excel.

    Original Title

    Excel_101_Ready_To_Use_Macros.pdf

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This 2-day course teaches students how to automate tasks in Excel using macros. It covers topics such as recording macros, working with workbooks and worksheets, selecting and modifying cell ranges, manipulating charts and pivot tables, integrating with other Office applications, and more. Prerequisites include basic to intermediate Excel skills along with experience working with and analyzing data in Excel.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    137 views2 pages

    101 Ready-To-Use Excel Macros: Class Duration: 2 Days

    Uploaded by

    daut311
    This 2-day course teaches students how to automate tasks in Excel using macros. It covers topics such as recording macros, working with workbooks and worksheets, selecting and modifying cell ranges, manipulating charts and pivot tables, integrating with other Office applications, and more. Prerequisites include basic to intermediate Excel skills along with experience working with and analyzing data in Excel.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 2

    101 Ready-To-Use Excel Macros

    Class Duration: 2 Days

    An Excel macro is a sequence of instructions that automates some aspect of Excel so that you can work
    more efficiently and with fewer errors. Macros are written in VBA, which stands for Visual Basic for
    Applications.

    Prerequisites: You should have completed Excel Basic and Intermediate or have the equivalent
    knowledge. The ideal candidate has experience working with data in Excel, along with familiarity with
    the basic concepts of data analysis such as working with tables, aggregating data, performing
    calculations, and creating charts.

    Getting Started with Excel Macros Padding Cells with Zeroes


    Macro Recording Basics Replace Blank Cells with a Value
    Understanding Variables Append Text to the Right/Left of Cells
    Create a Super Data Cleanup Macro
    Working with Workbooks via Macros Highlight Duplicates in a Range of Data
    Protect a Worksheet When Closing Hide All Rows Except for Duplicates
    Open a Workbook to a Specific Tab Selectively Hide AutoFilter Arrows
    Open Workbook Defined by a User Copy Filtered Rows to a New Workbook
    Refresh Data Connections on Open
    Close all Workbooks at Once Working with Pivot Tables
    Print all Workbooks in a Directory Refresh All Pivot Tables Workbook
    Prevent Closing Until Cell is Populated Create a Pivot Table Inventory Summary
    Hide All Subtotals in a Pivot Table
    Automating Worksheet Tasks with Macros Set all Data Items to Sum
    Add and Name a Worksheet Apply Number Formatting
    Hide All but the Active Worksheet Apply Pivot Table Restrictions
    Moving Worksheets Around Transpose Entire Data Range
    Sort Worksheets by Name
    Create Table of Contents Manipulating Charts with Macros
    Zooming with a Double-Click Align a Chart to a Specific Range
    Create a Set of Disconnected Charts
    Selecting and Modifying Ranges Color Chart Series to Match Source Cells
    Enumerating Through a Range of Cells
    Select and Format All Named Ranges E-mailing from Excel
    Inserting Blank Rows in a Range Mailing a Specific Range as Attachment
    Unhide all Rows and Columns Mailing a Single Sheet as Attachment
    Deleting Blank Rows/Columns Send Mail with a Link to a Workbook
    Apply Alternate Color Banding Mail to All E-mail Contacts
    Limit Range Movement Saving All Attachments to a Folder
    Dynamically Set Print Area Saving Certain Attachments to a Folder

    Working with Data Integrating Excel and Other Office Applications


    Convert Trailing Minus Signs Manipulating Access from Excel
    Trim Spaces from All Cells in Range Sending Excel Data to a Word Doc
    Truncate Zip Codes to the Left Five Simulating Mail Merge with a Word Doc
    Send Data to a PowerPoint Presentation Convert Workbook to a PowerPoint File

    You might also like