Basket Login

Professional Diploma in Excel

City Colleges’ Professional Diploma
  • Excel has proved itself as an essential tool for the success of any business
  • Available in two options – Essentials / Advanced
  • Delivered in Classroom or Online
  • Choose to study at your own pace or with our timetabled classes
  • City Colleges Diploma Award
  • A basic understanding of working with Windows or Mac applications is required for both course options

Enrolling Now

Price from €495
Call Enquire Request Callback Enrol

Classroom

Choose from two available course options – Essentials/Advanced.
Price from €395
  • City Centre Location
  • Fully Interactive Limited Class Size
  • 5 Weeks, 1 evening per week
  • Essentials – Starting September 2024
  • Advanced – Starting 11th June 2024
  • 6.30 to 9.30pm

Live Online

Choose from two available course options – Essentials/Advanced.
Price from €295
  • Live & fully online
  • Archived for review
  • 10 Weeks, 1 evening per week
  • Essentials – Starting September 2024
  • Advanced – Starting 11th June 2024
  • 6.30 to 9.30pm

On Demand

A flexible online approach developed to allow you to learn at your own pace.
Price from €295
  • Fully online
  • Pre Recorded
  • Start Anytime
  • Suit your own Schedule
  • Access for 12 weeks
  • 12 -13 weeks to send in the assignment
Loading…

Essentials Course Overview

“Excel has continuously proved itself as an essential tool for the success of any business.”

This course is designed to take new or existing Excel users and bring them to an essential level of proficiency in Excel. Having Excel essentials is a highly valued skill by industry as Excel provides the backbone for many financial services companies. Understanding the power of Excel and learning to design robust, safe, and scalable spreadsheets is a critical skill for most businesses.

When you take this programme, you will learn the power of Microsoft Excel starting from the beginning.
This course covers working with Microsoft Excel spreadsheet software to create, edit and manage worksheets and workbooks. Completing this Microsoft Excel course will improve your workplace skillset as you master Excel essentials.

  • 82% of jobs require Excel skills
  • Certified Excel skills can increase your earning potential by approximately 12%
  • Excel skills open the door to more jobs and career opportunities

Microsoft Excel is a powerful, industry standard application central to any role that involves working with data. As organising and manipulating data becomes increasingly important across a multitude of industries, employees who have knowledge of this tool are sought after.

Knowing the techniques of Excel will allow you to analyse and summarise data and present professional reports and dashboards to decision makers. Using Excel as a foundation, your analytical skills will improve, and you will save time and work more efficiently. Having experience in Excel is extremely valuable to employers and will increase your chances of being hired.

Whether you are new to Excel or understand just the basic concepts, this course is designed to build your analytical skills and will take you to an essential level of proficiency in Excel. Our lecturers have many years of industry experience across Business Intelligence and Analytics’ teams. They will bring this experience to you using real-life examples and practical applications of Excel.

When you take this course, you will learn the basics: how to open, close and save files, how to enter formulae into a cell, build basic charts and format a spreadsheet, then moving onto to more intermediate level Excel skills.

Excel Foundations (2 weeks)

  • Excel Fundamentals
  • Text and Formulas
  • Formatting Data
  • Sorting and filtering
  • Inserting Images and Shapes
  • Creating Basic Charts
  • Printing Worksheets
  • Data Validation
  • Importing and Exporting Data

Excel Concepts (3 weeks)

  • Text based functions
  • Lookup functions
  • Statistical functions
  • Conditional functions
  • Formula-based formatting
  • Date and Time functions
  • Logical operators
  • Array formulas
  • Excel Macros and VBA concepts
  • Python in Excel

Advanced Course Overview

“Excel has proved itself as an essential tool for the success of any business.”

This course was designed to take new or existing Excel users and bring them to a high level of proficiency in Excel.
Having a proficiency in Excel is a highly valued skill by industry as Excel provides the backbone for many financial services companies. Understanding the power of Excel and learning to design robust, safe, and scalable spreadsheets is a critical skill for most businesses.

When you take this programme, you will build on the fundamentals skills that you already have. It will help you acquire professional techniques providing long-lasting practical spreadsheet development skills. This will in turn put you in a better position to command a higher salary in today’s Excel reliant world.

This course covers working with Microsoft Excel spreadsheet software to create, edit and manage worksheets and workbooks. Completing this Microsoft Excel course will improve your workplace skillset as you master Excel Advanced level.

  • 82% of jobs require Excel skills
  • Certified Excel skills can increase your earning potential by approximately 12%
  • Excel skills open the door to more jobs and career opportunities

Microsoft Excel is a powerful, industry standard application central to any role that involves working with data. As organising and manipulating data becomes increasingly important across a multitude of industries, employees who have advanced knowledge of this tool are highly sought after.

Knowing the techniques of Excel will allow you to analyse and summarise data and present professional reports and dashboards to decision makers. Using Excel as a foundation, your analytical skills will improve, and you will save time and work more efficiently. Having experience in Advanced Excel is extremely valuable to employers and will increase your chances of being hired.

This course is designed to build your analytical skills and will take you to an advanced level of proficiency in Excel. Our lecturers have many years of industry experience across Business Intelligence and Analytics teams and will bring this experience to you using real-life examples and practical applications of Excel.

When you take this course, you will build on your existing fundamental skills to help you acquire professional techniques that will provide long-lasting practical spreadsheet development skills, and help you command a higher salary in today’s Excel reliant world.

This course will take you through more advanced concepts of working with data, pivot tables and VBA (Excel’s programming language). It concludes with the advanced topics of creating professional visualisations and dashboards which would impress at any level of an organisation.

Excel Pivot Tables for Data Analysis (3 weeks)

  • Connecting to data sources
  • Data structures in Excel
  • Power pivot
  • Pivot Table layouts and styles
  • Design and formatting options
  • Sorting, filtering, and grouping tools
  • Calculated fields, items and values
  • Pivot Charts, slicers, and timelines

Data Visualisation in Excel (2 weeks)

  • Column and bar charts
  • Pareto charts and histograms
  • Line charts and trend lines
  • Area charts
  • Scatter plots and Bubble charts
  • Waterfall and Funnel charts
  • Heat maps, 3-D Surface, and contour charts
  • Creating Excel dashboards
  • Python for Data Visualisation

Kayoum Khbuli

Course Award

A City College’s Professional Diploma Course is a focused, practical programme designed and delivered by an industry practitioner, that consolidates, upskills or reskills learners in a professional area. They are stand-alone qualifications that indicate that you have been trained in a particular area or specific subject matter.

City College Diplomas are suitable for career minded learners wishing to advance their professional skills and prospects. They are widely accepted by employers and many students are sponsored to study here by their organisation.

Corporate Training

In addition to our scheduled Professional Diploma courses, City Colleges can provide bespoke training over 3 – 4 days, please contact Kevin.Coyne@citygroup.ie for further details.

Learning Outcomes

Excel is a highly valued skill across many industries. Understanding the power of Excel and learning to design robust, safe, and scalable spreadsheets is a critical skill for most businesses.

Whether you are new to Excel or understand the basic concepts, this course is designed to build your analytical skills and take you to an advanced level of proficiency in Excel. Our lecturers have many years of industry experience across Business Intelligence and Analytics teams and will bring this experience to you using real-life examples and practical applications of Excel.

When you take this course, you will build on the fundamentals to help you acquire professional techniques that will provide long-lasting practical spreadsheet development skills, and help you command a higher salary in today’s Excel reliant world.

This course introduces you to the foundational skills of basic formula and formatting, then takes you through more advanced concepts of working with data, pivot tables and VBA (Excel’s programming language) It concludes with the advanced topics of creating professional visualisations and dashboards which would impress at any level of an organisation.

Related Courses

Why City Colleges?

Study options that Suit your Schedule

Study where you want when you want. On Campus, Live Online, and On Demand.

Industry Expert-Led Courses

100+ courses, across subject areas in Business, IT, Psychology, Criminology, Law, Media, Arts & Science with over 16,000 graduates

World Class Teaching

City Colleges Lecturers are industry leaders in their chosen fields

Our commitment to student experience

Our Programme Teams engage, support, and guide our students throughout their programme to ensure that their learning experience is a positive one and prepares them to use their new skills in the workplace.

Cutting Edge Programme Content

Our students enjoy some of the most contemporary and industry-relevant course content, developed by our industry-based practitioners to close skills gaps in the global workforce

Premium courses at affordable prices

City Colleges is committed to ensuring that our education and training programmes are accessible and affordable.