Microsoft Excel Charts and Macros

Microsoft Partner Excel Logo
Learn to develop macros and create effective charts in Microsoft Excel.

Course price includes:

  • Perth’s best IT trainers at Perth’s best CBD training centre
  • Free help desk support after your training
  • Interactive, practical and hands on learning
  • Comprehensive take-home training and reference manual with exercise files
  • Refreshments
  • Certificate of Attendance
  • Our 100% quality guarantee
  • Virtual option available

Duration

Half Day

Contact us for more information

Course Times

  • 9am to 12pm

Course Content

Charts

  • Overview of different chart types
  • Creating a new chart, the quick way
  • Working with chart data

Charting Techniques

  • Adding trendline
  • Creating combination charts
  • Adding data to charts
  • Formatting & repositioning chart elements
  • Working with advanced chart options

Excel Automation

  • What is a macro?
  • Record a simple macro
  • Record and run a macro with relative cell references
  • Attaching a macro to a button, shape or picture

Recorder Workshop

  • Recording a summation macro
  • Recording consolidations
  • Recording divisional macros
  • Testing macros
  • Creating objects to run macros
  • Assigning a macro to an object