Excel, Data Analysis & AI for Business

Planned curriculum

8 lessons in teaching order. Lessons open when the course launches, once their faculty-led teaching videos are recorded and verified.

1. 01Frame the business question and inspect the data

   • Define grain, units and a decision before analysis
   • Reconcile a source extract against a control total
2. 02Clean text, types and duplicates without losing evidence

   • Normalise labels and numeric types
   • Keep an explicit cleaning log and control totals
3. 03Build and test formulas with AI assistance

   • Use relative and absolute references correctly
   • Test formula suggestions against hand calculations
4. 04Summarise with PivotTables and reconcile the result

   • Build a PivotTable from clean tabular data
   • Detect Count versus Sum and stale source ranges
5. 05Prevent entry errors with validation and exception checks

   • Create and test a category dropdown
   • Explain the limits of validation
6. 06Choose charts and distinguish growth from causation

   • Choose a chart for a defined comparison
   • Calculate growth without implying causation
7. 07Model a decision with explicit assumptions

   • Separate observed data from scenario assumptions
   • Calculate break-even and sensitivity

Resources included at launch

4 resources, provided inside the course once it opens.

• Business sales practice workbook

  Fictional raw extract, checked source, formula summaries, entry dropdown and answer key. Build the PivotTable yourself.

  EXCEL WORKBOOK
• Formula testing sheet

  Expected and observed formula results with worked normal and boundary cases.

  EXCEL WORKBOOK
• Scenario model

  Editable assumptions, break-even and attendance sensitivity. Fictional teaching figures.

  EXCEL WORKBOOK
• Analysis audit and decision memo

  Cleaning log, reproducibility checklist, memo outline and explained capstone rubric.

  PDF DOCUMENT

Downloads are not available from this page.

Quick answers

Can I take Excel, Data Analysis & AI for Business now?

Not yet. It is Coming soon: the faculty-led teaching videos are still being prepared, and purchases are not open.

Who is it for?

Analysts, managers and professionals who work with spreadsheets.

How will it be taught?

Each lesson is planned as a faculty-led video with a short written summary, hands-on practice, a quiz and resources. The full written lesson text stays internal.

What device do I need?

You can read lessons and plan your work on a phone, but some exercises need a computer with desktop software such as a spreadsheet, document or presentation editor.

How does access work?

Courses are a one-time purchase with lifetime access to the content included when you buy. It is not a subscription, and it does not include courses released later unless they are named in what you bought.

Is there a certificate?

Students who mark every lesson complete can receive a certificate of completion. It confirms completion; it does not certify assessed practical competence.

Learning resources for every course are listed on the Learning Resources page, and you can read more about how AcademyGen teaches.