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

Requirements

A basic understanding of computers.

Why Excel

Excel is one of the most widely used programmes of its kind across the globe and has become the industry standard. Being familiar with Excel is extremely valuable to employers and can increase your chances of being hired by being able to show employers that you have great analytical skills.

Organising and manipulating data manually can be very time consuming and mundane, Excel will save you time and help you to work more efficiently. The ability to conduct statistical analysis in Excel is incredibly useful to help you use data effectively.

Excel is an easily accessible software or if you like a universal language that can be used across the globe.

Course Overview

This Diploma 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 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 covers working with Microsoft Excel spreadsheet software to create, edit and save worksheets and workbooks. Completing this Microsoft Excel course will improve your workplace skillset as you master Excel from Beginner to Advanced.

Course Content

  • Excel Fundamentals
  • Text & Formulas
  • Basic Functions
  • Modifying a Worksheet
  • Formatting Data
  • Inserting Images & Shapes
  • Creating Basic Charts
  • Printing Worksheets
  • Templates
  • Lists & List Functions
  • Data Validation
  • Importing / Exporting Data
  • Pivot Tables
  • PowerPivot
  • Working with Large Data
  • Conditional Functions
  • Lookup Functions
  • Text Based Functions
  • Worksheet Auditing
  • Worksheet & Workbook Protection
  • What If? Tools
  • Excel Macros
  • VBA Concepts

Diploma in Excel For Business Course Fee

Classroom-based: €695
(€795 if paying  in instalments)

Online course: €595
(€695 if paying in instalments)

If paying in instalments by direct debit, the deposit to book a place is €150 and the balance is split into three equal monthly payments.

Non-EU students: Call +353 1 4160034

Lecturer

...

Paul Noone

Dean, College of Information Technology

As Dean of the College of Information Technology in City Colleges, Paul Noone brings a wealth of experience in the IT Educational sector to this position. Paul is an experienced teacher of IT and believes strongly that a good level of proficiency in computer skills for everybody has never been more necessary and relevant. He also believes  that there is an unacknowledged need for people to continually reassess their own level of IT knowledge and understanding, so as to ensure that they keep up-to-date in this ever-changing IT world and never to allow their IT skills to become obsolete.

Since graduating in Digital Technology at DIT, Paul successfully established his own Web and Graphic Design business, creating a large portfolio of clients. Paul ran this business successfully before turning his attention to the development and teaching of a suite of IT courses. Paul has been teaching ICT to students for more than 5 years, which puts him in the informed position of being able to introduce a range of the most relevant ICT Courses to City Colleges.

Paul is committed to developing a varied range of ICT Courses and Modules for City Colleges which will be cutting edge and will reflect the ICT needs of today’s world. He is also committed to the provision of excellence in terms of course content and the quality of the teachers involved.

Prior to this, Paul was involved in the retail sector for many years, owning and running his own retail outlets in Dublin. His business experience also includes the introduction of an International retailing brand to Ireland, involving multiple retail outlets around Ireland.

Assessment

A pass grade on the written assignment will be required for awarding of the Diploma.

Similarly, the Project must be handed in on the due date unless a sound reason for lateness is provided. In such instances, an extension may be awarded at the discretion of the lecturer.

Why City Colleges?

  • Courses for students who are passionate about their subject, delivered by leaders in their field.
  • Live lectures which are also streamed live on Moodle and recorded for review
  • City centre location in South Great George’s Street, convenient for bus, LUAS, DART
  • Southside Dublin location in Dundrum
  • Study rooms and library in our City Centre location
  • Limited class size
  • Parking

Enrol Now

Select your Courses

Select the desired options and click the enrol button below when finished

Diploma in Excel For Business (Live Online)

Microsoft Excel

6:30 PM - 9:30 PM

€595

Diploma in Excel For Business (Classroom)

Microsoft Excel

6:30 PM - 9:30 PM

€695


MENU