# Learn Advance Excel Course With 50+ Formulas

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

### 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  In Excel In Hindi

3. COUNTIF Function In Excel In Hindi

4. COUNTIFS Function In Excel In Hindi

5. Averageif Function In Excel In Hindi

6. Averageifs In Excel In Hindi

### 7 Text Functions :

1 Proper Function In Excel

2 Upper Function In Excel

3 Lower Function In Excel

4 Left Function In Excel

5 Right Function In Excel

6 Mid Function In Excel In Hindi

7 Len Function In Excel

8 Trim Function in Excel

9 Concatenate Function In Excel

### 8 Logical reunions :

1 If Function In Excel

2 If And Function In Excel

3 If Or Function In Excel

4 Nested If Function

5 Choose

1 Relative

2 Absolute Reference

3 Mixed Reference

### 10 Count functions :

1 Count

2 Counta

3 Countif Function

4 Countifs Function

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

11 Macros

12 Page Setup With Printing Options

13 Data Security

1. How to calculate age in MS Excel

2. How to calculate percentage in MS Excel

3. How to convert Binary to Decimal Number in MS Excel

4. How to add country code before mobile no in MS Excel

5. How to calculate compound interest in MS Excel

6. How to convert number to text in MS Excel

7. How to remove duplicate value in MS Excel

### Function

ABS Function In Excel