Learn Microsoft Excel Course from beginning to Advanced. Learn Advance Excel Course with 50+ Excel Formulas such as VLOOKUP, Index & Match , Logical Formulas , Financial Formulas, cells formatting, macro and many more.
There are many categories of Excel formulas, but here are some of the most common ones:
1. Arithmetic Formulas: Used for basic mathematical operations like addition, subtraction, multiplication, and division.
2. Logical Formulas: Used for evaluating logical conditions like IF statements, AND, OR, NOT, etc.
3. Lookup and Reference Formulas: Used for finding and referencing specific data within a worksheet or across multiple worksheets.
4. Date and Time Formulas: Used for calculating and manipulating dates and times.
5. Text Formulas: Used for manipulating text strings, including concatenating, separating, and formatting text.
6. Financial Formulas: Used for calculating financial data, including interest rates, loan payments, and investment returns.
7. Statistical Formulas: Used for analyzing statistical data, including mean, median, mode, standard deviation, and variance.
8. Engineering Formulas: Used for performing engineering calculations, including calculations related to electricity, mechanics, and materials science.
9. Database Formulas: Used for working with data stored in a database.
10. Array Formulas: Used for performing calculations on a range of cells rather than a single cell.
Basic Excel
File Tab
Home Tab
Insert Tab
Page Layout Tab
Review Tab
View Tab
Advance Excel Tutorials
2. Logical reunions :
2 If And Function In Excel
3 If Or Function In Excel
4 Nested If Function
5 Choose
3. Cell referenced :
2 Absolute Reference
3 Mixed Reference
4. Lookup Function
5. Statistical Function In Excel:
2. Sumifs Function In Excel In Hindi
3. COUNTIF Function In Excel In Hindi
4. COUNTIFS Function In Excel In Hindi
5. Averageif Function In Excel In Hindi
6. Averageifs In Excel In Hindi
6. Count functions :
2 Counta
3 Countif Function
4 Countifs Function
5 Countblank
7 Text Functions :
2 Upper Function In Excel
3 Lower Function In Excel
4 Left Function In Excel
5 Right Function In Excel
6 Mid Function In Excel In Hindi
7 Len Function In Excel
8 Trim Function in Excel
9 Concatenate Function In Excel
8. Financial Formula
9. Other Excel Functions
10. Data Related Functions:
1 Sorting2 Data Validation
3 Consolidation
4 Pivot Table
5 Dashboards
6 Slicers
7 Drop Down List
8 Transpose
9 Remove Duplicates
10 Linking Sheets
11 Macros
12 Page Setup With Printing Options
13 Data Security
14 Password Protection
11. Beyond Of Syllabus
1. How to calculate age in MS Excel2. How to calculate percentage in MS Excel
3. How to convert Binary to Decimal Number in MS Excel
4. How to add country code before mobile no in MS Excel
5. How to calculate compound interest in MS Excel
6. How to convert number to text in MS Excel
7. How to remove duplicate value in MS Excel