Using Microsoft 365 Copilot efficiently in Excel 365
Efficient data analysis and visualization with AI
.svg)
Machine Learning Engineer
Introduction to Microsoft 365 Copilot
- Features and benefits of Microsoft 365 Copilot.
- An overview of the different versions of Microsoft Copilot.
- 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
In your online learning environment, you will find useful information, downloads and extra services for this training course once you have registered.
Learn with Microsoft 365 Copilot
- Excel more efficiently,
- optimize data analysis, visualization and reporting,
- to make work processes more efficient,
- increase personal productivity and
- improve collaboration through the use of modern technologies.
trainer, exercises, use cases.
Please note the following information for this training event:
Access to Microsoft Excel 365 for Windows and Microsoft 365 Copilot isrequired.
We generally recommend that you do not enter any specific personal data or sensitive business data training event AI tools before or during the training event .
Professionals, managers, and anyone who wants to boosttheir productivity and efficiency when working with Microsoft Excel 365 for Windows using Microsoft 365 Copilot.
Good basic knowledge of Excel is required.
.svg)