Demo storeTry this store's admin panel without an account; orders are in test mode.Open the panel
Vitrin
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.

In stock

Secure checkout

  • Visa
  • Mastercard
  • Troy
  • American Express
  • Cash on delivery
  • 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

InstructorKerem Aydemir — Builds web interfaces and likes putting data into tables and explaining it plainly.
Lessons11 lessons
Total length2 h 25 min of video
LanguageTurkish
Access12 months from the payment confirmation
FormatVideo lessons, PDF notes and exercises
What you needA computer and any spreadsheet program; an up-to-date web browser and at least 5 Mbps internet.
PrerequisitesBeing able to open a spreadsheet program and type into a cell is enough.
Certificate of completionOur certificate of completion (PDF) when you finish; it is not an official diploma or qualification.
Learning outcomesClean messy data; conditional and lookup formulas; summaries with pivot tables; a one-page report
Sample lessonHow a table is laid out (10 min)
Module 1Preparing the data: How a table is laid out (10 min) · Cleaning the data (14 min) · Sorting and filtering (11 min)
Module 2Formulas: Sum and average (12 min) · Conditional formulas (15 min) · Lookup formulas (16 min)
Module 3Summarising: Intro to pivot tables (15 min) · Grouping and slicers (13 min) · Conditional formatting (11 min)
Module 4Showing 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 review
Write a review

Your review is published once the store has approved it.

Your rating
At least 10 characters.
Never published.
Give the number of an order placed with this email and your review carries the “Verified purchase” badge.
Up to 3 photos; JPEG, PNG or WebP, at most 5 MB each. Photos are published with your review once it is approved; details such as the location are removed.

Questions and answers

No questions about this product yet.

Ask a question
We'll let you know by e-mail when it is answered. Your address is never shown.

You may also like