Excel Forum



Office 2010 Class #23: Excel Functions & Defined Names, SUM, COUNT, COUNTA, SUMIF, COUNTIF


The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end.
Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm
1. Topics Covered In Video:
2. Functions:
3. SUM (add)
4. COUNT (Count Numbers)
5. COUNTA (Count non-blank cells)
6. MIN (minimum value)
7. MAX (maximum value)
8. COUNTIF (count with a condition or criteria)
9. SUMIF (Sum with a condition or criteria)
10. STDEVP (standard deviation for the population)
11. Compatibility functions
12. How to name a range of cells using Defined Names Feature
13. Insert Function keyboard = Shift + F3
14. Paste Name keyboard = F3
15. Name Manager keyboard = Ctrl + F3
16. Create Names From Selection keyboard = Ctrl + Shift + F3
17. Use Defined Names in formulas
18. Learn about Name Manager





Got a Question? Ask it Here in the Forum.