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

1. Introduction to MS Excel

2. Formatting Cells, Rows, Columns

3. Conditional Formatting

4. Sorting Data

1. Sum

2. Average

3. Max

4. Min

5. Count

1. Sumif

2. Sumifs

3. Countif

4. Countifs

5. Averageif

6. Averageifs

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

1 Relative

2 Absolute Reference

3 Mixed Reference

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

11 Macros

12 Page Setup With Printing Options

13 Data Security