Main Profile

At A Glance

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
Length: 22:32

Contact

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

Want more info about Office 2010 Class #23: Excel Functions & Defined Names, SUM, COUNT, COUNTA, SUMIF, COUNTIF? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question