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.
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
Course contents
6 modules · 30 lessons · 3h 3m
1
Basics and Data Structuring
Mastering the Excel interface and the golden rules for correct data entry.
- A Tour of the Excel Interface and Table Structure
Understanding the difference between a workbook, a sheet, and a table, and how to organize the workspace.6 min - Golden Rules for Data Entry
Learning how to enter data to avoid common mistakes later on.6 min - Relative Cell References
Understanding how Excel behaves when copying formulas.6 min - Locking Cells (Absolute References)
Using the $ sign to fix values in calculations.7 min - Basic Arithmetic Operations (SUM & COUNT)
Performing simple addition and counting operations.6 min
2
Essential Functions and Smart Lookup
Handling text and searching for data with high efficiency.
- Text Functions: Cleaning and Merging Data
Using LEFT, RIGHT, and CONCAT to organize text.6 min - Decision Making with the IF Function
Building simple logic for results based on conditions.6 min - Introduction to XLOOKUP
Searching for values in tables using a modern and simple method.7 min - Advanced XLOOKUP Techniques
Handling missing values and performing reverse lookups.6 min - Statistical Functions (AVERAGE, MIN, MAX)
Quick analysis of maximum, minimum, and average values.5 min - Working with Dates
Understanding how Excel processes dates and calculating time differences.6 min
3
Dynamic Arrays and Data Quality
Using modern tools to ensure data cleanliness and processing speed.
- The Concept of Dynamic Arrays
Understanding how results automatically spill into adjacent cells.6 min - Extracting Unique Values with UNIQUE
Getting a non-duplicate list with a single click.6 min - Automatically Filtering Data with FILTER
Creating sub-tables that update automatically based on a condition.7 min - Data Validation
Creating drop-down lists and preventing incorrect data entry.6 min - Conditional Formatting
Visually highlighting data based on its values.6 min
4
Data Automation with Power Query
Saving hours of repetitive work by automating data import and cleaning.
- What is Power Query and Why Do We Need It?
Understanding the tool's role in transforming data without affecting the source.5 min - Importing Data from Various Sources
Connecting Excel to CSV files or other tables.6 min - Automated Data Cleaning Steps
Removing empty rows and changing data types with a single click.7 min - One-Click Data Refresh
How to apply the same cleaning steps to new data in the future.5 min
5
Data Analysis with Pivot Tables
Turning thousands of rows into useful summaries in seconds.
- Preparing Data for a Pivot Table
Ensuring the table is ready for analysis (the headers rule).6 min - Creating Your First Pivot Table
Dragging and dropping fields to understand the numbers.6 min - Summarizing in Different Ways (Sum vs Count)
Changing how values are displayed within the Pivot Table.6 min - Grouping Data
Grouping dates into months or years within the analysis.6 min - Calculated Fields
Adding custom calculations within the Pivot Table.7 min
6
Dashboards and Visual Presentation
Presenting results professionally and interactively.
- Creating Pivot Charts
Converting Pivot Tables into dynamic charts.6 min - Using Slicers
Adding interactive buttons to filter reports easily.6 min - Designing the Dashboard
Arranging elements to create a professional user interface.7 min - Connecting Slicers to Multiple Charts
Making a single button control the entire dashboard.7 min - Final Touches and Sharing
Hiding gridlines and protecting the file for sharing.5 min
Integrated Sales System Project
You will import raw sales data for a fictional company, clean it using Power Query, use XLOOKUP and UNIQUE to organize it, and finally build an interactive dashboard displaying sales performance by region and product.
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
3h 3m of practical content
Certificate of completion
Every course you complete on PickAClass issues a credential like this — original, with its own code, verifiable by URL, and detailed about what was actually demonstrated.
Reviews (15)
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.
Я работаю в отделе закупок и постоянно готовлю таблицы для отчётов, но пользовалась в основном базовыми функциями типа СУММ и СРЗНАЧ. Курс подробно разбирает более полезные вещи вроде ВПР, ИНДЕКС и ПОИСКПОЗ, и что важно — на примерах, похожих на реальную офисную работу, а не на выдуманных данных. Раздел про сводные таблицы оказался самым ценным, я наконец поняла логику группировки данных и смогла сама построить отчёт по поставщикам за пару часов. Темп подачи местами быстроват, особенно когда объясняют вложенные формулы, пришлось пересматривать некоторые уроки дважды. В остальном материал очень практичный и сразу применимый в работе.
شرح جداول البيانات المحورية كان واضحًا جدًا وساعدني فعليًا في إعداد تقارير عملي.
Excelente para aprender tabelas dinâmicas.
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.
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.
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.
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.
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.
Курс объясняет сводные таблицы намного понятнее, чем всё, что я пробовала раньше, с реальными примерами отчётов. Особенно понравилось, как разбираются формулы вроде ВПР и СУММЕСЛИ на конкретных задачах, а не абстрактно. После пары уроков я уже смогла сама сделать отчёт по продажам для своего отдела.
Хорошо объясняет функции ВПР и сводные таблицы, но пара примеров показались слишком простыми для тех, кто уже знаком с Excel на базовом уровне.
Świetnie tłumaczy tabele przestawne.
पिवट टेबल अब बहुत आसान लगती है।
Learners also took
Excel Essentials: Formulas, Functions, and Data Analysis
Excel and Copilot Foundations for Modern Data Work
XML and XSLT: Beginner's Guide to Data Transformation
Excel Payroll Management and Financial Modeling
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.
Get 10 courses a month
Members get 10 courses of their choice every month for $0. No per-course charges — you pay only the subscription.
- ✓ 10 courses every month
- ✓ Cancel anytime
Renews monthly. Unused courses expire at the end of each billing month.