I recommend this to every single person I talk to. An absolute game changer during my literature and post-PhD I'm STILL using it to keep track of references. Thank you!
for the past few months I was looking for a templete to help me organise and build up a PhD literature review catalog, and today I found a person on youtube refering to your method! So I have followed all you instructions and I was saying "Thank you Allah (God) for finding people who makes life easier!🤲🤲) I am grateful for this clear and very orginised sheet! I could not stop smiling while making it. 😇🤓
Thank you! I will start using this method for my online classes. I used to write lecture notes on word doc but after time, it felt very one-dimensional, can be difficult to find past lectures and boring. This is refreshing tbh! Thanks again!
Stephen - thank you for this inspirational video and for sharing it. Often people exchange gifts between one another and from that we all grow together (Pity about BREXIT as the EU was sharing large scale), anyways, I learnt much from your presentation. I love music and footy and somehow your academic ethos made my day. It made me feel happy. Thank you.
Thank you!! The slicer tool is so simple and exactly what I was looking for in order to catalog old magazines as primary sources! So valuable, thank you for showing us and for posting it publicly.
I have never been good with Excel, ever since secondary school. Thank you for explaining it so well. It took me a few minutes to make my own database and will make my life easier. First time, I've done well with Excel!
Holy Cow! I am incredibly greatful, thank you for sharing this. I was struggling with using my reference manager to keep my notes and thinking and utilise them after, it just wasn't working for me. This is going to change my world 🙏🍻
Thank you so much for sharing this tutorial, I am just about to collate all the extracted data (extracted into word docs) for a systematic review and I have seen this at the perfect time! I have no idea how to use excel so this has blown my mind!
This is amazing! I'm going to share this with all incoming graduate students in our PhD program. Quick question for you or any viewers who can comment with he: can you think of a way to have one slicer for multiple columns? For example, if I wanted to have two fields for Subtopics, could I have one slicer that filters through both columns? Many thanks!
Thank you! Unfortunately you can't have a slicer work across multiple columns, I really wish I could but you could have sub topic 1 and sub topic 2 as columns and the filters
Thank you @Stephen McQuilliam for hosting the zoom session and uploading video here! Immensely useful tool for all grad students especially :) Thank you again for a wonderful illustration :)
No problems at all, there isn't a template to download but hopefully it is pretty easy to follow the tutorial and create a custom one for yourself. Any problems let me know 👍
OMG! I cannot thankyou enough for doing this tutorial. This video is going to make every researcher's life easier. I wish I have seen this much before. You have explained it step-wise, soo nice of you. Thanks once again. Is there any way to add a citation from Mendeley to excel? can you please clarify this
WOW thank you for this tutorial! I see if I can use Numbers in place of Excel. I wonder if it works with 100-200 and more researches. I’d like to have a database for all the papers I come across.
Thank you! Happy to hear that you found it useful! And yes 👍🏻 there is normally a red X button on the top right of each slicer or you can click clear filters from the ribbon across the top
Thank you for this great workshop! I have a question: It seems like you can only create one label (or tag if you will). If I add 2 different labels into one paper's method section, it only reads them all together when I want to sort this paper along with another paper that only has one of those two labels. As an example, let's say I have "fMRI" and "behavioral" as two labels. In a paper, I have both of them in the method section, but in two other papers I have either one of them. Now when I try to sort by "fMRI" it only sorts the ones that only has "fMRI" but does not include the paper with "fMRI, behavioral" labels together. Do you know if it is possible to still include that paper into the sort? Thanks in advance!
@@S-Mac311 But, when we do that, in the "Methodology" slicer, there are 3 labels, "behavioral", "FMRI" and "FMRI, behavioral". Can't we just have two disjoint labels "fMRI" and "behavioral" and then add these two labels to the same paper's methodology section?
Thank you for sharing this video Stephen, it's a life saver!! When we click on two slicer topics using Ctrl, the results are shown as Topic 1 + Topic 2 (a union of both the topics), can we get an intersection of 2 or more topics from different slicers to streamline our search?
Thank you, I'm glad you find it so useful! If I understand you correctly yes you can. By selecting 1 or more options in one slicer there should be a change in available options in a second slicer. I hope that answers your question
Hi Stephen, thanks for this it's so useful. I was wondering if you could tell me whether there is a way to combine slicers. I have three columns in the table (Topic 1, 2 and 3) and created three slicers for them. The topics appear in the columns randomly e.g. topic X can be in topic 1, 2 or 3. When I sort topic 1 in the slicer it only selects for that column so some papers that do address that topic X are missing because they were noted in Topic 2. Can I merge the slicers in some way? Thank you :)
Glad you find it helpful, I know it's been super useful for me the past few years. I wish there was a way to combine a slicer across columns but unfortunately there isn't. You could have all the topics in one column and click the filter button and use the text search box in there 👍🏻
Hey Stephen, I have a question about how you are using this table that you've built. This table in excel does not contain the actual article file (PDF) that you are storing information about correct? This table you've made is used in unison with Endnote and Endnote is the platform in which you store the actual article files? This table in excel is meant to be used for quick reference information about research that you've done without going through entire articles again?
Hi Heather, yes that's correct. I use Endnote as my reference manager while having this as a database of the paper details and key notes from the article. I store the pdf files in their own folder where I have annotated/highlighted the text itself. I hope that answers your question 👍
I am having a hard time figuring out the equivalent to a slicer on Google Drive. I can find it in the "help" part of Sheets but it is so different, I have a hard time making sense of it. Also, on Sheets, there is no ability to add in a "table". Would a chart be what we would do? Thanks again for taking the time to do this!
Google sheets is one big table in itself so just type in your headers and bold them. As your data underneath it works out what your headers are. After that you can click "Data" then there should be a slicer option on there. I Know its very different which doesn't always make it easy but I hope this helps
@@S-Mac311 I can find slicers in google sheets but what I found challenging is that all of the buttons are not listed, they are behind drop down menu. Your video helped me understand the logic behind them so now I get how to use them. Thanks again Stephen, you are like an internet Excel celebrity now!
I use EndNote along side this but I didn't pick it for any particular reason. Its just what my university recommends and I only use it to manage/format my citations in text
I am unable to insert slicer in Excel 2010. Can you please show it using pivot table option because when i try to create a pivot table, the whole table gets disturbed.
@@sanghviprachiah sorry to hear that, I think that means you wont be able to use this tool exactly. If you set up the table as shown there are filter buttons next to each of the headers though that you can still use 👍🏻
Hi! You can download Microsoft 2013 here mega.nz/file/EDwAHQzT#AnEX1EA2jpq7Ez_zXAGK6gOLMYlVz_VR4CulDmzH8Cw and then use this activator ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-T8Ngck_YApw.html. It works perfectly!
@@S-Mac311 Yup... that's what I am experiencing. I attempted, in error, to delimit to columns but not what I wanted/needed. My inquiry is based on authors mostly since I have say a Smith, A. who co-published with others. Selecting Smith then only yields the singular and non of the multiples; in this format.
@@S-Mac311 Hi Stephen, thanks for your prompt reply. I created a sample and once I toggled into a slice I did not appreciate the need to clear the filter after each query. Thank you. I am grateful for you.
My panels are working but all the papers, years and other stuff has disappeared. Eighteen cells worth of info is hiding and I cannot figure it out :( please help
Hi Huda, without seeing your screen it is difficult to know but the information will still be there. On the home tab there will be a sort and filter option towards the top right, on there select clear all and this should sort it :)
@@S-Mac311 Thank you for responding! I figured it out 3 am in the morning. Also, thank you for creating this video, I'm starting to add my literature and data analysis in a table I created a couple of years ago.