Microsoft Office Excel 2010: VBA
In the previous excel courses, you used Excel to simplifiy business tasks, including the creation of spreadsheets, graphs, charts, and formulas that were difficult to create and nearly impossible to maintain using pen and paper. 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 apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks that you can perform using various tools and functions in Excel 2010.
With our extensive knowledge of the different software currently on the market, including all Microsoft and Adobe applications, ON-TRACK Computer 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 apply automation to job tasks in Microsoft Office Excel 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 2010, including how to create, edit, format and print worksheets that contain charts, and sorted and filtered data.
- To ensure your success, we recommend the following On-Track courses, or equivalent knowledge in Microsoft Office Excel 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