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.