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
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)
The Internet is a great place to connect with friends, work on projects, and even make money. However, there are some who will use the Internet to try and make money from YOU! Unfortunately, scams are becoming more and more advanced but thankfully I’ve got you covered! In this blogpost I’ll go over scam emails, what they are, how to identify them and what to do when you find them.
Make sure to read the Aberystwyth University page on spam emails before reading this blog post.
What is a phishing email?
A phishing email is an email that is designed to obtain sensitive personal data from you. This data may come in the form of your address, credit card information, or even your bank details! Phishing emails are usually disguised as legitimate business emails like the example below.
It’s easy to see how one might fall for a phishing email like this. Firstly, the email notifies the victim that their bank account may have been compromised which prompts them to act urgently. Secondly, there is nothing suspicious about the link at first glance. So how can you tell the difference between a legitimate email and a phishing email?
Blogpost by Jeffrey Clark (Student Digital Champion)
Making things easier
Microsoft Word is perhaps the most used and widely recognized computer program in all of academia. Virtually every course you can take at Aberystwyth University uses Microsoft Word to some degree, with some courses requiring you to do more with it than just type out an essay. In this blog post, I’ll tell you about some shortcuts in Microsoft Word that have helped me during my studies.
Tip 1: Keyboard shortcuts
Keyboard shortcuts are a combination of keys that you press to perform a function. For example, press control (ctrl) and C at the same time while highlighting text copies that text onto your clipboard. Instead of right-clicking and scrolling down the drop-down menu to ‘Paste’, you can press ctrl + V to paste the text instead.
The ALT key can also be used for shortcuts. Specifically, the ALT key is used for shortcuts as they relate to the top task bar. By holding down the ALT key for a few seconds, the keys for each shortcut will pop up. For instance, on my keyboard, pressing ALT and 2 will save my document.
But if we press ALT + S to go to the References tab…
We get an entirely new set of ALT keyboard commands to use!
By holding down the ALT with a different tab open we can see what shortcuts are available for each tab on the taskbar. If you forget what ALT key shortcuts do, holding the ALT key down will give you a helpful reminder of your keyboard shortcuts!
Cloud computing is often rated as one of the most sought-after tech skills, and with the recent shift towards remote working and learning, there’s no surprise that employers are searching for graduates with these skills.
Students, don’t miss out on an exciting opportunity by Microsoft to access their live training webinars, exam practice tests and Microsoft Fundamentals certification exams for FREE!
The three courses available for free are:
5th April 2022 – AI Fundamentals
7th April 2022 – Azure Fundamentals
8th April 2022 – Security Fundamentals
For more information about these free courses, download this information flyer by Microsoft:
Productivity seems to be the order of the day, with LinkedIn Learning courses related to Microsoft 365 being the most viewed by staff and students recently. We’re all familiar with Microsoft 365 but how many of us take full advantage of the tools and functionality it offers?
The use of MS Teams really came into its own during the pandemic across education sectors and the world of work with 91% of Fortune 100 companies using it in 2019. Beyond meeting virtually, MS Teams aids collaboration via chats, file sharing, task management, project planning, to-do lists and more. I recently attended an MS Teams meeting which made excellent use of virtual whiteboards, a tool I wasn’t aware of until then. Deciding which productively tool to use and when can be tricky, so learning more about each will help you in that decision.
If you want to learn more about Microsoft 365 tools here are the top five LinkedIn Learning courses viewed at Aberystwyth in the past 30 days. To activate your LinkedIn Learning account, which is free to all AU staff and students, check out our ‘getting started with LinkedIn Learning’ pages.