Office 2016 15

Excel Basics 3: Count & Add with COUNT, COUNTA, SUM, COUNTIFS, SUMIFS Functions

DESCRIPTION

Topics in this video:
(00:01) Introduction
(00:41) Different kinds of counting and adding
(02:28) Function Drop-down and screen tips to learn which function to use
(04:05) COUNT Function
(05:04) COUNTA Function
(06:16) SUM Function
(06:55) COUNTIFS Function
(10:14) Screen Click Trick to highlight an entire argument in a function.
(11:04) Be Careful of Spaces!!!!!
(11:48) SUMIFS Functions
(15:05) Use Ctrl Key to check your answers
(15:53) More Examples
(19:14) Homework you can do to practice
(20:06) Summary – Conclusion

NOTES

WORKBOOKS

Download “Office 2016 Video 15” Office-2016-Video-15.zip – Downloaded 4 times – 492 KB







Be the first to comment

Leave a Reply