Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulars
Resolved · Low Priority · Version 2003
Alisa has attended:
Excel Intermediate course
Excellent course, informative however for my role I will be need a good knowledge of formulars any tips on getting farmilar.
Hi Alisa
Thank you for your question; and welcome to the forum.
A couple of things you may find useful:
- Formulas always start with an equals sign =
- You can get a total for a row or column of numbers by clicking in the next available blank cell in the row or column; and using Alt + = to enter the Sum function. You will need to check that Excel has selected all the cells you wish to add together; if not you can use your mouse to select the cells that contain the values to be added.
- There is a key located to the left of the 1 key and below the Esc key on your keyboard which is called the pipe key - it has three different symbols on it. If you hold down the Ctrl key and press the pipe key at the same time, you will be able to see where all the formulas are in a spreadsheet. Use the same two keys to change your spreadsheet view back to normal.
I hope you find these useful.
Amanda
|
Excel tip:The Easiest and Quickest Way to use Autosum in Excel 2010Autosum is used frequently in Excel. As with almost every feature of Excel, there are more ways than one to use each feature. Below is the simplest way to use the Autosum feature. |
We'll call during UK business hours
Server loaded in 0.08 secs.