You are Here: Home >< GCSEs

# ICT watch

1. Do you any of you how to do spreadsheets? I understand all the other practicals except spreadsheets. How do you know what formula to use, how to remember the formulas. Any tips and tricks. Thanks in advance!!
2. (Original post by Dippy Jam)
Do you any of you how to do spreadsheets? I understand all the other practicals except spreadsheets. How do you know what formula to use, how to remember the formulas. Any tips and tricks. Thanks in advance!!
A lot of the time with excel you can select the equation from a list and then it gives you prompts for the certain numbers/cells you need.

Have you looked around for different video tutorials or short online courses that would give you a better understanding? If not, I’d suggest you have a look, even if you just type in the formula you want to get better at.

Any problems with that let me know. Good luck
3. Here are the official Microsoft docs for excel formulas/functions with examples for each.
https://support.office.com/en-us/art...6-c6d90033e188

There's not really any point in trying to memorise these functions or their syntax because you can just check the examples in the documentation. It's far more important that you understand how to use them and where they're appropriate to use.
4. t
(Original post by brainzistheword)
A lot of the time with excel you can select the equation from a list and then it gives you prompts for the certain numbers/cells you need.

Have you looked around for different video tutorials or short online courses that would give you a better understanding? If not, I’d suggest you have a look, even if you just type in the formula you want to get better at.

Any problems with that let me know. Good luck
Oh wow, I didn't even know you could do that in excel. I thought i had to memorize all the formulas. Thanks a lot.
5. (Original post by Dippy Jam)
t
Oh wow, I didn't even know you could do that in excel. I thought i had to memorize all the formulas. Thanks a lot.
No problem. Any problems let me know

TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

This forum is supported by:
Updated: March 11, 2018
Today on TSR

### Edexcel C3 Maths Unofficial Markscheme

Find out how you've done here

### 1,133

students online now

Exam discussions

Poll
Useful resources

## Study tools

### Essay expert

Learn to write like a pro with our ultimate essay guide.

See where you can apply with our uni match tool

### Make study resources

Create all the resources you need to get the grades.

### Create your own Study Plan

Organise all your homework and exams so you never miss another deadline.

### Resources by subject

From flashcards to mind maps; there's everything you need for all of your GCSE subjects.

### Find past papers

100s of GCSE past papers for all your subjects at your fingertips.