Excel 2013 Statistical Analysis #15: Create Dot Plot in Excel Using COUNTIFS and REPT functions
HTML-код
- Опубликовано: 11 сен 2024
- 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
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
You are a great teacher, thank your sir
You are welcome! Thanks for the kind words : )
Enthusiasm 10/10. Would recommend! :D
It's amazing!. Thanks Mike.
great tutorial! Thank you
Thanks
I know english little (bit), but I see video and I try understend it.
Thanks. Mike :-)))
You are welcome! Thanks for the thumbs up!
Cool trick :-)) Thanks.
You are welcome!
very useful trick, thanks
You are welcome!