Apr 17, 2022

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

1. Introduction to MS Excel

2. Formatting Cells, Rows, Columns

3. Conditional Formatting

4. Sorting Data

Top 10 Advance Excel Formula  


Module : 5  Basic Formulas : 

1. Sum 

2. Average 

3. Max 

4. Min 

5. Count


Module : 6 Statistical Function : 

1. Sumif 

2. Sumifs 

3. Countif 

4. Countifs 

5. Averageif 

6. Averageifs 


Module : 7 Text Functions : 

1 Proper 

2 Upper 

3 Lower 

4 Left 

5 Right 

6 Mid 

7 Len 

8 Trim 

9 Concatenate 


Module : 8 Logical reunions : 

1 If

2 If And 

3 If Or Error 

4 Function 

5 Choose


Module : 9 Cell referenced : 

1 Relative 

2 Absolute Reference 

3 Mixed Reference 


Module : 10 Count functions : 

1 Count 

2 Counta

3 Countif

4 Countifs 

5 Countblank 


Module : 11 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



Share:

0 Comments: