MS Excel Shortcuts for quick data analysis & reporting
Microsoft Excel is a spreadsheet developed by Microsoft for Windows, Mac OS X, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of Microsoft Office.
Use of Microsoft Excel
Create Charts – MS Excel allows users in data visualization through data insertion. Through MS Excel, data analysis can be done & represented in the form of charts.
Conditional formatting – Through MS Excel, various conditions can be imposed on the analysis & further data can be highlighted.
Trend Analysis – MS Excel is among the widely used tool to identify the trends from the data. Business owners often use excel worksheets in reporting & decision making process.
Microsoft Excel being a free & simple tool has been utilised across industries especially SME sector. Hence , for students & young executives it is highly recommended to learn MS Excel.
Click the below link to download MBA STAR MS Excel shortcuts