How to Build Fractions in Word 2010 by Peter Talent

Word 2010’s AutoCorrect feature can build common fractions for you. Actually, Word doesn’t build fractions as much as it pulls them from a set of existing fraction “characters.”

Word has only a few of those fraction characters. When you need your own, specific fraction, such as 3/64, you can create it on your own:

Step 1 Press Ctrl+Shift+= (the equal sign).
This keyboard shortcut enables the superscript command. (Superscript refers to a letter or number written above and to the side of another).

 Step 2 Type the numerator — the top part of the fraction.
For example, type 3 for 3/64.

Step 3 Press Ctrl+Shift+= again.
This time, the key combo turns off superscripting.

Step 4 Type the slash mark (/). This slash mark becomes the divider in the fraction.

 Step 5 Press Ctrl+= to turn on subscripting.  Subscripting involves a letter or number below and to the side of another.

Step 6 Type the denominator — the bottom part of the fraction.  The denominator in 3/64 is 64.

 Step 7 Press Ctrl+= to turn off subscripting.
There’s your fraction.
3/64

Peter will be teaching a 4 week course titled MS Excel 2010 Advanced from Tuesday 29th April. You can book your place here http://payments.liv.ac.uk/browse/extra_info.asp?compid=1&modid=2&catid=24&prodid=94

Controlling Business with Microsoft Excel by Peter Talent

Status

HIDE DATA IN EXCEL WORKSHEETS

Sometimes you may need to hide data in a
particular cell in an Excel worksheet. Let’s say you have some data in cell C5
you would like to hide from another viewer. See below;

Excel step 1

Click cell C5 to select it, and then click in the small square in the Number section (known as a dialog box launcher). See below:-

Excel step 2

Step 1 – When the Format Cells dialog box opens, click the Numbers tab (if necessary)

Step 2 – Select Custom from the Category list.

Step 3 – Now double-click the Type entry box and type three semicolons – ;;;

Step 4 – Click OK to close the dialog box and accept your new formatting.  (See below)

Excel Steps 3

At this point, the data in cell C5 disappears. It’s still there and will work in calculations, but it isn’t visible. If you need to check the data, just click the blank cell and the contents appear in the Formula entry box.

 

 

Access to Learning Fund

Link

The primary purpose of the Access to Learning Fund is to relieve financial hardship that might impact on a student’s participation in higher education.

Full-time and part-time students from the UK are eligible to apply.

Undergraduate students must have applied for their full student loan entitlement or other statutory funding and received the first payment before applying to the Access to Learning Fund. You can also apply if you have suspended your studies due to health reasons or caring responsibilities or you are repeating your course without attendance.

Postgraduate students must be able to show that they have made realistic provision at the start of the course to fund both tuition fees and living costs.

Application forms are available from Student Support Services reception or on request by contacting the Financial Support Team on fst@liverpool.ac.uk. Once the application form has been completed and the relevant evidence gathered, an appointment will be needed with a Money Adviser.

More information on the Access to Learning Fund can be found at www.liv.ac.uk/studentsupport/finance/alf.

As well as administering the Access to Learning Fund the Financial Support Team provides the following services:

  • liaising with funding bodies, such as Student Finance England, in complicated situations;
  • advice for students who need to withdraw, suspend or repeat part of their studies advising on the implications on both current and future funding;
  • advice for students experiencing problems with debt;
  • advice on welfare benefits;
  • one-to-one sessions for students who are experiencing problems budgeting their money;
  • financial capability events and workshops to highlight sensible spending.

We are based on the ground floor of the Student Services Centre, if you would like advice or support on any of the above please call in to see us between 9am – 4pm Monday – Friday.

Susan Haimes
Fst@liverpool.ac.uk
Student Administration and Support
19/02/2014