Microsoft Excel Expert (MOS) – Preparation
Preparation for the Microsoft Office Specialist Excel Expert exam: workbook management, advanced formulas, data and charts.
At a glance
- 3 days
Who it's for
- Advanced Excel users
- Analysts and accountants
- Candidates for MOS Excel Expert
Learning objectives
- Manage workbook options and settings
- Use advanced formulas and functions
- Manage and format data
- Create advanced charts and tables
Detailed content
- Templates and macros
- Protection
- Collaboration
- Lookup and dynamic arrays
- Logical functions
- Formula auditing
- Data validation
- Custom formats
- Conditional formatting
- PivotTables
- PivotCharts
- Exam practice
Day-by-day agenda
A typical schedule. In-company versions are tailored to your processes, data and timing.
- Workbook options
- Advanced formulas
- Data management
- Advanced charts
- Mock exam, review of weak areas and exam strategy
Practice, tools and assessment
Hands-on practice
- Hands-on lab on your laptop with a real business data set
- Build a complete dashboard from raw data to one-page report
- Data-cleaning challenge (Power Query / pandas)
- Case studies from Egyptian and Gulf organizations
Tools and templates you keep
- Practice files and solution workbooks
- Formula, DAX and shortcut cheat sheets
- Dashboard design checklist
- Course workbook and slide handouts
How learning is assessed
- Diagnostic test on day one to focus study time
- Chapter quizzes and a full timed mock exam in the official format
- Personal study plan until your exam date
Built on these standards and bodies of knowledge
- Microsoft PL-300 skills outline (Power BI)
- CRISP-DM data-analysis process
Certificate
Participants who complete the program and its assessment receive a certificate from The Excellence Center, which can be verified online.
Prerequisites: Good working knowledge of Excel
The exam is set and the credential awarded by Certiport. The Excellence Center provides preparation; it does not award Certiport credentials.
This program prepares for a certificate from a body on the Saudi HRDF (Hadaf) Professional Certificates list. Saudi citizens may be able to claim a fixed reimbursement of the certificate cost from HRDF: up to two certificates per person, after passing the exam, if the certificate is on HRDF's current list and the employer did not pay for it. HRDF approves the certificate, not the training provider. Check the HRDF website before enrolling. All HRDF-listed programs · Enrol in Saudi Arabia with our partner Elm E · HRDF
New in our 2026 portfolio — tell us your dates and we will confirm the trainer and schedule.
How it is delivered
- Public courses in Cairo, in-company programs and live online training
- Practical exercises, case studies and examples from your sector
- Can also run as Train & Stay in Sharm El Sheikh, Hurghada or Cairo
Frequently asked questions
How long is Microsoft Excel Expert (MOS) – Preparation?
The program runs 3 days. In-company versions can be adapted to your needs.
Is the course taught in Arabic or English?
Sessions are usually delivered in Arabic with English technical terms and materials. Full English delivery is available for in-company groups.
Can you run it inside our company?
Yes. In-company programs use exercises built on your own processes. Tell us the group size and preferred timing and we will send a proposal.
Will I receive a certificate?
Participants who complete the program and its assessment receive a certificate from The Excellence Center, which can be verified online.
More programs in this field
- Generative AI for ProfessionalsNew
- Advanced Analytics for Business Excellence5 days
- Advanced Excel4 days
- Business Intelligence5 days
- Data Analysis for Digital Marketing5 days
- Data Analysis Professional Program (Excel, Power BI, SQL & Python)10 days
- Data Analysis Using Excel4 days
- Data Analysis Using Excel & Power BI5–6 days
- Data Analysis Using Microsoft Power BI3 days
Get dates, fees and the full outline.
Tell us whether you are joining as an individual or planning a program for your team.