Excel for Everyday Work
A practical beginner-friendly course that teaches learners how to use Microsoft Excel for everyday office work, including data entry, formatting, formulas, sorting, filtering, charts, and basic reporting. No prior spreadsheet experience is required.
Prerequisites: None
What you'll learn
- Enter, format, and organize spreadsheet data into clear, consistent worksheets.
- Use formulas and practical functions such as IF, COUNTIF, and SUMIF for common tasks.
- Sort and filter larger datasets and manage them with Excel Tables.
- Turn data into charts and straightforward workplace reports.
- Build a complete Excel workbook and business report from raw data.
Roadmap
Course Curriculum Overview
Progression: AI → ML → Deep Learning → Gen AI → LLMs → Prompting → Modern AI
Enroll to unlockExcel Basics
Learn the Excel interface, worksheets, cells, rows, columns, and basic data entry.
Data & Formatting
Learn how to make spreadsheet data clean, readable, consistent, and professional.
Formulas & Functions
Learn how to calculate values automatically using formulas and essential Excel functions.
Useful Functions
Use practical functions such as IF, COUNTIF, SUMIF, and text and date functions to solve common workplace problems.
Sort & Filter
Learn how to quickly find, organize, and analyze information in larger Excel datasets.
Tables & Data
Learn how to turn ordinary ranges into powerful Excel Tables for easier data management and analysis.
Charts & Reports
Learn how to turn spreadsheet data into clear charts and simple professional reports.
Practical Excel
Apply Excel skills to common workplace tasks such as expenses, attendance, sales, inventory, and task tracking.
Advanced Basics
Learn productivity features that make everyday Excel work faster and more reliable.
Final Project
Combine the skills from the course to create a practical, professional Excel workbook from raw data to final report.
Course Complete
Complete all modules to unlock.