Shortcut Shari Logo

It's My Job to Make Your Job Easier!

Cover Image

TIP!Tuesday - Use Copilot in Excel to Build a Conference Session List

May 18, 20264 min read

In this tip, I use Copilot in Excel to pull conference session details from a web page and organize them into a table. Even better, Copilot connects the session list to attendee roles and suggests who should attend what. That is a big productivity win when you are planning for a busy event.

Let Copilot in Excel help turn a web page full of sessions into a planning table your team can actually use.

Conference planning can feel like trying to organize a sock drawer during a windstorm.

You have session titles on one page, attendee names somewhere else, roles in another tab, and everyone asking the same question:

"What should I attend?"

This week, I am using Microsoft Excel and Copilot to make that whole process a little less clicky, copy-pasty, and chaos-flavored.

The Problem With Conference Session Lists

Most conference websites are packed with great information, but they are not always packaged in the way your team needs to use it.

You may need to know:

  • What sessions are available

  • Who is presenting

  • What day and time each session happens

  • What level the session is

  • Where it is located

  • Which person on your team should attend

That is a lot of details to collect manually, especially when you are trying to plan across multiple attendees with different roles and priorities.

This is where Copilot in Excel can help.

The Prompt That Did the Heavy Lifting

In the video, I used a prompt that asked Copilot to review the list of sessions from a web address and create a table with the following information:

  • Session title

  • Presenter

  • Date

  • Time

  • Level

  • Location

  • Suggested attendee persona

Simple prompt. Big payoff.

Instead of manually bouncing between the conference website and my spreadsheet, Copilot helped collect the details and structure them into something useful.

The Bonus That Made This Even Better

Here is where it got fun.

Copilot did not just give me the session details I asked for. It also cross-referenced another tab in my workbook that included attendees, their roles, and their primary conference focus.

That means Copilot helped suggest which attendee should go to which session.

That is not just data entry. That is decision support.

And when you are planning for a team attending a conference, that kind of support can save time, reduce duplicate effort, and make sure people are attending sessions that actually match their role and goals.

Why This Tip Matters

This is a great example of using Copilot for practical workplace productivity.

We are not asking it to do something abstract or mysterious. We are giving it a real task:

"Help me turn this pile of information into something my team can use."

That is where Copilot shines.

It can help you move from scattered information to structured insight. And when you pair it with Excel, you can create a planning tool that is easier to review, update, filter, and share.

Try This Yourself

The next time you are planning for a conference, event, webinar series, or internal learning experience, try using Copilot in Excel to help organize the information.

You might ask it to create a table with:

  • Session or event title

  • Speaker or owner

  • Date and time

  • Topic or category

  • Audience or role

  • Priority level

  • Suggested attendee

If you already have a list of employees, roles, departments, or goals in another tab, include that context in your workbook so Copilot has more information to work with.

The better the context, the better the output.

Work Smarter, Not Harder

This tip is quick, but it is mighty.

Using Copilot in Excel to build a conference planning table can save time, reduce confusion, and help your team make smarter decisions about where to spend their time.

And let us be honest, conferences already come with enough decisions. Your spreadsheet does not need to be one of the hard ones.

Give it a try, and next week we will keep building on this conference planning scenario.

Key Takeaways

  • Copilot in Excel can help pull structured information from a conference web page.

  • A clear prompt can turn session details into a useful planning table.

  • Copilot can use other workbook tabs as context when suggesting attendee personas.

  • This is a practical way to save time when planning conference schedules.

  • Better context in your workbook can lead to more useful Copilot results.

You might say I’m a cross between Dear Abby…and the Crabby Office Lady…I miss the Crabby Office Lady!  While my crabbiness varies depending on the day…my passion for helping you to work smarter and not harder only grows with the knowledge I gain every single day.  So STUMP me!  Ask me questions!  It’s my opportunity to learn, too.  Having said that, I might now just opened a can of worms, but I welcome the challenge.

They call me ShortCut Shari because I love keyboard shortcuts, but there are so many other ways to get from A to B more quickly in your daily job…so let’s get to work!

Shortcut Shari

You might say I’m a cross between Dear Abby…and the Crabby Office Lady…I miss the Crabby Office Lady! While my crabbiness varies depending on the day…my passion for helping you to work smarter and not harder only grows with the knowledge I gain every single day. So STUMP me! Ask me questions! It’s my opportunity to learn, too. Having said that, I might now just opened a can of worms, but I welcome the challenge. They call me ShortCut Shari because I love keyboard shortcuts, but there are so many other ways to get from A to B more quickly in your daily job…so let’s get to work!

LinkedIn logo icon
Youtube logo icon
Back to Blog

How Can I Help?

We focus on the People Side of Change. Let's work together!