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 :)
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 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
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!
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?
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
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.
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..
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
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!!!!!
the videos are very use full and recommended to see in a serial order to pick up the skills in excel.
I never knew how to use this feature in Excel. Excellent tutorial!
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 :)
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.
Glad you found it helpful!
@@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
Sir-you’re a genus! I am going to try using this to customise the daily work assignments I get
Many thanks for your patience and covering almost everything. Bravo
My pleasure!
one of the best video..very simple and easy to understand... fall in love with your videos...thanks and gratitude
You’re welcome and thank you!
hi first well done thanks a lot, i watch your videos since 2019, you helped me create my channel art thanks !
You’re welcome!
Thanks for generously providing your practice tables.
Thanks for such a great content. Well explain !!
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!
You’re welcome!
I will try to use this formula. Thank you.
Thanks for simple File
thanks for knowledge
thank you very much
Thank you so much , you are a great teacher .
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?
you are a great teacher!! if any more power pivot videos plz send yiur link...🥰
This was so helpful! You are a great teacher. Thanks so much for doing this.
You are so welcome!
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
This lesson really useful, thanks for sharing. 👍
Benar, ini materi yang sangat bermanfaat
Thank you for your great videos. Is it possible to talk about forecasting and VBA scripting in Excel
?
Should the Tuition table to Student table be 1 to 1? Thanks
Very professional and useful channel. you teach much better than my college professor 🤭
Thank you, excellent presentation
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.
Very good teaching 😃
Thank you! 😃
thank you very much sir
I love this video
Thank you so much 💙
You're welcome 😊
Thank you
Thank you!
You're welcome!
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..
Thank you so much
Is this video enough for power pivot??
Thank you.
tnx teacher 🥰
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
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!!!!!
How to with databases
I'm not able to use Power Pivot in Excel web version. :(
Hi. Unfortunately, Power Pivot is not available on Mac =(
It is unfortunate. Such a great add-in
👍
Sorry to ask here but do you have any video on how to convert good old music CDs to mp3 format?
Hello, unfortunately I don't
przydatny filmik. Szkoda że po angielsku.
Great tutorial. Thank you
Please can you share your LinkedIn username?
Keep up the awesome work!! You need to research 'promosm'.
Thank you very much teacher tech. But my excel doesn't have pivot. What do I do.