Microsoft Excel
Gain industry ready skills. You’ll dive deep into real-world scenarios and learn from top industry practitioners.
.svg?dpl=dpl_5MWs9Y8sDneEMJLLBH7rk3Dtp8A1)
Next start
4th November 2026
6 Hrs
Schedule
Wed, 9:00AM till 12:00PM
Price
€195
Format
Day-time, Online Live
- See start dates
Course overview
Microsoft Excel is an indispensable tool for organizing, analyzing, and presenting data. In this course, you will discover how to make the most of Excel’s powerful features. Whether you’re brand-new to Excel or just looking to refresh your skills, these hands-on lessons will empower you to tackle data-related tasks with confidence.
Structured as a continuous workshop, the training covers everything from the basics of spreadsheet creation, formulas, and formatting, to more advanced topics like pivot tables and data visualization. You’ll learn best practices for managing and interpreting large datasets, setting up clear and organized workbooks, and generating in-depth data analysis through practical examples and real-world scenarios.
By the end of this course, you’ll be well-equipped with the foundational knowledge and techniques needed to navigate Excel’s robust functionality—allowing you to produce high-quality work in less time. Embrace the capabilities of Excel, and transform the way you plan, analyze, and present your data.
Entry requirements
Good Knowledge of English
Validated by industry leaders
Our graduates work at companies across Malta and beyond.
- mita
- SiGMA
- Betsson Group
- MeDirect
- Tipico
- PwC
- Casumo
- HILI Company
- 9H Digital
- Deloitte
- APS Bank
- Evolution
- GO
- LeoVegas
- FIAU
- Lo & Behold
- Bank of Valletta
- Microsoft
- Audi
- Booking.com
- Methode Electronics
.svg)
.svg)
.svg)
.svg)
.svg)
%20(white).png)
.svg){kind=small}
.svg)
.svg)
%20(white).png)
.svg)
.svg)
In depth curriculum
A module-by-module look at what you will cover in the Microsoft Excel, across 17 modules.
17 modules
Module 1
- Excel Interface & Ribbon Navigation
- View Settings, Freeze Panes & Splitting the Screen for Large Datasets
- Essential Keyboard Shortcuts
- Managing Workbooks & Worksheets
- File Formats & Saving Options (Excel, CSV, PDF)
Module 2
- Apply formatting and understand Text vs. Numbers
- AutoFill & Flash Fill for Data Entry
- Find & Replace
- Basic Formatting (Fonts, Colors, Borders, Merging, Text Wrapping)
- Using Format Painter (Single & Multiple Applications)
Module 3
- Understanding and making use of Formula good practices
- Understanding and Implementing the Functions
- Identifying the different types of errors
- Using the Logical Function If and making use of the logical operators
- Applying the TODAY & NOW Functions to create live and updated date and time
- Applying a shortcut to have a fixed date/fixed time
- Understanding the differences between Relative & Absolute Cell Referencing
- Making use of and understanding the difference between Trace Precedents & Trace Dependents in Formula Debugging
- Switching between the Show Formulas and Showing Values
Module 4
- Implementing Sorting & Filtering
- Creating basic charts (Column, Line, Pie, Formatting & Labeling)
- Printing & Page Setup (Headers, Footers, Scaling, Print Area)
Module 5
- Using Copilot for Quick Summarisation & Trends
- Smart Formatting & Auto-Fill using AI
Tools
- Copilot
Module 6
- Custom Number Formatting (Leading Zeros, Date, Currency)
- Conditional Formatting (Data Bars, Icon Sets, Colour Scales)
- Removing Duplicates & Cleaning Inconsistent Data
- Data Cleaning with Text to Columns & Flash Fill
- Importing & Exporting Delimited Files (CSV, TXT) and Web Queries
Module 7
- Applying Logical Functions
- IFERROR Function & Handling Formula Errors
- Lookup & Reference Functions
Module 8
- Using Data Validation for Error-Free Entries & Input Restrictions
- Linking to External Workbooks, Documents & Presentations for Data Consolidation
Module 9
- Excel Workbook Protection & Encryption
- Collaboration in Excel (Co-Authoring & Comments)
- Real-time Collaboration, Threaded Comments & Version Control
Module 10
- Creating & Formatting PivotTables for Data Analysis
- Using Slicers & Timelines for Interactive Reports
- PivotCharts & Customisation Techniques
Module 11
- Using Copilot to Automate Summary Reports & Chart Creation
Tools
- Copilot
Module 12
- Understanding & Applying Further Functions
- 3-D Function
- Formula Auditing & Using the Watch Window for Tracing Errors
Module 13
- Comparing the XLOOKUP vs. INDEX & MATCH for Dynamic Lookups
- Implementing GETPIVOTDATA function for Custom Pivot Reports
- Advanced Statistical & Mathematical Functions
- Naming Cells & Ranges
- Advanced Filtering
- Advanced Charts
Module 14
- Understanding and applying manual and auto grouping/outlines
- Applying the Subtotal Calculation option
- Using the Goal Seek
- Implementing the Scenario Manager for Decision-Making
Module 15
Advanced · Module 4: Case Studies
Module 16
- Recording Macros for Repetitive Task Automation
- Macro Security & Running VBA Scripts
- Automating Data Cleaning & Report Generation
Module 17
- AI-Powered Trend Analysis & Predictive Insights
- Copilot for Automated Pattern Detection
Tools
- Copilot
Request more details to view the full course syllabus, or book a call to speak with an education advisor.
Your global certification
At the end of the course, each student will be awarded an official certificate of participation by ICE Campus.
Learning experience
Every step of the way you receive support from your educator, your classmates and our dedicated student experience team. That is a promise.
Learning Platform
A courseware kingdom full of presentations, playbacks, quizzes & practice exercises accessible 24/7.
Taught by industry expert
Learn live with seasoned professionals in a unique, small-class environment.
Globally recognised certification
Worldwide recognised certifications by top tech brands which prove that you’re industry ready.
Student Experience Support
A helping hand before, during and after your learning journey.
Post-course educator support
Personalised feedback to help you achieve your goals for an additional 6 month window.
Practical learning
Hands-on exercises and real world projects to get you industry ready.
Pricing & funding. Simple, transparent.
Pay in one go or spread the cost, and check whether you can claim part of your fees back.
More info on funding
Convince your boss to sponsor your growth
Employers in Malta can recover part of the cost of training through the Investing in Skills (IIS) scheme.
What you’ll get
- Training by a Microsoft Certified Trainer (MCT)
- Official Microsoft Courseware (Format: Softcopy)
- Detailed Educator Presentations
Starting dates
Our classes do not have an enrolment deadline, but demand is high and they fill up ahead of time because we purposely limit class sizes to keep every class personal.
- Enrol nowOnline livePart time€195COPILOT
Microsoft Excel Intermediate
4th November 2026
- Wed, 9:00AM till 12:00PM
- 6 Hrs
- Enrol nowOnline livePart time€195COPILOT
Microsoft Excel Advanced
17th November 2026
- Tue, 9:00AM till 12:00PM
- 6 Hrs
- Enrol nowOnline livePart time€195COPILOT
Microsoft Excel Foundations
25th November 2026
- Wed, 9:00AM till 12:00PM
- 6 Hrs
Loved by students & brands
Katyana S.Advanced Excel It was a very good Excel refresh session.
Charlotte M.Advanced Excel Fruitful experience. The delivery of the course was great.
Anita O.Advanced Excel Very clear communication and a lovely friendly trainer. Thank you
Eszter M.Advanced Excel This course helped me a lot to fill in gaps in my Excel knowledge. Liana is a great teacher.
Janet C.Intermediate Excel It was very well organised. Answered many questions which I had and gained new knowledge.
Svetlana Z.Intermediate Excel Liana is incredibly patient and excellent at breaking down complex topics into easy-to-understand steps.
Julia S.Intermediate Excel Very educational and Educator was really good
Carmen B.Excel for Beginners Very informative and helpful.
Selima B.Excel for Beginners The course was interesting and the teacher engaging and friendly
Daniel C.Intermediate Excel Great experience and great lecturer!
Alvaro M.Intermediate Excel Truly well organised and delivered.
Marion V.Intermediate Excel Straight to the point! Effective training
You might also like
All courses
NewBuild & Launch Websites with AI
NewAI Agents & Workflow Automation with n8n
AIGP – Certified AI Governance Professional Course by IAPP
MQF5NewAI for Personal Productivity
SCQF8NewProfessional Diploma in AI
MQF3ICDL Workforce Course (Formerly ECDL Standard)
MQF4ICDL Professional Course (Formerly ECDL Advanced)
Managing Projects with Microsoft Project Course
Meet with an expert
Not sure this is the right course? Book a free call with an education advisor.
Microsoft Excel
3 classes starting · next 4 Nov 2026 · €195