Excel Sheet by Mitali Mittal_Part 2.xlsx

	A	B	C	D
1	EXCEL FORMULAS EVERY ANALYST SHOULD KNOW IN 2026
2	A self-paced learning workbook — by Mitali Mittal
3
4	FORMULA GUIDE BY MITALI MITTAL ( @tech_mitali_mittal)
5
6	Formula	What It Does	When To Use It	Syntax
7	XLOOKUP	Looks up a value and returns one or more matching columns from another range.	Any time you need to pull related info using an ID, code, or name as the key.	XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found])
8	FILTER	Returns every row that matches a condition, as a live self-updating list.	Building a report that should stay current automatically.	FILTER(array, include, [if_empty])
9	LET	Names a value or calculation once inside a formula and reuses it.	Any formula where the same calculation appears more than once.	LET(name1, value1, calculation)
10	LAMBDA	Builds your own custom, reusable, named Excel function -- no VBA.	The same formula logic needs to repeat identically across many sheets.	LAMBDA(parameter, calculation)
11	BYROW	Runs the same calculation across every row of a range automatically.	You'd otherwise drag a formula down hundreds of rows.	BYROW(array, LAMBDA(row, calculation))
12	TEXTAFTER	Extracts the text that comes after a delimiter.	Splitting emails into domains, pulling a code after a dash.	TEXTAFTER(text, delimiter)
13	XMATCH	Finds the position of a value in a range.	Paired with INDEX for lookups, or to find the most recent entry in a log.	XMATCH(lookup_value, lookup_array, [match_mode], [search_mode])
14	CHOOSECOLS	Pulls specific columns, in any order, out of a wider table.	A report only needs a few of your master sheet's columns, reordered.	CHOOSECOLS(array, col_num1, [col_num2, ...])
15	UNIQUE	Returns a distinct, duplicate-free list that updates automatically.	Building a dropdown list or distinct summary.	UNIQUE(array)
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100