As aulas sobre tabelas dinâmicas são bem práticas, só senti que a parte de fórmulas mais avançadas podia ter mais exemplos.
Essential Excel Skills: Functions and Pivot Tables
Learn to organize, analyze, and report on data efficiently using essential formulas and Pivot Table features for your daily office tasks.
-
💬
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
Feeling overwhelmed by spreadsheets? If you're tired of manual data work and want to use Excel more effectively, this course provides the foundational skills you need to work with confidence.
You will gain the practical ability to automate calculations, summarize large datasets, and create clear, insightful reports. This course is designed to transform you from a basic user into a capable practitioner who can leverage Excel to save time and deliver professional results at work.
What you'll learn:
- Understand the core Excel interface and data entry best practices.
- Master key functions like IF, SUMIFS, VLOOKUP, and the modern XLOOKUP.
- Apply Dynamic Array formulas to perform complex calculations with simple expressions.
- Build interactive Pivot Tables and Pivot Charts to summarize and visualize your data.
- Learn fundamental data cleaning and preparation techniques to ensure accuracy.
- Discover how to import and transform data with Power Query fundamentals.
- Practice creating structured reports for common business scenarios.
We start with the absolute basics of spreadsheets, then guide you through writing powerful formulas. You'll then apply these skills to create dynamic reports with Pivot Tables, building your knowledge step-by-step.
This course is for absolute beginners or anyone who has used Excel but lacks formal training. No prior experience is necessary.
Start your journey to becoming proficient in Excel today.
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. -
♾️
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)
Excel'deki temel fonksiyonları ve pivot tabloları sıfırdan öğrenmek isteyenler için gerçekten iyi hazırlanmış bir kurs. Her konu önce basit bir örnekle anlatılıyor, sonra gerçek bir veri setiyle uygulama yapılıyor, bu da öğrenmeyi çok kolaylaştırıyor. Özellikle pivot tablo bölümünde adım adım ilerleyip verileri farklı açılardan özetlemeyi öğrenmek çok işime yaradı. Anlatım sade ve gereksiz teknik detaylara boğulmadan ilerliyor. Kursu bitirdiğimde artık raporlarımı çok daha hızlı ve düzenli hazırlayabiliyorum.
Mình học khóa này để nắm lại các hàm Excel cơ bản và pivot table vì công việc mới yêu cầu làm báo cáo nhiều hơn. Cách giảng dạy khá mạch lạc, mỗi hàm đều có ví dụ minh họa rõ ràng trước khi chuyển sang bài tập. Phần pivot table đặc biệt hữu ích vì trước đây mình chỉ biết dùng sơ sài, giờ đã hiểu cách nhóm và tổng hợp dữ liệu linh hoạt hơn nhiều. Tốc độ bài giảng vừa phải, không quá nhanh khiến người mới như mình theo kịp được. Điểm trừ nhỏ là một vài bài tập cuối hơi lặp lại nội dung đã học.
এই কোর্সটা এক্সেলের গুরুত্বপূর্ণ ফাংশন আর পিভট টেবিল একদম সহজভাবে শিখিয়েছে। প্রতিটা উদাহরণ বাস্তব ডেটা দিয়ে করানো হয়েছে বলে বুঝতে সুবিধা হয়েছে। এখন অফিসের রিপোর্ট নিজেই বানাতে পারি, আগে যেটা অন্য কারো ভরসায় থাকতাম।
Khóa học giải thích các hàm Excel và pivot table rất dễ hiểu, ngay cả với người ít dùng công thức như mình. Phần thực hành với dữ liệu thật giúp mình nhớ lâu hơn nhiều so với chỉ xem lý thuyết. Giờ mình có thể tự làm báo cáo mà không cần hỏi đồng nghiệp nữa.
पिवट टेबल और फंक्शंस को बहुत आसान तरीके से समझाया गया है, बस कुछ जगह उदाहरण थोड़े जल्दी निकल जाते हैं।
Pivot Table yang dulu menakutkan kini jadi alat harian saya untuk ringkaskan laporan jualan.
Llevaba tiempo evitando aprender tablas dinámicas porque me parecían intimidantes, y este curso las explica de una manera tan progresiva que en un par de lecciones ya estaba armando mis propios reportes. Lo que más valoro es que no se queda solo en la teoría de las fórmulas, sino que muestra casos reales donde uno las necesitaría en el trabajo. Cada ejercicio parte de una hoja de datos desordenada y termina en un reporte limpio, lo cual ayuda mucho a entender el propósito de cada función. También me gustó el ritmo, ni demasiado lento ni saltando pasos importantes. Terminé el curso sintiendo que puedo organizar cualquier hoja de cálculo que me pongan enfrente.
Les explications sur les tableaux croisés dynamiques sont limpides et les exercices m'ont vraiment permis de m'entraîner sur des données concrètes.
Spiega bene le funzioni di base e le tabelle pivot con esempi pratici, avrei solo gradito qualche esercizio in più sulle formule condizionali.
事務の仕事で毎日Excelを使うのですが、VLOOKUPやINDEX/MATCHの使い分けがようやくしっかり理解できました。特にピボットテーブルの章は、売上データを部署ごとに集計する実際の例があってとても実践的でした。今までマウスで手作業していた集計が数分で終わるようになり、上司にも驚かれました。関数の組み合わせ方の説明も丁寧で、一つひとつ手を動かしながら進められます。受けて本当によかったです。
Explica las tablas dinámicas y las fórmulas esenciales de una forma tan clara que por fin dejé de tenerle miedo a Excel.
Covers the core functions and pivot tables clearly enough that I could build my first real report by the second lesson, though a couple of the formula examples felt rushed.
Duidelijke uitleg over draaitabellen en functies.
شرح رائع لدوال إكسل الأساسية وجداول البيفوت بطريقة سهلة ومباشرة. أعجبني أن كل درس يبدأ بمثال بسيط ثم ينتقل لتطبيق عملي على بيانات حقيقية. بعد الكورس أصبحت أعد تقاريري بسرعة أكبر بكثير من قبل.
Learners also took
💼 Job-ready
🎓 With certificate
Excel Essentials: Formulas, Functions, and Data Analysis
Certificate
Hands-on
₦21,000.00
→
💼 Job-ready
🎓 With certificate
Excel and Copilot Foundations for Modern Data Work
Certificate
Hands-on
₦21,000.00
→
💼 Job-ready
🎓 With certificate
XML and XSLT: Beginner's Guide to Data Transformation
Certificate
Hands-on
₦21,000.00
→
🔥 Hot
🎓 With certificate
Excel Payroll Management and Financial Modeling
Certificate
Hands-on
₦21,000.00
→
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