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 ...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.