Programa del Curso
Module 1 – Advanced Excel for Decision-Making (6 hours)
- Advanced formulas and functions (INDEX/MATCH, XLOOKUP, IF, nested formulas)
- Data analysis tools: PivotTables, PivotCharts, Power Query basics
- Automation with macros and Copilot suggestions
- Creating dashboards and reports for leadership insights
- Practical exercises applied to healthcare and management scenarios
Module 2 – PowerPoint for Impactful Presentations (6 hours)
- Professional slide design and storytelling techniques
- Effective data visualization and use of charts
- Integration with Excel and Copilot-generated presentations
- Tips for engaging executive audiences
- Final project: presentation building using Copilot
Module 3 – Word for Professional Documentation (6 hours)
- Creating and formatting professional reports and proposals
- Templates and styles for consistency and efficiency
- Integrating Copilot for writing, summarizing, and editing content
- Collaboration tools and version control
- Practical exercise: building a leadership report
Module 4 – Outlook for Productivity and Team Organization (6 hours)
- Advanced email and calendar management techniques
- Rules, categories, and automation for efficiency
- Copilot for drafting, summarizing, and scheduling assistance
- Integration with Teams and other Microsoft 365 tools
- Leadership-focused time management strategies
Module 5 – Microsoft Copilot in Leadership Workflows (6 hours)
- Overview of Copilot across Microsoft 365
- AI-assisted task automation in Excel, Word, and Outlook
- Prompt design for effective Copilot usage
- Ethical use of AI and data privacy best practices
- Hands-on practice: creating workflows using Copilot
Summary and Next Steps
Requerimientos
- An understanding of basic data management and reporting concepts
- Experience with Microsoft Office applications such as Excel, Word, PowerPoint, and Outlook
- Familiarity with online collaboration tools such as Teams or OneDrive
Audience
- Managers and decision-makers seeking to enhance productivity using Microsoft 365 and Copilot
- Professionals responsible for preparing reports, presentations, and documentation for leadership
- Teams aiming to leverage AI tools for automation and strategic insight generation
Testimonios (5)
Recientemente estuve luchando con algunos problemas con las tablas dinámicas y el curso me dio los conocimientos para trabajar con tablas dinámicas de forma más rápida, inteligente y eficiente.
Arina Moayed-Dzenisa - Universal-Investment-Gesellschaft mbH Branch Poland Sp. z o. o.
Curso - Microsoft Office Excel - poziom średnio zaawansowany
Traducción Automática
Ejemplos y búsqueda de soluciones
Monika Lesniewska - Takenaka Europe GmbH Sp. z o.o. Oddzial w Polsce
Curso - Excel Data Analysis
Traducción Automática
El hecho de que tenía diferentes hojas de cálculo y hojas de datos con ejercicios para que los hiciéramos.
Deepakie Singh Sodhi - Queens College, CUNY
Curso - Excel For Statistical Data Analysis
Traducción Automática
Trabajar y usar nuestros propios datos/hojas de cálculo, donde pudiéramos ver cómo nos beneficiaría más.
Julie - Environment, Marine and Fisheries
Curso - Excel VBA Introduction
Traducción Automática
I enjoyed the Excel sheets provided having the exercises with examples. This meant that if Tamil was held up helping other people, I could crack on with the next parts.
Luke Pontin
Curso - Data and Analytics - from the ground up
Traducción Automática