Wow. Color me impressed. I've been using Pivot Tables for quite a while, and I ignored a few of these functions. Thanks!

yes its not advandced options and not "tricks" just thé base

7:54 forgot to add chapter for adding comment with LET function.

Not able to download practice file even though subscribed

Watch in x1.5 speed :) But the tips are really good, thank you.

exactly what i needed, wished i had found this 12 months ago.

I'm really struggling to get two sets of survey data combined using pivot tables, please help!

why doesn't this work with dates?

Excellent

Wow! Amazing. I kept finding videos that required Power BI plugins or VB code. I was about to throw in the hotel. @how to excel for the win!

I'm here because of the 'Dilemma' music vid. lol

In All Commands, there does not appear to be a Select Objects command. There are quite a few Selects (All, Current Region, Elements, Labels, Visible Cells) but I cannot see the pointer like you can at 1:26. I have Microsoft Excel for Mac version 16 (2018). Help?

OH WOW. For years I have been looking for this kind of capability. It's not been publicized much. This is a fantastic tutorial, well organized, love the topic dividers and the pace and cursor guidance makes it easy to follow. Definitely one of my top tools and tips collection. THANK YOU!

How we can access api data into an excel having bearer token?

I would do, drag all cell, ctrl + g, select blank, push = to upper cell, hold ctrl and enter. Copy paste value if necessary

Hello how can I add attachment pdf

Dude… I thought I was good at excel 10 years ago… you are honestly on another level! 😮 The way this tool has changed with all its new functionality and features is beyond me now. Keep going and my recommendation would be to apply the logic learnt in programming languages. You are a machine. 💪🏻

Pivotby and Groupby are nice functions but not replacement of pivot tables .

Not available ...😢

Still function not available...

Respect

duuuuudeeeeeee...... this is eye opening to me.... i gonna try this now👍 Thanks👍 i hate pivot tables

I'm having a problem with this due to just opening and viewing the sheet counts as an edit, how do I get around this?

Is there a way to show a calendar on a datefield when there is no data on it?

Exactly the solution I needed. Thank you for this quick and easy video! Will definitely be subscribing and checking out your others. Great work!

I definitely loved it, impressive and amazing this saved me a lot of time....this is brilliant man, thank you

Thanks for sharing valuable videos........... I am trying to learn how to set up excel sheet to send email without opening it. The case is, I have several systems to be verified after a regular interval for their integrity. All systems are listed in an excel sheet and a condition formatting is applied to determine the due date for system integrity verification. Can we do it (I mean the email should be sent as a reminder to the concerned person on a due date without opening the excel sheet)? Thanks

How would I include my signature on these emails?

amazing, thanks from me that has problem in 2024

Wow!! This was a life saver. Thank you!!!

What is the problem if "insert filter" is grey, unable to click on it

Does this require excel 365 or something?, I don't have any stock option on excel 2021 (rich data type)

Very informative video. My Office 365 Excel still doesn't prompt the REGEX function. How can I activate it?

Check out my full courses and ebooks here: 👉 www.howtoexcel.org/courses/

thanks

I have 1000s of pdf like this with multiple invoice numbers. I need to extract this invoice numbers into the excel without opening any PDFs. Can you guide me what is the process?

Thank you! I was having a problem doing the, rename closed before saving reverting back to the default. My IT department simply said it was a “known [microsoft] issue”. I’ve been looking for a work around and the navigation option worked for me.

How to enable the power query window when it is completely greyed out in excel? Thanks

Glad I came across this video. Simple and effective. Great Tutor!

would be nice if the download actually worked. Requested hours ago and still haven't received any email.

Can dropdown lists from Excel be converted to PDF

you're a lifesaver :"" thank you very much!

Downloading example file does not work after filling my name and email in the dialog box.

Thanks for this information

I checked the "Add this data to the Data Module" when I created my pivot table. Now mine are set to count for some reason. On right click all of my 'summarize vales by' are greyed out. I have numbers in the cells, but I can't seem to change it. If I go to the value field like you did in the first example and try to change it, I get an error message - we can't summarize this field with average because it's not a supported calculation for text. But the cells are numbers. Do You have any idea how to correct this?

Perfect - thank you.

Superb stuff.

Very neat John, I can think of an immediate couple of uses for this in my work.

Check out my full courses and ebooks here: 👉 www.howtoexcel.org/courses/

The "groupby" function will do some of this.