Everyday skills

AI for spreadsheets and data: formulas, cleaning and charts

Formulas, cleaning, analysis and charts with an AI assistant

Use AI to write formulas, clean messy data, analyse and chart it, then check the results and keep sensitive data safe.

  • 20 min
  • 6 lessons
  • 8 question quiz
  • Certificate of completion
  • AR | EN
Pay withmadaApple PayVisaMastercard
  • WhatsApp support in Arabic
  • Certificate of completion
  • Arabic and English
  • Secure card payment

What you will learn

Six short lessons, then a quiz

  1. 1Lesson 1What AI can and cannot do with your data
  2. 2Lesson 2Formulas without the fear
  3. 3Lesson 3Cleaning messy data
  4. 4Lesson 4Analysis and questions
  5. 5Lesson 5Charts and the story
  6. 6Lesson 6Checking and data safety
  7. Knowledge check8 questions. Pass mark 80%. Try again as often as you need.

20 minutes

Short enough for one sitting, on phone or laptop.

8 question quiz

Pass mark 80%, with feedback on every answer.

Certificate of completion

With your name, the course and a unique number.

What you take away

The six things to remember

  • Fast, not certainAI explains, suggests formulas, spots patterns and drafts charts. It does not know your business rules and it can mis-sum. Every figure is a draft until you have checked it.
  • Describe, then testSay what is in which column and the result you want. Ask for the formula and a plain English explanation. Test it on rows you can check by hand.
  • Clean in orderCopy saved, rows counted, names and dates standardised, duplicates removed, count compared, rows spot checked.
  • Ask for the workingOne checkable question at a time, business rules stated, columns and calculation shown. Causes come from people.
  • One chart, one pointBars compare, lines show change, scatter shows a relationship, a big number stands alone. The title states the finding. No chart junk.
  • Check, then shareReconcile totals, spot check rows, traffic light the whole file, strip personal data, keep versions, involve finance when it matters.

Who it is for

  • Anyone who works in Excel or Google Sheets
  • People who clean, analyse or chart data for reports
  • Staff who avoid formulas and want help writing them

Questions about this course

How long does the course take?

About 20 minutes: 6 short lessons and a 8 question quiz. You can stop and pick up where you left off.

What certificate do I get?

A certificate of completion with your name, the course title, the date and a unique number, once you score 80% in the quiz. It is a certificate of completion from Capytech, not a government accredited qualification.

How much is it?

SAR 49, paid once. Or take every course with All Access for SAR 399 a year.

Do I need a particular AI tool?

No. The skills work in any mainstream assistant, such as ChatGPT, Microsoft Copilot, Gemini or Claude. Use the one your organisation allows.

Is it in Arabic or English?

Both. You get the full Arabic edition and the full English edition, and you can switch between them.

WhatsAppArabic or English