Learn basic to advanced level ms excel.
Curriculum
- 2 Sections
- 9 Lessons
- 4 Weeks
Expand all sectionsCollapse all sections
- MS Excel Formulas & FunctionsExcel Training - Basic1
- Excel Training - Advanced8
- 2.101. Formula and Functions – Introduction, sum, avg, min-max
- 2.202. Date & Time, Joining Texts, Common Keys
- 2.303. Cell Reference
- 2.404. Count, Min Max, SumProduct, DSUM
- 2.505. Usage If, Or, And, conditional formatting & conditional functions SumIf, countif
- 2.606. Vlookup, Hlookup, Match, Offset, Index
- 2.707. Manipulating Text – LEN, LEFT, RIGHT, Concatenate, Rept, Find, Search
- 2.808. Sort, Filter, Pivot, Text2Column
Basic to Advanced level of MS Excel
Requirements
- No Prior Knowledge Required
Features
- MS Excel
Target audiences
- All