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 :)
@jawaharlalkaramchetti5675
9 ай бұрын
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
@francesdobbins2964
Ай бұрын
I never knew how to use this feature in Excel. Excellent tutorial!
@wolfcub1870
5 ай бұрын
Sir-you’re a genus! I am going to try using this to customise the daily work assignments I get
@Frederick7419
Жыл бұрын
Many thanks for your patience and covering almost everything. Bravo
@TeachersTech
Жыл бұрын
My pleasure!
@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!
@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!
@StopWhining491
Жыл бұрын
Thanks for generously providing your practice tables.
@bettyfish1749
11 ай бұрын
This was so helpful! You are a great teacher. Thanks so much for doing this.
@TeachersTech
11 ай бұрын
You are so welcome!
@shivtiwary5103
Жыл бұрын
Thanks for such a great content. Well explain !!
@required.
8 ай бұрын
Thank you so much , you are a great teacher .
@sumardjo
4 ай бұрын
Thanks for simple File thanks for knowledge thank you very much
@tanweerabbasabbas649
Жыл бұрын
you are a great teacher!! if any more power pivot videos plz send yiur link...🥰
@HamdanYouTuber
Жыл бұрын
This lesson really useful, thanks for sharing. 👍
@ibugurudyah
Жыл бұрын
Benar, ini materi yang sangat bermanfaat
@ramin31tube
Жыл бұрын
Very professional and useful channel. you teach much better than my college professor 🤭
@tahirhanif9669
Жыл бұрын
Thank you, excellent presentation
@jingyu3891
Жыл бұрын
I love this video
@hammadhago
Жыл бұрын
Thank you so much 💙
@TeachersTech
Жыл бұрын
You're welcome 😊
@Mahendarreddy-wrkyt
4 ай бұрын
thank you very much sir
@surendrababu9184
7 ай бұрын
Very good teaching 😃
@TeachersTech
7 ай бұрын
Thank you! 😃
@asana.mardanloo3024
8 ай бұрын
Thank you for your great videos. Is it possible to talk about forecasting and VBA scripting in Excel ?
@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.
@rayt61
6 ай бұрын
Thank you!
@TeachersTech
6 ай бұрын
You're welcome!
@infamismworldwild6248
3 ай бұрын
Thank you
@ademuyiwamopelade4179
Жыл бұрын
Thank you so much
@roberth.9558
Жыл бұрын
Thank you.
@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?
@maribelcarlos5302
6 ай бұрын
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
@Excellearn_ir
Жыл бұрын
tnx teacher 🥰
@rw3486
9 ай бұрын
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.
@sqlservertutorialin3minute485
7 ай бұрын
Should the Tuition table to Student table be 1 to 1? Thanks
@tanveerabbas3271
21 күн бұрын
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❤
@vishalnadekar694
Жыл бұрын
Is this video enough for power pivot??
@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!!!!!
@josepheboba8821
6 ай бұрын
👍
@godlove3538
10 ай бұрын
How to with databases
@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
@DawnDeSantis-n9o
Жыл бұрын
I'm not able to use Power Pivot in Excel web version. :(
@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
@jurm2661
10 ай бұрын
przydatny filmik. Szkoda że po angielsku.
@InnocentMary-ch4vq
10 ай бұрын
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.
Пікірлер: 60