ChatGPT is greater than your personal assistant. It’s a tool that could make you super productive at work! Nonetheless, most of us only scratch the surface of what ChatGPT can truly offer.
In a recent article, I talked about some hidden gems I discovered while using ChatGPT on my on a regular basis life, but today I’ll show you ways I’ve been using ChatGPT to extend my productivity at work.
Let’s unlock the facility of ChatGPT on the office.
1. Use ChatGPT to automate your presentation and generate gorgeous Power Point slides
After I was graduating from university and on the point of submit my master’s thesis presentation, I felt quite overwhelmed. I needed to condense all the data from 95 pages right into a mere 10-minute presentation, which gave the impression of an inconceivable task. Each detail felt crucial.
Sadly, ChatGPT wasn’t available back then, so I needed to handle the whole lot by myself. But now, with ChatGPT I can generate the outline of my presentation and even generate gorgeous slides with VBA code (although I actually have zero coding knowledge).
Listed below are the steps I follow.
First, I write a plan specifying how much time the presentation should take and the predominant points to cover.
Then I receive a ready-made plan just like the one below.
Second, I let ChatGPT prepare each a part of the presentation using a prompt just like the one below.
Prompt: Write the content of the “Introduction” slide. It needs to be just one slide. Write down the keywords which shall be on the slide.
As you possibly can see I got some text that I could simply copy and paste into the presentation.
Finally, you possibly can make ChatGPT write VBA code to generate the Power Point slides. A video is price a thousand words so just follow the steps below to do it yourself.
2. Grow to be an Excel wizard using ChatGPT
I’ll make a confession immediately — I’m not an authority using Excel , but I learned quite a bit at work, which was quite difficult because I ended up doing many tasks manually, after I could have simply used Excel formulas.
But now, with ChatGPT things are simpler!
As an example, if I actually have a column with dates and I would like to put in writing the corresponding names of the times in the following column, I now know there’s a formula for that due to ChatGPT (yeah I’m a newbie in terms of Excel).
I described ChatGPT the formula I used to be searching for, and here’s what I got.
Then we only must test out what ChatGPT suggests.
I’ve got my data in the primary column, so I just have to copy the formula over to the column on the appropriate and click on Ctrl + 1.
We’re done!
Here’s one other example. I would like a barcode for all my items. I asked ChatGPT the way it could possibly be done. And here’s the reply I got.
Let’s follow the steps.
As soon as I actually have the ID for all my products and the CODE128 barcode font downloaded into Excel, I can begin generating the barcodes.
Now, all I actually have to do is select the text and alter the font style to the CODE128 barcode font. As soon as I modify the font style, the text shall be converted right into a barcode.
Pretty cool, isn’t it? Now you might have your individual Excel assistant!
Now, these were easy examples, but in this text, you possibly can see more advanced Excel formulas that ChatGPT can create for you.
3. Grow to be an “artist” with ChatGPT and Midjourney
ChatGPT and Midjourney complement one another perfectly.
ChatGPT excels at understanding and refining your request, while Midjourney is designed to bring that vision to life with stunning visual projections. Together, they create an ideal duo, ensuring your ideas and preferences are translated into a powerful end result.
Here’s an example.
Prompt for ChatGPT: “Create a prompt for Midjourney where shall be only black, green, and gold colours. It needs to be a design of a front room”
And here is the Midjourney prompt I got
A visually striking front room design, featuring a color scheme predominantly composed of black, green, and gold. This design should embody the brand’s aesthetic while providing a cushty and welcoming space for rest and socializing. Incorporate elements that showcase elegance, modernity and a touch of luxury.
Let’s try the prompt in Midjourney.
It turned out perfect! That’s what I used to be searching for.
For advanced examples of the best way to use ChatGPT and Midjourney to generate amazing AI images, check this text.
4. Use ChatGPT to turn out to be a self-taught employee
When we have now the identical job title for a very long time, plainly we don’t learn as much as we used to do in day 1.
As an alternative of searching for a latest job you should utilize ChatGPT to create a study plan to coach yourself and proceed growing professionally. You possibly can create a plan for virtually anything you’d like to check!
From writing to programming, ChatGPT can make it easier to create a study plan based on the time you might have available every day.
Personally, I used ChatGPT to create a language learning plan to learn German on the A2 level specifying my time available for studying and it provided day by day study topics and good recommendations.
5. Use ChatGPT to give you gift ideas in your coworkers
Sometimes it could be an actual headache to give you the right holiday gift, especially in case you’re trying to seek out something for people you don’t know well. You possibly can at all times use Google but its suggestions are often pretty generic.
ChatGPT is different. Often, I spill all the small print in regards to the person I’m purchasing for resembling their relationship to me, how old they’re, what they’re into, what you’ve given them before, your budget, and even the country where you propose to purchase the gift.
Let’s say, I’d prefer to buy a present for my 34-year-old coworker in Austria. He’s into video games and scouting (within the forest or mountains). I’ve got a budget of 100 euros.
Google didn’t bring the assistance I needed, so I toss all these ideas to ChatGPT, and voila! It comes up with personalized gift ideas based on my coworker’s interests and my spending limit.
Listed below are some suggestions it got here up with:
- Portable Hammock: Perfect for chillaxing outdoors or on scouting adventures.
- Outdoor Survival Kit: A practical and exciting gift for his outdoor escapades.
- Nature Field Guide: Helps him explore and learn more in regards to the great outdoors.
- Gaming Gift Card: Let him select and download his favorite games.
- Outdoor Activity Book: Full of fun challenges for his scouting adventures.
- Portable Power Bank: Keeps his devices charged up on the go. Exactly what he needs together with his infinite video games 🙂
I’m already considering buying a few them!