Learn Advance Excel Course With 50+ Functions || Advance Excel Syllabus

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. Row & Column 

7. Time Function (Hour , Minutes , Second)

8. Now And Today Function 

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


Post a Comment

0 Comments