MS EXCEL

What is MS EXCEL?

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, Mac OS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. Excel forms part of the Microsoft Office suite of software.

SYLLABUS:

  1. Basics – worksheet, workbook, (.xlsb, .slxm, .xls) sheet linking, sheet movement, sheet name change, sheet colour change, formula bar, view ( gridlines, full view, freeze pan.)
  2. Sum, count, min, max, small, large, choose.
  3. Average, mode, median, percentile, rank.
  4. If, sumifs, countifs, rank & if.
  5. Array formula.
  6. Index, match, vlookup, and hlookup.
  7. Indirect, concatenate, named ranges.
  8. Offset.
  9. Sum product.
  10. Pivot.
  11. Conditional formatting.
  12. Charts.

Why Learn MS Excel?

  • Getting Excel certificate stamps you got more technical skills than other this will get you more job opportunities in your way.
  • Companies prefer to hire the certified skill employees.
  • Excel training doesn’t focus only on making you an expert. It includes many modules to enhance your overall management skills so that you can grab higher positions as well.

ELIGIBILITY:

After completion of class 9 any one can join this course.

DURATION OF COURSE:

7 Weeks classes

ABOUT TRAINER:

Name: Mr. Raghav Nuwal

Education: MBA – IIM, B. Tech – IIT