This class is for those who want to learn useful Excel tricks with shortcut commands those are very useful in your day to day work. This class also includes basic information about Excel as sometime we use an application but don't know about its basics which also ask by interviewer. My main target is to aware you about specialities of excel, uses of excel in an organisation so that you are able to do job on any organisation as back-end executive, data entry operator and if learn advanced Excel with VBA then able to do mis executive job.
Topics:
Excel introduction and interface of excel
explain all about workbook worksheet rows columns cells
Excel basic shortcuts
difference between formula and function
Excel advanced shortcuts
advanced filter to get unique data and to get data as per condition
Fill blanks at once
data validation
Vlookup, hlookup, xlookup
Difference between vlookup and hlookup
Benifits of xlookup
Protections