Nabil Sir ... I couldn't believe my eyes that I could do it after watching your video step by step ... of course I made mistake and I cleared the macro and did once again ... thank you so much

Very nice. Explained in lucid way

Excellent Tutorial Sir! Great Effort. Thank you very much.

Great efforts as usual. Thanks.

@Officeinstructor

5 жыл бұрын

Thank you for the continuous encouragement متشكر جدا

Excellent tutorial my friend.Thank you so much

Very good tutorials every time! Thank you so much!

@Officeinstructor

5 жыл бұрын

Thank you... Glad you liked it

Cool Video Thank You Dr. Murad

@Officeinstructor

4 жыл бұрын

You are welcome my friend

Very good presentation

@Officeinstructor

5 жыл бұрын

Thank You

Great, Useful and helpful.

An excellent tutorial.. 🌟 🌟 🌟 Thanks a lot. 👍 🌟 🌟

@Officeinstructor

4 жыл бұрын

Thank you Salim

Nabil, thank you so much for the help but I would like to know how to make that macro but using a button in a another worksheet.

Very impressed by your high quality presentation. No stumbling over what to say, clear and concise steps and several excel tricks rolled together. You have a new subscriber for your efforts!

@Officeinstructor

4 жыл бұрын

What a nice comment... Subscribe to my blogsite to receive a Free copy of my text book"Pivot Tables from Zero to Hero"

mazing

Nice one

@Officeinstructor

2 жыл бұрын

Thank you

Hi thanks. Awesome

@Officeinstructor

5 жыл бұрын

Thank you

@yacniandou2753

5 жыл бұрын

Officeinstructor . Thanks. Looking for a simple way to drill down data in a dashboard worksheet based on 3 worksheets customers, invoices and payments. Kind of relationships in Excel

@Officeinstructor

5 жыл бұрын

Very easy to do in Power Pivot

My smiley is not in color when I added the same to the QAT ... any specific reason !!!!

Nabil , that’s amazing , could you please create food cost calculator , showing margin and cost % with a pie chart . That’s will be helpful.

@Officeinstructor

4 жыл бұрын

Thanks Samy. That's a good idea by the way which could lead us to much more topics. I kindly ask you to send me detailed raw data and requirements to think how I can build a project out of it. Check my company website for my contact information.

@samyraad5258

4 жыл бұрын

Officeinstructor appreciate the fast reply,i dont have any raw data in hands, but can be a simple example for food recipes, like tabouleh With drop down list for kg, grams exc. And to make it more attractive we will add reset button, tank you much and keep up the great lovely lessons . Samy

Good morning Nabil sir I am big fan of you.But my concern is try to publish your excel videos at least one video for a week sir.I am very much anxiously waiting Nabil sir.

@Officeinstructor

4 жыл бұрын

Thank You Venu Gopal for being a loyal fan... I will do my best to post more frequently... Stay Tuned. Nabil Mourad

Great tutorial. I got so much out of it! Do you have any idea why I get error's for my Macros if i use any kind of Pivot Table in them? I've followed every step you showed in this video but when running the macro I've just recorded I get error '424' or '5' and the Pivot Table doesn't look right.

A wonderful..Empty cells cause a problem in the Pivot Table and appear in print that I want to cancel or not show

100000 likes

@Officeinstructor

4 жыл бұрын

100,000,000 Thank You :)

How to creat buttons in sheet with this pivot table

@Officeinstructor

3 жыл бұрын

I created that in other videos

uhhhgggg.. the video was great but you didn't show me how to record the pivot chart :( my recording does not work :(

@Officeinstructor

5 жыл бұрын

Select any cell in the Pivot Table and hit Alt + F1