About this course
Clean data, build reports and automate repetitive office work by pairing Excel with AI assistants.
This is a focused 2-week bootcamp - short, intensive and built to give you one job-ready skill fast. It runs online in the August 2026 cohort (starting 1 August 2026) and is taught the EchoLens way: you learn by doing real, gradeable work rather than just watching lectures.
What's included
- Live, instructor-led online sessions across 2 weeks (8 hours total).
- Hands-on coding quests you solve inside the EchoLens browser compiler - nothing to install.
- Gems, stages and a leaderboard that keep you moving instead of grade anxiety.
- A verified certificate with a scannable QR code, ready to share on LinkedIn, when you finish.
- The first week is open free so you can try the course before you pay.
What you will learn
Course learning outcomes
By the end of this course, you will be able to:
- CLO 1. Clean, sort, filter and analyse data in Excel using core formulas, PivotTables and dashboard charts.
- CLO 2. Use AI to write, fix and explain formulas, and to accelerate data cleanup and text tasks.
- CLO 3. Build a repeatable, AI-assisted monthly reporting workflow that replaces a full day of manual work.
Course outline - class by class
8 classes, each with hands-on quests you clear in the portal - the whole first week is open free.
- Class 1. Taming your data - Raw data into a clean table: sorting, filtering, freezing panes and conditional formatting
- Class 2. The formulas that pay off - SUM and AVERAGE, IF for decisions, XLOOKUP across sheets, COUNTIF/SUMIF and joining text
- Class 3. PivotTables - Rows, columns and values, grouping dates and categories - reading a Pivot to answer a real question fast
- Class 4. Charts and a one-page dashboard - The right chart for the message, clean design, several charts on one page, and slicers for one-click filtering
- Class 5. Let AI write your formulas - Describe a calculation in plain English, get the exact formula back, fix errors and decode inherited formulas
- Class 6. AI for data cleanup and text - Standardising messy entries, splitting and combining fields, extracting pieces and categorising lists with AI
- Class 7. AI-assisted analysis and reporting - Paste the numbers, get the real insight: summaries, report narratives, chart advice - and sanity-check everything
- Class 8. Capstone: an AI-assisted monthly report - Every skill combined into one repeatable routine: raw data to a finished, sendable report in an hour
How you submit: Quests submitted as Excel workbooks, with an AI copilot linked to your uploaded sheet for in-context analysis and edits.
Your production end project
An Automated Monthly Business Report
A reusable workbook a manager reads in two minutes, refreshed by dropping in new data.
A complete, reusable monthly report that turns a month of raw data into a clean dashboard and a written summary, with Excel and AI working together - the exact deliverable an office professional hands a manager, or a freelancer hands a client, built to run again next month in an hour.
- ✓A cleaned, structured data sheet built from raw month data
- ✓Key metrics computed with formulas: totals, averages, lookups, and counts
- ✓At least two PivotTables that answer real questions
- ✓A one-page dashboard with three or more charts and a slicer
- ✓An AI-written summary and key findings section, sanity-checked against the numbers
- ✓A cover sheet and a short, send-ready manager email
- ✓Built so next month's data can be dropped in and the report refreshes
Shipped when: A finished workbook a manager could read in two minutes, that regenerates when new data is added, delivered with the send-ready email.
Who it's for
Excel + AI for Office Professionals suits learners at a beginner level who want a practical, project-based route into Excel + AI for Office Professionals. You need only a browser and an internet connection - all coding runs inside the EchoLens compiler, so there is nothing to set up.
Certificate
Finish every stage and EchoLens issues a verified certificate carrying a QR code anyone can scan to confirm it on our site. You can add it to your CV or share it to LinkedIn in one click.