Excel on Steroids PLUS Course


Number of Attendees:


This is an Advance course.  In this course you will learn how to take advantage of some of the more advanced features of Microsoft Excel to prepare and present your business data.

Data Analysis, Visualisation and Dashboards will teach you how to model your data so you can create interactive dashboard reports that will make analysing your data much easier, and will give you clearer insights so you can make smart business decisions.

Course Outline

  • Design meaningful Dashboard Reports catering to your audience’s requirements and goals following Dashboard design best practise.
  • Create dynamic data models which will serve as the back-end of your Dashboard using advanced functions and formula.
  • Create PivotTables and Pivot Charts.
  • Explore alternative visualization techniques like sparklines and conditional formatting for at-a-glance analysis
  • Create advanced and custom charts
  • Create an interactive, macro-charged Dashboard.

Terms & Conditions

Bookings and Payments

  • Seats are allocated on a first pay – first served basis and are secured on receipt of payment and registration form only.
  • ProTec Solutions will not refund fees due to non-attendance or cancellations. (See Postponement terms).


Course Duration

  • Training usually starts at 09:00 and finishes at 15:30.
  • Times may change to suit students and more time may be allocated or removed if need be.
  • Delegates arriving more than 30 minutes after training commenced will not be allowed to attend and will not be refunded the course fee.


Course Material

  • All course material is included in the course fee.
  • No additional free manuals will be supplied in the event of loss / forgetting manual when attending a course.
  • Delegates are required to bring their own laptop to use during the duration of the course. Please note minimum hardware requirements.
  • Delegates are required to bring their own consumable items such as a writing pad, pens, etc.


Entrance Requirements

Learners need to meet the course specific prerequisites as stipulated in the Course Outline before attending this course.


If a learner is not yet competent in the required prerequisites, then he/she must first complete the relevant courses before enrolling for this course. Should we find a student on one of our courses that does not meet the prerequisites they will be asked to leave, and the course fee will be forfeited.


Cancellations / Absenteeism

  • Attendee substitutions or postponements must be made in writing at least 2 working days prior to the course commencement date. Only one postponement allowed.  Postponements for courses booked on any special offer or promotion will only be allowed if it still comply with timelines as stipulated for the promotion and subject to availability.
  • Strictly NO cancellations accepted once payment received and seat confirmed. The full course fee will be payable, and no refund will be made.
  • ProTec Solutions reserves the right to cancel or postpone training due to any fortuitous events including when course registrations do not meet minimum levels.



  • In the event that a delegate does not arrive for the course and no written notice of postponement was received and confirmed 2 working days prior to the course commencement date, the full course fee will be payable, and no refund will be made.



  • ProTec Solutions reserves the right to substitute the facilitator should it be necessary.


Training Venue

  • ProTec Solutions reserves the right to move training to another training venue should it be necessary.