Scribd
Upload
5 views2 pages

Advanced Excel Formulas Guide

The document is a guide on advanced Excel formulas used in various fields such as reporting and finance. It covers categories including logical, lookup, text, date, and dynamic array functions, providing examples for each. Additionally, it offers tips for learning Excel formulas more effectively.

Uploaded by

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

Advanced Excel Formulas Guide

The document is a guide on advanced Excel formulas used in various fields such as reporting and finance. It covers categories including logical, lookup, text, date, and dynamic array functions, providing examples for each. Additionally, it offers tips for learning Excel formulas more effectively.

Uploaded by

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

Advanced Excel Formulas Guide

This PDF contains important Excel formulas that are widely used in reporting, analytics, dashboards, finance, and
office jobs.

Logical Functions

Formula Purpose Example

IF Checks a condition =IF(A2>50,"Pass","Fail")


IFS Multiple conditions =IFS(A2>90,"A",A2>75,"B")
AND Checks multiple TRUE conditions =AND(A2>50,B2<100)
OR Checks if any condition is TRUE =OR(A2>50,B2>50)
IFERROR Handles errors =IFERROR(A2/B2,0)

Lookup Functions

Formula Purpose Example

XLOOKUP Modern lookup =XLOOKUP(A2,D:D,E:E)


VLOOKUP Vertical lookup =VLOOKUP(A2,D:E,2,FALSE)
INDEX + MATCH Flexible lookup =INDEX(E:E,MATCH(A2,D:D,0))

Text Functions

Formula Purpose Example

LEFT Extract left characters =LEFT(A2,3)


RIGHT Extract right characters =RIGHT(A2,4)
MID Extract middle text =MID(A2,2,5)
TRIM Removes extra spaces =TRIM(A2)
CONCAT Joins text =CONCAT(A2,B2)
TEXTJOIN Joins with separator =TEXTJOIN(",",TRUE,A2:A5)

Date Functions

Formula Purpose Example

TODAY Current date =TODAY()


NOW Current date & time =NOW()
DATEDIF Difference between dates =DATEDIF(A2,B2,"D")
EOMONTH End of month =EOMONTH(A2,0)
WORKDAY Future workday =WORKDAY(A2,10)

Dynamic Array Functions

Formula Purpose Example

FILTER Filters data =FILTER(A2:C10,C2:C10>100)


SORT Sorts data =SORT(A2:C10,2,1)
UNIQUE Unique values =UNIQUE(A2:A20)
SEQUENCE Generates numbers =SEQUENCE(10)

Tips to Learn Faster


• Practice formulas daily using small datasets.

• Learn Pivot Tables alongside formulas.

• Build mini projects like dashboards and reports.

• Use keyboard shortcuts to improve speed.

• Practice data cleaning using Power Query.

You might also like