Regardless of its shortcomings, ChatGPT is definitely top-of-the-line AI instruments available on the market. It is all the time prepared so that you can ask it one thing, and it just about all the time has the precise reply. Nevertheless, simply because utilizing ChatGPT is simple does not imply it is also the very best or the quickest device for the job.
It won’t sound very intuitive, however there are situations in my workflows the place Excel is definitely the higher (and sooner) device than ChatGPT. It is not that ChatGPT cannot do the duty at hand; it is simply that by the point I’ve typed a immediate, pressed enter, and obtained a response, Excel has already finished it, a number of instances over. ChatGPT may help you recover from your spreadsheet fears, however it could’t fairly substitute Excel but.
Associated
Excel’s greatest shortcut has nothing to do with the keyboard — it is this field
Excel made issues simpler, I simply by no means seen.
Pivot tables nonetheless do the heavy lifting
Immediately summarize knowledge with out overthinking it
Screenshot by Yadullah Abidi | No Attribution Required.
If it’s good to examine numbers to see efficiency or a development, Excel is by far the simplest means to take action. For instance, when you have a sheet with 2,000 rows — product names, areas, dates, and income, and also you wish to discover out which area carried out the very best over the past quarter, simply spotlight the information, insert a PivotTable, set the area as row and income as worth, and also you’re finished. You get an instantaneous, interactive, and visible consequence proper inside the file you had been already utilizing.
Doing that in ChatGPT is a little bit of a problem. You must write a immediate that describes what you need whereas explaining the file’s knowledge to ChatGPT, which can already take longer than an Excel PivotTable. When ChatGPT is finished processing your file, you do not have lots of management over how the information will come out. You will possible get a static desk or a code snippet, after which work out what to do with it. Apart from, for those who needed to match the information in another way, you’d should repeat the complete course of.
Conditional formatting beats explanations
See patterns immediately as a substitute of asking for them
Conditional formatting may really feel like including pointless flash to in any other case excellent knowledge. Nevertheless, when you begin utilizing it proper, it’s going to prevent squinting at your spreadsheets for hours.
For example you’ve a job tracker sheet with 100 duties and their due dates. Determining which job is due when shall be a nightmare, contemplating that
all textual content seems to be equivalent when not formatted in an Excel spreadsheet. Your greatest guess for rapidly telling duties aside is to make use of conditional formatting in Excel to create three guidelines utilizing the TODAY() perform. Something due at the moment turns yellow, something overdue turns crimson, and upcoming duties are highlighted in inexperienced. When you’re finished, your sheet will robotically spotlight duties, serving to you see what you want visually at a look.
ChatGPT merely cannot do the identical. It will possibly inform you methods to arrange conditional formatting. You possibly can copy the paragraph above, paste it in ChatGPT, give it the sheet you are working with, and you will get step-by-step directions on methods to do the identical. You would ask it to generate a script that applies these conditional formatting guidelines to your knowledge. In that case, you will be working with Python in Excel, downloading the script, and operating it each time it’s good to make a change. To not point out, this may solely work in case your Excel set up helps Python.
Flash Fill appears like magic
Clear and remodel knowledge in seconds, no formulation wanted
Yadullah Abidi / MakeUseOf
Excel is nice at detecting knowledge patterns and replicating them throughout your spreadsheet to avoid wasting you’re employed. Say you’ve a column filled with full names, and also you need the primary names within the subsequent column. You kind the primary identify of your topmost entry, hit Ctrl + E, and Excel will fill the complete column primarily based on the sample it simply inferred. No formulation, immediate, or rationalization required.
Doing this job in ChatGPT, as soon as once more, requires describing the sample, together with a knowledge pattern, after which ready for a formulation or Python snippet. And that is earlier than you have pressed a single key in Excel, as a result of bear in mind, ChatGPT cannot do this for you. By comparability, Flash Fill is embarrassingly quick. Whether or not you are separating dates from timestamps, breaking codes aside, or the rest, Excel handles them and not using a single immediate.
Macros prevent from repetition
Automate as soon as — cease doing the identical job endlessly
Yadullah Abidi / MakeUseOf
Not solely can Excel carry out duties extremely rapidly, however it could additionally automate repetitive duties for you. For sure duties, particularly ones that require a selected sequence of actions, Excel macros can substitute formulation.
For instance, for those who do the identical sequence of duties on a spreadsheet each week, like opening the file, pasting new knowledge, formatting the header, making use of a formulation, and exporting, Excel’s Macro Recorder can document and retailer the complete sequence to robotically run while you press your shortcut key of selection.
Associated
I picked up fundamental VBA scripting and Excel immediately obtained significantly better
I attempted fundamental VBA and immediately reduce down repetitive work in Excel.
ChatGPT cannot run inside Excel, which means it merely cannot replicate this characteristic. It will possibly write a macro for you in VBA code, which you’ll then run in Excel. Nevertheless, ChatGPT hardly ever will get it proper in a single immediate, which means you will be going forwards and backwards between Excel and ChatGPT to debug your script.
AI isn’t the reply to every part
None of this implies ChatGPT is dangerous at spreadsheet-related duties. It is genuinely glorious at writing VBA from scratch, debugging formulation logic, and even for producing nested IF statements you’d spend minutes writing in seconds. ChatGPT with Excel is smart as a information that tells you methods to use Excel’s many native instruments and options to their greatest capability, and which options are greatest for what it’s good to do.
So the reply is not to turn out to be an Excel purist. It is to cease reaching for ChatGPT out of behavior, particularly when Excel has a sooner and simpler means of fixing that drawback.
OS
Home windows, macOS
Supported Desktop Browsers
All by way of internet app
Developer(s)
Microsoft
Free trial
One month
