Alisa has attended:
Excel Intermediate course
Formulars
Excellent course, informative however for my role I will be need a good knowledge of formulars any tips on getting farmilar.
RE: Formulars
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