Курс объясняет сводные таблицы намного понятнее, чем всё, что я пробовала раньше, с реальными примерами отчётов. Особенно понравилось, как разбираются формулы вроде ВПР и СУММЕСЛИ на конкретных задачах, а не абстрактно. После пары уроков я уже смогла сама сделать отчёт по продажам для своего отдела.
Practical Excel: Core Functions and Pivot Tables
A step-by-step guide for office professionals to analyze data and create reports using essential functions, modern formulas, and Pivot Tables.
-
💬
AI instructor
Ask about any lesson and get a clear answer instantly, anytime. -
🕐
Start anytime
No schedules or deadlines — learn at your own pace, whenever suits you. -
🌐
In English
Lessons, tasks and certificate — all fully in your language.
About this course
Are you using Excel for basic tasks but feel overwhelmed by complex data and repetitive work? This course provides the practical skills you need to work faster and smarter. You will learn to organize, analyze, and present data effectively, transforming raw numbers into clear business insights. By the end, you'll be able to confidently tackle common data challenges in any office environment.
What you'll learn:
* Understand the fundamentals of spreadsheet structure, cell referencing, and data entry best practices.
* Master essential functions for calculations and text manipulation, including the modern XLOOKUP formula.
* Build interactive reports and dashboards from scratch using Pivot Tables and Pivot Charts.
* Apply conditional formatting and data validation to create clean, error-free, and user-friendly spreadsheets.
* Learn the basics of Power Query to automate the process of importing and cleaning data.
* Practice using dynamic array formulas like FILTER and UNIQUE to manipulate datasets with ease.
The course starts with foundational concepts and terminology before guiding you through practical examples of formulas, data analysis, and reporting techniques. This course is designed for beginners. No prior experience with advanced Excel features is necessary; all you need is a desire to improve your skills.
Enroll now to unlock the full potential of Excel for your career.
What you'll get
-
📜
Certificate of completion
Add it to your LinkedIn profile -
💬
Personal AI tutor
Stuck on a lesson? Ask your built-in tutor anything, any time. -
🎧
Audio version included
Learn on the go — no screen needed -
♾️
Lifetime access
Come back anytime, no expiry -
📱
Phone or computer
Works anywhere, any device -
💸
14-day refund
No questions asked -
⚡
Short & focused
2h 36m of practical content
Reviews (15)
Excelente para aprender tabelas dinâmicas.
पिवट टेबल अब बहुत आसान लगती है।
Der Kurs erklärt Pivot-Tabellen so anschaulich, dass ich sie zum ersten Mal wirklich verstanden habe. Die Übungen basieren auf realistischen Beispielen wie Verkaufsdaten und Lagerbeständen, was das Ganze viel greifbarer macht. Ich konnte die Techniken schon am nächsten Tag für einen eigenen Bericht nutzen.
This finally made pivot tables make sense to me after years of just avoiding them at work. The examples walk through realistic scenarios like sales tracking and monthly reporting instead of generic filler data. I put together a report for my manager the same week I finished the course and it took a fraction of the time it used to.
I've used Excel casually for years but always avoided pivot tables because they seemed more complicated than they needed to be. This course breaks the whole process down starting with how to structure your raw data properly, which honestly fixed half my problems before I even got to the pivot table part. The walkthroughs on VLOOKUP and INDEX/MATCH are clear and use realistic office scenarios like tracking expenses and sales by region rather than throwaway example data. By the third lesson I was building a working sales report for my own team, and it actually looked professional. The pacing is steady enough that I never felt lost, even in the section on nested formulas. This is the first time pivot tables have actually clicked for me instead of just intimidating me.
I'd been faking my way through spreadsheets for years, copying formulas without really understanding them. This course finally made functions like VLOOKUP and INDEX-MATCH click for me, and the pivot table lessons were a revelation. I now build monthly reports that used to take me a full afternoon in well under an hour. The step-by-step approach meant I never felt lost, even with the newer dynamic formulas. Each module built logically on the last, which kept me motivated. Honestly the best practical Excel training I've done for office work.
Eu trabalho no setor administrativo há alguns anos e sempre me virei com o básico do Excel, mas nunca tinha usado tabelas dinâmicas de verdade. Esse curso explica cada função com calma, mostrando primeiro o problema real que ela resolve antes de entrar na parte técnica. A seção sobre criar relatórios com tabelas dinâmicas foi a que mais me ajudou, porque eu literalmente apliquei no relatório mensal da minha equipe na mesma semana. O ritmo é bom, nem muito lento nem corrido demais, e dá pra acompanhar fazendo os exercícios junto. Também gostei que os exemplos usam planilhas parecidas com as que a gente realmente usa no trabalho, tipo controle de vendas e estoque. Terminei o curso me sentindo bem mais confiante para montar relatórios sozinha.
Хорошо объясняет функции ВПР и сводные таблицы, но пара примеров показались слишком простыми для тех, кто уже знаком с Excel на базовом уровне.
Я работаю в отделе закупок и постоянно готовлю таблицы для отчётов, но пользовалась в основном базовыми функциями типа СУММ и СРЗНАЧ. Курс подробно разбирает более полезные вещи вроде ВПР, ИНДЕКС и ПОИСКПОЗ, и что важно — на примерах, похожих на реальную офисную работу, а не на выдуманных данных. Раздел про сводные таблицы оказался самым ценным, я наконец поняла логику группировки данных и смогла сама построить отчёт по поставщикам за пару часов. Темп подачи местами быстроват, особенно когда объясняют вложенные формулы, пришлось пересматривать некоторые уроки дважды. В остальном материал очень практичный и сразу применимый в работе.
شرح جداول البيانات المحورية كان واضحًا جدًا وساعدني فعليًا في إعداد تقارير عملي.
Trabalho com relatórios financeiros há um tempo, mas sempre dependia de colegas para montar tabelas dinâmicas mais complexas. Esse curso resolveu isso de um jeito bem direto, explicando cada etapa desde a organização dos dados até a criação do relatório final. O que mais gostei foi a parte sobre funções como PROCV e ÍNDICE combinadas com CORRESP, porque mostram como resolver problemas que eu via no trabalho quase toda semana. Os exercícios usam bases de dados que parecem reais, tipo controle de vendas por região, então dá pra praticar em algo próximo do que eu realmente faço. Consegui montar um relatório completo sozinha logo depois de terminar o módulo de tabelas dinâmicas. Foi a primeira vez que essas funções realmente fizeram sentido pra mim.
Explica las tablas dinámicas paso a paso de una forma tan clara que pude armar mi primer informe de ventas sin ayuda de nadie.
Kurs bardzo dobrze tłumaczy tabele przestawne krok po kroku, na przykładach zbliżonych do prawdziwej pracy biurowej. Podobał mi się fragment o łączeniu funkcji WYSZUKAJ.PIONOWO z tabelami przestawnymi przy tworzeniu raportów sprzedażowych. Po ukończeniu kursu sama zrobiłam raport dla swojego zespołu bez pomocy kolegów.
Świetnie tłumaczy tabele przestawne.
Learners also took
💼 Job-ready
🎓 With certificate
Excel Essentials: Formulas, Functions, and Data Analysis
Certificate
Hands-on
300,00 Kč
→
💼 Job-ready
🎓 With certificate
Excel and Copilot Foundations for Modern Data Work
Certificate
Hands-on
300,00 Kč
→
💼 Job-ready
🎓 With certificate
XML and XSLT: Beginner's Guide to Data Transformation
Certificate
Hands-on
300,00 Kč
→
🔥 Hot
🎓 With certificate
Excel Payroll Management and Financial Modeling
Certificate
Hands-on
300,00 Kč
→
Frequently asked
What do I need to take this course? +
Just a phone or computer with internet. No installs, no special hardware.
How do I pay? +
By card via Stripe. We don’t store card details — Stripe handles them securely.
Can I get a refund? +
Yes — full refund within 14 days, no questions asked.
How long will I have access? +
Forever. Once you purchase, the course is yours to revisit anytime.
Will I get a certificate? +
Yes. On completion you'll receive a certificate you can add to your LinkedIn profile.
Built for learners in
Tech
Design
Finance
Marketing
Healthcare
Education
Hospitality
Manufacturing