Learn Excel from Scratch

Wishlist Share

About Course

This comprehensive course is designed for complete beginners who want to build a strong foundation in Microsoft Excel. Starting with the very basics, you’ll learn how to navigate the Excel interface, work with cells, and understand essential tools and options that form the backbone of every spreadsheet task.

Whether you’re a student, job seeker, or working professional, this course will take you step by step from zero knowledge to confidently using Excel for everyday tasks including data entry, formatting, formulas, and basic calculations.

This course covers cells, formatting, IF functions, sorting, filtering, data validation, charts, tables, SUMIF formulas, and finally building a complete interactive dashboard using real data.

By the end, you’ll go from complete beginner to creating professional reports and dashboards with confidence.

What you’ll learn:

  • Navigating the Excel interface and workspace
  • Understanding cells, rows, columns, and worksheets
  • Entering, editing, and formatting data
  • Using basic formulas and functions
  • Organizing and managing data efficiently
  • Building a solid foundation for advanced Excel skills
Show More

What Will You Learn?

  • Navigate the Excel interface with confidence, even with zero prior experience
  • Understand cells, rows, columns, and how worksheets are structured
  • Enter, edit, and format data correctly for clean, professional spreadsheets
  • Apply basic formulas and functions to perform calculations automatically
  • Organize and manage data efficiently within a worksheet
  • Use essential formatting tools to make your spreadsheets clear and readable
  • Build a strong foundation for progressing to intermediate and advanced Excel skills
  • Create simple, functional spreadsheets independently by the end of the course.

Course Content

Introduction to Excel: Understanding Cells and Basic Interface
This topic introduces you to the Excel interface and teaches the basics of working with cells, including selection, data entry, and navigation

  • Excel Basics: Cells and Interface Overview
    14:55

Excel Essentials: IF Function, Percentages, Sorting, Filtering and More
This topic covers essential Excel formulas and data management tools, including the IF function for logical calculations, percentage formulas, and techniques for sorting and filtering data efficiently.

Excel Data Validation, Sheet Management, Charts & Tables
Learn how to apply data validation to control data entry, manage worksheets by deleting and color-coding sheet tabs, and visually present your data using Excel charts and tables for better analysis and reporting.

Excel Formulas Masterclass: SUMIF and Beyond
Learn essential Excel formulas beyond the basics, including SUMIF for conditional totals, along with other commonly used functions that help you analyze and calculate data more efficiently.

Excel Dashboard Tutorial: Turn Data into Visual Reports
Learn how to build a professional Excel dashboard from raw data, combining charts, tables, and formulas covered in earlier lessons to create a clear, visual summary for reporting and analysis.

Student Ratings & Reviews

No Review Yet
No Review Yet