Use the form below to request a seat in the upcoming Excel live virtual training.
Once submitted, you will receive a confirmation email with next steps.
This is a booking request, not a payment step.
About the Training
This live, instructor-led Excel Track is a complete training path designed for learners who want to build Excel skills from the ground up and progress to advanced reporting, dashboards, and analysis tools used in real business work.
The track combines the Beginner to Intermediate course and the Advanced course into one structured 8-day program.
- Live virtual sessions
- Hands-on exercises and examples
- Interactive Q&A during training
Training Schedule
- Duration: 8 days (2 blocks x 4 days)
- Time: 6:00 PM – 8:00 PM
- Format: Live virtual sessions
- Structure:
- Block 1: Beginner → Intermediate (Sunday–Wednesday)
- Block 2: Advanced (Sunday–Wednesday)
- Start date: Every Sunday after confirmation (Advanced block starts after completing the first block / next available cohort)
- Total live hours: 16 hours (8 sessions × 2 hours)
Course Outline
The training is structured across two blocks and eight live sessions, taking learners from Excel foundations to advanced formulas, dashboards, forecasting, and decision-making tools.
Week 1: Beginner to Intermediate (Days 1-4)
Day 1 – Excel Foundations
- Interface and navigation
- Workbook vs worksheet
- Data entry and editing
- Basic formatting
- Sort, filter, and freeze basics
- Save, share, and print basics
Day 2 – Core Formulas and Smart Formatting
- Formula basics
- Relative and absolute references
- SUM, AVERAGE, MIN, MAX, COUNT, COUNTA
- Basic IF
- Format as Table
- Conditional formatting basics
- Data validation basics
Day 3 – Working with Data Visually
- Charts
- Chart customization
- Sparklines
- Text cleanup basics
- Find/Replace, Go To Special, Paste Special
- Introduction to common data errors
Day 4 – Analysis and Intermediate Functions
- PivotTables
- PivotCharts
- Lookup functions
- Text functions
- SUMIF, COUNTIF, and AVERAGE
- Logical combination with IF + AND/OR
Week 2: Advanced (Days 5-8)
Day 5 – Data Preparation and Advanced Workbook Tools
- Excel Tables and structured references
- Advanced sort and filter
- Remove duplicates and data cleanup
- Text to Columns and Flash Fill
- Named ranges
- Working across worksheets and workbooks
- Protecting cells, worksheets, and workbooks
Day 6 – Advanced Formulas and Lookup Techniques
- Nested IF and IFS
- IF with AND / OR combinations
- IFERROR
- XLOOKUP
- INDEX + MATCH
- Two-way lookups
- Multiple-criteria lookups
- SUMIFS, COUNTIFS, and AVERAGEIFS
Day 7 – Dynamic Arrays and Advanced Data Analysis
- Dynamic array behavior and spill ranges
- FILTER
- SORT and SORTBY
- UNIQUE and SEQUENCE
- Advanced PivotTables
- Calculated fields
- Show Values As
- Slicers and Timelines
Day 8 – Dashboards, What-If Analysis, and Productivity
- PivotCharts
- Interactive dashboards
- Connecting slicers to multiple PivotTables
- Dashboard design principles
- Goal Seek
- Scenario Manager
- Data Tables
- Forecast Sheet
- Formula auditing
- Productivity tips and advanced shortcuts
Course fee: 152 JOD 190 JOD (20% off – Limited time)
For international: 216 USD 270 USD
Group pricing
Special rates for team bookings of 5+ participants. Group rates are separate from individual limited-time offers and are not combined with other discounts.
Please reach out through email hello@mroumi.com
Payment details will be provided after submitting the booking request.
You’ll receive a confirmation email, and I’ll follow up shortly with availability and next steps.