Excel 2021 Power User Tutorial

[@SiminLotfjou-e4m]

You explain every thing in a very clear and easy way.I am learning so much from you.Thank you so much❤

[@LearnitTraining]

You are so welcome!

[@MWafy-ei6le]

Very Amazing training, I'm definitely saving this for when I get stuck manipulating one of my data sets, however, something to note in the pivot tables section you went to options-> selected on generate getpivot data to turn it off so you can use the cell in a formula. Well I think their is an easier way for it is that you just type the cell number for example if you wrote =B4*5% it will give you the same result.

[@LearnitTraining]

Thank you for the great tip!

[@yaqubosmen1481]

Thanks Faz, bit late but watched your videos years ago to learn Excel! Great to still be learning.

[@LearnitTraining]

Great to hear!

[@mitchchancejo4242]

em cam on chi rat nhieu chuc chi nhieu suc khoe va thanh cong trong cong viec mong la trong tuong lai se co co hoi gap chi de duoc chi chi day nhieu hon

[@LearnitTraining]

Chúng tôi hy vọng bạn sẽ sớm nhận được nhiều tiền

[@EDitEsh13]

Thank you so much 😊❣️

[@LearnitTraining]

You are very welcome!

[@murtuzabhabhrawala9712]

Great tutorial as ever by Learn it. Thank you Faz

[@LearnitTraining]

Our pleasure!

[@mohamedtalaat5836]

Awesome Work, as usual, please can you tell me how can make these indicators ON VIDEO

[@LearnitTraining]

If you're talking about the arrows/boxes drawn on, we like to use ZoomIt: docs.microsoft.com/en-us/sysinternals/downloads/zoomit

[@Trucpq]

Big thanks. Could you give some session on Dashboard in Excel.

[@LearnitTraining]

Hi Truc! Thank you for watching and we will definitely look into that!

[@Jaya_Grafis]

Terima kasih banyak,

[@LearnitTraining]

Kembali

[@moneymarosx]

When trying to add calculated item, I keep getting an error that says "This PivotTable Report field is grouped. You cannot add a calculated item to a grouped field. I've tried various ways to fix it and rebuild, and it doesn't even work with the pivot table you have in the file. Please help :)

[@LearnitTraining]

You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com

[@enzostynberg7406]

What can i do to get this in excel? If a place (number) in a cell that should be in the range of 2 numbers, then that (number) gets placed in a specific cell of my choosing

[@LearnitTraining]

Hello Enzo! You can get help directly from our instructors at Offsite, our online community - www.offsitebylearnit.com

[@cho2566]

sorry i'm a liitle confused what's different between power user and your normal excel full course?

[@LearnitTraining]

The normal Excel course focuses on teaching the fundamentals of Excel while Power User courses focuses on using tools such as XLOOKUP and INDEX MATCH for data analysis.

[@depyegorbachyov6488]

My 2021 (home & student version) doesnt have xlookup formula. Is it normal?

[@LearnitTraining]

This article may help: support.microsoft.com/en-us/office/xlookup-function-b7fd680e-6d10-43e6-84f9-88eae8bf5929

[@depyegorbachyov6488]

@@LearnitTraining thank you