Learn Advance Excel Course With 50+ Formulas

Learn Microsoft Excel from beginning  to  Advanced. Learn Advance Excel Course with 50+ Functions / 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

Top 10 Advance Excel Formula  


5  Basic Formulas : 

1. Sum 

2. Average 

3. Max 

4. Min 

5. Count


6 Statistical Function : 

1. Sumif 

2. Sumifs 

3. Countif 

4. Countifs 

5. Averageif 

6. Averageifs 


7 Text Functions : 

1 Proper 

2 Upper 

3 Lower 

4 Left 

5 Right 

6 Mid 

7 Len 

8 Trim 

9 Concatenate 


8 Logical reunions : 

1 If

2 If And 

3 If Or Error 

4 Function 

5 Choose


9 Cell referenced : 

1 Relative 

2 Absolute Reference 

3 Mixed Reference 


10 Count functions : 

1 Count 

2 Counta

3 Countif

4 Countifs 

5 Countblank 


8) Data Related Functions: 

1 Sorting 

2 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



0 Comments: