Excel 2010 Statistics 03: Calculations, Formulas, Functions, Math & Comparative Operators

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
Learn all about making calculations in excel with Formulas and Functions:
1. Math operators
2. Comparative operators
3. Calculating Formulas
4. Functions like: SUM, AVERAGE, MODE.SNGL, STEV.P, COUNTIF, COUNTIFS
5. Learn how to put comparative operators in double quotes to use in COUNTIF and COUNTIFS functions
6. Learn how to join comparative operator with Number in COUNTIFS formula
7. Text Formulas
8. Logical Formulas
9. Keyboard for SUM: Alt + =
10. Keyboard to jump to bottom of range: Ctrl + Arrow
11. Keyboard to highlight range: Ctrl + Shift + Arrow
This is for the Highline Community College Busn 210 Statistical Analysis for Business and Economics taught by Michael Girvin.

Category:

Education

Tags:

• Excel
• Statistics
• 2010
• excelisfun
• Mike
• Gel
• Girvin
• Highline
• Community
• College
• Busn
• 210
• Statistical
• Analysis
• Business
• Economics
• Slaying
• Dragons
• Math
• Comparative
• operators
• Calculating
• Text
• Logical
• Formulas
• Functions
• SUM
• AVERAGE
• MODE.SNGL
• STEV.P
• COUNTIF
• COUNTIFS
• double
• quotes
• join
• Keyboard
• Alt
• plus
• equal
• Ctrl
• Shift
• Arrow
• highlight
• range

[worldfamous945]

THANK YOU !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!­!!!!!!!!

[ExcelIsFun]

@worldfamous945 , You are welcome!

[rvalluri1]

This is an awesome video, good job

[ExcelIsFun]

@rvalluri1 , I am glad that you liked it!!

[hard84qubes]

Is there anything covered in your book "Slaying the Excel Dragon" that is not covered in this terrific series of videos?

[ExcelIsFun]

Almost nothing in the statistics series is in the book. The book is a Basic Excel Book.

[rvalluri1]

Thank you for replying.