RC 9868954 · Registered with the Corporate Affairs Commission 0815 352 8844 · admin@myndtechsys.com

Training

Excel skills your team uses the same day

A pre-recorded beginner-to-master Excel course covering data entry, formulas, analysis and dashboards, plus in-house staff training.

The course

Excel: beginner to master

Pre-recorded lessons you can watch at your own pace, with practice files for every day and a final project built on real business data.

Week 1

Foundations

Workbook layout, data entry, formatting, tables, sorting and filtering, data validation and protecting sheets.

Week 2

Formulas that matter

SUM to SUMIFS, COUNTIFS, IF and IFERROR, text and date functions, absolute references and named ranges.

Week 3

Analysis

VLOOKUP, INDEX/MATCH, PivotTables, removing duplicates, cleaning messy data and reconciling two lists.

Week 4

Reporting & dashboards

Charts, conditional formatting, KPI tiles, a one-page dashboard and a final project with your own data.

Who it’s for

Practical skills for work

Built by people who use Excel every day for audits, reconciliations and dashboards, so every lesson is something you will use at work.

Join the next class
  • Admin, accounts and sales staff
  • Business owners who want to read their own numbers
  • Job seekers who need Excel on their CV
  • Teams that need in-house training: we come to you or train online
  • Practice files and templates you keep

Questions

Excel & data training: FAQ

Is the course live or recorded?

The main course is pre-recorded, so you learn at your own pace. You can send questions on WhatsApp as you go.

Do I need any experience?

No. Week 1 starts from the basics. If you already know the basics you can move straight to Week 2.

Can you train my whole team?

Yes. We run in-house sessions, on site or online, built around your own templates and reports.

Have a project or a problem in your numbers?

Tell us what you need. We reply on WhatsApp with clear next steps and a written quote.

Chat with us