Scribd
Upload
12 views4 pages

Essential Excel Formulas Guide

The document lists various formulas and functions commonly used in spreadsheet applications, including text manipulation, mathematical operations, and statistical calculations. It also provides examples of how to apply these functions, such as converting text to proper case and calculating sums and averages. Additionally, it includes references to features like drop-down lists and conditional formatting.

Uploaded by

Faheemullah Khp G8
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
12 views4 pages

Essential Excel Formulas Guide

The document lists various formulas and functions commonly used in spreadsheet applications, including text manipulation, mathematical operations, and statistical calculations. It also provides examples of how to apply these functions, such as converting text to proper case and calculating sums and averages. Additionally, it includes references to features like drop-down lists and conditional formatting.

Uploaded by

Faheemullah Khp G8
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

S.

No Formulas
1 left l
2 right t
3 upper UPPER Capital letter
4 lower Sentence case
5 proper Maximum
6 trim
7 -
8 *
9 constant cell with dollar
10 /
11 Minimum
12 Maximum
13 Sum
14 product
15 count
16 countif
17 counta
18 countblank
19 sumif
20 sumifs
21 average
22 IF
23 today
24 COUNT
25 COUNTA
26 COUNTBLANK
27 SUM
28 IF
29 VLOOKUP
30 CONCATENATE
31 COUNTIF
32 SUMIF
33 AVERAGEIF
34 DROP-DOWN LIST
35 CONDITIONAL FORMATING
36 TEXT TO COLOMN
ntence case
Proper faheem is a good boy Faheem Is A Good Boy
1- 1
2 2
3 3
4 4
5 425
6 2345
7 356
8 4563
9 3456
10 345
11 45
12 6345
13 345
14 345
15 356
16 a
17 63456
Minus #NAME?
add 701
product 24
divide 2
Minimun 1
Maximum 63456
sum 82392
count 16
counta 17
countblank 5
average 2.5
heem Is A Good Boy

You might also like