Video

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.

Nice! Is it possible to trigger the flow to run from a VBA macro?

Baby IIIII love youuu

Interesting…. How would you go about sending all 3 of your texts automatically?

My first thought on why I would want to consider doing texting in a " DIY" fashion would be for some reason like a security improvement. When I see this, what I see is that I'm giving my data to a SharePoint server and to a third-party app. All of a sudden my interest in DIY texting falls off. Having said that, it's really interesting that this is possible. I assumed it would be and it's interesting to see how. I've always had a hard time connecting the dots on doing zaps and things like that. This gets me a little closer in my mindset about doing things like zap's and interacting with third party apps.

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

I didn’t find anything advance with video, very basic, let’s start with get pivot and calculated fields

Cool. Thanks a lot, from Brazil