| |

Copilot Tip: Use Natural Language to Speed Up Excel Tasks

You’re staring at a spreadsheet like this, wondering how to highlight top sales and organize your data:

Region Sales Rep
West $12,500 Jordan
East $9,800 Casey
South $15,200 Morgan
North $7,600 Taylor

 

You’d normally need to:

  • Write a conditional formatting rule
  • Sort manually by region
  • Build a chart from scratch

With Copilot in Excel:

Just type a plain-English request like:

“Bold the rows where sales are above $10,000 and sort by region.”

Copilot will instantly:

  • ✅ Apply conditional formatting to highlight qualifying rows
  • ✅ Sort your data by region
  • ✅ Suggest charts or summaries to help visualize trends

After Copilot:

Region Sales Rep
East $9,800 Casey
North $7,600 Taylor
South $15,200 Morgan
West $12,500 Jordan

 

✨ Rows with sales over $10,000 are bolded
A bar chart of sales by region is suggested

Why it matters:

  • You don’t need to know formulas or dig through menus. Just describe what you want, and Copilot does the rest—making Excel more accessible and powerful than ever.
  • You can also ask Copilot to explain formulas or trends in your data, making it a great learning tool for non-experts.
  • Copilot helps users save time, reduce errors, and gain insights—especially useful for business users who aren’t Excel pros.

 

Ariel IT helps businesses simplify technology, strengthen cybersecurity, and stay compliant with evolving standards. As Business Professionals - Technical Experts, we partner with organizations to deliver reliable IT solutions that support growth and peace of mind.  Contact us to learn more

Similar Posts

  • Microsoft Office Tips- Excel- Using CTRL-D to copy data

    Excel – Use CTRL-D to duplicate the data from the cell above you have selected. You can highlight multiple cells to fill them all too! If your Office Applications are on your Taskbar, right-click the Office application icon to see your list of recent files. Click the file to open it. You can also right-click…

  • Snipping Tool Tips

    Capturing part of your screen for a presentation, email, or personal notes is a handy skill to have available. Windows 10 comes with the “Snipping Tool” for you to do just that. If you need a more advanced tool, my favorite is Hypersnap from Hyperionics, which also provides pretty decent image editing tools. Watch the…

  • What you need to know about your Domain Name!

    Domains and Domain Registration (and for you techies we’re talking about Internet domains, not AD Domains) are an important part of every business. Your Domain Name should be treated like any other asset in your company because that’s what it is. If you lose this asset the impact could be devastating. Devastating, you ask? Yes…….

  • |

    Keyboard shortcuts for Outlook

    I love Keyboard Shortcuts. Every time I have to reach for the mouse to do something I wonder if there is a shortcut to make that step a little faster. Mastering shortcuts in Office Products is a great way to save a little time everyday! These are a few shortcuts I use everyday as well…

  • |

    FreeConferenceCall.com

    Since we are talking about VoIP in our Blog this month it seems appropriate that the Tech Tip be about a cool (and Free) VoIP technology. FreeConferenceCall.com is exactly what it says. And, having used it a few times recently I was shocked at what you get! It’s Flexible, It’s Straightforward and It’s Secure! You…