Professional Diploma in Excel - Live Online | On Campus

This Excel course covers the following:

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

• 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.

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 Excel 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 Excel 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.

A City College Dublin’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 Dublin 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.

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