Advanced Excel - Using "Recommended Pivot Tables"

Рет қаралды 194,294

Technology for Teachers and Students

6 жыл бұрын

Here's my entire playlist of Excel tutorials: bit.ly/tech4excel Learn how to use this shortcut to quickly and easily add pivot table reports to your Excel spreadsheets. Download the example file that goes with this video: bit.ly/recommendedpivot ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa...
See below links to the CDs and bands mentioned in the video:
The Killers - Wonderful Wonderful: amzn.to/2G7AKlF
Brandon Flowers - The Desired Effect: amzn.to/2G6gBMG
Blaqk Audio -Material: amzn.to/2DUOfo1
Covenant - The Blinding Dark: amzn.to/2n1J0uH
Depeche Mode - Spirit: amzn.to/2E0BUio
Erasure - World Be Gone: amzn.to/2G46U1t
Future Islands - The Far Field: amzn.to/2DC7yVx
Hurts - Desire: amzn.to/2DX6Dww
OMD - The Punishment of Luxury: amzn.to/2DpzVmA
The Frozen Autumn - The Fellow Traveller: amzn.to/2DXfA9f
The Jellyrox - Bang and Whimper: amzn.to/2Drnvue
Ulver - The Assassination of Julius Caesar: amzn.to/2DoFLEB

Пікірлер: 62

@ArchiBarrel1991 6 жыл бұрын

You, sir, are a saviour. I have not been using Excel for several years already, and now I need it for my job, and it terrifies me a bit, because I remember very little about this program. But your tutorials help me brush up my skills (and learn new ones too!) and become more confident. Thank you!

@retroflame7008 4 жыл бұрын

Oh wow looks who's in the same situation as yours after 2 years 🤣 me!!

@selaa5185 4 жыл бұрын

Best ever excel tutorials. You explain everything so well and easy to understand. Thank you so much.

@josiebristow2173 3 жыл бұрын

Thank you for these excellent tutorials. I have always been terrified of pivot tables and they are not difficult as shown by yourself

@sleek4803 4 жыл бұрын

Very clear explanation at a great pace with scenarios that make sense thank you

@wilberforcethiribi4802 4 жыл бұрын

Your pivot table tutorial is a savior for me, you are very helpful sir.

@jennifermacias1449 3 жыл бұрын

Thanks for the lesson in recommended PT's and music. Love it!

@BIGBrice2013 2 жыл бұрын

I got a promotion 1 month ago making close to 6 figures now and have never used excel extensively until this new role. After your courses and just 3 weeks, my boss thinks I'm a pro! Thank you very much!!!!

@anneconroy3592 4 жыл бұрын

This is one of the best, clearest, least annoying (!) tutorials of this type that I've ever used. Helps that I like synthpop.

@QuietLumina 6 жыл бұрын

Thank you for these super helpful videos!

@smartphonevideography 6 жыл бұрын

You got yourself a new fan! Really great videos.

@tinal4119 5 жыл бұрын

you teach really well

@akshit6223 6 жыл бұрын

Just loved your videos. Super helpful

@venthusiast9244 2 жыл бұрын

Happy 1 million subscriber Sir !!! you have helped us a lot in understanding excel Thank you

@miracle_96keli30 3 жыл бұрын

Subscribed today after watching ur Pivot Table teaching video! ❤️❤️❤️❤️❤️

@anantshree.qm.3633 4 жыл бұрын

Could you please upload a tutorial on 1 to 1 and many to 1 mapping of tables?

@martijnnitzsche3346 3 жыл бұрын

Great explanation, thanks for helping to refresh my excel knowlegde

@Sukiipod 6 жыл бұрын

Best darn teacher EVER !!!!!!!!!!!

@sylviaeuale2718 4 жыл бұрын

This was another great video, I really appreciate how you carry the same data and ideas forward through the videos. It helps us to understand the data for asking the questions with things such as how to best design the pivot table. I am starting a new job tomorrow where I am going to be using excel a lot and I can not express how much you have helped me feel a bit better about the challenges that lie ahead for me, so thank you so much. I hope your videos keep going for a long time.

@kennethcastro937 3 жыл бұрын

Now feeling really good about learning this. Thanks! Subscribed

@rayyanasvani2568 3 жыл бұрын

Me too

@CyndyTangerineyyyy 3 жыл бұрын

Love your Excel tutorials!!

@francesdobbins2964 2 ай бұрын

Very informative video.

@chinonsomaranzu9108 10 ай бұрын

Video very helpful. Thanks

@lynnmcfadden655 3 жыл бұрын

Thank you Sir! I just made a spreadsheet report the long way and after, I remembered pivot tables.... duh!!! I could of saved hours of my life. Thanks for the refresher, my family thanks you (for all the hours I will now free up from future reports and instead spend with my family). Could you assist with trend analysis, pivot tables and graphs. I will be using data from several sheets. Cheers.

@tymothylim6550 4 жыл бұрын

Thank you for this video :)

@phemophemo5947 10 ай бұрын

Goodwork sir.

@mdobaidullahshake5186 5 жыл бұрын

it is very helpful for me

@shahidkazi9464 2 жыл бұрын

Thanks sir

@horvathgabor5485 4 жыл бұрын

Can you add to Pivot calculations columns, e.g. the "Sales" column is not in your basic table but you add this extra column to the Pivot table by multipling Price and Copies Sold?

@theubermensch9365 6 жыл бұрын

Because of you, I cannot stop listening to synthpop. 😂😂

@nbkuycd 4 жыл бұрын

@phemophemo5947 2 жыл бұрын

Goodwork

@sashaoleksiichuk5050 6 жыл бұрын

Would like to watch a tutorial about what-if analysis.

@supercrass 3 жыл бұрын

Also, add some Hot Chip to your collection - think they might slide in nicely along with what you've listed. :)

@davidzurc1 6 жыл бұрын

Do a video about graphics in excel, Good stuff here, thanks keep up the good work!

@vee815 6 жыл бұрын

Am using Microsoft Excel on my tab and am not seeing pivot table an some of the features why is this happening ?

@shivusb8961 6 жыл бұрын

Thanks teacher

@wildarivera6800 4 жыл бұрын

Why Excel should I get? Should I get 2020 or starting off with 2016 is good enough? BTW! You are outstanding and have been learning so much!

@MissNishthaAggarwal11 3 жыл бұрын

Amazing tutorials. Easily understandable.

@danab172 5 жыл бұрын

Yay! I got through your Excel videos in this strip. (I wouldn't have if not short, precise, friendly and with a great voice!)

@danab172 5 жыл бұрын

Where are your office and word tutorials to accompany the powerpoint and excel and google? thanks so much!

@danab172 5 жыл бұрын

Seriously, I'm not a tech fan, have a learning disability AND every other video on the web is too long, too awful of a voice or too something hard to understand. I'm a fan!

@idanraz9977 2 жыл бұрын

is the recommended pivot table as shown in the video only a windows thing? i'm running version 16.57 on mac and mine doesn't work that way.

@Mango_Bajito 5 жыл бұрын

I’ve searched for the first video regarding pivot tables but I wasn’t able to find it. Could you let me know the title of the video so I can watch it after this one?

@prajwalmahadevu9666 5 жыл бұрын

kzfaq.info/get/bejne/eNGdq9Wnrsyod3U.html

@boyshelby282 2 жыл бұрын

Question...I've recently gotten a Win10 update and suddenly the Blank Pivot Table option at the bottom of the Recommended Pivot Tables popout is no longer there. And trying to google it is futile. any ideas?

@seafox21 4 жыл бұрын

FINE I will go listen to some synthpop

@techteachersandstudents 4 жыл бұрын

Please do! Thanks for watching.

@seafox21 4 жыл бұрын

@@techteachersandstudents No, thank you for the tutorials! Would you consider doing any data analysis tutorials in excel?

@yimizheng 4 жыл бұрын

no new tweet since 2017 :'(

@lanarita11 5 жыл бұрын

you know the more you say 'my hypothetical store' the less i believe it doesn't actually exist :D

@techteachersandstudents 5 жыл бұрын

:) Let me know if you'd like to buy one of the CDs from me.

@mohiuddinriad4195 4 жыл бұрын

can you kindly give the file you have used for practice?

@nameisdivya Жыл бұрын

Man why u didn't add english subtitles?

@hhhgptsd7302 3 жыл бұрын

fake music store is missing THE FAINT, SHE WANTS REVENGE, HIM! 🥰🥰🥰🥰🥰🥰

@tutudesmond2299 10 ай бұрын

i have been following all your lects but unfortunately your videos turned out to be unclear

@techteachersandstudents 10 ай бұрын

There may be other, better KZfaq videos on the topics you're trying to learn. I hope you get the help you need.

@djrajutigriya3819 3 жыл бұрын

Aaj mera birthday h mujhe gift me 1 subscribe de

@HayderAhmed94 5 жыл бұрын

videos is cool but you talk a lot sir

@scide6372 5 жыл бұрын

He is teaching, what would you expect? he will "talk a lot ofc.

@phemophemo5947 2 жыл бұрын

Goodwork