MS Excel A65
500Basics 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