課程簡介
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
最低要求
- 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
客戶評論 (5)
材料範圍
Marcin - Instytut Energetyki- Panstwowy Instytut Badawczy
課程 - Word dla zaawansowanych
機器翻譯
課程範圍
Marcin - Instytut Energetyki- Panstwowy Instytut Badawczy
課程 - MS Word - poziom podstawowy
機器翻譯
Adam was very knowledgeable and had a great layout.
Corey Reis - Lockheed Martin
課程 - Advanced Slide Design in PowerPoint
關於影像格式和範本的一些小技巧 - 非常有用的:)
Natalia Wawrzyniak - Akademia Morska w Szczecinie
課程 - Advanced MS PowerPoint
機器翻譯
There was a good amount of information for the time of training. Also the trainer was very engaged with the group, especially when people were having troubles or asking questions. It was very nice of him to offer help in case of future ideas.