Excel Expert: Become an Excel Pro - 100% Free Online Course

This course is government-funded for all Irish residents with a PPS number, whether in full time employment or looking for work. The programme is delivered online by Cenit College, an authorised training provider for eCollege.

This programme aims to equip learners with expert-level Microsoft Excel skills and prepare them to confidently undertake the Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps) certification (MO 211). It supports learners in developing the deep proficiency and practical skills necessary to produce professional-grade Excel workbooks, effectively analyse data, and automate complex processes.

By completing this course you will be able to:

• Manage workbook options, settings, and advanced collaboration features.
• Apply advanced formatting and data validation techniques.
• Use logical, lookup, text, date/time, and aggregate functions to build complex formulas.
• Create, modify, and analyse Pivot Tables and Pivot Charts, including calculated fields and slicers.
• Produce and customise advanced chart types, including dual-axis, Waterfall, and Box & Whisker charts.
• Implement automation and productivity enhancements using macros and advanced functions.
• Analyse and visualise complex data to support business decision-making.
• Prepare and secure workbooks for distribution and professional presentation.

By successfully passing the exam at the end of the course, you will also achieve a MO-211 - MS Excel Expert (MS 365 Apps) Certificate, an industry recognised qualification certified by Microsoft.

REGISTER HERE - Microsoft 365: Excel Expert | SOLAS eCollege