Well verse with the excel knowldge.
Can under the data very well.
Excel shortcuts so that the data will be not take much time.
Basics of macros to compkete the task in the mentioned time
Following are the skills I Know
Vlookup,
Sum funtion,
Maximum & Minimum function,
IF function,
SUMIF function,
CountIF function,
AND function,
OR function,
LEFT, RIGHT & CONCATENATE function,
Round function,
Proper function,
Now Function,
Pivot tabels,
Conditional formatting
Excel functions can greatly enhance our ability to perform tasks in day to day activities in Excel. While their are hundreds of functions out there, I feel there are 15 functions that all Excel users know. Whether you are an office worker, or a small business owner using Excel to keep track of your finances or just the casual user, these 15 Excel functions can be very important time savers and enhance my ability to create better performing spreadsheets!