Copilot In Excel: NEW Feature Enables Copilot Use Without a Table

Posted on: 08/10/2024

Introduction to Copilot's New Features

Copilot in Excel has introduced some exciting new features that are designed to enhance your productivity. These updates might seem minor or major depending on your workflow. Let's dive into these new capabilities and see how they can streamline your Excel tasks.

Setting Up Your Data

In the past. To use Copilot you had to save your file to OneDrive. Turn on Autosave and make sure your data was a table. Now you can use a range instead of a table.

YouTube Video - Copilot in Excel - Use a Range instead of a Table

Feature available in Excel with Copilot

Copilot in Excel is a powerful tool that can help you with a variety of tasks to enhance your productivity. Here are some of the key features:

Data Analysis: Copilot can analyze your data and provide insights, trends, and summaries. It can help you understand your data better by highlighting key points and patterns.
Formula Assistance: It can suggest and create complex formulas based on your needs. Whether you’re working with basic arithmetic or advanced statistical functions, Copilot can help you get the right formula.
Data Visualization: Copilot can recommend and create charts and graphs that best represent your data. It can help you choose the right type of visualization to make your data more understandable and impactful.
Automation: It can automate repetitive tasks, such as data entry, formatting, and report generation. This can save you a lot of time and reduce the risk of errors.
Natural Language Queries: You can ask Copilot questions in natural language, and it will provide answers based on your data. For example, you can ask, “What were the sales figures for last quarter?” and get a quick response.
Collaboration: Copilot can assist in collaborative tasks by tracking changes, suggesting edits, and ensuring that everyone is on the same page.

Recent Articles

New Feature - Word for the Web: Edit Tables with Ease

Microsoft Word for the web has introduced some fantastic new features for editing tables. These enhancements are perfect for anyone who frequently uses tables in their documents.

Word - How to correctly select a paragraph, sentence, word, or the entire document with the mouse

Selecting a word, sentence, paragraph, or the entire document in MS Word is easy. Here is a short video on how to correctly select with the mouse.

Copilot in Excel: Conditional Formatting with Complex Functions

Copilot in Excel now supports Conditional Formatting with Formulas. This is an awesome feature. For example, Copilot can highlight an entire row where the State is Georgia and the city is Atlanta.

2 Methods to Separate Date and Time in Excel

Welcome to our guide on how to separate date and time in Excel. In this blog, we will explore two dynamic methods to achieve this: using the Integer (INT) function and employing Power Query.

Chris Menard

Chris Menard is a certified Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. He runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events every year, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the Support Staff Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.