So.....there are (at least) 3 different things called CoPilot.....
1. Copilot for Bing (this is increasingly being called Copilot for Windows). I use this for very specific searches. "I study Chinese brush calligraphy and want a brush made without animal products. I'll be in Kyoto soon - where's a good shop to look for one?" Of course I could have constructed a search "vegan calligraphy brush Kyoto" but the natural language does a better job when the search is tricky or has several factors. Think of it as a very clever front end to Bing search. It can do more than that but that's your start. It's also extremely good for error messages etc because you can give it the context and also things like your skill level ("rephrase that like I'm 5"). Also for reasons I needed to write a haiku about being at the seaside recently - Copilot rocks for this.
2. Copilot for Office 365. Just starting to use this but it's immense. I needed to knock up a quick bullet point slide to talk through some concepts in a meeting. I wrote a prompt and Powerpoint made me a 6 slide presentation nicely formatted with graphics. I refined the prompt, asked for a summary slide and corrected one piece of text. Under 10 mins start to finish to create a pretty presentation.
3. Copilot for Github. One of the best things invented int he past 3 years. If you write code, you need this. Other LLMs are available for VSC etc but Copilot for Github works pretty much like magic - whether it's wireframing a programme, setting up a new project, reducing repetitive typing or fixing errors - if you code, try it.