Amelia Roberts from Pragmatic Works demonstrates how to use Copilot in Excel to make the process of analyzing and visualizing data easier and more efficient. Copilot, a tool integrated into Excel, leverages artificial intelligence to provide insights, assist with formulas, and create visualizations in a few clicks, making it a great choice for Excel beginners and experienced users alike.

Getting Started with Copilot in Excel

Before starting with Copilot, make sure to enable AutoSave and save your file to OneDrive. This is a requirement for Copilot to function properly. Once everything is set up, follow these simple steps to use Copilot in Excel:

• Enable AutoSave: Ensure that your file is saved in OneDrive and AutoSave is on.
• Open Copilot: In the top right corner of Excel, open Copilot by clicking on the Copilot icon.

Key Features of Copilot

Here are some key features of Copilot that make it incredibly helpful in Excel:

1. Natural Language Prompts: Copilot understands natural language, meaning you can ask it anything as you would a friend. No technical jargon required. It suggests prompts like creating formulas, summarizing data, or applying conditional formatting, all based on the context of your current worksheet.
2. Creating Formulas: You can ask Copilot to create formulas for you. For example, if you want to calculate the total cost by adding two existing columns, Copilot will create the appropriate formula, apply it, and even provide an explanation for it.
3. Generating Visuals: Copilot allows you to easily create charts and visuals to compare data. For example, Amelia asked Copilot to create a bar chart comparing total cost across different cities. Copilot quickly generated the visual and even created a table for a detailed breakdown.
4. Conditional Formatting: Copilot can apply conditional formatting to highlight specific values. Simply tell it to "highlight cells with a value higher than 10," and Copilot will take care of the rest. Be specific in your prompt for better results. For example, if you only want to format one column, mention the column explicitly (e.g., "highlight cells in column G").
5. Data Insights: Copilot can provide insights into your data, offering visual representations and deeper analysis. For instance, asking for insights on total costs by city led Copilot to generate a scatter chart and frequency distribution.
6. Advanced Analysis with Python: For more in-depth analysis, Copilot can write Python code to perform advanced calculations. Even if you're not familiar with Python, Copilot’s integration allows you to use it with ease.
7. Learning and Customization: Copilot is a great tool for beginners to learn Python or advanced Excel functions. It can write Python code for you, allowing you to understand the process while working with your data. You can then modify the code as needed.
8. Making Recommendations: Based on your actions, Copilot will suggest improvements or next steps. For example, after analyzing the total cost, Copilot suggested sorting the data from smallest to largest, which Amelia found to be incredibly helpful.

Practical Example

Amelia provided a simple data set of different Disney rides, their costs, and the cities they are located in. Here’s how Copilot helped her:

• Formula Creation: Amelia wanted to calculate the total cost for each ride. She simply asked Copilot to create a formula that added the "cost to make" and "cost to maintain" columns.
  Copilot instantly generated the formula and displayed it for Amelia’s approval before applying it to the data.
• Creating a Visualization: Amelia wanted to compare total costs across different cities. Copilot generated a bar chart and added a table for a detailed breakdown of costs.
• Applying Conditional Formatting: She asked Copilot to highlight cells with values greater than 10. Initially, the prompt was too vague, but after refining it to specify column G, Copilot applied the formatting perfectly.
• Advanced Python Analysis: For a deeper analysis, Amelia used Copilot to generate Python code to examine the trends in the data. The results appeared in the form of a line chart showing the cost trends across different years.

Benefits of Using Copilot in Excel

• Saves Time: Copilot helps automate complex tasks like formula creation, data analysis, and visual generation, saving you hours of manual work.
• Enhances Productivity: By suggesting next steps and applying changes quickly, Copilot improves workflow efficiency.
• Great for Beginners: Copilot provides a user-friendly interface for those who are not familiar with advanced Excel functions or coding.
• Supports Advanced Users: Even experienced Excel users can benefit from Copilot’s quick insights and Python-based analysis capabilities.

Learn More About Copilot

If you’re interested in learning more about Copilot in Excel, Pragmatic Works offers a comprehensive training program on-demand. They also offer a Co-Pilot Bootcamp where you can gain hands-on experience.

Don't forget to check out the Pragmatic Works' on-demand learning platform for more insightful content and training sessions on Copilot and other Microsoft applications. Be sure to subscribe to the Pragmatic Works YouTube channel to stay up-to-date on the latest tips and tricks.