Topfolio
Career TracksMicro Free CoursesTask CoursesPracticeInterview PracticeWork ExperienceProjects
Career TrackBlog
Support
Micro Free Courses

Excel for Data Analytics (Short & Focused)

19 lessons

  1. 1. THE EXCEL ESSENTIALS
    1. Video lesson1. Interface & Navigation6m
    2. Video lesson2. Cell Referencing8m
    3. Interactive tutorial3. QUIZ: Excel Basics15m
  2. 2. EXCEL CLEANING & LOGIC
    1. Video lesson1. Data Cleaning10m
    2. Video lesson2. Text Functions & Data Quality12m
    3. Interactive tutorial3. QUIZ: Data Cleaning20m
    4. Video lesson4. Lookup Functions10m
    5. Interactive tutorial5. QUIZ: Lookup functions15m
    6. Video lesson6. Logical & Math Functions15m
    7. Reading7. GUIDE: Logical & Math Functions (IF, COUNTIF, AVERAGEIF)8m
    8. Project submission8. SUBMISSION: Module 260m
  3. 3. EXCEL PIVOT TABLES
    1. Video lesson1. Pivot Table Basics12m
    2. Video lesson2. Interactivity10m
    3. Video lesson3. Conditional Formatting & Charts10m
    4. Reading4. GUIDE: Report Connections, Date Grouping & Formatting8m
    5. Interactive tutorial5. QUIZ: Pivot Tables20m
    6. Project submission6. SUBMISSION: Pivot Tables60m
  4. 4. EXCEL DASHBOARDS
    1. Video lesson1. Building the Dashboard10m
    2. Project submission2. SUBMISSION: Dashboard60m
Dashboard
Career TracksMicro Free Courses
Task Courses
SQL & PythonInterview Prep
Work ExperienceProjectsResume Feedback
CertificatesMy OrdersRefer & Earn
Join Community
Micro Free Courses

Excel for Data Analytics (Short & Focused)

19 lessons

  1. 1. THE EXCEL ESSENTIALS
    1. Video lesson1. Interface & Navigation6m
    2. Video lesson2. Cell Referencing8m
    3. Interactive tutorial3. QUIZ: Excel Basics15m
  2. 2. EXCEL CLEANING & LOGIC
    1. Video lesson1. Data Cleaning10m
    2. Video lesson2. Text Functions & Data Quality12m
    3. Interactive tutorial3. QUIZ: Data Cleaning20m
    4. Video lesson4. Lookup Functions10m
    5. Interactive tutorial5. QUIZ: Lookup functions15m
    6. Video lesson6. Logical & Math Functions15m
    7. Reading7. GUIDE: Logical & Math Functions (IF, COUNTIF, AVERAGEIF)8m
    8. Project submission8. SUBMISSION: Module 260m
  3. 3. EXCEL PIVOT TABLES
    1. Video lesson1. Pivot Table Basics12m
    2. Video lesson2. Interactivity10m
    3. Video lesson3. Conditional Formatting & Charts10m
    4. Reading4. GUIDE: Report Connections, Date Grouping & Formatting8m
    5. Interactive tutorial5. QUIZ: Pivot Tables20m
    6. Project submission6. SUBMISSION: Pivot Tables60m
  4. 4. EXCEL DASHBOARDS
    1. Video lesson1. Building the Dashboard10m
    2. Project submission2. SUBMISSION: Dashboard60m

Browse Topfolio

All coursesPracticeProjectsCareer tracks
  1. Home/
  2. Courses/
  3. Excel for Data Analytics (Short & Focused)/
  4. THE EXCEL ESSENTIALS/
  5. Interface & Navigation
Back to THE EXCEL ESSENTIALS

Interface & Navigation

Learn the ribbon and where to find tools quickly.

6 minutesVideo Lesson
🎯 Free Guest Mode: You are learning for free. Sign in to save your completion progress and quiz answers.

Ready to continue?

Mark this lesson as complete when you're ready to proceed.

Next: Cell Referencing
Topfolio

Learn data analytics online. Real skills, real projects, real community.

courses

  • Career Tracks
  • Work Experience
  • Best Data Analyst Course in India
  • SQL Fundamentals
  • SQL Advanced
  • Python for Data
  • Micro Free Courses

practice

  • SQL Fundamentals Interview Test
  • SQL Advanced Coding Test
  • All Practice Tests

resources

  • How to Become a Data Analyst
  • SQL Interview Questions
  • Data Analyst Salary Guide
  • Free Datasets for Practice
  • SQL vs NoSQL Guide
  • Data Analyst vs Data Engineer vs Data Scientist

employers

  • Enterprise Screening
  • AI Proctoring Demo
  • Volume Pricing
  • Employer Portal

company

  • About
  • Terms
© 2026 Topfolio. All rights reserved.Made with ❀️ for aspiring analysts