EXCEL IN REAL WORLD.

Excel is a universal known tool by how it handles data and also how it's used to analyze data.
Below are some of the ways excel is used in real world;

1. Finance Industry

• Excel is used in this industry to track for profits or losses to track growth.

• Used to forecast financial discipline by a company

1. Human Resource

-In companies, the HR is tasked with tracking everything employees have to do including how they are supposed to get paid and mostly, the HR uses excel to do that and is responsible for all their data.

1. Sales & Marketing

-Customer and sales tracking.

-Campaign performance dashboards.

-Market research survey data.

3 Excel function/formulas

1. VLOOKUP
   -We might use VLOOKUP to look for related data let's say when you have two lists or data but both have a common identifier.

2. Concatenate Formulas
   -Assume you want to have a worker's name and where they live, you can combine those two in a different cell by using this formula.

3. Pivot Tables
   -Assume you want to check how a product is doing in different states if not cities, you can use the pivot tables to analyze that and you'll have your views or results.

PERSONAL REFLECTION
Before I enrolled for this course, I had a hint of how excel is used but didn't know it was this broad. With the concept of using functions and also visualization I can now see this all differently.

Just from excel definition, excel have taught me the importance of cleaning data. This will help even in the future how I approach data. And with the help of visualization, I can now group important takes instead of just looking for them manually from a dataset.

In conclusion, I now see data differently. Before I used to be overwhelmed by the size of data but now I approach all this as an opportunity since handling messy data and large data is now a normal thing to me.