Copilot Smart Routines: Excel

Description

Let Copilot in Excel be your personal coach.

In this two-hour workshop you learn to work in Excel with Copilot helping you at every step. You explore the Excel environment, enter and format data and work with Flash Fill. You build formulas with Copilot, use cell references, conditional formatting and tables, and analyse your data.

You also discover where Copilot's limits lie. Finally, you learn how to prepare your data so Copilot can work with it.

What's in it for you?

• New Excel users become independent faster

• Participants ask Copilot their questions instead of a colleague

• Well-structured files that Copilot can keep working with

After this training you can

• Find your way around Excel and enter and format data correctly

• Build basic formulas with Copilot

• Work with cell references, conditional formatting and tables

• Analyse your data and make a worksheet print-ready

• Use Copilot in Excel purposefully and assess its limits

Target audience

Employees who work with Excel and want to integrate Copilot into their work.

Prerequisites

No prior knowledge required. Participants have a Copilot for Microsoft 365 licence.

Contents

• Introduction and agenda (15 min)

• Getting to know Excel and Copilot (15 min)

• Copilot in Excel: formulas, formatting, complex data, drop-down lists, splitting rows and more (60 min)

• Creating dashboards in Excel (20 min)

• Takeaways and Q&A (10 min)

Price

On request.