Scribd
Upload
8 views3 pages

? Basic Formulas

This document provides a comprehensive list of Excel formulas categorized into basic, text, logical, lookup, data cleaning, date & time, and advanced formulas. It also includes real-life business use cases and important shortcuts for Excel. Additionally, it offers instructions for converting the content into a PDF and a prompt for generating a downloadable Excel formulas PDF.

Uploaded by

cpm.addor
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
8 views3 pages

? Basic Formulas

This document provides a comprehensive list of Excel formulas categorized into basic, text, logical, lookup, data cleaning, date & time, and advanced formulas. It also includes real-life business use cases and important shortcuts for Excel. Additionally, it offers instructions for converting the content into a PDF and a prompt for generating a downloadable Excel formulas PDF.

Uploaded by

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

🟢 BASIC FORMULAS (BEGINNER)

SUM
=SUM(A1:A10)

AVERAGE
=AVERAGE(A1:A10)

COUNT / COUNTA
=COUNT(A1:A10)
=COUNTA(A1:A10)

MAX / MIN
=MAX(A1:A10)
=MIN(A1:A10)

🟢 TEXT FORMULAS
CONCAT / TEXTJOIN
=TEXTJOIN(" ",TRUE,A1,B1)

LEFT / RIGHT / MID


=LEFT(A1,4)
=RIGHT(A1,10)
=MID(A1,2,5)

LEN / TRIM
=LEN(A1)
=TRIM(A1)

🟡 LOGICAL FORMULAS
IF
=IF(A1="LM","Life Member","Annual Member")

IF + AND / OR
=IF(AND(A1>50,B1<100),"Yes","No")
🟡 LOOKUP FORMULAS
VLOOKUP
=VLOOKUP(A2,A:B,2,FALSE)

XLOOKUP (Recommended)
=XLOOKUP(A2,A:A,B:B)

INDEX + MATCH
=INDEX(B:B,MATCH(A2,A:A,0))

🟠 DATA CLEANING FORMULAS


FIND / SEARCH
=SEARCH("@",A1)

SUBSTITUTE
=SUBSTITUTE(A1,"|",",")

TEXTSPLIT (Excel 365)


=TEXTSPLIT(A1,"|")

🔵 DATE & TIME FORMULAS


=TODAY()
=NOW()
=DATEDIF(A1,B1,"Y")

🔴 ADVANCED FORMULAS
COUNTIF / SUMIF
=COUNTIF(E:E,"LM")
=SUMIF(A:A,"Borivali",B:B)

FILTER
=FILTER(A2:I200,E2:E200="LM")

UNIQUE
=UNIQUE(A2:A200)

⭐ REAL-LIFE BUSINESS USE


Split multiple phone numbers
=TEXTSPLIT(G2,"|")

Area-wise data
=FILTER(A2:I200,ISNUMBER(SEARCH("Borivali",I2:I200)))

Membership summary
=COUNTIF(E:E,"Life Member")

⌨️IMPORTANT SHORTCUTS
 Ctrl + T → Convert to Table
 Ctrl + Shift + L → Filters
 Alt + = → AutoSum
 Ctrl + 1 → Format Cells

📄 CONVERT THIS INTO PDF


1. Copy everything
2. Paste into Word / Google Docs
3. Save as PDF

✅ NEXT STEP

Reply “Generate PDF”


➡️I will create and give you a downloadable Microsoft Excel Formulas PDF (Beginner to
Advanced) ready to use.

If you want:

 Hindi / English version


 Practice exercises included
 Real-estate specific Excel PDF

You might also like