Excel Forum
Similar Content
List All Defined Names and Values in the Worksheet in Excel
Tutorial: Quickly list all Defined Names and their Values in the worksheet without using a macro. ...
Simple Excel Function to Combine Text with a Separator
Tutorial: Excel function that makes combining text very easy. This function is simpler and better th...
Simple Excel Function to Extract a Word or Text from a Cell
Tutorial: Excel function that makes it easy to extract a word or text from a cell in Excel. This is ...



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.