Amazing Macros (Microsoft Excel 2010/2013/2016) (7.5 hrs)

Course Code: CRS-N-0040878

This course introduces Microsoft Excel users to the advanced features in creating and managing Excel macro. Participants will learn how to record macro, execute macros in variety of different methods, editing macro, and creating a simple dialog boxes.

  • Learn about the advanced features in creating and managing Excel macro
  • Able to record, execute, and edit macro

Using macros

  • Opening a workbook containing macros
  • Running a macro
  • Using a shortcut key
  • Using the visual basic toolbar
  • Opening the visual basic editor window
  • Using the visual basic editor window

Recording macros

  • Recording a macro
  • Assigning a shortcut key
  • Using relative references
  • Assigning a macro to a menu
  • Deleting a macro from a menu
  • Deleting a macro

Editing macros

  • Writing a new macro
  • Entering macro comments
  • Copying macro commands
  • Editing macro commands
  • Typing macro commands
  • Running a macro from the code window

Custom button in Quick Access Toolbar

  • Creating a custom button
  • Adding a button to Quick Access Toolbar
  • Assigning a macro to a button
  • Changing a button image

Adding custom controls to a worksheet

  • Using a macro button
  • Creating a macro button
  • Copying a macro button
  • Formatting a macro button
  • Moving / sizing a macro button
  • Deleting a macro button

Participants will benefit from the hands-on practical sessions during the course.

This course is suitable for information professionals with prior understanding of Microsoft Excel and wish to have the expert abilities to key, manipulate and report data with ease.

Prerequisite

Participants must be an advanced user of Microsoft Excel 2010/2013/2016 for at least l year.

Duration : 1 day (7.5 hrs)
Time : 9:00am – 5:30pm

Course Fee : $320.00
Nett Fee Incl. 7% GST : $342.40
SDF Support* : $15.00

* Please click HERE for detailed information on course fee funding schemes, SkillsFuture credit, and complete listing of funded courses. This course is eligible for use of SkillsFuture credit.

(A course in partnership with COMAT)

Key Benefits
  • Learn about the advanced features in creating and managing Excel macro
  • Able to record, execute, and edit macro
Course Contents

Using macros

  • Opening a workbook containing macros
  • Running a macro
  • Using a shortcut key
  • Using the visual basic toolbar
  • Opening the visual basic editor window
  • Using the visual basic editor window

Recording macros

  • Recording a macro
  • Assigning a shortcut key
  • Using relative references
  • Assigning a macro to a menu
  • Deleting a macro from a menu
  • Deleting a macro

Editing macros

  • Writing a new macro
  • Entering macro comments
  • Copying macro commands
  • Editing macro commands
  • Typing macro commands
  • Running a macro from the code window

Custom button in Quick Access Toolbar

  • Creating a custom button
  • Adding a button to Quick Access Toolbar
  • Assigning a macro to a button
  • Changing a button image

Adding custom controls to a worksheet

  • Using a macro button
  • Creating a macro button
  • Copying a macro button
  • Formatting a macro button
  • Moving / sizing a macro button
  • Deleting a macro button
Learning Methodology

Participants will benefit from the hands-on practical sessions during the course.

Who Should Attend

This course is suitable for information professionals with prior understanding of Microsoft Excel and wish to have the expert abilities to key, manipulate and report data with ease.

Prerequisite

Participants must be an advanced user of Microsoft Excel 2010/2013/2016 for at least l year.

Course Details

Duration : 1 day (7.5 hrs)
Time : 9:00am – 5:30pm

Course Fee : $320.00
Nett Fee Incl. 7% GST : $342.40
SDF Support* : $15.00

* Please click HERE for detailed information on course fee funding schemes, SkillsFuture credit, and complete listing of funded courses. This course is eligible for use of SkillsFuture credit.

(A course in partnership with COMAT)

Course Application

Details Registration
January 13, 2020 - January 13, 2020 (9:00 am - 5:30 pm) Closed
February 19, 2020 - February 19, 2020 (9:00 am - 5:30 pm) Closed
March 18, 2020 - March 18, 2020 (9:00 am - 5:30 pm) Closed
August 27, 2020 - August 27, 2020 (9:00 am - 5:30 pm) Register Now
September 23, 2020 - September 23, 2020 (9:00 am - 5:30 pm) Register Now
October 30, 2020 - October 30, 2020 (9:00 am - 5:30 pm) Register Now
November 30, 2020 - November 30, 2020 (9:00 am - 5:30 pm) Register Now
December 16, 2020 - December 16, 2020 (9:00 am - 5:30 pm) Register Now