1 / 2
NewWith certificate
Data analysis with spreadsheets
Formulas, pivot tables and readable charts
₺749
Taxes calculated at checkout · Digital delivery — no shipping
It is delivered by e-mail as soon as your payment is confirmed, so there is no right of withdrawal.
If it is faulty, we replace it or refund it.
Secure checkout
- Secure checkout · 3-D Secure
- Easy returns
- Local support
Description
You learn to read the spreadsheets you meet at work every day quickly and correctly: cleaning, formulas, conditional formatting, pivot tables and clear charts.
The exercise files use sales, stock and budget examples. Everything works in all common spreadsheet programs.
SKU: KAM-43-01-150
Product details
| Instructor | Kerem Aydemir — Builds web interfaces and likes putting data into tables and explaining it plainly. |
|---|---|
| Lessons | 11 lessons |
| Total length | 2 h 25 min of video |
| Language | Turkish |
| Access | 12 months from the payment confirmation |
| Format | Video lessons, PDF notes and exercises |
| What you need | A computer and any spreadsheet program; an up-to-date web browser and at least 5 Mbps internet. |
| Prerequisites | Being able to open a spreadsheet program and type into a cell is enough. |
| Certificate of completion | Our certificate of completion (PDF) when you finish; it is not an official diploma or qualification. |
| Learning outcomes | Clean messy data; conditional and lookup formulas; summaries with pivot tables; a one-page report |
| Sample lesson | How a table is laid out (10 min) |
| Module 1 | Preparing the data: How a table is laid out (10 min) · Cleaning the data (14 min) · Sorting and filtering (11 min) |
| Module 2 | Formulas: Sum and average (12 min) · Conditional formulas (15 min) · Lookup formulas (16 min) |
| Module 3 | Summarising: Intro to pivot tables (15 min) · Grouping and slicers (13 min) · Conditional formatting (11 min) |
| Module 4 | Showing it: Choosing the right chart (12 min) · A one-page report (16 min) |
Customer reviews
No reviews of this product yet. Be the first to write one.
Write a reviewWrite a review
Your review is published once the store has approved it.
Questions and answers
No questions about this product yet.









