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
2. Formatting Cells, Rows, Columns
3. Conditional Formatting
4. Sorting Data
Top 10 Advance Excel Formula
5 Basic Formulas :
3. Max
4. Min
5. Count
7. Time Function (Hour , Minutes , Second)
6 Statistical Function :
1. Sumif
2. Sumifs
3. Countif
4. Countifs
5. Averageif
6. Averageifs
7 Text Functions :
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
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