ADVANCE EXCEL
You’ll learn how to use Excel for data analysis, visualization, and automation. You’ll also learn how to create custom Excel functions and macros.
Syllabus
| Syllabus |
|---|
| 1.SHEET ANALYSIS |
| 2.FILTER & ADVANCE FILTER |
| 3.SUB TOTAL |
| 4.SOLVER |
| 5.DATA |
| 6.CONSOLIDATION |
| 7.ALL OF DATA VALIDATION |
| 8.WHAT IF ANALYSIS |
| 9.VLOOKUP |
| 10.NESTED VLOOKUP WITH MULTIPLE |
| 11.TABLE |
| 12.HLOOKUP |
| 13.PIVOT TABLE |
| 14.TOP 10 FORMULAS |
| 15.DATA SERIES |
| 16.CASE FORMAT |
| 17.DB FUNCTION |
| 18.DATE/TIME & CELL JOINING |
| 19.SHEET JOIN |
| 20.CELL STYLE |
| 21.CELL FORMAT |
| 23.IF ERROR |
| 24.IFNA |
| 25.SUMIF |
| 26.SUMIFS |
| 27.COUNTIF |
| 28.COUNTIFS |
| 29.ALL TEXT FUNCTION |
| 30.FV |
| 31.SLN |
| 32.RATE |
| 33.PV |
| 34.SCENRAIO MANAGER |
| 35.NPER |
| 36.SHORTCUT KEYS |
| 37.INDEX |
| 38.FREEZE PANES |
| 39.PROTECT SHEET & WORKBOOK |
| 40.ROUND FUNCTION |
| 41.ALL CONDITIONAL FORMATTING |
| 42.PRACTICAL PROJECT |