MS Excel A65

500 5000

Basics To Advanced Excel Training For Students

Language - Explanation in Hindi + English Mix 

Course is designed to equip students with Excel Skills required in a Job/Articleship

Topics Covered In Basic Course - 
1) Creating an excel file, entering data in excel, saving a workbook, reopening a saved workbook
2)  Hiding or unhiding rows/columns, creating multiple sheets within excel, renaming sheets, hiding/unhiding sheets
3) Formatting a data set (borders, cell alignment, cell coloring etc.), using excel toolbars and menus - like merging cell, format painter, creating lists etc.
4) Editing cells, inserting comments,  copy and paste special, filtering & sorting data, conditional formatting, copying filtered data
5) Using Formulas - Count, Sum, Average, Max, Min, If, Sumif, Sumifs, CountA, Countif, Vlookup,Trim , Concatenate/&, Proper
6) Creating charts and pivot tables, importing data into excel text to column, removing duplicate values
7) Inserting hyperlinks and objects within excel
8) Using various shortcuts in excel to work faster - cheat sheet
9) Advance Excel Module Includes Goal Seek, Index Match, Loan Repayment Schedule, Macros, Building Financial Model 
10) 4-5 case studies on practical work used in industry (relevant for auditing and case study on how to make Schedule III Balance sheet in excel) 
11) Course can be viewed 3 times completely however chat facility/study group is available for 12 months 
12) Access to Excel Community - Study Groups - 24*7 Access For 1 Year

Note - Certificate of completion available after course completion

Limited Period Offer - Grab The Opportunity