Home › Courses › Advanced Excel: Formulas, Pivot Tables, Dashboards & Automation

Advanced Excel: Formulas, Pivot Tables, Dashboards & Automation

Microsoft Excel is one of the most in-demand workplace skills, used in accounts, sales, stores, HR, banking and almost every office job. This course takes you from the very basics to an advanced, job-ready level, step b…

👥 2 students⏱ 2 Months

Demo Class

Demo class video coming soon.

What you will learn

  • Module 1: Excel Basics
  • Module 2: Productivity Tools & Shortcuts
  • Module 3: Advanced Formatting & Data Validation
  • Module 4: Logical & Text Functions
  • Module 5: Lookup Functions
  • Module 6: Math, Statistical & Date Functions
  • Module 7: Data Cleaning & Analysis
  • Module 8: Pivot Tables & Pivot Charts
  • Module 9: Charts & Dashboards
  • Module 10: Automation (Macros)
  • Module 11: Real-time Projects & Certification

Description

Microsoft Excel is one of the most in-demand workplace skills, used in accounts, sales, stores, HR, banking and almost every office job. This course takes you from the very basics to an advanced, job-ready level, step by step.

You will start with Excel fundamentals (cells, formatting, basic formulas), then move on to the most important functions (IF, VLOOKUP, XLOOKUP, INDEX-MATCH, SUMIFS and more), data cleaning, Pivot Tables, charts and interactive dashboards, and finally macros to automate repetitive work.

Every lesson uses simple explanations and real workplace examples. By the end, you will complete three real-time projects (Sales Report, Payroll and Inventory) that you can show in interviews and use at work.

Learn on your mobile or computer, anytime, at your own pace.

Who this course is for

  • Complete beginners who want to learn Excel from scratch
  • College students and job seekers
  • Accountants, office administrators and data entry staff
  • Shop and business owners (stock, billing and sales records)
  • Bank and government exam aspirants
  • Existing Excel users who want to move to an advanced level

Course requirements

  • Basic computer knowledge (using a mouse, keyboard and files)
  • A computer or laptop with Microsoft Excel 2016 or later (Excel 2021 / Microsoft 365 recommended for XLOOKUP)
  • No prior Excel knowledge needed. We start from the basics.

Course Curriculum

Module 1: Excel Basics4 lessons
  • Lesson 1 : Excel Interface, Workbook, Worksheet and Ribbon
  • Lesson 2: Entering, Editing and Selecting Data
  • Lesson 3: Introduction to Home Tab – Clipboard, Font & Alignment Groups
  • Lesson 4: Conditional Formatting in Excel: Automatically Highlight Your Data
Module 2: Productivity Tools & Shortcuts0 lessons
    Module 3: Advanced Formatting & Data Validation0 lessons
      Module 4: Logical & Text Functions0 lessons
        Module 5: Lookup Functions0 lessons
          Module 6: Math, Statistical & Date Functions0 lessons
            Module 7: Data Cleaning & Analysis0 lessons
              Module 8: Pivot Tables & Pivot Charts0 lessons
                Module 9: Charts & Dashboards0 lessons
                  Module 10: Automation (Macros)0 lessons
                    Module 11: Real-time Projects & Certification0 lessons
                      💬 Chat on WhatsApp