This course will introduce you to macros in Excel and show you how to leverage their power to make your work with Excel easier.

Prerequisites: Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality

For an optimal experience please check the minimum computer system requirements.

This online course forms part of the SkillsNet short course suite.

Please note this course is only available to CPA Australia members.

Learning objectives

  • Identify the features of Excel 2010 macros
  • Use the Macro Recorder to record and run a macro
  • Identify the steps in recording a macro using the macro recorder
  • Edit and delete macros
  • Run a macro in different ways
  • Prepare for recording a macro
  • Record and run a macro
  • Assign a macro to the developer tab on the Ribbon
  • Add a macro the Quick Access Toolbar

Audience

End users seeking proficiency in the use of Microsoft Excel 2010 at an advanced level.

60 Minutes

365 Days

loading...