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

Excel Start File: https://people.highline.edu/mgirvin/AllClasses/216_2010/Content/04Excel/Excel2010IsFun!START.xlsm Excel Finished File: https://people.highline.edu/mgirvin/AllClasses/216_2010/Content/04Excel/Excel2010IsFun!FINISHED.xlsm Free Excel 2010 book: https://people.highline.edu/mgirvin/AllClasses/216_2010/Content/04Excel/Excel2010IsFun!.pdf The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. 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