At awesome chocolates, we have a colleague who is good with Excel, but not yet Awesome. So, the other day, I caught him doing this... and I had to show him a few better options.
⏱ In this video:
=============
0:00 He was adding data to charts like this
0:37 He was expanding charts like this
1:12 He was going to make a new chart!
2:00 He wanted to make a "donut" Bar chart
2:46 He was eating a donut
3:01 He was highlight stuff like this
4:56 He wanted to spice up a Pivot Report
5:57 He was doing the TTTT report like this
7:02 He wanted to make a DYNAMIC Chart
SAMPLE workbook:
===================
Need a hand with these tips. Check out this practice workbook.
https://chandoo.org/wp/wpcontent/upl...
Be a BOSS with Excel with these videos
===================================
Don't be silly. Up your Excel game and impress everyone in the office. Check out these quick videos and learn something new.
I Saw my Boss do this in Excel! • I saw my boss do these 10 things in E...
Combine sheets with this trick • AWESOME Excel trick to combine data f...
Combine files with this trick • Powerful trick to combine all Excel f...
Combine tables with this trick • How to connect two tables in Excel ...
10 Copy Paste tricks in Excel • 10 *SURPRISING* Copy Paste Secrets fo...
10 Data Cleaning tricks in Excel • Data cleaning in Excel 10 tricks *P...
10 Formatting tricks in Excel • 10 Excel formatting tricks *ONLY* exp...
Want more? Why not join my Excel School program? As the REDBULL says, it will give you WINGS!!!
Soar here https://chandoo.org/wp/excelschoolp...
~
CONNECT WITH ME
2nd channel (in Telugu) / @data_with_chandoo
Instagram (for tips & behind scenes) / chandoo.xlsx
Twitter (fresh updates) / r1c1
Website (1000+ articles, files) https://chandoo.org/wp/
Classes https://chandoo.org/wp/excelschoolp...
~
F.R.I.E.N.D.S clips from various episodes
Music from Epidemic Sound. Get 30 days free here https://www.epidemicsound.com/referra...
~
What are the 3 rules Ross uses to analyse data?
Pivot!
Pivot!
Pivot!
#Excel