Udemyintermediatepl

MS Excel - praktyczne funkcje i proste tabele przestawne

Excel course: master popular features in just 1.5 hours! Learn essential skills for data management and analysis. Perfect for beginners.

4.4(6)
23students
1h 35m
Certificate
Paulina Klama
Paulina KlamaSkuteczna Edukacja IT

Course Content

MS Excel - praktyczne funkcje i proste tabele przestawne is an intermediate-level Udemy course taught by Paulina Klama. It runs 1h 35m, is taught in Polish, and includes a certificate of completion. Learners rate it 4.4 out of 5 from 6 reviews, with 23 students enrolled. It is a paid course, last updated November 2023.

  • Boost Your Productivity with MS Excel: Practical Functions & Pivot Tables

This course is designed for office workers looking to streamline and accelerate their daily tasks using powerful MS Excel functions and simple pivot tables. It's also ideal for anyone wanting to delve into data analysis and reporting.

Forget dry theory! We focus on practical application. This training is divided into 3 sections, each containing video recordings with hands-on exercises.

In each video, I'll show you the Excel screen and walk you through each step, explaining how each function or option works.

What you'll get:

  • 3 Excel Files:
    1. The Excel file used in the demonstrations, so you can follow along.
    2. A task list detailing all covered exercises, with hints and extra challenges for you to practice.
    3. A helpful presentation with 20 slides covering functions, tables, and screenshots.

Master Essential Excel Functions:

Gain confidence with key functions like:

  • VLOOKUP: Efficiently search for data vertically.
  • IFERROR: Handle errors gracefully.
  • IF: Make decisions based on conditions.
  • COUNTIF: Count cells based on criteria.
  • COUNTIFS: Count cells based on multiple criteria.
  • SUMIF: Sum values based on criteria.
  • SUMIFS: Sum values based on multiple criteria.
  • AVERAGEIF: Calculate the average based on criteria.
  • AVERAGEIFS: Calculate the average based on multiple criteria.

Create Simple Pivot Tables:

Learn to build effective pivot tables:

  • Properly position fields within the table areas.
  • Customize the layout of your pivot tables.
  • Discover other useful pivot table tips and tricks!

My courses are delivered in a clear, easy-to-understand language, ensuring you absorb maximum knowledge and can immediately apply it to your work.

Enroll now and unlock the power of Excel!

$ whoami — the devs behind tutorialsearch.io

Need a web app built? Hire the team behind TutorialSearch.io

We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.

4.9(24)
2h 2m
all

SQL Top 100: Praktyczne zadania

by Rafał Podraza - Testowanie Oprogramowania

4.9(188)
2h 1m
all
4.9(435)
5h 2m
intermediate

54 praktyczne rady z języka Python

by Videopoint Grupa Helion

4.9(87)
10h 24m
intermediate

Excel SuperHero

by Adam Kopeć

4.9(2,371)
20h 53m
all