How Excel is used in Real-World Data Analysis

Excel is a spreadsheet program developed by Microsoft that features calculation capabilities, graphic tools, pivot tables and VBA-a macro programming language. Excel organizes data or information in rows and columns

Excel is a useful tool in the real-world data analysis! It is used for business analysis-use of various types of data to help in decision making with regards to the business. Excel is used for financial planning and reporting-one can generate financial statements and balance sheets. Financial reporting is essential in predicting future financial performances and assessing probable investments and risks that may be involved. Additionally, excel is used to store and manage data hence making it easy to access and extract information when needed

The features in excel are:
1.Data entry and management-Excel allows one to enter data in rows and columns, the data can further be used to perform tasks by applying the formulas in excel such as SUM, AVERAGE & IF
2.Formulas: Excel can be used to perform functions; for instance, the SUM adds the values in the cells, AVERAGE calculates the average of values in a particular column, VLOOKUP is used to search for a value in column and match it in the second column
3.Operators-Excel consists of various operators such as +, -, *, <,>...etc, these are used to perform calculations during the analysis of data.

After learning excel, my perception of it has really changed, it is a simple tool that is interesting and powerful at the same time, I can't wait to explore more of it and apply it!