How to use Power Pivot - Microsoft Excel Tutorial

[@jawaharlalkaramchetti5675]

the videos are very use full and recommended to see in a serial order to pick up the skills in excel.

[@ibugurudyah]

I just found this content and it's very good for the subject matter, I'm a high school teacher of office skills competency. Thank you for the lessons given.

[@TeachersTech]

Glad you found it helpful!

[@ibugurudyah]

@@TeachersTech I am Indonesian, I use subtitles to understand the use of language in this video, but even so I can understand what is meant in the video

[@bingleboy007]

I love the way you teach excel. I bought an online excel course and it's very descriptive with little practical presentation session at the end of the course. Mostly that make me asleep. But it's great, the way you do it with actual live presentation on the screen :)

[@Frederick7419]

Many thanks for your patience and covering almost everything. Bravo

[@TeachersTech]

My pleasure!

[@wolfcub1870]

Sir-you’re a genus! I am going to try using this to customise the daily work assignments I get

[@Excelvenky]

one of the best video..very simple and easy to understand... fall in love with your videos...thanks and gratitude

[@TeachersTech]

You’re welcome and thank you!

[@francesdobbins2964]

I never knew how to use this feature in Excel. Excellent tutorial!

[@StopWhining491]

Thanks for generously providing your practice tables.

[@YTGamerboyPG3D]

hi first well done thanks a lot, i watch your videos since 2019, you helped me create my channel art thanks !

[@TeachersTech]

You’re welcome!

[@shivtiwary5103]

Thanks for such a great content. Well explain !!

[@tanweerabbasabbas649]

you are a great teacher!! if any more power pivot videos plz send yiur link...🥰

[@bettyfish1749]

This was so helpful! You are a great teacher. Thanks so much for doing this.

[@TeachersTech]

You are so welcome!

[@required.]

Thank you so much , you are a great teacher .

[@tahirhanif9669]

Thank you, excellent presentation

[@AyushiRai-oo1wh]

Very insightful. Thank you for creating this tutorial. A doubt. I used formula =RELATED(Tution[Total Amount]) - 'Student Info'[Payment Received] to calculate Amount Owing in Student Info table. On calculation, if 'Student Info'[Payment Received] > Tution[Total Amount], valuse should be a negative integer. Why it shows as a positive integer?

[@ramin31tube]

Very professional and useful channel. you teach much better than my college professor 🤭

[@fliptop157]

My take away is on the Table Relationships. Separate related tables can have the same Primary Key (as "Student ID"), as long as it's unique to the respective Table (as in your "Grades" Table). Even though "Student ID" is the primary key in your Student ID Table. I used to think each Table required it's own unique key but I see now it only requires a unique key. -Thanks!

[@TeachersTech]

You’re welcome!

[@ibugurudyah]

I will try to use this formula. Thank you.

[@surendrababu9184]

Very good teaching 😃

[@TeachersTech]

Thank you! 😃

[@HamdanYouTuber]

This lesson really useful, thanks for sharing. 👍

[@ibugurudyah]

Benar, ini materi yang sangat bermanfaat

[@asana.mardanloo3024]

Thank you for your great videos. Is it possible to talk about forecasting and VBA scripting in Excel ?

[@danielgrossmann8463]

Hi. Thank you for teaching power pivot. Would you know how I can dedicated measures for multiple row in pivot table using power pivots? I am really struggling with this.

[@jingyu3891]

I love this video

[@maribelcarlos5302]

I find your tutorials very helpful and I was able to re-create it on my own. My concern now is using the files from my OneDrive. I works well on my laptop. But when I login to another device, it is looking for the Onedrive files saved in my laptop. What should I do then. Thanks in advance

[@rw3486]

Thanks. This is useful. Can you provide an example that uses Power Query to get and clean multiple files, some of which have more than 1 million rows, then use PowerPivot to create the model (linking the files or tables), then create a Pivot chart. I think you can create a "connection only" for the large file(s), should you do that in Power Query or Power Pivot? Maybe you have to do it in power query? But Power Pivot seems to advertise that as a feature. Could you do it without Power Query? Or does "cleaning" the data require Power Query.

[@sumardjo]

Thanks for simple File thanks for knowledge thank you very much

[@hammadhago]

Thank you so much 💙

[@TeachersTech]

You're welcome 😊

[@Excellearn_ir]

tnx teacher 🥰

[@Mahendarreddy-wrkyt]

thank you very much sir

[@ademuyiwamopelade4179]

Thank you so much

[@rayt61]

Thank you!

[@TeachersTech]

You're welcome!

[@infamismworldwild6248]

Thank you

[@roberth.9558]

Thank you.

[@sqlservertutorialin3minute485]

Should the Tuition table to Student table be 1 to 1? Thanks

[@EverestAkigwe-h7l]

Is it possible to get the tables that you used?

[@fluffyhoneytina]

I have always had problems creating relationships and it never works for me..I end up using get data and merging. I wish I could use power pivot but I am dumb..

[@PizzzzzzaPie1018]

Hey Jamie - I will have to start watching all your videos to help myself learn. In the meantime, I was left this horrendous spreadsheet by a former co-worker that I have come to figure out fairly well. However, this spreadsheet looks up values based on current year and another year related to the client. For the life of me, I cannot get it to work since she left it was before 2020 and how she has it calculating is based on 1900 years. (I am probably not making sense). I am an absolute novice at Excel and I was wondering if I could somehow get your personal help? Is that something you do? I have tried everything to make these calculations work and I figured it out on some but not on this one particular one. I would be SO VERY GRATEFUL!!!!!

[@vishalnadekar694]

Is this video enough for power pivot??

[@tanveerabbas3271]

thks .. after creating total fees column in tuition fees sheet. when i come to student info sheet and strat writing related after= sign options do not come up. tried it all. why!!. plz assist❤

[@josepheboba8821]

👍

[@nmekadaniel8804]

I have be trying to import your practice data so I can play with it but I can’t,on my system I use to select import from other source then I will select web.shouldn’t I be selecting web? am cut up please anyone should help out I will appreciate

[@IsraelBatYam]

Hi. Unfortunately, Power Pivot is not available on Mac =(

[@TeachersTech]

It is unfortunate. Such a great add-in

[@freekorean9568]

Sorry to ask here but do you have any video on how to convert good old music CDs to mp3 format?

[@TeachersTech]

Hello, unfortunately I don't

[@godlove3538]

How to with databases

[@DawnDeSantis-n9o]

I'm not able to use Power Pivot in Excel web version. :(

[@jurm2661]

przydatny filmik. Szkoda że po angielsku.

[@InnocentMary-ch4vq]

Great tutorial. Thank you Please can you share your LinkedIn username?

[@jonathanj8613]

Keep up the awesome work!! You need to research 'promosm'.

[@ariannageorge6615]

Thank you very much teacher tech. But my excel doesn't have pivot. What do I do.