Scribd
Upload
14 views3 pages

Excel Functions With Applications - GPT

The document provides a comprehensive overview of various MS Excel functions categorized into Mathematical, Logical, Text, Date & Time, Lookup & Reference, Statistical, Financial, Information, and Array & Advanced functions. Each category lists specific functions along with their applications, such as basic calculations, decision-making, data validation, and dynamic data filtering. This serves as a guide for users to understand and utilize Excel functions effectively for different tasks.

Uploaded by

normyuser666
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
14 views3 pages

Excel Functions With Applications - GPT

The document provides a comprehensive overview of various MS Excel functions categorized into Mathematical, Logical, Text, Date & Time, Lookup & Reference, Statistical, Financial, Information, and Array & Advanced functions. Each category lists specific functions along with their applications, such as basic calculations, decision-making, data validation, and dynamic data filtering. This serves as a guide for users to understand and utilize Excel functions effectively for different tasks.

Uploaded by

normyuser666
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

All MS Excel Functions with Applications

Mathematical Functions
Functions:

SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, ROUND, INT, MOD, ABS, PRODUCT,

QUOTIENT

Applications:

- Basic calculations

- Summing columns/rows

- Statistical analysis

- Removing decimals

- Calculating absolute values

Logical Functions
Functions:

IF, AND, OR, NOT, IFERROR, IFNA

Applications:

- Decision-making formulas

- Error handling

- Conditional analysis

Text Functions
Functions:

LEFT, RIGHT, MID, LEN, FIND, SEARCH, UPPER, LOWER, PROPER, CONCAT, TEXTJOIN,

TRIM, SUBSTITUTE

Applications:

- Extracting substrings

- Cleaning text
- Merging strings

- Case formatting

- Replacing text

Date & Time Functions


Functions:

NOW, TODAY, DATE, TIME, YEAR, MONTH, DAY, WEEKDAY, HOUR, MINUTE, SECOND,

DATEDIF, NETWORKDAYS

Applications:

- Timestamping

- Calculating age

- Deadline tracking

- Workday calculation

Lookup & Reference Functions


Functions:

VLOOKUP, HLOOKUP, INDEX, MATCH, XLOOKUP, INDIRECT, OFFSET, CHOOSE

Applications:

- Searching values

- Dynamic referencing

- Table lookups

- Retrieving related data

Statistical Functions
Functions:

STDEV, STDEVP, VAR, VARP, MEDIAN, MODE, LARGE, SMALL, RANK

Applications:

- Data distribution analysis


- Ranking scores

- Identifying outliers

Financial Functions
Functions:

PMT, FV, PV, NPER, RATE, NPV, IRR

Applications:

- Loan calculations

- Investment evaluations

- Amortization tables

Information Functions
Functions:

ISNUMBER, ISTEXT, ISBLANK, ISERROR, TYPE, CELL

Applications:

- Data validation

- Error checks

- Data type determination

Array & Advanced Functions


Functions:

FILTER, SORT, UNIQUE, SEQUENCE, LET, LAMBDA, SUMPRODUCT, AGGREGATE

Applications:

- Dynamic data filtering

- Advanced automation

- Multi-criteria summaries

You might also like