Forum Discussion
Import a CSV File and Pivot tables
Riny_van_Eekelen okay I know what you mean but the thing is there are two parts to it and I dont know if I put it together in one or separate. I am really confused on what to do in general. I have absolutely no experience with excel.
Do you think you could help me?
I'm not a historian and have no clue about what you are supposed to analyse. I can't make the table(s) for you. But, you managed to "import" the data into Excel. Creating the Pivot Table is no more than following the instructions in your assignment paper. Just select a cell anywhere inside the data and press DATA (in the menu at the top) and then "Summarise with Pivot Table" and see what happens. Follow the instructions a try. Don't be scared to do wrong. If you do, discard and start from the beginning. You'll figure it out.
PS: Don't really understand that you are asked to do this without having been told about the basics of pivot tables in Excel. Good Luck!