My top 5 uses for ChatGPT, from a daily user

I'm a total convert to ChatGPT. I’ve reached a point where I can’t imagine completing many tasks without it. On the best days, I feel like there are 3 or 4 of me. Perhaps more.

Tens of millions of people fit that description, but that still leaves many more millions who have either never used ChatGPT, or only dabbled with it without fully realising its potential.

In this email I’ll list the kinds of tasks where I’ve found ChatGPT to be game changing. Note that other capable AI assistants exist - and this list is almost certainly likely to be equally applicable to the likes of Claude, but I haven't used them to the extent that I have ChatGPT.

Copying and pasting vast text tracts, or uploading long documents (multiple of them if needed), and simply asking for a summary (providing a specific structure for that summary if desired) has saved me hours and hours both in my professional and job seeking life.

At 128,000 tokens, or around 85,000 words, the "context window" (the amount of content the AI can consider when drafting its response) is huge. To put that in perspective, that's longer than a typical novel.

As a recent job seeker, I'll give you a concrete practical example of this in action. I needed to review a lot of job specs every day. It's important to understand what each job actually is, what you'll be doing on a day to day basis, and what type of skills and experience successful applicants will have.

If you work in any sector where job titles are too ambiguous or weird to do this for you (recent highlights for me have been "ghost buster", "chief of staff" and "founders associate"), you have to rely on the spec. Unfortunately lots of recruiters and companies write incredibly long and not very well structured job specs, meaning a lot of work to read and parse these specs .

What to watch out for: Ask ChatGPT to include references to specific documents, pages or paragraphs to make it easy to fact check its summaries.

There are countless potential uses for a knowledge base but by way of example I'm going to extend the job seeking use case above. Having summarised a job spec via ChatGPT, what could be a more natural next step than working out if you're a good fit for the job, where you have gaps in necessary skills or experience, and which achievements in your career you could highlight for each of the requirements of the spec?

Here, the knowledge base is your CV, personal statement, LinkedIn profile or any other record of your skills, experience, career history and achievements. Now you’ll have shaved off a chunk of time in working out what the job entails and who they're looking for, but you're also already positioned to make a decision on whether to apply and what to include in a custom CV and cover letter.

Note for this application, you want a fresh one off chat with the basic ChatGPT or with a custom GPT - custom instructions won't cut it for a knowledge base this long and you don't want to use a single saved conversation as it will risk polluting the context window of the current job of interest with other job specs you have discussed before.

This works when you already have a good grounding in Excel or can at least describe the input and expected outputs.

My most common use of ChatGPT for Excel formulas is not to do things that I can't do, but to write lengthy formulas that I can do but can't be bothered to write out - those long nested formulas where there is a possibility of an error. The other day I had cause to iteratively xlookup values from about 15 columns to try and find a match, and writing or clicking that out manually is much slower than just saying "nest 15 xlookups, in turn looking up cells B2-P2 in column A and returning column D".

In a way, ChatGPT is like having a patient tutor, guiding me through the logic behind each function and formula step-by-step. And because it provides explanations, I’m not just copying and pasting; I’m actually learning why certain formulas work in certain ways. So it’s not only a time-saver but a learning tool.

I recommend standing instructions to have ChatGPT explain the formulas it's providing, which helps to catch the rare errors it makes and also makes the tool act as a tutor not just an assistant. An important side effect of this for me has been that I've learned a lot of formulas and functions that I wasn't aware of - or at least learned how to use them better. For example, in the last couple of weeks I've picked up or honed my use of the lookup function and formulas that output and handle arrays like unique and transpose.

What to watch out for: Sometimes the AI will take things too literally. For example, I once asked if there was a way to improve a formula so that I wasn't writing out the same xlookup twice, with the intention of finding something faster or more efficient. It found a solution of course, but the replacement was more complex to write and execute.

Actual developers and software engineers will want to explore dedicated AI coding tools (many of which are interfaces into GPT built specifically for the job), but for casual or occasional coding I’ve found ChatGPT to be incredibly useful.

I’m by no means a professional code, but I can get by pretty well. I can describe what I want, and read code well enough to usually understand what it's doing. For SQL, Python, PHP and other languages, I’ll often sketch out the logic I want in simple sentences, and ChatGPT generates code that does just that. While it’s not a substitute for knowing how to code, it’s an exceptional companion for building functions, fixing bugs, custom tools and more.

And it’s not just writing code from scratch; if I have a piece of code that’s behaving oddly, I can paste it into ChatGPT, explain the issue, and it’ll provide a modified and easily copied block of code to make it work or run more efficiently.

This only works well if you have a basic understanding of what the code should look like. Knowing a bit about the structure, syntax, and logic of the language you're working with is key – enough to follow what the code’s doing and spot if something seems off. With that in place, ChatGPT becomes an invaluable coding partner, speeding up development and making troubleshooting smoother. But like it's use as an Excel formula assistant, with explanations required as a standing instruction its also going to act as a tutor at the same time.

Suppose you have data in rows that need stacking into columns or vice versa, break down messy data formats or do a text to column operation where the separator is longer than 1 character or varies throughout the string.

Normally, I'd be writing Excel formulas, SQL or Python for the task – and that's still very much worth knowing and investing in long term. But for those quick jobs or when you’re on a tight timeline and don't need to build something repeatable, ChatGPT is incredibly helpful thanks to its built in ability to read and execute code on uploaded data. This isn't a case of having it write formulas or teach you how to do something, but just doing it and giving you back a reformatted and downloadable output.

I've not only been impressed by its ability to do the data prep, but also the brevity of explanation required. For the exercise of turning data in rows into columns, I used to write out in quite a lot of detail where I expected each bit of data to end up, but have now come to realise that a very short and objectively quite poor instruction suffices.

In practise, this means I can solve data formatting issues on the fly, with minimal disruption to my workflow.

While I don’t recommend skipping the fundamentals of tools like Excel and SQL (you’ll need them), ChatGPT’s efficiency is hard to ignore when it comes to one-off data wrangling.