Question description:
This user has given permission to use the problem statement for this
blog.
I rate shoddy work mercilessly. I require an expert to handle my complex finance data for very critical and analytical skills and data in excel. dont risk if you are an average expert
Solved by M. J. in 13 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
24/05/2018 - 04:52
Hello, how are you?
User
24/05/2018 - 04:52
Am good thanks, yourself?
Excelchat Expert
24/05/2018 - 04:53
Am good too. How may I be of assistance to you?
User
24/05/2018 - 04:54
I require some advice on how to present my finance data in a simple way
Excelchat Expert
24/05/2018 - 04:55
Do you mind uploading the excel file so that I can examine it locally?
User
24/05/2018 - 04:56
Am afraid it contains very sensitive data so i cannot share
User
24/05/2018 - 04:56
Are you not able to explain?
Excelchat Expert
24/05/2018 - 04:56
I can and i will
Excelchat Expert
24/05/2018 - 04:57
Now, you need to use a pivot table
User
24/05/2018 - 04:57
How do i go about that?
Excelchat Expert
24/05/2018 - 04:58
You need to select the whole of your data you want to analyse then click insert
User
24/05/2018 - 04:58
Hold on please
Excelchat Expert
24/05/2018 - 04:58
Am waiting
Excelchat Expert
24/05/2018 - 04:58
Are you there?
User
24/05/2018 - 04:58
Yes
Excelchat Expert
24/05/2018 - 04:59
Then choose pivot table
User
24/05/2018 - 04:59
ok
Excelchat Expert
24/05/2018 - 04:59
then choose to present the table on a new worksheet
Excelchat Expert
24/05/2018 - 05:00
are you able to do that?
User
24/05/2018 - 05:00
yes
Excelchat Expert
24/05/2018 - 05:00
click ok
Excelchat Expert
24/05/2018 - 05:02
It will take you to a new sheet where yo will need to click on the blank table on your left so that it populates field options on your right
Excelchat Expert
24/05/2018 - 05:02
are you there?
User
24/05/2018 - 05:03
Yes i got it, then i have all the options in this field list
User
24/05/2018 - 05:03
Now i can choose them as i want
Excelchat Expert
24/05/2018 - 05:03
Exactly
User
24/05/2018 - 05:04
Oh thankyou so much
User
24/05/2018 - 05:04
am so grateful
Excelchat Expert
24/05/2018 - 05:04
You are so welcome. Please remember to rate me well after closing the session. A 5star will be kind enough. And a nice comment if you don’t mind.
User
24/05/2018 - 05:04
Sure, i will
Excelchat Expert
24/05/2018 - 05:05
Have a good day
User
24/05/2018 - 05:05
Good day too
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.