Software and apps

Managed Software Centre


Specialist software on University managed Windows desktops and laptops can be accessed using the  ‘Managed Software Centre’, which contains a list of all the software currently licensed for you and/or your device.

In the Start Menu, scroll down to ‘Managed Software Centre’,

Excel - Freeze Panes

Freeze Panes

Freeze Panes can be used to lock specific columns or rows in place so that you may see them where-ever you are within the data. 

In the view tab of the ribbon you will find the "freeze panes" drop down menu:

 

Excel Number Formatting

Number Formatting in Excel

Excel can handle lots of different format types of numbers, but you must regularly choose what type of number format you wish to be expressed on the cells containing those numbers. If you don't, you may suffer problem when calculating functions or expressing the data in a specific way.

Examples:

  • Date
  • Time
  • Percentage
  • Monetary value
  • fraction
  • text

 

Excel - Quick selection Techniques

 

Excel Quick Selection Techniques

In Excel to highlight/select data you can "click and drag" around the data to select it, there are in fact several different ways you can highlight/select data a lot faster or more effciently. Esspecially when you have large ammounts of data. 

I shall outline the selection methods you can use here:

Night Light feature in Windows 10 - reduces "blue light"

If you are concerned about the health impact of "Blue Light" (the light that comes from a PC monitor, tablet, mobile phone, TV), then there is a filter built into Windows 10 that you may wish to enable. 

Windows 10 has a Night Light setting which gently reduces the monitors blue-tones, giving the screen a warmer look. This can be manually switched on and off, or you can set it to automatically adjust to sunset and sunrise.