Excel Statistics 02: Calculations, Operators, Formulas

See how to make calculations in Excel using formulas and cell references. Learn about the different Excel Math operators and functions that you can use in Formulas.

We will see five types of formulas:

1) Formulas with cell references and operators
2) Formulas with Functions
3) Formulas with Functions and operators
4) TRUE / FALSE formulas
5) Text Formulas

This is a beginning to end video series for the Business & Economics Statistics/Excel class, Busn 210 at Highline Community College taught by Michael Gel ExcelIsFun Girvin

Category:

Education

Tags:

• Excel
• 2007
• Statistics
• formulas
• functions
• cell
• references
• operators
• TRUE
• FALSE
• Text
• Formulas

[cherryqianli]

Really like your teaching style. I learn a lot from your videos. Thanks a lot~

[ExcelIsFun]

@cherryqianli , you are welcome!

[MrPercyvel]

Short cut keys are not working in my computer et Shift+9, Shift+0 etc. Am using a french keyboard so is it my systems problem or a macro has to be created for using these short cut keys?

Thanks

[ExcelIsFun]

@MrPercyvel , I am not sure. Post question to THE best site;

mrexcel [dot] com/forum

[nayarules160192]

Hi,

When calculating the mean, why do you re-calculate the sum again?

Wouldn't it be better to use the value in cell D27?

Thanks.

[ExcelIsFun]

Yes, you can do that.

[Irmoush]

you are great! thanks

[ExcelIsFun]

Search for and then watch this video title:

'excelisfun Search for Excel Videos, Playlists & Download Workbooks '

[ExcelIsFun]

Search for and then watch this video title:

'excelisfun Search for Excel Videos, Playlists & Download Workbooks '

[MegaYoutubing1]

what's website from where I can download..??