August 18, 2020
I would like to make an Excel file containing a list of people, the company where they work, the industry in which they work, how I am connected with them (Facebook / Linkedin / Twitter / Instagram or combinations), place of residence and possibly some extra notes on the person. Of this data I would like to be able to see the statistics, such as how many people do I know through Linkedin and how many people work at the same company or branch.
Since I don't have much experience with Excel, I started looking for a template. Unfortunately, there are many extensive templates with functions that I do not need. I just want to keep it as simple as possible. Is there anyone here who knows a good template, or someone who could put it together easily? Thanks in advance!
July 16, 2010
Welcome to our forum!
You can do this with a PivotTable and Slicers. Start with the following columns:
- Contact Name
- Facebook (enter a Y or N)
- LinkedIn (enter a Y or N)
- Twitter (enter a Y or N)li
- Instagram (enter a Y or N)
Once you've got some data you can use a PivotTableto analyse the data and Slicersto filter it.
I hope that points you in the right direction.