Data Visualisation for Excel

295 per participant
Earn 6 CPD points for this course.
Book Now

€295for members

€395for non-members


Full Day


This course is an introduction to the more advanced features of spreadsheets and their use. By the end of this course, delegates should be comfortable with automating worksheet functionality, as well as using a variety of different analysis tools, data presentation and working effectively with multiple workbooks.

See full course details Ask a question

This course is designed to introduce existing users of Microsoft Excel to the Principles of Data Visualisation using Microsoft Excel Charts.

By the end of this course, delegates should be comfortable with applying Data Visualisation principles to create pleasing and informative Dashboards using Chart Options and Chart Design in Excel. You will gain an understanding of how to choose the best chart for your dataset and how your dashboard can tell a story to your audience. As a Consolidation Task at the end of the day, you will learn how to present your charts in an Excel Dashboard and export into PowerPoint based on the knowledge you have gained during the course.

The course is targeted towards people who have a good knowledge and understanding of MS Excel and who wish to learn some of the Visualisation features.

Attendees should have a working knowledge of Excel with AN understanding of the use of large datasets. No prior knowledge of creating charts is required.

The is a 1 Day Programme delivered from 09.30hrs – 16.30hrs.

Data Visualisation Key Principles
  • Learning Data Visualisation Best Practice
  • Choosing the Best Chart Type for your Data and Audience
Chart Types & Secondary Axis
  • Comparison Charts
  • Correlation Charts
  • Distribution Charts
  • Composition Charts
  • Combo Charts with Secondary Axis
Chart Elements
  • Manipulating Chart Elements to emphasis your Visual Story
  • Best use of Titles, Labels and Gridlines
  • Trendlines, Axis & Legend Options
  • Choosing Design and Colour Schemes
  • Alignment and Positioning Techniques
  • Number and Series Formatting
Chart Data
  • Choosing Data Series
  • Changing Data Source & Chart Type
  • Moving and Positioning Charts
Preparing Data for Analysis
  • Importing data to Excel for analysis
  • Removing Duplicates and Blank rows
  • Use Find and Replace to Cleanse Data
  • Split Columns using a delimiter or fixed width
  • Using Text Functions
  • Formatting Dates
  • Paste Special
Pivot Tables and Pivot Charts
  • Summarising Large Datasets using Pivot Tables
  • Fields, Row & Column Headings, Values
  • Filters and Slicers
  • Refreshing Data
  • Creating a Pivot Chart from Summarised Data
Creating a Visual Dashboard
  • Create a pleasing visual dashboard in Excel
  • Remove Gridlines and Sheet Options
Exporting Charts to PowerPoint
  • Exporting Visualisation’s to PowerPoint

On completion of the course candidates will receive:

  • CIF Data Visualisation for Excel CPD Certificate
  • 6 CPD Points
  • Member Rate: €295.00
  • Non-member Rate: €395.00

Upskill your employees with 4 Microsoft courses and receive a discounted rate. The courses include:

  • Excel Advanced
  • Data Visualisation for Excel
  • MS Project Management
  • Power BI

For All Enquiries or Course Bookings Contact:

Conor Greham: 01 4066031 / [email protected]

Robert Butler: 01 4066071 / [email protected]

The CIF can deliver this programme in house and may be tailored to your companies requirements.

In terms of programme delivery, the CIF can facilitate learning by virtual means (online via Zoom), or in classroom format (at your premises), subject to criteria. Please get in touch to discuss your requirements.

Need help or have a question?

Send us a message and we will be back to you as soon as possible.

See full course details

Booking information

Please inform the details for your booking.

Number of Participants:
This field can't be Empty
This field can't be Empty
Email field can't be Empty