Advanced Pivot Table Techniques (to achieve more in Excel)

  Рет қаралды 1,999,672

Leila Gharani

Leila Gharani

Күн бұрын

Пікірлер: 1 400
@LeilaGharani
@LeilaGharani Жыл бұрын
Tired of wasting hours in Excel? Pivot Tables can cut your work in half 👉 www.xelplus.com/course/excel-pivot-tables/ 👈 My Pivot Table Essentials course will teach you how. Download the Pivot table sample file here 👉 pages.xelplus.com/pivot-tables-advanced
@elenoanaivalu5060
@elenoanaivalu5060 2 ай бұрын
Hi! entered my details but I still don't get the sample file in my email. Any other way I can get it?
@RobynWingerter
@RobynWingerter 3 жыл бұрын
I started a new job a month ago, and because of you, I am WOWING my new boss from watching all of your excel videos. I had never used pivot tables before and he thinks I'm a genius! LOL THANK YOU!
@LeilaGharani
@LeilaGharani 3 жыл бұрын
That's great! Good luck with the new job!
@kimberleydickson9003
@kimberleydickson9003 2 жыл бұрын
@@LeilaGharani i
@cmelfe5888
@cmelfe5888 2 жыл бұрын
That's so awesome! I too, recently started a new job requiring alot of Excel. I was honest and upfront letting my boss know I was more on the intermediate side vs advanced level but very willing and very much wanting to learn more. To Excel at Excel ... but I have a question.... if you happen to see my response???
@RobynWingerter
@RobynWingerter 2 жыл бұрын
@@cmelfe5888 Sure. I'll do my best
@alaashebeeb8729
@alaashebeeb8729 2 жыл бұрын
good luck and try to watch all Leila`s videos to make the the spreadsheets easy for navigating through
@tetley69
@tetley69 3 жыл бұрын
Leila, I have to say that I find the way you teach, talk and explain things absolutely perfect. I find most tutorials online hard to follow and/or not explained properly. But the way you teach, I feel any user of any level of expertise will both benefit and learn from. You don't rush, you are soft spoken, you move at a perfect pace and I find that I look forward to learning more from you from your other videos. I just wanted to congratulate you on a job well done and I thank you for putting these videos out here for others to learn from. Thank you again.
@naveedwantt2846
@naveedwantt2846 2 жыл бұрын
Hey, can u please help me with this question... ‌Imagine u r working on a data set that has 20 Call quality Parameters arranged vertically in 20 columns, with 250 entries, from 20 Agents who report to 5 TLs who in turn report to 2 Managers. In four steps explain how you present manager wise Data & TL wise data seperately. Please do help, it's really very important for me!
@rajkumarbalasubramaniam7232
@rajkumarbalasubramaniam7232 2 жыл бұрын
I agree 100%
@BrianBoudreau
@BrianBoudreau Жыл бұрын
@@naveedwantt2846 This is what ChatGPT says about your question: 1. Sort the data set by Manager and TL columns, so that all the entries for each Manager and TL are grouped together. 2. Use the "Group" function to create separate groups for each Manager and TL. 3. Use the "Sum" function to calculate the total for each Call Quality parameter for each group. 4. Use the "Pivot Table" function to create separate tables for Manager and TL wise data, with the Call Quality parameters as rows and the Manager/TL names as columns.
@AJWilcox
@AJWilcox Жыл бұрын
Haha this was epic. I do a LOT with pivot tables so I wasn't expecting to learn so much, but it turned out I only knew 3 of the tips. Way to go Leila! Thanks for the killer videos for us geeks.
@LeilaGharani
@LeilaGharani Жыл бұрын
Haha, happy to help :)
@loizoumech
@loizoumech 2 жыл бұрын
If School had more teachers like you, the world would have been a better place :) Thank you for creating the content and sharing with everyone. Your videos are always clear and practically useful.
@henryg5735
@henryg5735 3 жыл бұрын
I particularly liked the use of symbols within custom number formats - new to me, and of much wider use. Oh, and the grouping, but the whole video is excellent.
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Glad you liked it, Henry!
@naveedwantt2846
@naveedwantt2846 2 жыл бұрын
Hey, can u please help me with this question... ‌Imagine u r working on a data set that has 20 Call quality Parameters arranged vertically in 20 columns, with 250 entries, from 20 Agents who report to 5 TLs who in turn report to 2 Managers. In four steps explain how you present manager wise Data & TL wise data seperately. Please do help, it's really very important for me!
@antoniosanzr
@antoniosanzr 18 күн бұрын
The multiple pivot reports with one click blew my mind 🤯 thnks!!
@parahiamin6765
@parahiamin6765 2 жыл бұрын
Why the 91 dislikes? So much time and effort has been spent to produce a professional video that has, from the comments, helped a lot of people to gain a more advanced understanding of pivot tables! Plus, it's totally free!!!
@newlightning2306
@newlightning2306 6 ай бұрын
I couldn't agree more!
@sojo089
@sojo089 3 жыл бұрын
When you think you know it all about PT and 90% of the tips show totally new things that are not present in huge books! Great great material Leila! you are AWESOME!
@vinayramachandran4992
@vinayramachandran4992 3 жыл бұрын
Agree !!
@formosa3645
@formosa3645 3 жыл бұрын
@@vinayramachandran4992
@jarcadipane2849
@jarcadipane2849 Жыл бұрын
There is not one single video that I have watched from your channel that has not taught me a half dozen things that I was not even aware of! I am so appreciative! Great, great, great channel!
@shaileshk4486
@shaileshk4486 2 жыл бұрын
I have been using Pivots for ~7 yrs now and i can assure, these particular tips can help you do almost anything and everything to summarize data with pivots!
@sachinrv1
@sachinrv1 3 жыл бұрын
Three things. 1) Your videos never fail to impress. 2) Your videos always keep us engaged through out. 3) Authenticity of your knowledge sharing is unparalleled.
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Aww, thank you Sachin! You're too kind!
@andyjackson8802
@andyjackson8802 Жыл бұрын
Hi Leila, hands down, one of the best videos concerning pivot tables that I have seen. You Rock! Please keep sharing your knowledge with others.
@MithunKumar-iz7ru
@MithunKumar-iz7ru 3 жыл бұрын
No better excel instructor than you on youtube. You actually changed my professional career. Big thank you
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Thank you so much for watching and supporting! I’m very happy the tutorials had a positive impact for you.
@RT-hh3vl
@RT-hh3vl 3 жыл бұрын
Hi Leila, would it be possible for you to do a video on the journey you have made over the last 5 years? Your patience and resilience could be a huge lesson for all of us... many thanks
@LeilaGharani
@LeilaGharani 3 жыл бұрын
I'll think about. Thank you for your suggestion, Robert.
@nevermind4780
@nevermind4780 3 жыл бұрын
I always amazed by leila's creative ideas and thought process.
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Thank you 😊
@dyandsa798
@dyandsa798 3 жыл бұрын
The insert timeline part is gold. Thanks!
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Our pleasure :)
@robrayborn1349
@robrayborn1349 3 жыл бұрын
You are always so clever! I've been working with Pivot Tables for years and didn't know about a 3rd of what you presented. Probably should mention that when you double click on a cell in a pivot table you will only get the first 1,000 rows of that detail. If your original data is > 1,000 rows of data then not all will be present when you double click on the cell.
@barttitulaerexcelbart9400
@barttitulaerexcelbart9400 3 жыл бұрын
Thanks Rob, this is called drill down...
@amolj2249
@amolj2249 3 жыл бұрын
Thanks for this important point. Actually I am facing a problem with sum mismatch between pivot table sum and original data table sum. My data table is 8000+ rows. So is this reason why pivot is not working...
@priyeshsanghvi8424
@priyeshsanghvi8424 2 жыл бұрын
@@amolj2249 You can increase the drill down to more than 1000 rows limit....please google for the solution.
@samuelorozco3439
@samuelorozco3439 3 жыл бұрын
I also took this as a challenge to see if I knew all of these. I was defeated by the "create reports with one click" lol Will give you about 90% of the credit though - all the other ones I knew I learned from your guides on different videos. As always, top quality content. My go to for everything Excel related :)
@NganNguyen-nc5cv
@NganNguyen-nc5cv 2 жыл бұрын
Me too. I like that function
@wayneedmondson1065
@wayneedmondson1065 3 жыл бұрын
Hi Leila. Some great tips in there.. thanks for sharing them! One I can add.. when you drill down to see the underlying details of a particular Pivot Table cell, if you want just a temporary quick look, you can then delete the created drill down worksheet with CTRL+z. Saves a little time vs. other methods of worksheet deletion such as: right click, delete, confirm delete. Thanks again for all your tips :)) Thumbs up!!
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Great tip! Thanks for sharing, Wayne.
@HenryChukwu-hg8xt
@HenryChukwu-hg8xt Жыл бұрын
kzbin.info/www/bejne/r3ndhZJ4isyah80
@sanjaypadval1819
@sanjaypadval1819 3 ай бұрын
Found the best channel for Excel formulas understanding... Love from India ❤
@annakelly7214
@annakelly7214 3 жыл бұрын
Thank you, I got hooked on your training, started with Udemy, now added youtube snapshots. Absolutely brilliant, a mine to explore - makes learning fun and fascinating. I always get extra bits form your training. Wow! X
@aamiraziz2642
@aamiraziz2642 2 жыл бұрын
All of your videos are very useful. Their tone is simple and very understandable. Anyone get proficient in MS office just by watching those videos. Hats off for you.
@LeilaGharani
@LeilaGharani 2 жыл бұрын
Glad you like them!
@milofonbil
@milofonbil 3 жыл бұрын
Leila, I would love to see a segment on using pivot tables to create graphs to analyze data.
@natmze
@natmze 3 жыл бұрын
I would love that
@Javier_Bltrn
@Javier_Bltrn 3 жыл бұрын
bump
@janhermanek2159
@janhermanek2159 2 жыл бұрын
Wow, your videos are such an eye opener, just realised I have been usine Excel at max 5%
@karendonovan6702
@karendonovan6702 Жыл бұрын
This is AWESOME!! I use excel a lot and pivot tables but was not aware of all these options! Great - thank you!
@ashfaquehossain8592
@ashfaquehossain8592 3 жыл бұрын
Hi Leila- I am from Bangladesh & currently in Fraud Analysis & Reporting. Your tutorials are really great & helpful. The "Little" excel I know- thanks goes to your tutorial.
@JM-1963
@JM-1963 3 жыл бұрын
If you think you know it all, Leila will show you a new horizont
@LeilaGharani
@LeilaGharani 3 жыл бұрын
😊
@excelmastervba
@excelmastervba 3 жыл бұрын
Always true 😄
@AbhishekSingh-wk5nm
@AbhishekSingh-wk5nm 3 жыл бұрын
Absolutely!!
@JherTee_Gaming
@JherTee_Gaming 3 жыл бұрын
@@LeilaGharani can i send an emai? I need some advice from you please .
@hkr1147
@hkr1147 3 жыл бұрын
I hope this is limited to Office products
@xloneclick
@xloneclick 2 жыл бұрын
thank you Leila for your training videos so fluent and so efficient. the best optimized time for a huge added value
@ptichka1371
@ptichka1371 3 жыл бұрын
Thank you, Leila! I'd love to take a whole course on creative dashboards based on advanced pivot table table usage. Maybe you have enough projects to combine into a course for us? 😉
@I_Follow_Jesus
@I_Follow_Jesus 3 жыл бұрын
I recently changed careers from an electronic technician to a business analysist. You videos and Udemy courses have been very beneficial.
@navjotsingh2251
@navjotsingh2251 3 жыл бұрын
What made you switch, just curious.
@I_Follow_Jesus
@I_Follow_Jesus 3 жыл бұрын
@@navjotsingh2251 I was an RF Hardware Engineering Technician who was dealing with a lot of data that was slowing down decision making. I started learning Python to add some automation. My efforts were recognized by my employer and I was offered the role of Business Analysist. I'm absolutely loving the new role.
@michebernier5298
@michebernier5298 3 жыл бұрын
Leila - not only am I so very grateful that you share your knowledge 3 of these functions I had no idea I could do, and I've already made changes to Pivot Tables I use daily. Thank you so much for intelligent well planned and informatively helpful videos. Subscribed and liked !
@AbhishekSingh-wk5nm
@AbhishekSingh-wk5nm 3 жыл бұрын
The grouping by no. of days is really useful to fetch week on week data !! Thanks a lot Leila...
@colormile-vid8888
@colormile-vid8888 3 жыл бұрын
I never knew how I would use the timeline feature. Now I see that I could use it in one of my reports. As always, Leila shows the community very useful tips and tricks that can be applied easily. I truly envy your knowledge in excel. Thanks Leila!
@beyobeya
@beyobeya 3 жыл бұрын
And she showed us how to use timeline in just a few seconds, yet it was all that we needed to know. She's a fantastic trainer!
@boka88bo
@boka88bo Жыл бұрын
U blow my mind with Create Multiple Pivot Reports With 1 Click. tnx!
@TheWinningSperm888
@TheWinningSperm888 3 жыл бұрын
This has given me so many ideas for some personal projects of mine. The list should have been 20 not 10!
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Hope it will be helpful for your projects.
@jayasimhanrao3269
@jayasimhanrao3269 Жыл бұрын
It is really amazing to know the utility the excel provides for users. Thank you & kudos to you for sharing your knowledge.
@watsonshia1917
@watsonshia1917 3 жыл бұрын
Those things really come with time and on the job training but Leila is able to roll all those years of experiences into one for you, amazing !
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Thank you!
@ElTigreFIME
@ElTigreFIME 2 жыл бұрын
@Leila - you deserve millions of subscribers with these videos. Thanks so much and keep up the great job!
@LeilaGharani
@LeilaGharani 2 жыл бұрын
Wow, thank you!
@toddmoore8893
@toddmoore8893 2 жыл бұрын
I want to like this more than once! Love Love Love pivot tables!! Thanks for all the great Excel videos. I am teaching a Pivot table class next week and wanted a few more tips to share with the audience and you have provided some great ones here! I love teaching excel and I love that when I prepare for a class I always end up learning more myself!
@gurumurthy1637
@gurumurthy1637 3 жыл бұрын
Such easy solutions for complex problems! Calculated fields in pivot tables will make life so much simpler! You are awesome Leila 👏👏
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Happy to help!
@IsmailShimau
@IsmailShimau 3 жыл бұрын
Another advanced pivot table technique to cover is report connections:- Use case: add report connections to the timeline so that all connected reports will be updated with the same timeline. This works with all pivot table slicers too.
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Thanks for sharing!
@alexandrkrav
@alexandrkrav 2 жыл бұрын
It is super lesson to extend knowledge of pivot table. Dear Leila, thanks you.
@joebateman9668
@joebateman9668 Жыл бұрын
The one extra tip I would add is, when inserting a pivot table check the "add to data model". This allows you to write Dax measures.
@davidpoulin6961
@davidpoulin6961 Жыл бұрын
Selecting data model also lets you do distinct counts. Very useful if you have duplicate items in a column but you want to count each item only once.
@arsovdraganvranje
@arsovdraganvranje 2 жыл бұрын
I have watched many of yours videos, great job, and finally you have added an option to download the file from the video which is very helpful (hope you will add on all yours tutorials) Thanks for helping us
@MarwanAShareef
@MarwanAShareef 3 жыл бұрын
When i get notification from my mobile, directly i know that comes from Leila, 😁 all others blocked directly 😁
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Wow, thank you for your trust.
@carlstiller2261
@carlstiller2261 2 жыл бұрын
Excellent, my favourite was calculating delta between months.
@jayacharya7333
@jayacharya7333 3 жыл бұрын
When Leila challenges to comment "if you knew all these write in comment means you wouldn't know all." I was beaten by icons.
@LeilaGharani
@LeilaGharani 3 жыл бұрын
😁
@biljanamajstorova3332
@biljanamajstorova3332 3 жыл бұрын
Win+dot made me failed as well on this challenge 😀
@AmitRoy-om3tp
@AmitRoy-om3tp 3 жыл бұрын
It is one of the best videos on Pivot tables I have ever watched. Thanks a lot, Leila.
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Wow, thank you!
@mandemusongo441
@mandemusongo441 2 жыл бұрын
I love tha fact that your videos are short enough and yet so full of information. thank you for doing this.
@LeilaGharani
@LeilaGharani 2 жыл бұрын
Glad you like them!
@riansyahsumajaya
@riansyahsumajaya 2 жыл бұрын
Superb information you've got Leila, really maximize efficiency. Good work!
@LeilaGharani
@LeilaGharani 2 жыл бұрын
Glad you think so!
@Untaian_Kata
@Untaian_Kata Жыл бұрын
Because of u, I'm fallin love with excel. Thank you leila. 😇❤️
@MHassan441
@MHassan441 3 жыл бұрын
Out of 10 tips introduced by you, following 8 were new to me: Adjust Pivot table Field List Settings Create Multiple Pivot Reports With 1 Click Add Data Bars to Pivot Tables Calculate the Difference Between Columns Smart Custom Number Formatting Create Your Own Custom Groupings How to Group Date Fields Add A Timeline to Your Pivot Table Thank you so much.
@LeilaGharani
@LeilaGharani 3 жыл бұрын
I’m very happy you discovered new tips here 😊
@marthacastro4488
@marthacastro4488 17 күн бұрын
Thank you, Leila, every time I learned something new!
@studymenia1207
@studymenia1207 Жыл бұрын
OMG... Amazing Super useful video for any Excel user ...How on earth can someone teach so beautifully... Thanks a ton Leila... You are out of this world...
@aniljaggarwal60
@aniljaggarwal60 2 жыл бұрын
You are sacrificing all the knowledgeable treasure of Excel on the world, in return you get the love and respect of the world. Keep getting such awards.
@vincentcollin6490
@vincentcollin6490 2 жыл бұрын
Je découvre votre chaine KZbin. Je suis très impressionné et admiratif de votre savoir faire et savoir communiquer ! Félicitations. I discover your KZbin channel. I am very impressed and admiring your knowledge and communication skills! I congratulate you.
@aaronkerr3317
@aaronkerr3317 2 жыл бұрын
I have to say, i use pivot tables every day and tip 2 will change my life, I completed this manually and this will save me so much time, thank you so much, amazing
@collinsdeloach6815
@collinsdeloach6815 Жыл бұрын
As a user of Excel and Pivot Tables for many years, you have nailed it and taught this old dog some new tricks. Thanks!
@ca1ifax
@ca1ifax 3 жыл бұрын
Leila is my Go To person for anything Excel. I recommend her to my friends as well because she's very easy to follow.
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Thank you for your support!
@andreashermle2716
@andreashermle2716 Жыл бұрын
Lejla, you are one of the best IT-instructors on the WEB, concise and at the same time detailed explanations. Keep up the good work.
@maxamdxasan9462
@maxamdxasan9462 9 ай бұрын
Liela, Actually, I have appreciated the way you have explained the pivot tables with good guidance, and I hope someone who watched your videos' will never need teaching about how the pivot tables work. I would like to say thanks you for your teaching us, and I wish you all the best.
@LeilaGharani
@LeilaGharani 8 ай бұрын
Thank you for the kind words!
@umarhayatkhanlodhi3358
@umarhayatkhanlodhi3358 2 жыл бұрын
Asalam'alaykum Umar Hayat Khan is here, I am from Pakistan, Sister I have listened your several lessons and all were very helpful, I am very grateful for your teaching very well thank sister.
@luigivenafro
@luigivenafro Жыл бұрын
With a lot of arrogance I think I can do my pivot tables quite well and then, with your video, I always discover new tricks!!! Congratulations for the exposure and the clarity of the explanations! Thank you 😊
@LeilaGharani
@LeilaGharani Жыл бұрын
Glad it was helpful, Luigi!
@danielpkd1
@danielpkd1 2 жыл бұрын
Thank you Leila for the wonderful videos. Stay Blessed
@derrickludwig
@derrickludwig 3 жыл бұрын
You are awesome! I learned 2 super valuable tricks that would have saved me a ton of hours in the past.
@bernardobenvegnupasinatto7090
@bernardobenvegnupasinatto7090 2 жыл бұрын
Creating groups is amazing. Helps a lot when we are analysing the data.
@LeilaGharani
@LeilaGharani 2 жыл бұрын
Glad it was helpful!
@retief5057
@retief5057 2 жыл бұрын
The way you describe things is absolutely brilliant, simple and to the point. Well done !! Question: How do you change the formatting of multiple columns with values, with "one click", without having to change every column on its own. Surely there must be a quicker way??
@RSk15068
@RSk15068 3 жыл бұрын
I watched your two videos done about pivot tables . I had a basic knowledge of pivot tables before watching your videos. Now I think I am doing well with pivot tables. Thank you very much .
@shaheryarmalik9670
@shaheryarmalik9670 2 жыл бұрын
That was overwhelming for me... one of the BEST VIDEO TUTORIALS i have ever seen... and i have been using Excel from last nearly 20 years...
@LeilaGharani
@LeilaGharani 2 жыл бұрын
Glad you liked it!
@sriramya3179
@sriramya3179 Жыл бұрын
Thanks a lot Leila, this video helps a lot for a Data Analyst in our Day to Day work activities.
@sanjaykukreja0909
@sanjaykukreja0909 2 жыл бұрын
I have not seen any quick informative video like this anytime in my 7 years of professional career ! Thanks a ton !
@nurebhuiyan7319
@nurebhuiyan7319 3 жыл бұрын
Leila, you are the best in excel tutorial. So simple way you show everything is easy to remember. I will see your other videos as well. Best wishes for you.
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Thank you so much!
@zahirsabit8134
@zahirsabit8134 2 жыл бұрын
Leila, you're absolutely the best teacher I had ever.
@1stone379
@1stone379 3 жыл бұрын
I like how these examples are broken up in individual segments so I can get straight to a different topic if I need that currently. Bravo
@haashini10031985
@haashini10031985 3 жыл бұрын
Wow... Wow... Wow... No words for your knowledge and wisdom... Lots of respects for your passion oN Excel. Thanks a million
@fekaduabetu9429
@fekaduabetu9429 2 жыл бұрын
Leila, I have no words to explain! Simply thank you!!! I am benefiting from much more from you
@a68tbird
@a68tbird 3 жыл бұрын
I thought I was an Excel Ninja, but wow was I wrong!! I've learned so much from watching your videos. Today it was the tip, "Creating Multiple Pivot Reports With 1 Click". That is great! Thanks so much for your videos!
@rozlobo1538
@rozlobo1538 3 жыл бұрын
OMG.... i wish i knew about individual reports before, i would have saved half my life creating each report. Thank you so much for these brilliant tips.
@dolf1n1
@dolf1n1 2 жыл бұрын
Exceptional I’ve watched so many excel videos on pivot tables and given up. You way of explaining is the best way to learn. 😊
@francois830
@francois830 Жыл бұрын
I totally agree with Tetle. Leila you are AMAZING!!!.
@Алексей-б6к5е
@Алексей-б6к5е 3 жыл бұрын
Amazing Leila, Amazing Video. Thank you.From Russia with love.
@LeilaGharani
@LeilaGharani 3 жыл бұрын
большо́е спаси́бо! 😁
@eleniviglaki
@eleniviglaki 2 жыл бұрын
I just love your work, very inspiring, thank you!
@meleciosantiago1155
@meleciosantiago1155 2 жыл бұрын
She is really amazing...thank you so much!
@boogienating
@boogienating 2 жыл бұрын
Upset that there's no button for heart. I loved this vid! Super helpful!
@akshayjadhav6647
@akshayjadhav6647 Жыл бұрын
You have covered almost all the hidden secrets of Pivot table.. Really amazing.. Appox 40% things have never seen before. Thanks a lot for upgrading us.
@Mohammedshafi-Msk
@Mohammedshafi-Msk 3 жыл бұрын
wow, that is awesome. My favourites are Custom Grouping, Timeline, Adjust Field List Setting & Multiple Report in One Click. Today I learned something new. Thanks, Mam.
@Sandy-ko9jq
@Sandy-ko9jq 3 жыл бұрын
I was aware of all the 10 tricks that u have shown, but it was a nice refresher. The symbol tricks I was not aware couple of days before seeing this video, which also I learned through ur another video. Thanks for doing nice work for Excel learners.
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Great 👍
@phorton968
@phorton968 3 жыл бұрын
Very informative. My stock just went up. Your lesson paid dividends. Much, much appreciated.
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Glad to help!
@robwillox7033
@robwillox7033 3 жыл бұрын
I found this video very helpful. I had been doing my column formatting using Value Field Settings. I had no idea that you could format using a right click in a column. I think you saved me at least 5 minutes of monotony per table. That was great. I also didn't know that if you have data formatted as a table that you can just click a cell in that table to create the link. Very good!
@teofilotamele569
@teofilotamele569 3 жыл бұрын
Adding symbols to custom number was new to me. thanks for sharing.
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Happy to help.
@woofwoof416
@woofwoof416 7 ай бұрын
I knew about the double-click to get the details. I DID NOT know about the option to be able to see separate reports based on filtering. That's a useful feature I wasn't aware of. Thanks for that tip.
@LeilaGharani
@LeilaGharani 7 ай бұрын
You're very welcome!
@hussainakhtar1094
@hussainakhtar1094 3 жыл бұрын
I have been watching your videos for sometime now. I had an interview today with an Adv. Excel test...and I used SUMIFS and Pivot table techniques to present similar and varied results with payroll data. Thank you Leila... :)
@LeilaGharani
@LeilaGharani 3 жыл бұрын
That is awesome!
@Chakkalakkal
@Chakkalakkal 3 жыл бұрын
Very helpful, will save me a lot of time generating my reports.THANK YOU.
@LeilaGharani
@LeilaGharani 3 жыл бұрын
Glad it helped, Thomas!
@salvi2606
@salvi2606 2 жыл бұрын
I always learn something new from your videos
@aygerimkulmamirova4123
@aygerimkulmamirova4123 8 ай бұрын
Thank you for great training, I will be using them in my daily work
@Faisals_Adventures
@Faisals_Adventures 9 ай бұрын
Absolutely loved all the tricks. This is quite amazing.
@markpodesta4605
@markpodesta4605 3 жыл бұрын
Thank you Leila. I am learning new things about pivot tables.
@LeilaGharani
@LeilaGharani 3 жыл бұрын
That's great! There's always more to learn :)
@weeraonkhongwut7028
@weeraonkhongwut7028 2 жыл бұрын
Thank you so much Leila. Your explained makes me very clear and can useful.👍
@krobbie89
@krobbie89 2 жыл бұрын
This is soo good. And I had scrolled by this video many times before thinking that there probably wasn't much more to learn on Pivot tables.
@LeilaGharani
@LeilaGharani 2 жыл бұрын
Glad you found it helpful, Robert.
Excel Pivot Table EXPLAINED in 10 Minutes (Productivity tips included!)
13:22
Пришёл к другу на ночёвку 😂
01:00
Cadrol&Fatich
Рет қаралды 10 МЛН
From Small To Giant Pop Corn #katebrush #funny #shorts
00:17
Kate Brush
Рет қаралды 67 МЛН
PivotTable Tricks That Will Change the Way You Excel (Free File)
17:47
MyOnlineTrainingHub
Рет қаралды 136 М.
5 Excel Tools Most Users Never Think to Use (Files Included)
12:34
MyOnlineTrainingHub
Рет қаралды 216 М.
5 Excel Secrets You'll Be Embarrassed You Didn't Know
17:32
Excel Campus - Jon
Рет қаралды 201 М.
Advanced Pivot Table Tricks ONLY Experts Know
9:39
Kenji Explains
Рет қаралды 486 М.
This is how I ACTUALLY analyze data using Excel
24:05
Mo Chen
Рет қаралды 210 М.
Say Goodbye to IF Statements in Excel with SWITCH
7:45
Teacher's Tech
Рет қаралды 526 М.
Common Excel Pivot Table Features People Miss (and you?)
12:45
Leila Gharani
Рет қаралды 120 М.
Are These Pivot Table Mistakes Costing You?
9:45
Leila Gharani
Рет қаралды 39 М.
Best Pivot Table Design Tips to Impress Anyone
12:18
Kenji Explains
Рет қаралды 211 М.
Пришёл к другу на ночёвку 😂
01:00
Cadrol&Fatich
Рет қаралды 10 МЛН