Have you ever worked on a large Excel document where you’ve scrolled down to find a figure, but then you’ve had to scroll back up to the top again to remind yourself of what the headings was for that column?!
There’s an incredibly useful function in Excel that can help with this issue, which enables you to freeze single or multiple rows and columns. You can access this feature within Excel by clicking View > FreezePanes.
Watch the video below to learn how to freeze columns and rows:
Blogpost by Laurie Stevenson (Student Digital Champion)
I published Part 1 of this blogpost earlier this week, where I introduced you to 5 tips and tricks to help you make the most of Excel, and this blogpost contains 5 further tips! If you want to learn more about Excel, please visit my new Excel LinkedIn Learning collection.
Tip 6: Adding in multiple rows or columns at once
If you want to add more than one row or column in one go, this tip will save you the time of having to do this one row at a time.
Highlight the number of rows or columns you want
Right-click on the highlighted rows or columns
Choose Insert from the drop-down menu that appears
Tip 7: Adding bullet points
Finding the button to add these is not as easy as on Microsoft Word but luckily there are a couple of different ways to do this.
Blogpost by Laurie Stevenson (Student Digital Champion)
Feel a sense of dread whenever you have to use Excel for your degree? Well, we’re here to help! Many degrees will require the use of Excel at some point for data analysis, maths calculations, graph or chart creation, project management and much more.
Excel can seem complicated and daunting to some, particularly if you are relatively new to it, so I’ve put together a list of tips and tricks as well as a new Excel LinkedIn Learning collection to help you out.
Keep an eye out on our blog later on this week as I’ll be publishing the second part of this blogpost, which will include 5 more tips and tricks on using Excel!
Tip 1: Useful keyboard shortcuts
Keyboard shortcuts involve pressing more than one key simultaneously and if memorised can save you a great deal of time. For example, use CTRL+A to select all the cells in a spreadsheet. Take a look at the following list of good ones to learn:
Ctrl + N
Create a new workbook
Ctrl + O
Open an existing workbook
Ctrl + S
Save the active workbook
F12
Save the active workbook under a new name, displays the save as dialog box
Ctrl + W
Close the active workbook
Ctrl + C
Copy the contents of the selected cells to the Clipboard
Ctrl + X
Cut the contents of the selected cells to the Clipboard
Ctrl + V
Paste/insert the content of the Clipboard into the selected cells(s)
Blogpost by Jeffrey Clark (Student Digital Champion)
Introduction to Primo
It can be challenging to go into any library and find what you’re looking for. Most libraries contain hundreds of books, and the Hugh Owen library has THOUSANDS of books. If you want to find what you’re looking for with clinical precisions, then I recommend you give Primo a try. Primo is a digital library catalogue used by Aberystwyth University. It’s a massive database that allows students to search for books to loan from the University, make lists of books to check-out, and access online versions of reading materials. It has tonnes of features which have made my time at Aberystwyth that much easier. While it’s easy to see it as ‘just Google search for the library’, it’s much more than that. From saving lists of books to requesting books I need for my course, Primo has saved me time and from many headaches during my studies. In this blog post I’ll be going over Primo, what it does, and how to make it work for you.
Using the search function
Using Primo’s search function is easy. Simply type the name of the item you wish to find and Primo will tell you where it is in the Hugh Owen library or if you can access it online (some items have both online and physical copies.) Primo’s search function is set to search for ‘all items’ by default, which can muddy your search results a bit by giving you too many options.
At the bottom of the search bar, there are three drop-down menus which have options to help you find EXACTLY what you’re looking for. For example, let’s say that I want to search only for books by John Steinbeck. From the bottom of the search bar, I would select ‘Books’, then ‘with my exact phrase’, selecting ‘as author/creator’ and finally searching ‘John Steinbeck.’
Don’t be a copycat! Welcome to part 2 of our series on fake news and plagiarism. In part one we looked at the world of smoke and mirrors that is fake news. In this part, we will go over the many forms of plagiarism, how to avoid accidental plagiarism, and ways you can combat deliberate acts of plagiarism.
What is plagiarism? Plagiarism is the act of presenting someone else’s work as if it were your own without giving credit to the original author(s) of the work. In other words, plagiarism is a form of theft but instead of physical property it is the idea of someone else, or intellectual property. There are several ways of committing plagiarism, many accidental and others intentional. Fortunately, virtually every course at Aberystwyth University goes over the basics of academic integrity as well as the proper referencing scheme to use for your course. More information on plagiarism can be found through the LibGuides page on plagiarism.
