# 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

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

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

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

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