Learning Formulas

**Stenner** · 06-15-2017, 02:47 AM

Hi All

I don't believe I am breaking any rules here however I may have misunderstood some of the rule page so please tell me if I am and I will delete the post.

I am slowly increasing my knowledge of excel, I would say I am still a beginner in terms of knowing formulas and how they work.
I can do basic IF, SUMIFS etc but when it comes to nesting formulas, lookups etc I am clueless.

Could any one recommend a site or course they found useful to learn these formulas. I currently use Chandoo.

Regards

Aarron

**JohnTopley** · 06-15-2017, 02:51 AM

Take a look at ExcellsFun on YouTube:

**Stenner** · 06-15-2017, 03:01 AM

Thanks John I will have a look

**FDibbins** · 06-16-2017, 02:09 AM

Your post is just fine, I see no problems with it.

Being self-taught (and mostly from here), my suggestion would be to stick around here and try and answer some questions, and more importantly, look at how some of the experts answer the questions. See if you can pick their formulas apart, or try and change then to make them do other stuff

**sandy666** · 06-16-2017, 02:21 AM

Most information is on MS site: Excel help center
Also simple F1 after open Excel workbook

**FDibbins** · 06-16-2017, 02:47 AM

Thinking again, the Fx button next to the formula bar can also be invaluable for debugging formulas and fining missing/misplaces ()'s

**Stenner** · 06-19-2017, 02:21 AM

Thanks all! I have downloaded some good workbooks from chandoo and then used ExcellsFun to look more into the formuals. I am sure eventually I will be able to contribute to this forum!