๐ฅ Learn Excel in just 2 hours: https://kevinstratvert.thinkific.com
In this step-by-step tutorial, learn how to pull together charts in Excel. Charts are a great way to visualize and analyze your data, and Excel offers a variety of different chart types. You have line charts, pie charts, bar charts, pivot charts, and many more. In this video, we will cover the basics of creating, formatting, and modifying charts in Excel, as well as some tips and tricks to make your charts more effective.
๐ RESOURCES
– Sample workbook to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whaEnzu9I-uuDX-aaxg?e=nn2IXE
– Alt + F1: Creates a new chart on the current worksheet
– F11: Creates a new chart on a new worksheet
โ TIMESTAMPS
00:00 Introduction
00:29 Insert chart
03:50 Modify chart selection
04:31 Avoid totals in charts
04:56 Select non-contiguous data
05:34 Change chart type
06:06 Chart shortcut keys
07:49 Chart titles
08:49 Chart elements
10:48 Styles and colors
11:09 Filter
11:32 Chart design tab
12:23 Chart format tab
12:53 Chart templates
14:03 Advanced options
15:52 Adjust position and size
16:44 Switch row and column
17:51 Sparklines
19:06 Pie charts
20:28 Pivot charts
23:55 Wrap up
๐บ RELATED VIDEOS
– How to Create Pivot Table in Excel: https://youtu.be/PdJzy956wo4
– Playlist with all my videos on Excel: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
๐ฉ NEWSLETTER
– Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/
๐ฝ CONNECT WITH ME
– Official web site: http://www.kevinstratvert.com
– LinkedIn: https://www.linkedin.com/in/kevinstratvert/
– Discord: https://bit.ly/KevinStratvertDiscord
– Twitter: https://twitter.com/kevstrat
– Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
– TikTok: https://www.tiktok.com/@kevinstratvert
– Instagram: https://www.instagram.com/kevinstratvert/
๐ MY COURSES
– Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/
๐ REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5
๐ SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?sub_confirmation=1
๐ SUPPORT THE CHANNEL
– Hit the THANKS button in any video!
– Amazon affiliate link: https://amzn.to/3kCP2yz (Purchasing through this link gives me a small commission to support videos on this channel — the price to you is the same)
#stratvert #excel
