DigiTip 52: Strikeout Star! ➖

Have you ever wanted to cross something out in Excel? Sometimes you don’t want to delete or hide the cells. DigiTip 52 has a quick shortcut to help you out! 

Simply select the relevant cell(s) and use the shortcut: Ctrl + 5 

To follow our DigiTips, subscribe to our Digital Skills Blog. Or alternatively, you can bookmark this webpage, where a new DigiTip will be added each week!

DigiTip 49: Interesting Graphs in MS Excel 📈

Do you want to add interesting ways of presenting your data in MS Excel? DigiTip 49 can help with that by introducing Sparklines. Sparklines are small graphs that only take up one cell in an excel sheet and are an effective way of presenting data without having a graph that takes up a whole sheet. This could be useful for presenting data that is important but not vital to a presentation.

  • First you need an appropriate amount of data as shown.
  • Then select the Cells which you want to use to present the data and go to insert in the tabs and choose the type of graph you want from sparklines.
  • Select the data range you want to use, in the example that would be B2:F4.
  • And there you go; you should have a graph that presents the data all in a single cell.

To follow our DigiTips, subscribe to our Digital Skills Blog. Or alternatively, you can bookmark this webpage, where a new DigiTip will be added each week!

DigiTip 24: Make using Excel easier by freezing columns and rows 📊

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 > Freeze Panes.


Watch the video below to learn how to freeze columns and rows:

To follow our DigiTips, subscribe to our Digital Skills Blog. Or alternatively, you can bookmark this webpage, where a new DigiTip will be added each week!

Microsoft Excel Tips and Tricks (Part 2)💡

Blogpost by Laurie Stevenson (Student Digital Champion)

Banner with 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.

Read More

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