Connect with us

Tools

Revolutionise Your Spreadsheets: 5 Ways to Up Your Excel Game with Microsoft Copilot

Learn how to leverage Microsoft Copilot to enhance your Excel skills and streamline your workflow with AI-powered features.

Published

on

Excel

TL;DR:

  • Microsoft Copilot simplifies complex Excel tasks, making it easier for users to generate insights, formulas, and formatting.
  • Copilot is available on desktop versions of Excel with a Microsoft 365 subscription and a Copilot Pro subscription.
  • Key features include generating data insights, suggesting formula columns, applying colour and formatting, understanding your database, and tidying up messy data.

Are you tired of navigating complex formulas, endless data cleaning, and time-consuming formatting in Excel? Microsoft’s AI-powered Copilot assistant is here to transform your spreadsheet experience. From generating formulas to highlighting interesting data, Copilot empowers you to work smarter, not harder. Let’s dive into the most cutting-edge methods to leverage Copilot’s features and elevate your Excel game to the next level.

Why Copilot Matters for Spreadsheet Users

Copilot acts as your personal assistant in Excel, understanding your spreadsheets just like you do. It can suggest formulas, reply to your questions, and even help you do more with specific cells. For example, if you’re dealing with a monthly expense database, simply ask Copilot to calculate things and make a chart based on the data.

Copilot doesn’t perform magic; it accomplishes the same tasks you could with advanced Excel features and functions. The main advantage is that you don’t need to dig into Excel menus and can use a single interface to get the job done. This is a boon for new Excel users who are less familiar with writing formulas.

Accessing Copilot in Microsoft Excel

First, note that Copilot in Microsoft Excel is available only on desktop versions. You can’t access it on the Excel web version. Excel’s desktop apps require a Microsoft 365 subscription, starting at $7 per month for Microsoft 365 for Home.

Once you download Excel on Windows or Mac, you need to purchase a Copilot Pro subscription to unlock access to the AI bot in Office apps, including Excel. It is priced at $20 per month.

Advertisement

Now, you can launch Microsoft Excel on Windows or Mac and find the Copilot button under the Home menu at the top. Let’s check out some of its capabilities in action.

Get Insights from Your Data

Thanks to a neat Copilot integration in Excel, you can easily generate valuable insights from a database. Let’s start with an example.

  1. Open an Excel sheet with a database and click the Copilot icon in the top-right menu.
  2. Simply ask Copilot to show data insights.
  3. The AI chatbot can quickly analyze the data and create a small pivot chart to display the number of units sold by each salesperson.
  4. Copilot also shares a small summary of the data in text format.

Without Copilot, you would have to convert the database into a table and generate pivot tables in a different sheet to extract the same data. Copilot does the same job with only a simple text prompt.

Similarly, you can ask, “How many units did Jim sell?” and the system should calculate and display the final data with a pivot table. You can even get specific with your requests. For example, you can ask, “Which month did Jim sell the most units?” and get relevant answers in no time.

Generate Suggestions for a Formula Column

Based on your current database, Microsoft Copilot can also suggest a formula column and let you insert one with a single click. Let’s continue with the same example.

  1. Open the Excel sheet and ask Copilot to “Show a suggestion for a formula column.”
  2. Excel calculates the total sales by removing the dollar sign from the sales amount and multiplying it by the number of units sold. It even shows the required function in case you’d like to use or adapt it for another column.
  3. You can glance over the top five results and click “Insert column” for whichever suggestion(s) you would like to utilise.

In the example above, Excel generated a formula column randomly. You can even be specific with your requests. When I asked, “Combine salesperson and region and create another column,” Excel quickly created a formula and showed a column preview.

The possibilities are endless here. It all depends on your use case, database, and text prompts. You should be as descriptive as possible with your prompts to get the desired results in no time.

Advertisement

Apply Colour and Formatting

This is another time-saving hack for Copilot users in Excel. When you are looking for specific data or a product, fire up Copilot and ask it to highlight relevant cells.

  1. I opened the same Excel sheet.
  2. I summoned Microsoft Copilot and asked it to highlight all cells with “XPS 14.”
  3. It showed a suggestion and a preview. By clicking “Apply,” we can see the formatting in action.

You can also ask for “Total ‘Units Sold’ for ‘Profit’ excluding ‘$6000′” and get the final results. Just click “Apply,” and you will instantaneously have the information you requested via chat.

Understand Your Database

Microsoft has smartly integrated Copilot into your databases. You can just select columns and use the Copilot shortcut to highlight data or generate charts in real time. Let’s continue with the same example.

  1. Open an Excel sheet. Let’s select the columns for salesperson and units sold.
  2. Click the Copilot button, slide to “Chart,” and create a quick graph that shows the total number of sales by each employee.

You can also slide to the “Tables” menu and check some of the ready-to-use pivot tables.

Copilot changes suggestions based on the data you select in Excel. It can be a huge productivity booster for professionals who frequently deal with large databases.

Other Copilot Capabilities in Excel

Copilot efficiently tidies up messy data by removing extra spaces, merging values from different columns, highlighting duplicates, and applying sorting and filtering.

As you can see from the screenshots above, it also suggests recommendations for formulas, functions, and actions based on your context.

Advertisement

Programmers can even go a step ahead and ask Copilot to write VBA code to automate command tasks in Excel.

Excel on Autopilot

Overall, if you are a power Excel user, Copilot is definitely worth your while to take for a test drive. It can automate your tedious tasks, help you uncover insights hidden within your data, and streamline your workflow in minutes. What are you waiting for? Explore Copilot, use the tricks above, and turn your Excel experience from a chore into a breeze.

Aside from Excel, your active Copilot plan unlocks the AI assistant on other Microsoft 365 apps, including OneNote. Check out our separate post to find the top tricks for using Copilot in Microsoft’s note-taking app.

Comment and Share:

What’s your favourite Copilot feature in Excel? Share your experiences and thoughts on how AI is transforming your workflow. Don’t forget to subscribe for updates on AI and AGI developments and comment below!

You may also like:

Advertisement

Author


Discover more from AIinASIA

Subscribe to get the latest posts sent to your email.

Continue Reading
Advertisement
Click to comment

Leave a Reply

Your email address will not be published. Required fields are marked *

Learning

Beginner’s Guide to Using Sora AI Video

This friendly guide covers features and tips to help you transform simple text prompts into visually stunning videos while using Sora AI.

Published

on

Using Sora AI

Hello, lovely readers! If you’ve ever dreamt of creating lively, imaginative videos straight from simple text prompts, then Sora AI is about to become your new best friend. Developed by OpenAI, the Sora AI text-to-video generator lets you transform words into dynamic video content. But before you dive in, there are a few tricks of the trade that’ll help you get the most out of this cutting-edge tool.


Table of Contents

  1. What Is Sora AI?
  2. Getting Started with Sora AI
  3. Crafting Effective Prompts
  4. Advanced Features of Sora AI
  5. Limitations of Sora AI
  6. Key Differences: Original Sora vs. Sora Turbo
  7. Incorporating Personal Assets
  8. General Guidelines for All Prompts
  9. Category-Specific Tips
  10. Prompt Refinement Checklist
  11. Real-World Applications of Sora AI
  12. Conclusion & Next Steps

What Is Sora AI?

Picture this: a magical AI tool that can generate videos from simple text descriptions, courtesy of OpenAI. Much like text-to-image generators (e.g., DALL·E or MidJourney), Sora AI uses a diffusion model to take your prompt—something like “A cat playing the piano on a moonlit rooftop”—and transform it into a short video clip.

  • Creative Storytelling: Sora excels at conjuring cinematic or whimsical visuals.
  • Cinematic Effects: You can try out film noir, 3D animation, or even a painterly vibe.
  • Animation of Still Images: Animate a static photo (say, your favourite landmark) and watch it come to life!

Do keep in mind that Sora does have its quirks:

  • Human Imagery Restrictions: They’re quite cautious about privacy and ethics.
  • Occasional Inconsistencies: Some videos end up looking a bit wonky—think odd proportions or peculiar motion.

Getting Started with Sora AI

1. Accessing Sora

  1. Head over to Sora’s official website and sign in with your OpenAI login.
  2. If you’re in a region where Sora’s not yet available, a VPN might come in handy.
  3. Choose your plan: free or paid subscription. Premium users enjoy higher resolutions and longer clips.

2. Familiarising Yourself with the Interface

  • Prompting Window: The space where you type your imaginative descriptions.
  • Storyboard: A timeline-like tool for building multi-scene videos.
  • Blend Editor: Lets you merge and transition between multiple clips.
  • Remix Tool: Tweak or reinterpret older videos with fresh prompts.

3. Setting Up Video Parameters

  • Aspect Ratio: 16:9 for widescreen, 1:1 for social media squares—take your pick!
  • Resolution: Going for 1080p uses more credits but looks crisp.
  • Video Length: Some plans allow up to 60 seconds.

Crafting Effective Prompts

A brilliant video is only as good as the prompt you feed Sora. Here’s what works:

  1. Use Clear and Concise Language
    • Avoid baffling jargon.
    • Example: “A futuristic cityscape at night with glowing neon signs, flying cars, and a robotic figure on a rooftop.”
  1. Incorporate Visual Styles
    • You can say “watercolour,” “stop motion,” “film noir”—Sora will adapt.
    • Example: “A black-and-white film noir scene of a detective under a flickering streetlight in the pouring rain.”
  1. Add Camera Techniques
    • Want slow motion or a panoramic sweep? Just mention it.
    • Example: “A slow-motion close-up of a flower blooming in a sunny meadow.”
  • Set the Mood
    • Describe lighting, weather, and emotional vibes to guide the model.
    • Example: “A cosy living room at dusk, with warm lighting and light rain tapping on the window.”


Advanced Features of Sora AI

Sora AI comes packed with a few extra goodies:

  1. Storyboard Tool
    • Perfect for plotting a mini-film. Arrange scenes before generating.
  2. Blend Editor
    • Seamlessly merge multiple video segments.
  3. Remix Existing Videos
    • Revisit or alter older clips with new prompts or styles.
  4. Looping Content
    • Create endless loops for social media or eye-catching GIFs.
  5. Image-to-Video Conversion
    • Turn static images into snazzy animated clips.
  6. Video Extension
    • Add extra frames to lengthen an existing clip.
  7. Text-, Image-, and Video-to-Video Inputs (Sora Turbo)
    • More ways to feed Sora your creative ideas.
  8. Remix, Re-Cut, and Blend Tools
    • Remix: Swap or update elements in an already-generated clip.
    • Re-Cut: Fine-tune specific parts of the video.
    • Blend: Melt different objects or scenes together for unique transitions.

Limitations of Sora AI

Like any AI tool, Sora isn’t perfect. Here are the main caveats:

  1. Physical Accuracy
    • Expect the occasional floating chair or bizarre object movement.
  2. Continuity and Object Permanence
    • Longer sequences can sometimes have items popping in and out randomly.
  3. Video Duration Caps
    • Even if you pay for Pro, you might be limited to under 60 seconds.
  4. Resolution Constraints
    • 1080p is your limit for now.
  5. Performance and Queue Times
    • At peak hours, you may find yourself twiddling your thumbs while Sora processes.
  6. Ethical & Moderation Limits
    • You’ll be stopped if you try to generate something too controversial or featuring humans.
  7. Lack of Fine-Grained Control
    • Beyond your text prompt, micromanaging details is tricky.

Key Differences: Original Sora vs. Sora Turbo

There’s the original Sora and the shiny upgraded version, Sora Turbo. Here’s a quick rundown:

  1. Speed and Efficiency
    • Sora Turbo is a proper sprinter, generating multiple clips at once.
  2. Video Quality and Duration
    • Original Sora could handle up to 1 minute, whereas Turbo caps each clip at about 20 seconds (though you can merge them later).
  3. New Features and Customisation
    • Tools like Remix, Re-Cut, Loop, and a fancier Storyboard.
  4. Input Methods
    • Turbo accepts text, images, and even video-to-video prompts.
  5. Accessibility
    • Both are available if you’re on OpenAI Plus or Pro, but usage limits differ.

Incorporating Personal Assets

Want to insert your own pictures or short clips? No problem:

  1. Media Upload
    • Upload images or mini videos by clicking the “+” or “Upload” button.
  2. Customisation
    • Blend your media with AI-generated visuals, or add transitions and visual effects.
  3. Privacy Settings
    • If you don’t fancy sharing your personal content, just disable “Publish to Explore”.

General Guidelines for All Prompts

  1. Brevity: Keep it under 120 words—short and sweet!
  2. Specificity: Focus on one or two main ideas.
  3. Imagery: Paint a clear mental picture for the AI.
  4. Avoid Sensitive Content: Don’t poke the moderation bear.
  5. Build Complexity Slowly: If you want something intricate, iterate step by step.

Category-Specific Tips

  1. Sequence Prompts
    • Works: Clear transitions or progressions (e.g., “A knight travelling across a desert, discovering a hidden oasis”).
  1. Doesn’t Work: Muddled, overly abstract sequences.
  2. Example: “An epic duel between a Balrog and a Paladin Platypus in a desert world.”
  1. Human-Focused Prompts
    • Works: Humorous or relatable actions (e.g., “A mime crossing a marathon finish line”).
  1. Doesn’t Work: Anything too philosophical or jam-packed with details.
  2. Example: “A man strolling through a snowstorm, wearing a helmet made of raw meat.”
  1. Animal-Focused Prompts
    • Works: Fun, vibrant scenarios (e.g., “Cats dressed as wizards facing camera and casting spells”).
  1. Doesn’t Work: Animals performing too many abstract or contradictory actions at once.
  2. Example: “A sabre-toothed tiger padding along a glowing riverbank in a prehistoric forest.”

  1. Figure-Focused Prompts
    • Works: Distinctive, stylised scenes (e.g., “A weathered robot scavenging in an abandoned city”).
  1. Doesn’t Work: Mashing too many cultural icons into a single prompt.
  2. Example: “A superhero cameo reminiscent of anime, delivering a massive punch that shakes the earth.”
  1. Location-Focused Prompts
    • Works: Captivating environmental descriptions (e.g., “Drone footage of ancient tribes on a mountain at sunset”).
  1. Doesn’t Work: Overdoing the details so that the setting becomes cluttered.
  2. Example: “A neon-drenched cityscape welcoming the year 2078, fireworks included.”


Prompt Refinement Checklist

  1. Clarity: Is your description straightforward and easy to follow?
  2. Engagement: Does your prompt conjure a strong mental image or storyline?
  3. Focus: Avoid cramming 10 different big ideas into one prompt.
  4. Tone: Pick a vibe—playful, cinematic, dramatic—and stick to it.
  5. Content Sensitivity: Steer clear of copyrighted figures or explicit subject matter.

Real-World Applications of Sora AI

  • Social Media: Short, snappy clips for Instagram, TikTok, or YouTube Shorts.
  • Storytelling: Quick teasers or imaginative sketches for your next big idea.
  • Education: Bring tutorials or lessons to life with short explainers.
  • Marketing: Spice up ad campaigns with unique, AI-generated flair.

Conclusion & Next Steps

All in all, Sora AI is a splendid tool for spinning text into visual gold—especially if you love creative, short-form storytelling. It’s not flawless, mind you: longer or more complex prompts can trip it up. But as a starting point for playful, cinematic, or downright quirky videos, it’s in a league of its own.

For a more professional setting—like detailed brand adverts or longer educational videos—Sora might need a bit more polish to handle intricacy. Still, it’s well worth a try if you’re eager to push the boundaries of AI-generated content.

Happy creating, folks!

Disclaimer: This guide blends community wisdom and publicly available resources. Use at your own discretion, and have fun exploring the wild world of Sora AI!

Advertisement

You may also like:

Author


Discover more from AIinASIA

Subscribe to get the latest posts sent to your email.

Continue Reading

Tools

Google’s New AI Search Mode—An Early Sneak Peek

Discover how Google’s new AI Mode, tested internally, aims to revolutionise search results for more open-ended queries. Learn about its features, powered by Gemini 2.0, and how it might change your online search experience.

Published

on

Google’s New AI Search Mode

TL;DR – What You Need to Know in 30 Seconds

  • Google is internally testing a new “AI Mode” in Search, powered by a custom version of Gemini 2.0.
  • This new mode is aimed at more open-ended, exploratory queries like advice and product comparisons.
  • The user interface is still in its early stages but features a conversational layout with AI-generated answers.
  • Currently only tested by Google employees in the US, with a possible launch as early as this year.
  • It points towards a more interactive, voice-friendly Search experience for users worldwide.

Google’s New AI Search Mode—What Do We Know Already?

Today, we’ve got a fascinating look at Google’s latest internal experiment with Search: a brand-new “AI Mode.” Don’t worry, it’s not a corny sci-fi flick—it’s Google’s first big step towards taking its already impressive Search capabilities to new heights.

If you’ve been following Google’s AI journey, you’ll know it’s been experimenting like mad lately. The search giant is clearly keen to outdo itself, especially given the fierce competition in the AI space. Let’s dive into this new “AI Mode,” see what it’s all about, and have a good old natter about why it might just change the way we find and digest information.

A Brief Overview

  • What is AI Mode?
    It’s a newly tested feature in Google Search, powered by a custom version of Gemini 2.0, designed to handle open-ended and exploratory queries more effectively. Rather than giving you a list of links, it provides breakdowns of information plus prompts to dig deeper.
  • Why now?
    It’s Google’s push to see if there’s a demand for a more conversational, AI-driven approach. Traditional Search does the job fine for most queries, but those bigger “advice” or “comparison” style questions haven’t always been served as well.
  • What’s in it for you?
    You can ask something like, “How many boxes of pasta do I need for a family party?” or “Which jacket material is best for cold, rainy winters in Asia?” and you’ll get an overview that’s more helpful than a standard list of links.

Powered by Gemini 2.0

We’ve heard loads of chatter about Google’s Gemini recently. It’s a powerful large language model that’s meant to be a big leap forward from previous AI systems. This “custom version” in AI Mode apparently brings advanced reasoning and thinking capabilities directly into your search bar. While that might sound like jargon to some, the bottom line is it should be more accurate and context-aware when dealing with follow-up questions.

An Early Look at the Interface

At the moment, a small group of Google employees in the US are testing this new interface. It’s a bit of a hybrid between the standard Search page and a chatbot. You’ll still see the query at the top, but instead of 10 blue links, you get a more elaborate AI-driven response. Meanwhile, there’s a card on the right (or somewhere in that ballpark) with links if you want to dive deeper.

Although the design is in its early stages, it’s clearly part of Google’s broader plan to offer a more interactive and informative search experience. And for all the mobile fans out there, yes—it’s designed to work on your phone, with voice input on Android and iOS. Handy if you’re on the go!

Why This Matters

So, why should you care? Whether you’re a business owner in Singapore researching the best marketing strategies, a student in Seoul comparing study-abroad programmes, or simply a curious netizen in Bangkok looking for aquascaping supplies, the new AI Mode could make your life a lot easier. Instead of sifting through link after link, you can get structured info right away, plus relevant links all in one place. It’s a bit like having your own dedicated research assistant.

Advertisement

Well, at the moment, only Googlers in the US have access. Google CEO Sundar Pichai hinted that 2025 will be “one of the biggest years for Search innovation yet,” so we can’t guarantee an exact date, but it’s possible we’ll see a broader roll-out sometime this year. Keep an eye on AIinASIA for further updates, as we’ll keep you posted the second we get word.

Final Thoughts on Open-ended Queries

From classic web-search to voice-search and now AI-driven results, Google is clearly on a mission to streamline how we discover and digest information. This new AI Mode, powered by Gemini 2.0, appears to be a significant step forward in making Search even more conversational and context-aware.

For those of us in Asia, this can’t come soon enough. Imagine exploring local cuisines, planning trips, or learning new skills with AI Mode’s helpful breakdowns at your fingertips. The future of Search looks just a little bit brighter—and a lot more AI-driven.

That’s all for now, folks. Thanks for stopping by AIinASIA! As always, don’t forget to drop your thoughts below. We’d love to hear if you’re excited for Google’s new AI Mode, or if you’re a bit sceptical about AI chatbots changing the way we search.

Stay updated with AIinASIA for the latest on Google’s AI developments and everything else that’s hot in the world of artificial intelligence. If you liked this piece, do give it a share—and if you didn’t, share it anyway to let your mates know what’s coming next in the AI realm!

Advertisement

You may also like:

Author


Discover more from AIinASIA

Subscribe to get the latest posts sent to your email.

Continue Reading

Life

ChatGPT’s New Custom Traits: What It Means for Personalised AI Interaction

ChatGPT’s new trait assignment feature lets users personalise their chats by adjusting tone and style from Chatty to Gen Z, or Analytical.

Published

on

ChatGPT trait assignment

TL;DR – What You Need to Know in 30 Seconds

  • OpenAI has introduced a new trait assignment feature for ChatGPT, allowing users to personalise its tone and style.
  • Users can specify a nickname, profession, and personality traits like “Chatty,” “Encouraging,” or “Gen Z.”
  • This feature does not affect ChatGPT’s memory, which separately retains or forgets past interactions.
  • The update is currently rolling out on ChatGPT.com and Windows, with mobile and MacOS versions coming soon.
  • While this enhances customisation, it still relies on prompt engineering, meaning it doesn’t deeply change how the AI works.
  • OpenAI moderates trait usage to prevent misuse and ensure compliance with its terms of service.

OpenAI’s New ChatGPT Update: Custom Traits for a Personalised Experience

OpenAI has launched a new customisation feature for ChatGPT, giving users the ability to assign personality traits to the AI. This update aims to enhance how users interact with ChatGPT, making conversations feel more natural and tailored to individual preferences.

Instead of a one-size-fits-all AI assistant, users can now adjust ChatGPT’s tone, engagement style, and personality to better match their needs—whether for professional tasks, casual conversation, or content creation.

How It Works: Assigning Traits to ChatGPT

Users now have greater control over ChatGPT’s persona by specifying:

  • Preferred Name/Nickname – ChatGPT will refer to users by their chosen name.
  • Profession – Users can provide their job title or field for more relevant responses.
  • Traits – Users can choose from a variety of styles, such as:
    • Chatty – More conversational and engaging.
    • Encouraging – Supportive and motivational.
    • Gen Z – A more informal, youthful style.
    • Skeptical – More critical and questioning in responses.
    • Analytical – Ideal for professional or logical discussions.
    • Creative – A better fit for brainstorming and ideation.
    • Concise – Focused on summarised, to-the-point replies.
    • Empathetic – Suitable for more sensitive topics.

This feature is separate from ChatGPT’s memory, meaning it doesn’t remember details across different conversations but instead modifies responses in real time based on user input.

Is This a Deep AI Upgrade or a Simple UI Change?

Despite the buzz, this is not a fundamental change to ChatGPT’s underlying model. The feature relies on prompt engineering, meaning it adjusts responses rather than truly altering how the AI thinks or operates.

In essence, it’s a user-friendly way to tweak ChatGPT’s style using preset prompts rather than requiring users to manually provide detailed instructions.

Advertisement

Moderation Considerations

To prevent misuse or inappropriate modifications, OpenAI moderates the customisation options to ensure they align with its terms of service. While users can tailor ChatGPT’s personality, it won’t allow for harmful or misleading persona adjustments.

What’s Next? Expansion to More Platforms

The trait assignment feature is currently rolling out to:

  • ChatGPT.com
  • Windows desktop app

Coming soon: The update will be available on MacOS and mobile apps in the next few weeks.

However, users in the EU, Norway, Iceland, Liechtenstein, and Switzerland won’t have immediate access due to regulatory considerations.

Potential Impacts: A Step Towards More Personalised AI?

This update marks a shift towards making AI interactions feel more human-like and relatable. It’s particularly useful for:

  • Businesses and professionals – More tailored, industry-specific AI interactions.
  • Casual users – A more engaging and fun conversation experience.
  • Content creators – An AI that aligns better with their preferred tone and style.

That said, it also raises questions about how personality traits might impact AI reliability, especially when it comes to factual accuracy and biases in different roles.

Final Thoughts

OpenAI’s new trait assignment feature is a welcome addition for users looking for a more personalised ChatGPT experience. While it doesn’t represent a deep technical shift, it streamlines customisation and could pave the way for even more user control over AI interactions in the future.

Advertisement

For now, the biggest takeaway is that ChatGPT can sound more like the assistant you want it to be—whether that’s chatty, analytical, or even a little bit Gen Z.

Let’s Talk AI!

How are you preparing for the AI-driven future? What questions are you training yourself to ask? Drop your thoughts in the comments, share this with your network, and subscribe for more deep dives into AI’s impact on work, life, and everything in between.

You may also like:

Author


Discover more from AIinASIA

Subscribe to get the latest posts sent to your email.

Continue Reading

Trending

Discover more from AIinASIA

Subscribe now to keep reading and get access to the full archive.

Continue reading