Microsoft Excel Tips and Tricks (Part 1)💡

Blogpost by Laurie Stevenson (Student Digital Champion)

Banner with 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 + NCreate a new workbook
Ctrl + OOpen an existing workbook
Ctrl + SSave the active workbook
F12Save the active workbook under a new name, displays the save as dialog box
Ctrl + WClose the active workbook
Ctrl + CCopy the contents of the selected cells to the Clipboard
Ctrl + XCut the contents of the selected cells to the Clipboard
Ctrl + VPaste/insert the content of the Clipboard into the selected cells(s)
Ctrl + ZUndo your last action
Ctrl + POpen the Print dialog
Alt + HOpen the home tab
Alt + NOpen the Insert tab
Alt + POpen the page layout tab
Ctrl + SSave a workbook
Ctrl + 9Hide the selected row(s)
Ctrl + 0Hide the selected column(s)

Read More

LinkedIn Learning Collections to support students preparing for their exams

As exam season approaches we have put together a couple of collections on LinkedIn Learning to help you banish the stress of exams and to help you revise more effectively.

This collection has some tips and advice to help you revise and study for your exams.

Exam season can be a challenging time for students, this collection gives you some strategies and advice for managing your stress levels around exams.

All Aberystwyth University students and staff have free access to LinkedIn Learning. Please see our login instructions and more general FAQ’s to help you during exam time. 

Ten Top Library and Information Services Tips

Banner with Student Digital Champion

Starting university can be a daunting and navigating the IT side of things can be confusing. We’ve therefore put together a collecting of helpful links and videos to cover any questions you may have about our IT and library services at Aberystwyth University.

Tip1: Where is everything in the Hugh Owen Library? Watch this virtual library tour:

Tip 2: Which buildings on campus have student printers? Here is the location of all printers on campus.

Tip 3: How do I print from a university printer? Watch this short demo video:

Tip 4: How do I top up my AberCard? Log into your account here to top up your AberCard.

Read More

LinkedIn Learning: What new skills could you learn?

Blog post by Laurie Stevenson (Student Digital Champion)

LinkedIn Learning is a free online learning platform with over 16,000 courses on everything from personal development, design, creative activities, study skills, technical support and so much more! Take a look at this content from our Information Service Instagram @ISAberUni account for some tips and tricks to get you started.

Activate your account by 6 January 2023 to be entered into a raffle where you will have the opportunity of winning one of three £20 vouchers!

Click Read More below for the text version of these visuals.

Read More

Come and visit our LinkedIn Learning stall during Welcome Week!

Blog post by Laurie Stevenson (Student Digital Champion)

Banner with Student Digital Champion

LinkedIn Learning, which is a free online learning platform, is available to all students. Our stand has information about the platform and shows examples of the sort of short videos, courses and skills you can find on it.

What’s more, if you sign up to LinkedIn Learning by the end of Welcome Week, either online or by using the QR code on our stand, you will be entered into a raffle where you will have the opportunity to win one of three £20 vouchers!

You will find the stand on the ground floor of the Hugh Owen Library (Level D) at the back near the stairs.