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.
Advance Excel Tutorials
1. Introduction to MS Excel2. Formatting Cells, Rows, Columns
3. Conditional Formatting
4. Sorting Data
5 Basic Formulas Of Excel :
1. Sum2. Average
3. Max
4. Min
5. Count
6. Row & Column
7. Time Function (Hour , Minutes , Second)
8. Now And Today Function
6 Statistical Function In Excel:
1. Sumif In Excel In Hindi2. 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
7 Text Functions :
1 Proper Function In Excel2 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 Logical reunions :
1 If Function In Excel2 If And Function In Excel
3 If Or Function In Excel
4 Nested If Function
5 Choose
9 Cell referenced :
1 Relative2 Absolute Reference
3 Mixed Reference
11) Financial Formula
11) Lookup Function
Index And Match
2 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
12) 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
Advance Excel
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
0 Comments