# @thecheatsheets on Instagram

- **Type:** Video
- **Original URL:** https://www.instagram.com/p/DVTdrVQDQZo
- **Gondola URL:** https://gondola.cc/posts/63431302-thecheatsheets-instagram
- **Thumbnail:** https://img.gondola.cc/tr:w-,h-,fo-auto/postThumbnails/4d210c65bf.jpg
- **Posted:** 2026-02-28T14:00:07.000+00:00
- **Account Owner:** CheatSheets (@thecheatsheets) — https://gondola.cc/thecheatsheets

## Caption

Top 100 Excel Functions to Learn:

✅ Math & Basic Arithmetic
	•	SUM
	•	SUMIF
	•	SUMIFS
	•	PRODUCT
	•	QUOTIENT
	•	MOD
	•	ROUND
	•	ROUNDUP
	•	ROUNDDOWN
	•	INT
	•	TRUNC
	•	ABS
	•	SIGN
	•	POWER
	•	SQRT

✅ Logical Functions
	•	IF
	•	IFS
	•	IFERROR
	•	AND
	•	OR
	•	NOT
	•	XOR
	•	SWITCH

✅ Lookup & References
	•	VLOOKUP
	•	HLOOKUP
	•	XLOOKUP
	•	INDEX
	•	MATCH
	•	LOOKUP
	•	FILTER
	•	SORT
	•	SORTBY
	•	UNIQUE
	•	CHOOSE
	•	OFFSET
	•	ROW
	•	ROWS
	•	COLUMN
	•	COLUMNS
	•	FORMULATEXT
	•	HYPERLINK

✅ Date & Time
	•	TODAY
	•	NOW
	•	DATE
	•	TIME
	•	DAY
	•	MONTH
	•	YEAR
	•	WEEKDAY
	•	WEEKNUM
	•	HOUR
	•	MINUTE
	•	SECOND
	•	EDATE
	•	EOMONTH
	•	DATEDIF
	•	NETWORKDAYS
	•	WORKDAY
	•	ISOWEEKNUM

✅ Information & Error Handling
	•	ISBLANK
	•	ISNUMBER
	•	ISTEXT
	•	ISERROR
	•	ISNA
	•	N
	•	TYPE
	•	ERROR.TYPE
	•	NA

✅ Text Functions
	•	TEXT
	•	CONCAT
	•	TEXTJOIN
	•	LEFT
	•	RIGHT
	•	MID
	•	LEN
	•	TRIM
	•	PROPER
	•	UPPER
	•	LOWER
	•	REPLACE
	•	SUBSTITUTE
	•	REPT
	•	CHAR
	•	CODE
	•	CLEAN

✅ Statistical & Data Analysis
	•	AVERAGE
	•	AVERAGEIF
	•	AVERAGEIFS
	•	MEDIAN
	•	MODE
	•	MIN
	•	MAX
	•	PERCENTILE
	•	PERCENTRANK
	•	RANK
	•	VAR
	•	STDEV
	•	CORREL
	•	FORECAST
	•	TREND

#excel #functions #study #googlesheets #spreadsheet

## Stats

- **Views:** 54,897
- **Likes:** 1,413
- **Shares:** 0
- **Comments:** 0

## Tags

googlesheets, excel, study, functions, spreadsheet

---
Copyright (c) Gondola