Excel Training Dubai · In-Company & Online

Excel that finally works the way your team works.

Practical, English-language Excel training for teams in Dubai — from first formula to advanced modelling. We build the programme around your real files, your reports and your deadlines, and deliver it at your office or live online.

Beginner and advanced tracks At your office in Dubai or live online 600+ corporate references

How an in-company training comes together

Four steps, roughly three weeks from first call to training day.

1
ScopeA short call about who is in the room, what they build in Excel today and where it hurts.
2
DesignWe pick the modules, set the level and rebuild the exercises around your own spreadsheets.
3
DeliverA hands-on day — everyone works in Excel from the first ten minutes, not on slides.
4
ApplyParticipants leave with their own working files, a cheat sheet and a follow-up Q&A session.

Why teams in Dubai book us

Training built around your files, not a generic curriculum

Most Excel courses teach features. We teach the work — the reports, reconciliations and dashboards your people actually have to deliver on Monday morning.

In Dubai and online

We come to your office anywhere in the UAE, or run the same programme live online for teams split across offices and time zones.

Beginner to advanced

Two clearly separated tracks, so nobody sits through material they already know and nobody gets left behind on day one.

Useful the next morning

Short inputs, long hands-on stretches and real company data. People go back to their desk and use it immediately.

Two tracks

Pick the level — or run both back to back

Many clients book the beginner track for one group and the advanced track for another in the same week. We keep the language, the shortcuts and the file conventions identical across both, so the whole team ends up working the same way.

Track 1 · Beginners

Confident with the everyday 80%

For people who use Excel daily but never learned it properly — and end up doing by hand what Excel could do in seconds.

  • Structure and format tables so they stay readable and reusable
  • Sort by several criteria, filter with AND / OR logic, freeze panes
  • Number formats: currency, dates, percentages — and why they matter
  • Cell references and the famous dollar sign, explained once and for good
  • First functions: SUM, AVERAGE, COUNT, IF, COUNTIF, SUMIF
  • Conditional formatting, heat maps and sparklines
  • Your first PivotTable — and when a PivotTable is the wrong tool
  • Clean, readable charts instead of the default blue bars
  • The 20 shortcuts that save the most time
Track 2 · Advanced

Modelling, lookups and analysis at speed

For analysts, finance, HR and operations people who already live in Excel and want to stop fighting it.

  • XLOOKUP, VLOOKUP / HLOOKUP and INDEX & MATCH with several criteria
  • Nested IF, IFERROR, SUMIFS, COUNTIFS and named ranges
  • Dynamic arrays: UNIQUE, FILTER, SORT and spill ranges
  • PivotTables that hold up: slicers, calculated fields, clean source data
  • Date and working-day calculations across projects and rosters
  • Goal Seek, data tables and break-even analysis
  • FORECAST, TREND and SUMPRODUCT for planning and scenarios
  • Auditing and protecting models so others cannot break them
  • Advanced chart types: waterfall, bridge, Gantt, dot plot and slope charts

What we cover

Three areas, assembled to fit your group

This is the full catalogue. In a one-day training we cover a focused selection; over two days we go deep. You tell us the use cases, we tell you honestly what fits in the time.

Data & tables

Getting messy data into shape and finding the answer inside it.

Table formatting best practiceTransposing tablesBulk calculations on a columnSearching within tablesFreezing rows and columnsMoving columns quicklyHiding gridlinesMulti-level sortingAND / OR filtersLocking cellsHiding rows and columnsCurrency, date and percent formatsComparing two tablesFinding and removing duplicatesMerging tablesConditional formattingIcon sets and heat mapsSparklinesFormat PainterAutoFillCell references and the dollar signImporting data from PDFProtecting sheets and workbooksPivotTablesTime-saving shortcutsDropdown listsNamed rangesLinking images to cells

Formulas & functions

The calculations that do the work while you do something else.

IFNested IFAND / ORConditional formatting with formulasDate calculationsNETWORKDAYSCOUNTIFCOUNTIFSLEFT / RIGHT / MIDLEN / COUNT / COUNTACONCATText to ColumnsISBLANKUNIQUESUBTOTALINDEX & MATCHData validation dropdownsFREQUENCYVLOOKUP & HLOOKUPXLOOKUPMulti-criteria lookupsGoal SeekData tables & break-evenFORECASTTRENDSUMPRODUCTSUMIFSUMIFSFormula auditingIFERROR

Charts & visualisation

Charts that make the point instead of leaving the audience to hunt for it.

  • Design principles and techniques that direct your audience's attention
  • How to choose the right chart type for your data
  • Adapting charts so the message lands immediately
  • Building the most common cases: before-and-after comparisons, distributions
  • High-impact chart types: bridge charts, Gantt charts, integrated bar charts, dot plots, waterfalls and slope charts

Formats

However it fits your calendar

Groups of 6 to 12 work best — small enough that we can look over every shoulder, large enough to keep the energy up. All sessions are delivered in English.

In-company in DubaiOne or two days at your office. We arrive with the exercises already rebuilt around your own files and reporting logic.
Live onlineThe same programme in four half-day blocks, scheduled in Gulf Standard Time. Ideal for teams spread across the UAE, KSA and Europe.
Lunch & LearnFocused 90-minute sessions on one theme — PivotTables, XLOOKUP or charts — to keep momentum after the main training.

References

Trusted by more than 600 corporate clients

A selection of the organisations that have booked SkillDay trainings.

Joern Steinz, Excel trainer and founder of SkillDay

Your trainer

Joern Steinz (MBA)

Founder & CEO, SkillDay

Your Excel trainer is SkillDay founder and CEO Joern Steinz (MBA), a graduate of EADA Business School in Barcelona. He spent years living inside Excel — first as a management consultant at Accenture, then in corporate development at XING AG and Freenet Group. Since 2014 he has been passing on his best Excel techniques in hands-on, genuinely entertaining seminars, and SkillDay has grown into a network of experienced trainers delivering across Europe, the Gulf and online.

Happy to answer any question about the Dubai training directly — call 0049 175 566 4329 or write to jsteinz@skillday.com.

2014Delivering seminars since
600+Corporate references
EN / DETraining languages

Where we deliver

Dubai, the wider Gulf, and anywhere online

We travel to your team. In-company sessions run at your own office, in a hotel meeting room or a co-working space — whatever suits the group. Beyond the Gulf, SkillDay trainings run regularly out of ten European locations.

DubaiAbu DhabiSharjahAcross the UAEWider GCC on requestLive onlineHamburgBerlinMunichFrankfurtCologneDuesseldorfStuttgartHanoverViennaZurich

Good to know

Questions we get asked before booking

How long does an Excel training take?

Most groups book one full day per track. Two days give room to work through the advanced lookup and modelling material properly. Online, we split the same content into four half-day blocks so nobody loses a full working day.

What if our people are at very different levels?

That is the usual situation, and it is exactly why we split into two tracks. Before the training we send a short skills check, then group people accordingly — or run the beginner track in the morning and the advanced track on the following day.

Do you work with our own spreadsheets?

Yes, and we prefer it. Send us two or three typical files in advance and the exercises get rebuilt around them. Participants leave with working versions of their own reports, not a folder of sample data.

Which version of Excel do you teach?

Whatever your team uses. We cover Microsoft 365 and Excel 2019 or later, on Windows and Mac, and we flag where a shortcut or function differs between them.

Is the training delivered in English?

Yes. All sessions in Dubai are held in English. German is available for teams that prefer it.

What happens after the training day?

Everyone gets the exercise files, a cheat sheet of the shortcuts and functions covered, and a follow-up Q&A session a few weeks later — the point at which the real questions usually surface.

Get in touch

Tell us who is in the room — we will send you a tailored proposal

One short call is usually enough for us to understand the group, the level and the use cases. You get a concrete programme and a date — no obligation attached.

Joern is often in workshops during the day, so email or the form is the fastest route. You will hear back within 24 hours — or call 0049 175 566 4329.

SkillDay
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.