Woodthorpe IT Solutions Ltd

Excel Training

17

Apr'15

Use a shortcut to show all formulas in a spreadsheet

If you have a spreadsheet that you are not sure what is a formula or what is a static (typed …

Read More

03

Apr'15

Use a shortcut to create a sum function to total numbers

If you want to total a set of numbers you would use the Autosum (sum function) in Excel. This enables …

Read More

06

Mar'15

Move through all your open workbooks with a shortcut

When you have more than one workbook open, and you want to switch from the current workbook to another, it’s …

Read More

06

Feb'15

Quickly enter the current date and or time into your sheet

To enter today’s date into a cell, simply press Ctrl+; and then Enter. Ctrl+; also enters the date while you …

Read More

09

Jan'15

Create a graph quickly in Excel

Drag over the data you want to create a graph for and press F11 on your keyboard. You will now …

Read More

26

Dec'14

Move to the bottom or top of a list quickly

If you have a list of say 1000 items and you want to get to the bottom of it you …

Read More
© Woodthorpe IT Solutions Site by Ben Timney Business vector designed by Freepik
All prices on this site are excluding VAT unless otherwise stated.