Learn Advance Excel Course With 50+ Formulas

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 Excel
2. Formatting Cells, Rows, Columns
3. Conditional Formatting
4. Sorting Data

5 Basic Formulas Of Excel :

1. Sum
2. 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 Hindi
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

7. Product and Sumproduct Function in Excel 

8. Subtotal Function In Excel

7 Text Functions :

1 Proper Function In Excel
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 Logical reunions :

1 If Function In Excel
2 If And Function In Excel
3 If Or Function In Excel
4 Nested If Function
5 Choose

9 Cell referenced :

1 Relative
2 Absolute Reference
3 Mixed Reference

10 Count functions :

1 Count
2 Counta
3 Countif Function
4 Countifs Function
5 Countblank

11) Financial Formula 

1. PMT ( EMI Calculate)

2. IPMT (Interest Calculate)

3. PPMT (Principle Amount Calculator)

4. PV (Present Value)

5. FV (Future Value)

11) Lookup Function 

Lookup Function 

Vlookup Function 

Hlookup Function 

Index And Match 

12) Data Related Functions:

1 Sorting
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

Advance Excel 

1. How to calculate age in MS Excel
2. 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

Function

ABS Function In Excel