Introduction
Course overview
()
1. Audit and Understand Your Data
How to audit data with Copilot
()
How to audit Excel models with Copilot
()
2. Clean and Prepare Your Data
How to clean messy data with Copilot
()
How to merge multiple sheets with Copilot
()
3. Structure and Organize Your Data
How to apply conditional formatting with Copilot
()
How to filter and sort data with Copilot
()
How to add calculated columns with Copilot
()
How to analyze text and extract sentiment with Copilot
()
4. Write and Fix Formulas
How to write Excel formulas with Copilot
()
How to debug formula errors with Copilot
()
5. Analyze and Visualize Your Data
How to create pivot tables with Copilot
()
How to generate charts with Copilot
()
How to compare datasets with Copilot
()
How to build a forecast model with Copilot
()
How to create Excel dashboards with Copilot
()
Ex_Files_15_MSFT_Copilot_Tips.zip
(245 KB)