I have good knowledge of excel below mentioned are my excel skill and i have also good speed of typing
EXCEL SKILLS:
● VLOOKUP
● INDEX and MATCH.
● Separating input data from calculations.
● IF, AND, OR to use basic conditional logic formulas.
● Pivot Tables
● Named Ranges
● Making charts that combine multiple types (e.g. a line graph overlayed on a bar chart, clustered bar
charts, )
● Array Formulas
● Custom number formats (e.g. making 3000000 show up as "$3.0 million")
● Conditional Formatting
● Special types of paste (paste link, paste values, paste formats, etc)
● Doing almost everything with keyboard shortcuts
● Text-To-Columns (To parse flat text files)