Hi Sir, Myself sundar from chennai, First i would appreciate on your brief explanation for MIS role, it is very clear to understand. i have been working as HR for past 3 Years, but my role as HR is not satisfying me. I was looking for a change where i don't interact with people much, and so i came across MIS Executive Job profile. I just need you to advice me whether this MIS Role will suit me. Pl advice
I did my BSc in Biotech and then i did my MBA and got into HR (Being a HR i play a role of Joker between Orga.. and Emp.. I lack my real skill to prove myself) I m pretty good in excel and i have little analytical skill too (I believe) So i need you to advice me please Regards Sundar On Tuesday, July 26, 2011 4:28:15 PM UTC+5:30, Anand Kumar wrote: > > Hi, > > In case of MIS Executives the kind of the data sets is very rigid. The > data is always in the same format. Mostly the amount of data would > also be the same every day/week. The frequency of reports would be > also same for them, i.e. the MIS is generated on a weekly, daily or 15 > days or quarterly basis. The data is extracted from a source which is > set by a business analyst beforehand and should not or is not > manipulated without prior permission. Considering all this we can > conclude: > > 1. MIS Executive is Good at Excel functions like Lookup, Vlookup and > Hlookup > 2. He/She has some knowledge of pivot tables and data extraction. > 3. He/She can work comfortably on data sets of around 20,000 rows and > 200 colums (approx) > 4. He/She should have some knowledge of text manipulation functions > (Concatenate, len, find, left, right etc). > 5. He/She should be comfortable using combination of functions e.g. > extract first name from email id in cell A1 when A1 contains > anan...@gmail.com <javascript:> > 6. He/She should be able to use logical functions > 7. Should be able to use error handling functions available in MS > Excel. > 8. Last but not the least WILLINGNESS TO LEARN. > > Warm regards, > Anand Kumar. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
