---
title: Excel for Analysts | Pellam Institute (Almanac Lite demo)
description: Formulas, pivot tables and clean models, with exercises you can reuse at work. Almanac Lite theme demo for HubSpot.
---
[Skip to content](https://www.airdatethemes.com/almanac-lite/programmes/excel-for-analysts#main-content)
[](https://www.airdatethemes.com/almanac-lite?hsLang=en)
Open the menu
- [Programmes](https://www.airdatethemes.com/almanac-lite/programmes?hsLang=en)
- [Dates](https://www.airdatethemes.com/almanac-lite/dates?hsLang=en)
- About
- [Our story](https://www.airdatethemes.com/almanac-lite/about?hsLang=en)
- [Contact](https://www.airdatethemes.com/almanac-lite/contact?hsLang=en)
[Enrol](https://www.airdatethemes.com/almanac-lite/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/almanac-lite/programmes/excel-for-analysts#dates) [Ask an advisor](https://www.airdatethemes.com/almanac-lite/contact?hsLang=en)
Tuition
Next start
Where
Duration
Format
Level
Teaching
Certificate
Enrol by
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. Past dates leave the list on their own.
DatesPlaceStatusPrice
**No dates are planned yet.**
Leave your email below and we will write as soon as the next dates are set.
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
Questions
## Before you enrol
Still unsure? [Write to an advisor](https://www.airdatethemes.com/almanac-lite/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 one working day 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/almanac-lite/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.
## All programmes
Data & AI
- [Data Analysis with SQL and Python](https://www.airdatethemes.com/almanac-lite/programmes/data-analysis-sql-python?hsLang=en)
- [Applied Machine Learning](https://www.airdatethemes.com/almanac-lite/programmes/applied-machine-learning?hsLang=en)
- [Analytics for Managers](https://www.airdatethemes.com/almanac-lite/programmes/analytics-for-managers?hsLang=en)
- [Excel for Analysts](https://www.airdatethemes.com/almanac-lite/programmes/excel-for-analysts?hsLang=en)
Product & Design
- [Product Management Foundations](https://www.airdatethemes.com/almanac-lite/programmes/product-management-foundations?hsLang=en)
- [UX Research in Practice](https://www.airdatethemes.com/almanac-lite/programmes/ux-research-in-practice?hsLang=en)
- [Service Design Sprint](https://www.airdatethemes.com/almanac-lite/programmes/service-design-sprint?hsLang=en)
Leadership
- [New Manager Programme](https://www.airdatethemes.com/almanac-lite/programmes/new-manager-programme?hsLang=en)
- [Negotiation Masterclass](https://www.airdatethemes.com/almanac-lite/programmes/negotiation-masterclass?hsLang=en)
[](https://www.airdatethemes.com/almanac-lite?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/)
- [Programmes](https://www.airdatethemes.com/almanac-lite/programmes?hsLang=en)
- [Dates](https://www.airdatethemes.com/almanac-lite/dates?hsLang=en)
- [About](https://www.airdatethemes.com/almanac-lite/about?hsLang=en)
- [Our story](https://www.airdatethemes.com/almanac-lite/about?hsLang=en)
- [Contact](https://www.airdatethemes.com/almanac-lite/contact?hsLang=en)
© 2026 Pellam Institute. All rights reserved.
- [Privacy](https://www.airdatethemes.com/privacy?hsLang=en)
- [Terms](https://www.airdatethemes.com/terms?hsLang=en)
```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 one working day 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?"
} ]
}
```