Scheduled Dates (sort by: location | date) |
Request availability or book by selecting a date: Central London
City
England
Berkshire
Buckinghamshire
Greater Manchester
Tyne and Wear
West Midlands
Yorkshire (West)
Scotland
Prices exclude VAT.
Why do prices vary? Using CourseMonster, you search the schedules of over 100 training companies in one convenient location. Choose the city, date and price that best suits you.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.
|
Course Overview In this course you apply the Visual Basic for Applications (VBA) programming language to simplify many of the tasks in Excel. Audience Students looking to gain the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations. In addition, students who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data. Prerequisites Excel to a Power User level. Course Outline Developing Macros - Create a Macro with the Macro Recorder
- Edit a Macro
- Debug a Macro
- Customize Toolbars, Menus, and Hotkeys
Formatting Worksheets - Sort Data
- Insert Rows and Columns
- Insert Text
- Format Text
- Duplicate Data
- Generate a Report
Creating an Interactive Worksheet - Determine Dialog Box Type
- Capture User Input
Working with Multiple Worksheets - Insert, Copy, and Delete Worksheets
- Rename Worksheets
- Modify the Order of Worksheets
- Print Worksheets
Performing Calculations - Create User-defined Functions
- Automate SUM Functions
How to make a booking for the MEX03-V2 course
|
