JEMTEC

  This question I get from students, whom I have been teaching and they find Excel to be a software which is specially designed for accounting purposes or managers preparing their reports. To answer this query, I surveyed and observed many multi-national companies and startups who come to campuses for placements for professionals, and the answer was that Excel skills was one of the criteria. Hence, considering the importance of it, below are top 5 excel functions a professional or student must know for standing out in the workplace or being sought after. 1.        Conditional formatting : One of the tools of Excel to visualize the data in your spreadsheet. Based on the condition put, you can colourfully create patterns dynamically whether it is cell background or cell value, duplicate or unique values. 2.        Pivot Tables/Charts : Another powerful feature provided by Excel, helpful in summarizing large amounts of data ie. Extract the significant characteristics from the datase