Scribd
Upload
55 views2 pages

MS Excel Formulas and Commands

The document provides a comprehensive list of common MS Excel formulas and commands, categorized into basic formulas, text functions, logical functions, lookup & reference functions, date & time functions, financial functions, data cleaning & manipulation, and common Excel commands. Each formula is accompanied by a brief description of its function and syntax. This serves as a quick reference guide for users to enhance their Excel skills.

Uploaded by

Exam Baba
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
55 views2 pages

MS Excel Formulas and Commands

The document provides a comprehensive list of common MS Excel formulas and commands, categorized into basic formulas, text functions, logical functions, lookup & reference functions, date & time functions, financial functions, data cleaning & manipulation, and common Excel commands. Each formula is accompanied by a brief description of its function and syntax. This serves as a quick reference guide for users to enhance their Excel skills.

Uploaded by

Exam Baba
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

MS Excel Formulas and Commands

# Common MS Excel Formulas and Commands

## Basic Formulas:
1. **SUM**: =SUM(A1:A10) - Adds values from A1 to A10.
2. **AVERAGE**: =AVERAGE(A1:A10) - Finds average.
3. **COUNT**: =COUNT(A1:A10) - Counts numbers.
4. **COUNTA**: =COUNTA(A1:A10) - Counts non-empty cells.
5. **IF**: =IF(A1>10, "High", "Low") - Conditional logic.

## Text Functions:
6. **LEFT**: =LEFT(A1, 5) - Extracts left 5 characters.
7. **RIGHT**: =RIGHT(A1, 3) - Extracts right 3 characters.
8. **MID**: =MID(A1, 3, 4) - Extracts 4 characters from position 3.
9. **LEN**: =LEN(A1) - Counts characters in a cell.
10. **CONCATENATE** / **TEXTJOIN**: =TEXTJOIN(" ", TRUE, A1, B1) - Joins text.

## Logical Functions:
11. **AND**: =AND(A1>10, B1<5) - Returns TRUE if both conditions are met.
12. **OR**: =OR(A1>10, B1<5) - Returns TRUE if any condition is met.
13. **NOT**: =NOT(A1>10) - Reverses condition.

## Lookup & Reference Functions:


14. **VLOOKUP**: =VLOOKUP(1001, A2:C10, 2, FALSE) - Finds value in table.
15. **HLOOKUP**: =HLOOKUP(1001, A2:C10, 2, FALSE) - Horizontal lookup.
16. **INDEX**: =INDEX(A1:C10, 2, 3) - Finds value by row and column.
17. **MATCH**: =MATCH(50, A1:A10, 0) - Finds position of value.
18. **CHOOSE**: =CHOOSE(2, "Apple", "Banana", "Cherry") - Picks second value.

## Date & Time Functions:


19. **TODAY**: =TODAY() - Current date.
20. **NOW**: =NOW() - Current date and time.
21. **YEAR**: =YEAR(A1) - Extracts year.
22. **MONTH**: =MONTH(A1) - Extracts month.
23. **DAY**: =DAY(A1) - Extracts day.
MS Excel Formulas and Commands

## Financial Functions:
24. **PMT**: =PMT(5%/12, 60, -20000) - Calculates loan payments.
25. **PV**: =PV(5%/12, 60, -500) - Calculates present value.
26. **FV**: =FV(5%/12, 60, -500) - Calculates future value.

## Data Cleaning & Manipulation:


27. **TRIM**: =TRIM(A1) - Removes extra spaces.
28. **CLEAN**: =CLEAN(A1) - Removes non-printable characters.
29. **TEXT**: =TEXT(A1, "MM/DD/YYYY") - Formats text.

## Common Excel Commands:


- **CTRL + C**: Copy
- **CTRL + V**: Paste
- **CTRL + X**: Cut
- **CTRL + Z**: Undo
- **CTRL + Y**: Redo
- **CTRL + P**: Print
- **CTRL + S**: Save
- **CTRL + F**: Find
- **CTRL + H**: Replace
- **CTRL + SHIFT + L**: Apply filters
- **ALT + E + S + V**: Paste special values

This document contains essential formulas and commands for efficient Excel usage.

You might also like