---
title: Excel for Analysts | Pellam Institute (Almanac demo)
description: Formulas, pivot tables and clean models, with exercises you can reuse at work.
---
[Skip to content](https://www.airdatethemes.com/programmes/excel-for-analysts#main-content)
[](https://www.airdatethemes.com/almanac?hsLang=en)
Open the menu
- Programmes
[View all](https://www.airdatethemes.com/programmes?hsLang=en)
- Dates
- [All dates](https://www.airdatethemes.com/dates?hsLang=en)
- [Calendar](https://www.airdatethemes.com/calendar?hsLang=en)
- [Events](https://www.airdatethemes.com/events?hsLang=en)
- [London campus](https://www.airdatethemes.com/london?hsLang=en)
[View all](https://www.airdatethemes.com/dates?hsLang=en)
- [For teams](https://www.airdatethemes.com/for-teams?hsLang=en)
- [Pricing](https://www.airdatethemes.com/pricing?hsLang=en)
- About
- [Our story](https://www.airdatethemes.com/about?hsLang=en)
- [Instructors](https://www.airdatethemes.com/instructors?hsLang=en)
- [Student stories](https://www.airdatethemes.com/stories?hsLang=en)
- [Help centre](https://www.airdatethemes.com/help?hsLang=en)
- [Contact](https://www.airdatethemes.com/contact?hsLang=en)
[View all](https://www.airdatethemes.com/about?hsLang=en)
[Enrol](https://www.airdatethemes.com/enrol?hsLang=en)
# Excel for Analysts
Formulas, pivot tables and clean models, with exercises you can reuse at work.
[See dates and enrol](https://www.airdatethemes.com/programmes/excel-for-analysts#dates) [Download the syllabus](https://www.airdatethemes.com/programmes/excel-for-analysts#syllabus)
Tuition
Next start
Where
Duration
Format
Level
Teaching
Certificate
Enrol by
Overview
## What you will be able to do
About fifteen hours, at your own pace. You build clean, reusable spreadsheet models with the formulas and pivot tables analysts use every day, with exercises based on real business files.
- Write formulas that stay correct
- Summarise data with pivot tables
- Build models others can follow
- Check your work before you share it
Next start
- **0**days
- **00**hours
- **00**min
- **00**sec
[Enrol for this date](https://www.airdatethemes.com/programmes/excel-for-analysts#enrol) About the programme
No date is open for enrolment right now.
Curriculum
## Fifteen hours, three parts
3 modules 15 hours of teaching
1. Part 1 Formulas that last 5 h
- Lookups and references
- Conditional formulas
- Dates and text
OutcomeYou will fix a broken spreadsheet.
2. Part 2 Pivot tables 5 h
- Summaries and filters
- Grouping by date
- Charts from pivots
OutcomeYou will turn raw data into a monthly report.
3. Part 3 Clean models 5 h
- Inputs, calculations, outputs
- Checks and error handling
- Sharing safely
OutcomeYou will build a model a colleague can use.
Dates
## Choose your date
Each date has its own place, schedule and seats. The early-bird price ends by itself.
DatesPlaceStatusPrice
**No dates are planned yet.**
Leave your email below and we will write as soon as the next dates are set.
Tuition
per person, all taxes included
[Enrol](https://www.airdatethemes.com/programmes/excel-for-analysts#enrol)
- All live classes and their recordings
- Feedback on every project from a working analyst
- Two career coaching sessions
- Professional certificate
Pay in full, in 3 monthly instalments, or ask us to invoice your employer.
**Funding:**
Instructors
## People who do the work, then teach it
- AO
### Amara Osei
Lead, Data & AI
Nine years as an analyst in retail and public health. Designed our SQL and Python programme and still teaches the SQL weeks.
- SQL
- Python
- Statistics
- JB
### Jonas Brandt
UX researcher, Berlin
Runs research for a public transport app used by two million people. Teaches interviews and usability testing on campus in Berlin.
- Interviews
- Usability testing
- Synthesis
- PR
### Priya Raman
Product lead
Led product teams at two fintech companies in London and Toronto. Brings a real product brief to every cohort.
- Discovery
- Roadmaps
- Prioritisation
- DO
### Daniel Okafor
Leadership coach
Former engineering manager, now a coach for first-time managers. Hosts the one-to-one and feedback sessions.
- One-to-ones
- Feedback
- Delegation
Students
## In their words
- > I already used spreadsheets every day. The SQL weeks changed how I work: I now pull my own numbers instead of waiting two days for them.
SM Sofia Marin Data analyst, now at a logistics company Data Analysis with SQL and Python, 2026
- > Day three, we tested our prototype with real participants. It was uncomfortable and it was the most useful day of the week.
TN Tomasz Nowak Product designer, Berlin UX Research in Practice, 2025
- > I came for the frameworks and stayed for the other managers in my group. Eight of us still meet once a month.
GA Grace Adeyemi Engineering manager, Toronto New Manager Programme, 2025
## Download the full syllabus
Twelve pages: every week, every project, the tools you will use and what past students built.
PDF · 12 pages · 2.4 MB
[Download the PDF](https://www.airdatethemes.com/hubfs/airdate-demo/almanac/almanac-sample-syllabus.pdf?hsLang=en)
Questions
## Before you enrol
Still unsure? [Write to an advisor](https://www.airdatethemes.com/contact?hsLang=en): we answer within one working day.
### Enrolment and funding
How do I enrol?
Pick a date on the programme page and fill in the application form. An advisor calls you within two working days to check the programme fits. You then confirm your seat with a deposit.
Can my employer pay for the programme?
Yes. Most of our students are funded by their employer. We can send an invoice, accept a purchase order, and give you a syllabus and a training agreement for your manager.
Ask your advisor for the employer pack.
Can I get a refund?
You get a full refund if you cancel up to 14 days before the start date. After that, we refund half the fee until the end of the first week, or move you to a later cohort at no cost.
### During the programme
How many hours a week should I plan for?
About ten hours a week for part-time programmes: two live evening classes, plus exercises in your own time. On-campus days in London, Berlin and Toronto are listed with each date.
What if I miss a class?
Every live class is recorded and posted the same evening. Watch it, do the exercise, and bring your questions to the weekly office hour. If you miss more than three classes, we can move you to the next cohort.
Do I get a certificate?
Yes. You receive a Pellam Institute certificate when you attend at least 80% of the classes and hand in the final project. It lists the hours and the skills covered.
## Enrol
Pick a date, leave your details, and an advisor confirms your seat within one working day. Nothing to pay yet.
Questions first? [Read the FAQ](https://www.airdatethemes.com/programmes/excel-for-analysts#faq) or book a 15-minute call with an advisor.
Choose your date
No date is open for enrolment right now. Leave your details and we will write when the next one opens.
Keep exploring
## Other programmes
No programme matches these filters.
[Enrol](https://www.airdatethemes.com/programmes/excel-for-analysts#enrol)
## All programmes
Data & AI
- [Data Analysis with SQL and Python](https://www.airdatethemes.com/programmes/data-analysis-sql-python?hsLang=en)
- [Applied Machine Learning](https://www.airdatethemes.com/programmes/applied-machine-learning?hsLang=en)
- [Analytics for Managers](https://www.airdatethemes.com/programmes/analytics-for-managers?hsLang=en)
- [Excel for Analysts](https://www.airdatethemes.com/programmes/excel-for-analysts?hsLang=en)
Product & Design
- [Product Management Foundations](https://www.airdatethemes.com/programmes/product-management-foundations?hsLang=en)
- [UX Research in Practice](https://www.airdatethemes.com/programmes/ux-research-in-practice?hsLang=en)
- [Service Design Sprint](https://www.airdatethemes.com/programmes/service-design-sprint?hsLang=en)
Leadership
- [New Manager Programme](https://www.airdatethemes.com/programmes/new-manager-programme?hsLang=en)
- [Negotiation Masterclass](https://www.airdatethemes.com/programmes/negotiation-masterclass?hsLang=en)
[](https://149405016.hs-sites-eu1.com/en/growth-sessions?hsLang=en)
Short, practical programmes taught by people who do the work. Online and on campus in London, Berlin and Toronto.
hello@example.com
+44 20 0000 0000
- [Linkedin](https://www.linkedin.com/)
- [Youtube](https://www.youtube.com/)
- [Instagram](https://www.instagram.com/)
- Accueil
- Produits
- Tarification
- Blog
- Entreprise
© 2026 Your organisation. All rights reserved.
- Accueil
- Produits
- Tarification
- Blog
- Entreprise
```json
{
"@context" : "https://schema.org",
"@type" : "FAQPage",
"mainEntity" : [ {
"@type" : "Question",
"acceptedAnswer" : {
"@type" : "Answer",
"text" : "Pick a date on the programme page and fill in the application form. An advisor calls you within two working days to check the programme fits. You then confirm your seat with a deposit.
"
},
"name" : "How do I enrol?"
}, {
"@type" : "Question",
"acceptedAnswer" : {
"@type" : "Answer",
"text" : "Yes. Most of our students are funded by their employer. We can send an invoice, accept a purchase order, and give you a syllabus and a training agreement for your manager.
Ask your advisor for the employer pack.
"
},
"name" : "Can my employer pay for the programme?"
}, {
"@type" : "Question",
"acceptedAnswer" : {
"@type" : "Answer",
"text" : "You get a full refund if you cancel up to 14 days before the start date. After that, we refund half the fee until the end of the first week, or move you to a later cohort at no cost.
"
},
"name" : "Can I get a refund?"
}, {
"@type" : "Question",
"acceptedAnswer" : {
"@type" : "Answer",
"text" : "About ten hours a week for part-time programmes: two live evening classes, plus exercises in your own time. On-campus days in London, Berlin and Toronto are listed with each date.
"
},
"name" : "How many hours a week should I plan for?"
}, {
"@type" : "Question",
"acceptedAnswer" : {
"@type" : "Answer",
"text" : "Every live class is recorded and posted the same evening. Watch it, do the exercise, and bring your questions to the weekly office hour. If you miss more than three classes, we can move you to the next cohort.
"
},
"name" : "What if I miss a class?"
}, {
"@type" : "Question",
"acceptedAnswer" : {
"@type" : "Answer",
"text" : "Yes. You receive a Pellam Institute certificate when you attend at least 80% of the classes and hand in the final project. It lists the hours and the skills covered.
"
},
"name" : "Do I get a certificate?"
} ]
}
```