In this video, I demonstrate how to use Copilot in Microsoft Excel to seamlessly apply conditional formatting to data involving text, dates, and numbers. I first ensure the worksheet meets the prerequisites for using Copilot by saving it to OneDrive or SharePoint, enabling Autosave, and structuring the data as a table.
Through practical examples, I showcase Copilot's capability to intuitively handle requests such as highlighting certain states in a specific color, marking purchases above a threshold, and changing the font color for recent invoice dates.
Copilot is a great addition to all Microsoft 365 products, but in Excel it's amazing at understanding prompts and taking action.
Chapters:
00:00 Introduction
00:25 Setting Up for Copilot: Requirements
00:57 Diving into Conditional Formatting with Copilot
01:08 Example 1: Conditional Formatting with Text
02:07 Example 2: Conditional Formatting with Numbers
03:12 Example 3: Conditional Formatting with Dates
04:18 Conclusion
Check out my new Microsoft Copilot Course and all Excel and Teams courses:
[ Ссылка ]
Blog Post [ Ссылка ]
And make sure you subscribe to my channel!
-- EQUIPMENT USED ---------------------------------
○ My camera – [ Ссылка ]
○ Microphone - [ Ссылка ]
○ Camera tripod – [ Ссылка ]
○ Studio lights - [ Ссылка ]
○ Dual monitor mount stand - [ Ссылка ]
○ Web camera – [ Ссылка ]
○ Shock mount - [ Ссылка ]
○ Boom Arm - [ Ссылка ]
-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – [ Ссылка ]
○ Screenshots – Snagit – [ Ссылка ]
○ YouTube keyword search – TubeBuddy – [ Ссылка ]
DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!
#copilot #chrismenard #excel
Copilot in Excel: Using Conditional Formatting
Теги
Microsoft ExcelCopilot TutorialConditional FormattingExcel TipsExcel Data AnalysisOneDrive IntegrationSharePoint ExcelExcel Table DesignAutosave FeatureExcel ProductivityExcel for BeginnersCopilot FeaturesText Formatting ExcelDate Formatting ExcelNumber Formatting ExcelExcel Quick TipsExcel Online TrainingExcel Conditional RulesData Visualization ExcelExcel Functionschris menard