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. 😇🤓
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!
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!
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!
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.
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
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
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 :)
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 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
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.
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?
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
@@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 ua-cam.com/video/T8Ngck_YApw/v-deo.html. It works perfectly!
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!
@@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.
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 👍
@@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.
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. 😇🤓
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!
This is what I've wanted for years! Thank you!
Shared with my lab and going to shout it from the rooftops, esp for undergrads and early grad students.
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!
This is awesome. One of the best thing on You Tube. Must have for researches.
What an elegant and powerful solution ! 1000 thanks
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.
Glad I could help!
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!
just found your video today and started with my systematic overview immediately. thank you sooo much!
Glad you found the video useful, happy to help! And good luck with the systematic review
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.
Also, you are a natural at this, thank you so much
This is going to change my life - thank you.
Thanks for sharing this Stephen. It's very, very helpful. I've adopted it to keep track of books I read as well.
I think that's a great idea and glad you found the video useful
Thank you very much! This is very helpful and brilliant!
Thank you very much for this valuable tool. Greetings from México!
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!!! Life saver I am getting that 1st class thanks to this
This was great! Thanks so much for sharing this with us all! I can't wait to show my lab and the data course I am teaching in the fall.
This is really great,! Thanks for sharing with with students who are working on systematic reviews!
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!
LIFE SAVER! Thank you very much, Stephen, for sharing!
Thank you so much! This will help a lot.
Excellent tutorial, thanks for sharing!
This is the best thing ive ever seen
It's Amazing! Thanks a lot for making my life easier
that was so helpful thank you so much
YOU HAVE SAVED MY LIFE! Thank you!
This is brilliant! thank you so much.
Thank you! I glad you found it useful
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
Great resource! Thank you for sharing.
Thanks for sharing it's really necessary and helpful for scholars 👍
Brilliant Ste. Well done
Thanks Dan, I appreciate it
This is what Ive been searching for. Thank you so much for sharing.
Is there a template we can download?
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 👍
Holy shit, this is amazing. Thank you so much for sharing this!
this is incredibly beautiful--thank you so much!
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
Thank you so much!
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 :)
Thanks, really helpful!
thanks, nice sharing..
Wish I knew this year 1..but will come in handy for dissertation
This is great!! Thanks= you so much for this!
Fantastic! Thank you for 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.
I'm not sure about that many people contributing but I cant see why not. My database now has over 400 papers and still works very smoothly
@@S-Mac311good news then! Thank you for your reply. It’s good to have only one place for all the references.
brilliant
thank you so much that's so helpful
Thanks a lot for this Stephen, really great.
Do you have to clear the filter to bring back the entire table every time?
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
Thanks, that was amazing!
Thanks, this helped a lot✌
Is it possible to do the same with Numbers for MacOS?
And thank you for the tutorial: it’s incredible how such a simple feature may be so powerful.
Honestly I'm not sure with Mac but I'm sure there will be a similar way to get the same result 👍🏻 hope it helps
@@S-Mac311 I suppose too, maybe under another label. I'll check it out. Thank you again.
i want more videos on that topic
This looks great! Can we do this in google sheets as well?
Thank you! I am pretty sure you can but the layout of the tabs and slicers are slightly different 👍
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
@@S-Mac311 thanks a lot
Has anyone tried to do something similar with Libre Calc as it doesn't have slices I believe?
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.
Can you please share an excel template that one could use?
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!
No problem, if you hold CTRL while you select your two methods that should show both
@@S-Mac311 did not expect it to be that simple :) thanks!
@@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?
Would you be able share the xls?
Hello, thank you so much for sharing! I am wondering if there is a way to make the font size smaller in the slicer.
Hello, there should be a way to do that in either the slicer tab or by right clicking on the slicer and going to format
Thank you! What citation manager would you recommend?
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
Since I have a 2010 version of MS office, the options don't show in slicer. Is there any other way?
Can you still add slicers do the sheet? You may be able to update them by clicking "data refresh" on the "Data" tab in the toolbar
@@S-Mac311 Nope, not able to add slicers at all. I think they work only in versions 2013 and after.
@@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 👍🏻
@@S-Mac311 yes, I'll have to do that. Thanks.
Hi! You can download Microsoft 2013 here mega.nz/file/EDwAHQzT#AnEX1EA2jpq7Ez_zXAGK6gOLMYlVz_VR4CulDmzH8Cw and then use this activator ua-cam.com/video/T8Ngck_YApw/v-deo.html. It works perfectly!
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!
One last thing, this video you hosted, do you do others? If so, how do I sign up?
So where to get the pdf steps?
Question.... If I have a book or article with multiple authors or dates of publication can this be formatted into the slicer function?
In this format it would save multiple authors/dates as one option in a slicer not as individuals I'm afraid
@@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.
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 👍🏻
@@S-Mac311 oh nooo thats such a shame haha! OK thank you I will try that :D
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 👍
@@S-Mac311 Thank you!
I am unable to retrieve my original table once the filter is selected on my MAC
Hi John, I'm not sure about the problem you're having because I don't have a Mac myself. Does the table not come back once you unselect the filter?
@@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.
Which citation manager do you use?
I use EndNote alongside this 👍🏻