Data Visualisation for Excel

Price
€ 295 per participant

Earn 6 CPD points for this course.

€295for members

€395for non-members

9:00am-5:00pm

Full Day

Online

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

COURSE OUTLINE

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.

COURSE CONTENT

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

CERTIFICATION & CPD

On completion of the course candidates will receive:

CIF Data Visualisation for Excel CPD Certificate
6 CPD Points

COURSE FEE

Member Rate: €295.00
Non-member Rate: €395.00

CIF MICROSOFT BUNDLE

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

FIND OUT MORE

CONTACT INFORMATION

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.