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 : 

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 : 

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


8) 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 


Post a Comment

0 Comments