Learn By Us

Office & IT

MS Excel & Advanced Excel

Workbooks, formulas, PivotTables, and dashboards for everyday office work.

★★★★★4.8 · Based on 214 learners6 lessons · 1 hr 32 min

MS Excel & Advanced Excel takes you from a clean worksheet to analysis you can defend. You will learn how to organise data, write formulas that stay correct, and summarise large sheets with PivotTables. The lectures are pre-recorded, so you can pause on a formula and try it before the next lesson.

Course syllabus

  1. 01. Workbook basics

    • A sheet that stays tidy

      Rows, columns, formats, and why a messy sheet breaks later work.

      14 min
    • Freeze, filter, and sort

      Find the rows you need without losing the rest of the table.

      12 min

  2. 02. Formulas

    • SUM, AVERAGE, IF, and cell references

      Relative and absolute references, and formulas that still work when you copy them.

      18 min
    • Lookup and text formulas

      VLOOKUP or XLOOKUP, plus simple text cleanup before a report.

      16 min

  3. 03. Analysis

    • PivotTables

      Turn a long table into a summary without rewriting the data.

      17 min
    • A small dashboard

      Charts and a one-page view a manager can read.

      15 min

Lecture videos stay with the course. Playback for enrolled students will open once payments are available. Video links are not published on this page.