profile

Leila Gharani - XelPlus

6 ChatGPT Tricks You Have to Know 🤖

Published 8 months ago • 4 min read

3 things we’re covering today:

  • A huge Copilot update
  • More Python news for Excel
  • How to send animated stickers on WhatsApp

🎬 6 Simple ChatGPT Tricks I Wish I’d Known Sooner

video preview

My latest video is all about how to use ChatGPT in smarter, more efficient ways!

Here’s a quick overview of each tip.

  1. Remember Me - Custom Instructions: Click on your profile picture inside ChatGPT and you’ll see an option for ‘custom instructions’. This lets you explain who you are, your preferences, and how you want ChatGPT to respond every time you ask a question in future. This saves you a lot of time in future interactions!
  2. Write Like You - Custom Writing Style: There’s also an option inside ChatGPT’s Custom Instructions called “How would you like ChatGPT to respond?”. There you can let ChatGPT know your preferred writing style by providing examples - making sure it sticks with your preferred tone and style.
  3. Self-Critique: Here’s a super-powerful tip. Ask ChatGPT to analyze and critique its own text output. This will almost always enhance the quality of responses. For example: “are there any logical flaws in your argument”, or “did you say this as concisely as possible?”
  4. Self-Prompting: Instruct ChatGPT to generate suitable prompts for specific tasks. This can save a lot of time, as you don’t have to think of the right questions to ask.
  5. Make it Crisp: Control the length of responses by setting word count limits, allowing for concise replies.
  6. Different Output Formats: Specify the desired output format for ChatGPT responses, such as tables, CSV, HTML, JSON, or others, to meet your specific needs.

📢 Unlock the Power of Summaries with Shortform AI

I love Shortform’s super-detailed book guides.

But now they're taking things to another level with the recent release of Shortform AI!

It’s game-changing browser extension that generates detailed summaries of blogs, articles, emails (and even YouTube videos) in a single click.

Add the extension to your browser, and you’ll be able to:

  • 🔍 Preview content before diving in
  • 🧠 Review key ideas from your favorite pieces of content
  • 🌎 Learn background context to understand the issues better
  • 📚 Understand counter-arguments to form a well-rounded opinion
  • 📈 Explore related ideas to supercharge your learning

Even better, Shortform AI is included with Shortform's premium service at no extra cost!

Sign up here for a free trial at http://shortform.com/leila. XelPlus Weekly readers also get 25% off the annual subscription - that’s equivalent to 3 free months!

Thank you to Shortform for sponsoring today's newsletter. 😊

🤓 Geeky News

✈️ Copilot - A Major Update from Microsoft

Microsoft made a series of announcements and outlined their vision for their AI companion tool Copilot on Thursday.

Copilot will begin rollout to Windows 11 starting September 26th 2023. It will be a part of every app (including paint, photos, etc), and will include over 150 new features!

Here are some of the key changes:

  1. AI Enhancements for Apps: Paint and Photos apps now incorporate AI features like background removal, layers, and background blur in Photos to improve digital creation and photo editing.
  2. Microsoft Shopping: Use pictures to find what you need, or use Bing chat to summarize reviews and best choices.
  3. Bing Search: Bing now remembers earlier conversations, so it can give you more personalized answers.
  4. Microsoft 365 Copilot: This will be your AI assistant at work and will be available for enterprise customers on November 1. It will help us with tasks across Microsoft 365 apps such as Word, Excel, PowerPoint, Outlook, Teams and more. It will include 365 Chat which can answer questions by combining information from the web as well as work data and personal user activity.
  5. New Outlook for Windows: The updated Outlook for Windows integrates multiple email accounts, including Gmail, Yahoo, and iCloud, into one app and offers intelligent tools for email composition and document attachment. “Sound like me”, for example, personalizes any email to your voice. You can use plugins to connect with different applications.
  6. Copilot Lab: This helps you get better at prompts by giving AI suggestions, and even letting you share good prompts with co-workers.
  7. Designer + Word: There’s now Designer app integration in Word, letting you bring AI-created images into your documents. Designer is powered by OpenAI’s DALL-E.
  8. Copilot in Excel: Microsoft also introduced Copilot support for Python in Excel combining the most exciting features of Excel and powerful analytics of Python. With Copilot you get to explain what you need in simple words and it will write the code for you: Here’s the video.

📊 Excel - Introducing the Python Editor from Excel Labs
Excel Labs has a new addition - Python Editor! It’s a dedicated code editor that lets you write and edit Python formulas in Excel!

It provides a dedicated code editor (similar to Python notebook environments), offering benefits like:

  • Viewing the flow of code execution
  • Support for longer sections of code
  • Standard Visual Studio Code features
  • Flexibility for intermittent coding workflows.

To access it, update the Excel Labs add-in or install it from the Add-ins Store, and then launch the Python Editor.

💚 My Favorite Things

🤪 Create Animated Stickers From Live Photos on Your iPhone
Want to torment your friends and family with animated stickers on WhatsApp?

Look no further than this fun Howtogeek article, which shows you how to take a Live Photo with your iPhone and send it as a sticker on WhatsApp:

  • Open a WhatsApp chat
  • Tap the plus sign (attachment button) in the bottom left
  • Press and hold a Live Photo and Choose "Select as GIF"
  • WhatsApp will preview the Live Photo as a GIF
  • Send!

🚀 Power Stories

I’m thrilled to have Veronica be a part of our XelPlus community!

Congratulations on completing our Automate with Power Query course Veronica. Sounds like amazing things lie ahead in your career!

Got a success story about using your XelPlus skills? I’d love to hear it! Hit reply to share the details, and inspire other students 😇

See you next week,

Leila

Want more?

▶️ Subscribe on YouTube

🖇️ Follow me on LinkedIn

🥇 Join 400,000+ students in our courses

📣 Want to sponsor XelPlus Weekly? Get in touch here.

This newsletter contains affiliate links, which give us a small commission on any purchase made at no cost to you. This helps us run XelPlus Weekly and bring you updates like this. Thank you for your support!

Leila Gharani - XelPlus

Helping you easily overcome data challenges with Excel & Power BI

XelPlus is a leading online education company, providing training courses for Excel, Power BI, Finance, and Google Sheets. XelPlus’ bestselling courses are popular among financial analysts, CFO’s, and business owners. Technology is changing fast. We help our members turn confusion into confidence with every skill learnt.

Read more from Leila Gharani - XelPlus

Thinking VLOOKUP is dead now that we have XLOOKUP? Think again. It's still used across thousands of spreadsheets. It has some limitations, but if you're aware of them and use it correctly, you'll get the job done quickly. Also, this edition of Between the Sheets includes: Power tools making a difference Better technical answers from ChatGPT Solution for tab hoarders If you were forwarded this message, you can get the free weekly email here. 🎬 Master VLOOKUP for effortless reporting In my...

5 days ago • 4 min read

Today, we're diving deeper into Excel's View tab to show you some lesser-known, yet incredibly handy features that will change the way you manage your workbooks. Also in focus: sharing views in Excel for the web AI writing assist in any online text box OneDrive offline capabilities If you were forwarded this message, you can get the free weekly email here. Master the Window options in Excel's View tab A while ago we covered the magic of Freeze Panes. But there are other buttons in the View...

12 days ago • 4 min read

We’re almost done with our New Excel Business Charts Course and it’s looking great! I'm currently reviewing the final videos. Meanwhile, the team is busy finalizing the cheat sheets, lesson notes, and quick guides. This morning, I reviewed the lecture "How to Pick the Right Chart". And wow! It took me right back to my corporate job, staring at the screen, wondering, "How on earth do I make this data tell a story?!". There was SO MUCH to show. Picking the right chart might seem easy, but...

about 1 month ago • 4 min read
Share this post