Victoria has attended:
Excel Introduction course
Excel Intermediate course
Formulas
How can you link formulas in 2 separate excel spreadsheets?
RE: Formulas
Hello Victoria
Hope you are well you would normally do linking formulas on the intermediate course but i will what you need to do
firstly when you are linking formulas you need to use your mouse and your keyboard to create the formula, and i will show you an example of this below:
=E5+Sheet2!D3 this is how the formula looks, but when you create this you will need figures in both of the cells used in the formula then, type =e5+ then click the sheet 2 tab at the bottom of the screen then click on cell d3 when you have done that press enter
Hope this helps
Mark east