Overview
Curriculum
Overview
Microsoft Excel is a software or we can say a Reporting Tool, developed by Microsoft. This is
the part of Microsoft office suite.
Microsoft Excel is a spreadsheet or a big table which contains many cells, rows and columns.
Microsoft introduced Excel on September 30, 1985.
Now days Excel is the essential part of any business.
Every file in the computer system has a file extension like wise Excel has extension .XLS OR
.XLSX.
MS Excel has many different kind of functions and formulas by which we can make our work
easier and interesting.
the part of Microsoft office suite.
Microsoft Excel is a spreadsheet or a big table which contains many cells, rows and columns.
Microsoft introduced Excel on September 30, 1985.
Now days Excel is the essential part of any business.
Every file in the computer system has a file extension like wise Excel has extension .XLS OR
.XLSX.
MS Excel has many different kind of functions and formulas by which we can make our work
easier and interesting.
Learning Excel does not really expect any specific education or knowledge just detailed knowledge of computers will be good.
Opting for this course is just a way of enhancing your knowledge and management skills. This advanced Excel training course is formulated precisely for spreadsheet users who are already proficient and wishing to take their skills to an advanced level. This will make you stand out and skillful from the old MS Excel training.
These days, many companies and jobs require advanced Excel skills. Having a detailed conception of these Complex functions can help you secure a better job or position in a well known multinational company, will boost your career to a whole new level. Advanced Excel skills can also help with your startup. This will make you more optimistic, able and stand out from the rest.
Curriculum
Masters in Excel
Data Validation
1. Specifying a valid range of values for a cell2. Specifying a list of valid values for a cell
3. Specifying custom validations based on formula for a cell
Working with Reports
1. Creating Pivot tables2. Formatting and customizing Pivot tables
3. Using advanced options of Pivot tables
4. Merge more than one table in one pivot table
5. Pivot charts
6. Consolidating data from multiple sheets and files using Pivot tables
7. Creating Slicers ( Version 2010 & Above)
Dynamic Dashboard
1. Creating Dynamic Dashboard2. Use of Developer Tools
3. Using some tricks to show desirable reports
C Recursion
C Storage Class
C Function Examples
More Functions
1. Date and time functions3. Database functions
4. Power Functions (CountIf, CountIFS, SumIF, SumIfS)
5. INDIRECT, ADDRESS, ROW, ROWS, COLUMN, COLUMNS, SMALL, LARGE Etc.
List of Formulas What we will Cover in this Course
Financial Functions
1.DB2.DDB
3.FV
4. FVSCHEDULE
5. PMT
6. PPMT
7. IPMT
8.PV
10. ISPMT
11. NPER
12. RATE
13. RRI
14. SLN
Logical Functions
15. AND16. FALSE
17. IF
18. IFERROR
19. IFNA
20. IFS
21. NOT
22. OR
23. SWITCH
24. TRUE
Text Functions
25. CONCAT26. FIND
27. SEARCH
28. LEFT
29. RIGHT
30. MID
31. LEN
32. LOWER
33. UPPER
34. PROPER
35. NUMBERVALUE
36. REPLACE
37. SUBSTITUTE
38. TEXT
39. TEXTJOIN
40. TRIM
Date & Time Functions
41. DATE42. DATEVALUE
43. DAY
44. DAYS
45. DAYS360
46. EDATE
47. EOMONTH
48. HOUR
49. MINUTE
50. SECOND
51. MONTH
52. YEAR
53. ISOWEEKNUM
54. NETWORKDAYS
55. NETWORKDAYS.INTL
56. NOW
57. TODAY
58. TIME
59. TIMEVALUE
60. WEEKDAY
61. WEEKNUM
62. WORKDAY
63. WORKDAY.IMTL
Lookup & Reference Functions
64. ADDRESS65. CHOOSE
66. ROW
67. ROWS
68. COLUMN
69. COLUMNS
70. GETPIVOTDATA
71. LOOKUP
72. VLOOKUP
73. HLOOKUP
74. INDEX
75. INDIRECT
76. MATCH
77. OFFSET
Other Functions
78. ABS79. MOD
80. SUM
81. SUMIF
82. SUMIFS
83. COUNT
84. COUNTA
85. COUNTBLANK
86. COUNTIF
87. COUNTIFS
88. SUBTOTAL
89. ROUND
90. ROUNDDOWN
91. MROUND
92. ROUNDUP
93. FLOOR
94. CEILING
95. RAND
96.RANDBETWEEN
97. AVERAGE
98. AVERAGEIF
99. AVERAGEIFS
100. SMALL
101. LARGE
102. MAX
103. MAXA
104. MAXIFS
105. MIN
106. MINA
107. MINIFS
108. ISBLANK
109. ISERR
110. ISERROR
111. ISEVEN
112. ISODD
113. ISFORMULA
114. ISLOGICAL
115. ISNA
116. ISNONTEXT
117. ISNUMBER
118. ISTEXT
119. SHEET
120. SHEETS
121. CONCATENATE