This Pivot Table Trick Will Blow Your Mind || Excel Malayalam
ฝัง
- เผยแพร่เมื่อ 18 ก.ย. 2024
- In this tutorial you can learn how to generate separate worksheet from Pivot Table (Malayalam) Report filter page, which support for all the versions of Microsoft Excel like 2003, 2007, 2010, 2013, 2016 and 2019.
A Pivot Table helps to get an overview of the data represented in the Excel spreadsheet and it analyse, summarize the data for easy analysis, quickly extract the data from any part of the Pivot Table and show only relevant data in our reports.
Other Videos You Might Like:
10 Magical Time Saving Tips & Tricks To Make You Excel Expert : • 10 Magical Tricks in M...
Learn Basic VLOOKUP Function in 5 Minutes : • Learn Basic VLOOKUP in...
How to Use SUBTOTAL Function in MS Excel : • How to Use SUBTOTAL Fu...
5 Easy Method to Find & Remove Duplicate Data in Excel : • Find & Remove Duplicat...
How to Create a Pivot Table in Excel : • Learn Pivot Table in 1...
Excel IF Function | IF, SUMIF, COUNTIF, NESTED IF : • IF, SUMIF, COUNTIF, NE...
12 Functions in 12 Minutes || Excel Text Functions : • Data Cleaning Function...
MIND-BLOWING Excel Trick | Auto Advanced Filter - • How do I use advanced ...
Difference Between VLOOKUP vs HLOOKUP - • What is VLOOKUP vs HLO...
How to Insert Blank Rows & Columns After Every Data in Excel : • How to Insert Blank Ro...
Let’s connect on social:
Facebook: / skill2succced.alfan
LinkedIn: / mohammed-alfan-23a94b30
Instagram: / z_one_clt
Twitter: / toalfan
One of best excel classes in youtube. Easy methods ,nice presentation
Thanks Brother :)
Very very simple teaching .... nicely understanding... Much thankful dear alfan...
Very useful..thanks Boss
How to extract a huge data from a merged cell and paste it in
a column wise eg..drawing numbers, Revision etc.
Could I join in a live online class?pls provide your
Thanks for your teaching 👍
Thanks Man :)
ഇതൊരു പുതിയ അറിവാണ് . Thank you
Most welcome😊
MIRACLE SMOOOTH TEACHING THANKS😍👍
😇
Awesome Alfan.... you deserve more subscribers
🙏😊
Thank you
Most welcome😊
Very useful information. Thank you so much
Thank you... Amazing tricks ... Well done
Nice idea! Thanks
😊
best presentation
Thanks a lot
Very useful, thank you bro
Great session...Had a great learning...can u pls share the data sheet
Excellent
Thank you! Cheers!
Pwoli💥💥
Best class ever available..
Sir can u please send me the data for practice?
Sure😊Your mail id pls...
hi sir, while practising this example why its not showing SHOW REPORT FILTER PAGES in pivot table option
Thank you bro 🌹🌹🌹
Welcome 😊
sir ,how can we easily finish bank reconciliation (BRS) through excel.Could you please upload a video?
Sure Vivek, I will upload it soon (With Simple way) :)
GOOD VIDEO
Sir plz upload pivot chart , date related functions
Noted👍😊
@@rows_columns ok sir🙏😊
Supper class
Why I tired the salary count it's just showing Numbers 1,2,4 in each row the salary amount count is not getting displayed
Super 😘
Super
Ellam paranja pole cheythittum the option "show report filter pages" is grey in colour..
Hello Brother, Have you tried adding a field from the PivotTable Field List to the Report Filter by dragging the field from the list to the report filter area?
Good info 👍
😊
Great 👍
Aging report simple aayi video cheyyuno?
Monthly attendance sheet should be saved in excel through macro (ex. clear sheets, and copy sheets, please advise
Will explain it in separate video and upload it👍
Hai bro,
Classes ayitt cheyunundo. I am interested
Ur whatsapp no pls😊
Hello how to go back to previous step
How to remove this individual sheets?
Thank u
Dear AlFan, I am not able to fix the drop menu in Pivot table icon. I am using Excel 2013. Tried through customize the ribbon also. What is the solution ?
Hi Raju,
Have you tried adding a field from the PivotTable Field List to the Report Filter by dragging the field from the list to the report filter area?
Bro paid, not paid ulla oru customer data..undennu karuthuka.. remarks column el paid ..other remarks okke undennu karuthuka.. enikke pivot table vendathe customer name total unpaid , total paid..grand total.. ingane oru table cheyyamo
Sure bro.. Njaan separate video undaki kanikam😊😊
Count and sum ഒന്നിച്ചു display പറ്റുമോ
Avasam separate sheet il vannu shesham athu engane aanu pazhaya sheet pole ayakunnath...oro sheetum delete aakno atho vere options undo sir
Yes brother....else you can try in different sheet by taking back up original one😊
Excel il Charts prepare chaiyunna video idamo?
Sure.. Will plan and upload it soon👍😊
Sir show report filter pages option inactive anu, adhe nthanu karenam. Plz help....
Adhu ningalude Filter Box empty aayirikkum..
No sir I'm already added it. 2016 Excel aanu..
How come?🤔
Sir njan entay practice file njan sir ene mail el share chyedhittunde...sir time ullappo onne nokkitte pattuanel reply thannal upakaram ayirunne
Sure.. will check 👍
ഫിനാൻഷ്യൽ റിപ്പോർട്ട് ഉണ്ടാകുന്ന മോഡൽ ചെയ്യാമോ
There is no option to add "show report filter page," in my Excel .. please help me !
This option not available also in customize ribben
Hello Brother, Have you tried adding a field from the PivotTable Field List to the Report Filter by dragging the field from the list to the report filter area?
@@rows_columns Now ok
Can i add all data(Filter column Title) in one by one sheet using this method ?
Yes!
Map chart in ppt പറയാമോ
Sir ഞാൻ ഇത് ചെയ്തപ്പോൾ values-count of salay ആണ് display ആകുന്നത് sum of salary കൊടുക്കുമ്പോൾ answer 0 കാണിക്കുന്നു. ഒന്ന് സഹായിക്കാമോ
Please share your sheet to skills2succeed.alfan@gmail and whatsapp no too..
Hi brother, 'Show report filter page' is greyed, can u plz help?
Hello Brother, Have you tried adding a field from the PivotTable Field List to the Report Filter by dragging the field from the list to the report filter area?
@@rows_columns when i created pivot table, i hadn't given anything in 'filter'. Now dragged one column to filter and tried. Now it's ready. Anyway thank you very much... will keep on watching 🤝🤝🤝
😊
Hello, Pivot table nte coloumn wise totol varunnathu kalayan pattumo, phone number kittumo
Yes, just follow the below steps;
Click anywhere in the PivotTable to show the PivotTable Analyze and Design tabs.
Click Design > Grand Totals.
Pick the option you want: Off for Rows & Columns. On for Rows & Columns. On for Rows Only. On for Columns Only....
@@rows_columns thanks very much.......... ❤️❤️❤️
😊
Plz share the worksheet
Thanks for watching it Brother 😊 You can download complete worksheets from the google drive link which I recently provided in my community tab. Happy Learning 😊
Hellooo..Ea excel sheet onu send cheyth tharooo..
Ur mail Id please....
❤
How can we install new version of excel?
Hi.. Have you already brought the product from online? Or Yet to buy... ?
@@rows_columns can get cracked version 😬or how much will it cost
@basil bazi Lol...🙏😀 Bro.. If you are planning for business purpose, I suggest you to go for 2019 Home version.. I think It cost around 5999/- (Directly From MS site)
👍👍👍
Bro ithu onnu share cheyamo
Pls check description bro..
OMG
black shirt suits for you
Pls share the pivot table details in my email id if possible.. Thanks for your tutorial.. Very very informative
Sure Bro.. Pls share your mail id pls😊
@@rows_columns Hi Bro pls note my ID ananthakrishnn73@gmail.com. aiting for the next video ASAP. Pls post a video regarding mail merge if possible Thanks
👍✌️🤝
Dear sir,
helpful....
I send one question to your whatsapp, please reply
📌To Learn Microsoft Excel in English, Click on the Below Link:
th-cam.com/video/Cn3-bLDkGMY/w-d-xo.html
Great information. Thanks brother❤.
🤝