Back to Tutorials | Interactive Beginner

Office 365 Excel Functions Tutorial

30 minutes admin 75 views Internal

External Tutorial

This tutorial is hosted on Internal. Click below to access it.

Overview

Master MAP, LAMBDA, UNIQUE, FILTER, SORT, LET & More — By Puneet Arora

Prerequisites

Basic Excel navigation and cell references
Understanding of simple formulas (SUM, AVERAGE, IF)
Knowledge of relative vs absolute cell references

Learning Outcomes

Apply MAP function with LAMBDA to process multiple columns simultaneously
Use UNIQUE and FILTER to extract specific data from large datasets
Implement SORT and SORTBY to organize data dynamically
Create reusable custom functions with LET and LAMBDA
Transform data shapes with ROW, COLUMN, TOROW, and TOCOL
Build loops with BYROW and BYCOL for row/column-wise calculations

Tutorial Info

Type Interactive

Difficulty Beginner

Duration 30 minutes

Provider Internal

Published Mar 26, 2026

Last Updated May 22, 2026