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