Professional Diploma in Excel

Duration: 5 Weeks | Learning Modes: Live Online or On Campus | Contact Hours: 15 Hours

This course is available via live online learning or part time, on campus.

The Professional Diploma in Excel is designed for beginners and existing Excel users who want to develop practical spreadsheet, reporting, and data analysis skills. Learners will build a strong foundation in Microsoft Excel and progress to advanced techniques used across business, finance, operations, and analytics environments.

This programme develops the knowledge and confidence required to create robust spreadsheets, analyse data efficiently, automate repetitive tasks, and produce professional reports and dashboards that support business decision-making.

Learning Modes

Live Online
Delivered through live online lectures with real-time interaction and access to recorded sessions.

• 1 evening per week
• Delivered over 5 weeks
• Recorded sessions available for review

On Campus
Delivered through classroom-based learning at our Dublin city centre campus.

• 1 evening per week
• Delivered over 5 weeks
• Interactive classroom environment

Qualification: City College Dublin Professional Diploma in Excel

Course Structure

This Excel programme covers essential and advanced spreadsheet skills including:

• Excel Fundamentals and Workbook Management
• Formulas and Functions
• Data Formatting and Validation
• Sorting, Filtering and Data Management
• Charts and Data Visualisation
• Importing and Exporting Data
• Text Functions and Lookup Functions
• Statistical and Conditional Functions
• Date and Time Functions
• Logical Operators and Array Formulas
• Pivot Tables and Advanced Reporting
• Introduction to Excel Macros and VBA
• Python in Excel

Entry Requirements

No formal qualifications are required.

Learners should have:

• Basic computer skills
• Access to Microsoft Excel
• An interest in developing spreadsheet and data analysis skills

Assessment

Assessment is based on practical application of Excel skills through exercises and project-based activities completed throughout the programme.

Career Opportunities

Excel skills are highly valued across a wide range of industries and professions including:

• Business Administration
• Finance and Accounting
• Data Analysis
• Operations and Supply Chain
• Project Management
• Business Intelligence and Reporting

The programme also provides a strong foundation for further study in data analytics, business intelligence, and digital technologies.

Why Choose This Course?

✔️ Develop practical, job-ready Excel skills
✔️ Learn industry-standard spreadsheet techniques
✔️ Gain experience with reporting and dashboards
✔️ Introduction to VBA and automation concepts
✔️ Suitable for beginners and intermediate users
✔️ Flexible online and on-campus study options
✔️ Highly valued skill across all industries