Course Description

Diploma in Data Analytics – Introduction: April 2021

Diploma in Data Analytics – Introduction: April 2021 is a course run by City Colleges, Dublin. For more information about Diploma in Data Analytics – Introduction: April 2021 at City Colleges, please review the details below.

Course Dates

Next Course Commencing:
26th April 2021
11 weeks, 1 evening per week from 6.30 to 9.30pm

Course Award

Award: City Colleges Diploma

Course Fee

€1,035 (€1,135 if paying by installments)
Live Online:
€895 (€995 if paying by installments)

Power Business Intelligence without Coding

Diploma in Data Analytics

Course Overview

“Excel is the only business software that ever worked!”
It is a fact that over the next two years 76% of companies are planning to increase their investment in data analytics. Data analytics is the science of analysing raw data in order to draw conclusions about that information and being able to analyse that data is a powerful skill that will help you make better informed decisions.
Learn Microsoft Excel in our Diploma in Data Analytic. Excel is one of the best tools for data analysis and indeed it’s built-in pivot tables are arguably the most popular analytic tool.

In this Diploma in Data Analytics you will learn how to:

  • Filter, Sort and Format Data
  • Apply the IF, nested IF, VLOOKUP and the HLOOKUP functions of Excel
  • Visually represent Data using a Pivot Table
  • Use Pivot Tables and Pivot Charts to Create a Dashboard
  • Use Calculated Fields within Pivot Tables to Calculate Profitability and find any Abnormalities
  • Use Formulas to Aggregate the Data as an Alternative to Pivot Tables for more Flexible Reports

*This course is intended for anyone who wants to take the data analysis technologies in Excel beyond formulas and add more advanced capabilities such as dashboards, hierarchies, and relationships.


A basic understanding of Microsoft Excel

The Diploma in Data Analytics – Introduction: April 2021 course at City Colleges is listed in's national courses finder.
Training ProviderCity Colleges
Course LocationDublin
Location PostcodeDublin 2
Course Start Date26th April 2021
Course Duration11 weeks
Course FeeClassroom: €1,095 (€1,195 if paying in instalments) Online: €695 (€795 if paying in instalments)
For more information about City Colleges, please visit our College page on by clicking here.

Course Provider

City Colleges

Wicklow House, 84-88 South Great George’s Street, Dublin, Republic of Ireland

Make Enquiry

Please insert your contact details and any additional information you require and we will forward your request to City Colleges

Captcha code        I confirm I have read the Cookie Information, Terms and Conditions and Privacy Policy and I agree to join the community.


City Colleges
Wicklow House
84-88 South Great George’s Street, Dublin
Republic of Ireland
Visit Website