ChatGPT For Excel: Tips & Tricks to 10X Your Productivity

Today, we're going to explore ways you can leverage ChatGPT to transform the way you work with Excel. Imagine having formulas effortlessly crafted for you and uncovering shortcuts to make everything simpler.

LEARN MORE
===========

🔔 SUBSCRIBE if you’d like more tips and tutorials like this.

📢 Please leave me a COMMENT. I read them all!


🎁 SHARE this video and spread the Excel love.

Or if you’re short of time, please click the 👍

#ChatGPT #Excel #ExcelTips

[MyOnlineTrainingHub]

❓What's the one Excel task or formula that always seems to stump you?

[roshannair]

Index match always stumps me. It seems simple, but I always find myself watching videos or reading about it

[chrism]

Great video Mynda! I've started to use ChatGPT several times when I get stuck with a formula, and also in DAX.

[piterqantropus]

Amazing Mynda, thanks for all your content!

[elecirlisboa]

Excelente vídeo Mynda! Parabéns, vou incluir no ChatGPT no meu dia a dia! ☺

[alxj]

Using the same for power query Mynda, in these busy days it's helped make it more accessible to update values easily in the query editor and 'how to tricks'

[johnkasongo]

Index & match always stump me!!!!😔!!! Fantastic tutorial Mynda!

[Windex]

My top formula issues tend to be dynamic hyperlinks (don't use them enough and keep forgetting), long IF...SUBSTITUTE chains, working with dates in array formulas and LAMBDAs.

[windyrainStorm]

Can you please make videos about REDUCE function and the use of MAP and FILTER

[Acheiropoietos]

Did you speed up the ChatGPT responses Mynda? Mine are always so slow. Great post, as ever. 👍

[NeshaStanic]

ChatGPT 3.5 o4 4.0 or Copilot or Bard?
BTW, my stumps are:
- comparing different tables with similar data to find differences
- not able to import data from tables from various web sources, just won't import (mainly ones with daily currencies etc
- creating centralized data table out of very complex business, so that various reports are created, and sharing it with various parties, connecting with SharePoint data, Outlook...
All in on 365 platform, company wise.

[paulbriggs]

my tough one, have not solved it yet, is to have a sortfilter command that is looking at a table and it outputs a list. Then I want to put another sortfilter under that output to create another output area. If I leave one or 2 blank rows it works, then if I add more data to the original table to increase the length of the output, I get spill as there is not enough room for the top one to output before running into the second output. Was thinking it would be cool to have the distance between the 2 outputs expand based on the data size.

[mikaelrundberg]

I use the excel sheets to make test or certificate documents and use "Rows to repeat at top". But the only way to get page numbers on each page is in headers/footer, i can't find a way to get it in to a cell in the part of "Rows to repeat at top" area that i picked.

[Talon]

I have a desktop computer that's not connected to the net for security reasons. If I want to bring my excel version up to date since it has windows 7 on it now. Is there a way to get the new version as a one time down lode file I can transfer to my computer?

[mathijs]

Not updating VBA is a mistake of MS.
Excel online wont match excel desktop.
Why use office script?

[youranonymousfriend]

If I have a data in cell A1 to A10 and I want to paste it into filtered table. Suppose there is a filter applied and it hides say row 2 then 5 then 13 randomly so i want to skip them hidden rows while pasting. So my A1 goes to row 1 A2 goes to row 3 and A4 goes to row 6.

[jtnjkoz]

Trying to determine employee headcount by month using start dates and termination dates is a hassle. For me, it involves nexted IF statements that include AND and OR combinations to account for all the possible scenarios (e.g., an employee starts and leaves in the same month, starts partway through the month, etc.).

[IamTheReaper]

Hmm, I'm still on the fence with ChatGP, but it's definitely something to think about 😎

[CVH]

With let and lambda you can do apportionment with a single formula

[miguelangelponce]

Hi yMnda I can't download the workfile, would you please resend it?