Excel 2013 Statistical Analysis #15: Create Dot Plot in Excel Using COUNTIFS and REPT functions

Download files: people.highlin...
Topics in this video:
1. (00:10) What is Dot Plot
2. (00:58) Create Dot Plot
3. (01:20) Create Sequential Numbers 0 to 10
4. (01:40) Change Column Widths & Style Formatting
5. (02:15) Cell Chart Formula
6. (02:30) COUNTIFS to Count with one condition / Criteria
7. (03:04) REPT function to Repeat dots
8. (04:19) Cell Formatting Dialog Box for Aligning Dots in cell vertically
9. (05:02) Copy and Paste Cell Chart and Quick Ways to Edit and Change Cell Ranges in Formulas

[@excelisfun]

Excel 2013 Statistical Analysis #15: Create Dot Plot in Excel Using COUNTIFS and REPT functions
Download files: people.highline.edu/mgirvin/excelisfun.htm
Topics in this video:
1. (00:10) What is Dot Plot
2. (00:58) Create Dot Plot
3. (01:20) Create Sequential Numbers 0 to 10
4. (01:40) Change Column Widths & Style Formatting
5. (02:15) Cell Chart Formula
6. (02:30) COUNTIFS to Count with one condition / Criteria
7. (03:04) REPT function to Repeat dots
8. (04:19) Cell Formatting Dialog Box for Aligning Dots in cell vertically
9. (05:02) Copy and Paste Cell Chart and Quick Ways to Edit and Change Cell Ranges in Formulas

[@shahinmahmud4978]

You are a great teacher, thank your sir

[@excelisfun]

You are welcome! Thanks for the kind words : )

[@Jack456821]

Enthusiasm 10/10. Would recommend! :D

[@marekzadecki470]

It's amazing!. Thanks Mike.

[@pranshul67]

great tutorial! Thank you

[@Clifffffffffford]

Thanks

[@aknoimak]

I know english little (bit), but I see video and I try understend it.
Thanks. Mike :-)))

[@excelisfun]

You are welcome! Thanks for the thumbs up!

[@BillSzysz1]

Cool trick :-)) Thanks.

[@excelisfun]

You are welcome!

[@NareshKumar-om3uh]

very useful trick, thanks

[@excelisfun]

You are welcome!