Using Microsoft 365 Copilot efficiently in Excel 365

Introduction to Microsoft 365 Copilot

• Features and benefits of Microsoft 365 Copilot.
• Overview of the different Microsoft Copilot variants.
• Integration of Microsoft 365 Copilot in Excel.
• Practical application examples.

Basic data analysis with Microsoft 365 Copilot

• Filters, sorting and grouping of data.

• Recognizing patterns and trends.

First steps with Excel formulas and functions

• Using formulas and functions with Microsoft 365 Copilot.

• Error detection and correction in formulas.

• Use of Microsoft 365 Copilot for statistical functions.

• Efficient use of text, date, and time functions with Microsoft 365 Copilot.

Data visualization with Microsoft 365 Copilot

• Creation of tables, diagrams and graphs.
• Adaptation of visualizations based on Copilot recommendations.
• Adaptation of visualizations to specific requirements.
• Use of conditional formatting to highlight trends and anomalies.

Advanced Excel functions with Microsoft 365 Copilot

• Expand your data analysis capabilities with complex functions and Microsoft 365 Copilot.
• Using Microsoft 365 Copilot for conditional analysis and dynamic arrays.
• Application of advanced analysis techniques and functions.

More complex data analysis

• Conditional analyses and dynamic arrays.

• Data consolidation and linking.

• Efficient merging and analysis of data from different sources.

Microsoft 365 Copilotin Pivot Tables

• Creation and optimization of pivot tables.
• Advancing pivot table analysis with Microsoft 365 Copilot.

Insight into the integration of Microsoft365 Copilotwith other Microsoft products

Best practices, tips & tricks from the experts