Microsoft Office Excel 2013 / 2010: Macros
You now want to simplify your work in the Excel environment by automating many of the repetitive tasks that are part of the spreadsheet development process. In this course, you will learn how to create macros to simplify many of the tasks and achieve automation!p>
With our extensive knowledge of the different software currently on the market, including all Microsoft and Adobe applications, ON-TRACK Corporate Training Ltd. has a diverse and flexible schedule that can be customized to your needs – we offer group course (both public and corporate), one-on-one training, and on-site training options. We also have easily accessible on-line training videos available.
Duration: 1 Day
Objectives
- You will learn to automate Excel tasks in Microsoft Office Excel 2013 / 2010
- Creating, editing and debugging macros
- Format worksheets using macros
- Create an interactive worksheet
- Work with multiple worksheets
- Perform Calculations
Target Student
- Advanced Microsoft Excel professionals who need to automate Excel spreadsheet tasks using Visual Basic for Applications (VBA)
Prerequisites
- Knowledge of Microsoft Office Excel 2013 / 2010, including how to create, edit, format and print worksheets that contain charts, and sorted & filtered data.
- To ensure your success, we recommend the following On-Track courses, or equivalent knowledge in Microsoft Office Excel 2013 / 2010: Levels 1, 2 and 3.
Outline
- Section 1 - Developing Macros
- Create a Macro with the Macro Recorder
- Edit a Macro
- Debug a Macro
- Customize the Quick Access Toolbar and Hotkeys
- Work with Macro Security
- Section 2 - Formatting Worksheets Using Macros
- Insert Text
- Format Text
- Sort Data
- Duplicate Data
- Generate a Report
- Section 3 - Creating an Interactive Worksheet
- Determine the Dialog Box Type
- Capture user Input
- Section 4 - Working with Multiple Worksheets
- Insert, Copy and Delete Worksheets
- Rename Worksheets
- Modify the Order of Worksheets
- Print Worksheets
- Section 5 - Performing Calculations
- Create user-Defined Functions
- Automate SUM Functions