دورة رائعة وشرح واضح جداً للصيغ.
Practical Excel for the Modern Office
Master essential formulas, data analysis, and reporting techniques to become more efficient and confident in your daily work.
-
💬
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 like you're only scratching the surface of what Excel can do? This course is designed to take you from the basics to confidently handling the data-related tasks that modern office jobs demand.
You will learn how to organize data, perform calculations, and create clear, professional reports. Move beyond simple data entry and start using Excel as a powerful tool to solve problems and improve your productivity.
What you'll learn:
- Master fundamental formulas and functions, including IF, VLOOKUP, and the modern XLOOKUP.
- Apply conditional formatting, sorting, and filtering to organize and analyze data effectively.
- Create compelling charts and graphs to visualize your data and communicate insights clearly.
- Summarize large datasets quickly and build interactive reports using PivotTables.
- Understand and use Dynamic Array formulas to work more efficiently with ranges of data.
- Learn the principles of data cleaning and preparation to ensure accuracy in your work.
- Get a foundational introduction to Power Query for automating data import and transformation tasks.
This course starts with the core terminology and interface of Excel, then progressively builds your skills through practical examples and explanations. You'll learn to approach common business problems with the right tools.
This course is for absolute beginners. No prior experience with Excel is required. We will start from the very beginning and build your skills step by step.
Enroll today to start your journey toward becoming a proficient Excel user.
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 (10)
엑셀 함수와 데이터 분석 방법을 실무에 바로 쓸 수 있게 알려줘서 정말 좋았어요.
Enfin des formules Excel expliquées simplement, top.
Excel formülleri ve raporlama konusunda gerçekten işe yarayan bir kurs, özellikle veri analizi kısmı çok faydalıydı. Pivot tablolara kısaca değinilmiş olması biraz eksik kaldı benim için. Yine de günlük ofis işlerimde çok işime yaradı.
Excel war für mich immer ein Buch mit sieben Siegeln, doch dieser Kurs hat das geändert. Die wichtigsten Formeln und Datenanalyse-Techniken werden so erklärt, dass man sie sofort anwenden kann. Vor allem beim Erstellen von Berichten bin ich jetzt viel schneller und sicherer. Jede Lektion baut sauber auf der vorherigen auf. Im Büroalltag spare ich dadurch täglich richtig viel Zeit.
Наконец-то формулы Excel объяснили понятно, без сложной терминологии, и сразу с практическими примерами.
Eu já usava Excel no trabalho há anos, mas de forma bem básica, e esse curso mudou completamente minha relação com a planilha. As aulas sobre fórmulas essenciais são explicadas devagar o suficiente para acompanhar mesmo quem não tem background técnico. A parte de análise de dados me ajudou a organizar relatórios que antes eu fazia de forma manual e demorada. Gostei muito também de como os exercícios usam situações reais de escritório, não só exemplos genéricos. No fim das contas, terminei o curso conseguindo montar relatórios em uma fração do tempo que levava antes.
This course finally made Excel formulas click for me after years of just winging it at work. The data analysis and reporting sections are laid out logically, building on each lesson instead of jumping around. I'm now putting together reports in a fraction of the time it used to take.
Mas kumpiyansa na ako sa mga formula at paggawa ng report; sana mas marami pang halimbawa, pero malaking tulong na ito.
日々の集計で関数に詰まることが多かったのですが、この講座で基本の数式とデータ分析の流れがすっきり整理できました。レポート作成がぐっと楽になっています。ピボット周りの説明がもう少し厚いと完璧でしたが、十分おすすめです。
Learners also took
💼 Job-ready
🎓 With certificate
Excel Essentials: Formulas, Functions, and Data Analysis
Certificate
Hands-on
KSh 2,000.00
→
💼 Job-ready
🎓 With certificate
Excel and Copilot Foundations for Modern Data Work
Certificate
Hands-on
KSh 2,000.00
→
💼 Job-ready
🎓 With certificate
XML and XSLT: Beginner's Guide to Data Transformation
Certificate
Hands-on
KSh 2,000.00
→
🔥 Hot
🎓 With certificate
Excel Payroll Management and Financial Modeling
Certificate
Hands-on
KSh 2,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