Course Description

Diploma in Excel - Advanced 26th January 2022 * Subject to Change



Diploma in Excel - Advanced 26th January 2022 * Subject to Change is a course run by City Colleges, Dublin. It is a 'Blended Learning - Mix of Classroom & Online' course with a duration of 10 weeks, 1 evening per week from 6.30 to 9.30pm. Diploma in Excel - Advanced 26th January 2022 * Subject to Change gives a Course Qualification of Diploma. For more information about Diploma in Excel - Advanced 26th January 2022 * Subject to Change at City Colleges, please review the details below.

Course Details


Full Course Name:

Diploma in Excel – Advanced

Course Dates


Next Course Commencing:
26th January 2022 * Subject to Change
Duration:
10 weeks, 1 evening per week from 6.30 to 9.30pm

Course Award


Award:
Diploma in Excel – Advanced

Course Fee


Classroom:
€695 (€795 if paying by installments)
Live Online:
€595 (€695 if paying by installments)

Why Excel

Microsoft Excel is a powerful, industry standard application central to any role 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 advanced 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.

What Will I Learn From This Course?

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.

Course Content

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

Advanced 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

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
The Diploma in Excel - Advanced 26th January 2022 * Subject to Change course at City Colleges is listed in Courses.ie's national courses finder.
Training ProviderCity Colleges
Course LocationDublin
Location PostcodeDublin 2
Course TypeBlended Learning - Mix of Classroom & Online
Course QualificationDiploma
Course Start Date26th January 2022
Course Duration10 weeks, 1 evening per week from 6.30 to 9.30pm
Course Time26th January 2022 * Subject to Change
Course FeeClassroom: €695 (€795 if paying by installments) Live Online: €595 (€695 if paying by installments)
Phone(01) 4160034
For more information about City Colleges, please visit our College page on Courses.ie 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 Courses.ie community.
 

Map

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