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
1. Introduction to MS Excel
2. Formatting Cells, Rows, Columns
3. Conditional Formatting
4. Sorting Data
Top 10 Advance Excel Formula
5 Basic Formulas :
1. Sum
2. Average
3. Max
4. Min
5. Count
6 Statistical Function :
1. Sumif
2. Sumifs
3. Countif
4. Countifs
5. Averageif
6. Averageifs
7 Text Functions :
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
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
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
0 Comments:
Post a Comment