Udemy

Free Excel Work Basics: Formulas, Lookups and Pivot Tables

Everyday spreadsheet work often moves from entering a few records to answering questions about a much larger table. Grzegorz Z introduces that progression through workbook navigation, formatting, formulas, references and common summary tools.

Free learning access

Listed as Free on Udemy when checked on 21 October 2026. No coupon or subscription trial is required for the listed lessons. Enrollment needs a Udemy account; availability can change.

About this course

Everyday spreadsheet work often moves from entering a few records to answering questions about a much larger table. Grzegorz Z introduces that progression through workbook navigation, formatting, formulas, references and common summary tools.

The lessons cover SUM, averages, minimum and maximum values, IF, conditional formatting, counting and text combinations. The later part introduces lookup functions, dates, sorting and filtering, before finishing with pivot tables, pivot charts and slicers.

Official course Excel for Work – Basics
Created by Grzegorz Z
Platform Udemy
Language English
Level Beginner — Udemy listing
Listed duration 94 minutes; 13 lectures across 1 sections
Certificate Not included with a new free enrollment

Skills you’ll gain

  • Using stable cell references
  • Building basic logical formulas
  • Finding values with lookup functions
  • Summarizing data with pivot tables

The course expects basic Windows familiarity and access to an installed version of Excel. A commercial Excel license is not supplied with free enrollment, and feature availability differs across versions. LibreOffice Calc is a free alternative for practicing many spreadsheet concepts, although menus and exact feature behavior will differ from the demonstrations.

This is a broad beginner survey, with several advanced-sounding topics introduced in short lessons. Use it to learn what the tools do and identify areas for further practice, rather than assuming a brief lookup or pivot-table example covers every workplace case. The formulas and exercises have not been independently executed during this review.

Enroll Now ↗

Related courses for your next step

Compare course focus, level and study time
Compare the published course outlines. A lower level is a preparation option, not a required prerequisite.
Course Level Focus Study time
This course — Free Excel Work Basics: Formulas, Lookups and Pivot Tables Beginner Using stable cell references · Building basic logical formulas · Finding values with lookup functions 94 minutes (Udemy listing)
Excel Formulas and Functions: Free Course Intermediate Excel formulas · Logical functions · Conditional calculations 10h 7m of video; practice time is additional
Free Excel Data Visualization Course: Pivot Tables and Charts Beginner Organizing a chart-ready data table · Summarizing data with pivot tables · Creating spreadsheet charts 31 minutes (Udemy listing)

Frequently asked questions

Is Microsoft Excel included for free?

No. The instructional course is free; access to the software is separate.

Are lookup functions and pivot tables covered?

Yes. The public syllabus names XLOOKUP, HLOOKUP, VLOOKUP and a final lesson on pivot tables, charts and slicers.

Checked on 21 October 2026 using the public course details and syllabus. Coursya has not watched every lesson or tested full playback. New free enrollments do not include a Udemy completion certificate, instructor Q&A or direct messages.

Share this course

Questions & discussion

Share a useful question or correction. Comments appear after moderation. Please avoid personal or sensitive information.

Add to the discussion

Your email address will not be published. Required fields are marked *