You were hired as a financial data analyst at a construction company. You were given a table and subsequent instructions on what to do with the data.The table is about vehicle purchase requests from the company’s branches. It includes all cash inflows that can be brought by those assets.
*All paragraphs underlined and in italics are the instructions from your boss.
Action: Change the Data Format
First, your boss wants the raw data to be readable.
You can notice that the cash flows are hard to read because they don’t have any comma or dots that separate the numbers. This problem will be magnified if we are all ready to perform more calculations.
To solve this, we have to change the format of the cash flows into the Number format. Here’s how to do this:
Step 1: Select the values whose format is to be changed.
Step 2: At the center of the Home Tab, you should find a dropdown which lists different kinds of formats.
Step 3: You can choose either Number or Currency. If you choose a number, the data will change into a comma-dot format. If you choose Currency, the data will have a currency sign aside from changing into the comma-dot form. Assuming you have chosen currency, it will look like this:
Step 4: If you want to change the currency, just click on the arrow like the one shown below:
Step 5: Under Number, choose Currency. You will be able to find a drop-down named Symbol. From there you can choose the currency you want.
What have you noticed? Don’t you think the data is hard to read because of the currency? The currency is not so important at all so let’s use the Number format.
Step 6: Use the Number format so that it’s more readable. The data should now look like this:
View All BIWS Courses –Free $97 Bonus for FinanceWalk Readers