Skip to content
Home Tutorials Roadmaps Courses
Log in Join free

Excel for Data Analytics

Transform raw data into actionable insights with advanced Excel formulas, pivot tables, and dashboards.

SU Taught by Sukhwinder Singh 0 enrolled Beginner

What you will learn

  • Write advanced Excel formulas
  • Create pivot tables and charts
  • Build interactive dashboards
  • Analyze data with Excel tools
  • Automate repetitive tasks
Master Excel for data analysis - the most in-demand skill for analysts, accountants, and business professionals.

Covers formulas, functions, VLOOKUP/XLOOKUP, INDEX/MATCH, conditional formatting, data validation, pivot tables, charts, dashboards, data analysis tools, and automation basics.

Who this is for:
- Students preparing for data analyst roles
- Professionals wanting to analyze business data
- Accountants and finance professionals
- Anyone working with spreadsheets

Course Syllabus

0 lessons · 4 modules
1. Excel Basics 3 lessons
  1. Lesson content for "Excel interface and navigation".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  2. Lesson content for "Formatting and cell management".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  3. Lesson content for "Basic formulas - SUM, AVERAGE, COUNT".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
2. Formulas & Functions 5 lessons
  1. Lesson content for "IF, AND, OR logical functions".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  2. Lesson content for "VLOOKUP and HLOOKUP".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  3. Lesson content for "XLOOKUP - the modern replacement".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  4. Lesson content for "INDEX and MATCH combination".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  5. Lesson content for "COUNTIF, SUMIF, AVERAGEIF".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
3. Data Visualization 3 lessons
  1. Lesson content for "Chart types and when to use them".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  2. Lesson content for "Conditional formatting".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  3. Lesson content for "Data validation rules".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
4. Pivot Tables & Dashboards 4 lessons
  1. Lesson content for "Creating pivot tables".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  2. Lesson content for "Pivot charts and slicers".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  3. Lesson content for "Building interactive dashboards".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon
  4. Lesson content for "Data analysis tools and What-If analysis".

    Want to watch the video lesson?

    Enroll now to get full video access + certificate.

    Coming soon

Student reviews

No reviews yet - be the first after you complete the course!

Prerequisites

Basic computer knowledge. No prior Excel expertise needed.

Related courses