Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Excel Basics 3: Count & Add with COUNT, COUNTA, SUM, COUNTIFS, SUMIFS Functions (Intro Excel #3). That video is uploaded by ExcelIsFun at 2017-10-18T20:20:31-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [fQsz6mKDobE]
| Name | Excel Basics 3: Count & Add with COUNT, COUNTA, SUM, COUNTIFS, SUMIFS Functions (Intro Excel #3) |
| Video Uploader | Video From ExcelIsFun |
| Upload Date | This Video Uploaded At 19-10-2017 03:20:31 |
| Video Discription | Highline College Busn 216 Class: Computer Applications taught by Michael Girvin. Download Excel Start File: Download File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EB03-CountingAddingWithCriteria.xlsx Download Excel Finished File: Download File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EB03-CountingAddingWithCriteriaFinished.xlsx Download Full Written Notes: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/Office2016Class15-ExcelBasics03-IntroductionToExcel03.pdf Class web page link: https://people.highline.edu/mgirvin/AllClasses/216v2016/Content/04Excel/Excel2016.htm Topics in this video: 1. (00:01) Introduction 2. (00:41) Different kinds of counting and adding 3. (02:28) Function Drop-down and screen tips to learn which function to use 4. (04:05) COUNT Function 5. (05:04) COUNTA Function 6. (06:16) SUM Function 7. (06:55) COUNTIFS Function 8. (10:14) Screen Click Trick to highlight an entire argument in a function. 9. (11:04) Be Careful of Spaces!!!!! 10. (11:48) SUMIFS Functions 11. (15:05) Use Ctrl Key to check your answers 12. (15:53) More Examples 13. (19:14) Homework you can do to practice 14. (20:06) Summary - Conclusion fQsz6mKDobE |
| Category | Education |
| Tags | Highline College | Busn 216 | Mike Girvin | Michael Girvin | excelisfun | Excel Basics | Learn Excel | Excel | Excel 2016 | Learn Excel for Free | Learn Excel Online | Complete Lesson in Excel | Basic Excel | COUNT Function | COUNTA Function | SUM Function | COUNTIFS Function | SUMIFS Function | Adding with Conditions | Adding with Criteria in Excel | Count with Conditions | Count with Criteria | How to use COUNTIFS | SUMIFS not working | SUMIFS for adding | COUNTIF | SUMIF |
