book a course

Our Training

Build the confidence and skills you need to succeed with our practical professional development and IT courses, led by expert trainers with ongoing support.
See all courses

Explore our courses

IT & Digital Skills

Professional Development

PD Training

Build confidence, leadership, and workplace skills with our practical professional development courses. Delivered in Perth or live online, with expert trainers and ongoing support included.

read more

Explore our programs

Communication

Leadership

Project Management

Qualifications

Advance your career with nationally recognised qualifications and practical training. Delivered in Perth or live online, with expert trainers and ongoing support.
Learn More

Explore our Qualificationss

Microsoft Excel Charts and Macros

Microsoft Excel new logo with Microsoft Partner written on it.
Free Post-course Support
100% Quality
Guarantee
Interactive
Learning
eCertificate of Attendance

Microsoft Excel Charts and Macros

In Person Virtual

This course is available as a private group session or 1-on-1 training only. Enquire today to learn more!

Location: Training can be delivered at our Perth CBD training centre, at your site or virtually for added convenience
Duration: Half day (3-hour)

Our Perth CBD venue is easy to access by public transport.

Course Overview

Course Overview

In this half day Excel course, you will learn how to create compelling charts to visually present data and automate repetitive tasks using macros, including recording and editing macros, working with chart types and formatting options, and applying practical techniques to improve efficiency, consistency and productivity in your spreadsheets within a professional business environment.

Dates

No upcoming dates available.

Book a course

This course is available as a private group session or 1-on-1 training only. Enquire today to learn more!

Course Information

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

By the end of the workshop, participants will be able to:

  • Create a chart from any table data
  • Modify and format the chart to your choice
  • Using a trendline to show comparisons or for forecasting
  • Creating a macro to save repetition
  • Attach the macro to a command button for faster/efficient use

Completion of Microsoft Excel Intermediate course or equivalent knowledge is required.

“The course was very easy to follow and practical. It was beyond my expectations” – Kate from Water Corporation

” It was interactive, engaging & understanding. The best course I have been on, at work” – Paul from Landgate

“It was really good, the trainer answered every question and gave me the knowledge i needed” – Brandon from Water Corporation

“The course met my expectations!” – Davina-Lee from the Dept of Finance

FAQs

No FAQs found.