Office & Microsoft 365
Bureautique & Microsoft 365 — Practitioner
Become efficient with advanced Excel and collaboration in Teams and SharePoint.
You deepen Excel (advanced formulas, pivot tables) and collaboration with Teams, SharePoint and OneDrive. The capstone is a shared, collaborative management workbook.
Objectives
- Master Excel advanced formulas
- Analyze data with pivot tables
- Collaborate with Teams, SharePoint and OneDrive
- Design a shared management workbook
Program
Advanced Excel
- Nested formulas and lookups
- Pivot tables
- Conditional formatting
Microsoft 365 collaboration
- OneDrive file sharing
- Teams workspaces
- SharePoint libraries
Management workbook
- Structuring data
- Automating calculations
- Sharing a collaborative workbook
Prerequisites
Excel and Microsoft 365 basics.