About this training
A 2-day all-level program for office workers, finance, sales, HR, and operations professionals who want to 3-5x speed up daily Excel work with Microsoft 365 Copilot, Analyze Data, Python in Excel, AI-powered formula generation, forecasting, and Power Query AI. KVKK compliance included.
This training is designed for: Office workers, executive assistants Accountants and finance professionals Sales analysts, marketing analysts HR specialists and compensation analysts Operations and supply chain managers SME owners and solo entrepreneurs
Why this course matters: The only Turkish program that integrally addresses Microsoft 365 Copilot, Python in Excel, Analyze Data, Power Query AI. Reduces daily Excel hours by 50-70% with natural language formula generation, automatic PivotTable, AI Insights. Provides department-based (finance, sales, HR, operations) use case catalog. No Python experience required — teaches Python in Excel from scratch. Establishes KVKK-compliant Excel data sharing discipline. Produces template library for your own department in the capstone.
Learning outcomes by the end of the programme: Manage Excel with natural language commands via Microsoft 365 Copilot. Generate complex formulas (VLOOKUP, LAMBDA) with AI. Extract automatic insights with Analyze Data. Build pandas + matplotlib workflows with Python in Excel. Accelerate data preparation with Power Query AI. Perform time-series forecasting with Forecast Sheet. Generate VBA macros with ChatGPT/Claude. Develop department-based AI-powered Excel templates. Apply KVKK-compliant Excel data sharing discipline.
Prerequisites and recommended background: Active Excel usage experience (basic-intermediate) Microsoft 365 Copilot license (recommended; trial accepted) A modern Windows or Mac computer Office work or finance/sales/HR/operations experience Python experience NOT required — started from scratch in Module 5
- Turkey's only 2-day training that integrally addresses Microsoft 365 Copilot, Analyze Data, Python in Excel, Power Query AI features
- Natural language VLOOKUP, XLOOKUP, INDEX/MATCH, SUMIFS, LAMBDA formula generation
- pandas, matplotlib, scikit-learn workflow with Python in Excel
- Department-based use case catalog: finance, sales, HR, operations
- VBA macro generation with External AI (ChatGPT/Claude)
- KVKK-compliant Excel data sharing and sensitivity labels
Key Takeaways
- Manage Excel with natural language commands via Microsoft 365 Copilot.
- Generate complex formulas (VLOOKUP, LAMBDA) with AI.
- Extract automatic insights with Analyze Data.
- Build pandas + matplotlib workflows with Python in Excel.
- Accelerate data preparation with Power Query AI.
- Perform time-series forecasting with Forecast Sheet.
- Generate VBA macros with ChatGPT/Claude.
- Develop department-based AI-powered Excel templates.
- Apply KVKK-compliant Excel data sharing discipline.
Data Analysis with Excel + AI Training (Microsoft 365 Copilot)
A 2-day all-level program for office workers, finance, sales, HR, and operations professionals who want to 3-5x speed up daily Excel work with Microsoft 365 Copilot, Analyze Data, Python in Excel, AI-powered formula generation, forecasting, and Power Query AI. KVKK compliance included.
About This Course
This training is designed for office professionals who want to integrate Excel's 2024-2026 AI transformation into their daily workflows. With features like natural language commands via Microsoft 365 Copilot, automatic insights via Analyze Data, pandas/matplotlib/scikit-learn power via Python in Excel, data preparation via Power Query AI, formula and VBA macro generation via ChatGPT/Claude external integration, Excel is no longer a 'spreadsheet tool' but has transformed into an 'AI-augmented analytics platform.'
The disciplinary backbone of the program is Microsoft 365 Copilot for Excel usage (highlight, sort, filter, summarize, insights), natural language formula generation (VLOOKUP, XLOOKUP, INDEX/MATCH, SUMIFS, LAMBDA), automatic PivotTable suggestion with Analyze Data, Anaconda integration and pandas/matplotlib workflow with Python in Excel, AI-powered PivotTable and chart generation, time-series with Forecast Sheet, Power Query's Column from Examples and AI Functions, VBA macro generation with External AI (ChatGPT/Claude), department-based use case catalog (finance, sales, HR, operations), and KVKK-compliant Excel data sharing discipline.
The training consists of 2 days, 12 modules, and over 55 hands-on lessons. In the capstone, you design an end-to-end AI-powered Excel workflow for your own department. After this training, a typical knowledge worker reduces daily Excel hours by 50-70%.
Training Methodology
Turkey's only 2-day training that integrally addresses Microsoft 365 Copilot, Analyze Data, Python in Excel, Power Query AI features
Natural language VLOOKUP, XLOOKUP, INDEX/MATCH, SUMIFS, LAMBDA formula generation
pandas, matplotlib, scikit-learn workflow with Python in Excel
Department-based use case catalog: finance, sales, HR, operations
VBA macro generation with External AI (ChatGPT/Claude)
KVKK-compliant Excel data sharing and sensitivity labels
Who Is This For?
Why This Course?
The only Turkish program that integrally addresses Microsoft 365 Copilot, Python in Excel, Analyze Data, Power Query AI.
Reduces daily Excel hours by 50-70% with natural language formula generation, automatic PivotTable, AI Insights.
Provides department-based (finance, sales, HR, operations) use case catalog.
No Python experience required — teaches Python in Excel from scratch.
Establishes KVKK-compliant Excel data sharing discipline.
Produces template library for your own department in the capstone.
Learning Outcomes
Requirements
Course Curriculum
46 LessonsInstructor
Şükrü Yusuf KAYA
AI Architect | Enterprise AI & LLM Training | Stanford University | Software & Technology Consultant
Şükrü Yusuf KAYA is an internationally experienced AI Consultant and Technology Strategist leading the integration of artificial intelligence technologies into the global business landscape. With operations spanning 6 different countries, he bridges the gap between the theoretical boundaries of technology and practical business needs, overseeing end-to-end AI projects in data-critical sectors such as banking, e-commerce, retail, and logistics. Deepening his technical expertise particularly in Generative AI and Large Language Models (LLMs), KAYA ensures that organizations build architectures that shape the future rather than relying on short-term solutions. His visionary approach to transforming complex algorithms and advanced systems into tangible business value aligned with corporate growth targets has positioned him as a sought-after solution partner in the industry. Distinguished by his role as an instructor alongside his consulting and project management career, Şükrü Yusuf KAYA is driven by the motto of "Making AI accessible and applicable for everyone." Through comprehensive training programs designed for a wide spectrum of professionals—from technical teams to C-level executives—he prioritizes increasing organizational AI literacy and establishing a sustainable culture of technological transformation.
Frequently Asked Questions
Apply for Training
Boutique training with limited seats.
Pre-register for Next Groups
Leave your info to be the first to know when the next batch opens.
1-on-1 Mentorship
Book a private session.
Categories
Related programs
Professional Software Development with Claude Code Training
A comprehensive, advanced 4-day training program for software professionals seeking enterprise-level mastery of Anthropic's agentic coding platform, Claude Code. Production-grade agent architecture with MCP integrations, Hooks, Sub-agents, Skills, and the Claude Agent SDK.
4 GünadvancedLLM Alignment Engineering with RLHF, DPO, and GRPO Training
A 3-day advanced Turkish LLM alignment training that covers the RLHF (PPO), DPO, KTO, IPO, SimPO, ORPO, and DeepSeek R1 GRPO algorithms at both math and code level; and teaches reward modeling, Constitutional AI, RLAIF, reasoning-model alignment, and the TRL/Axolotl/LLaMA-Factory/OpenRLHF/verl toolchain at production grade.
3 GünadvancedBuilding AI Agents with the Claude Agent SDK Training
A comprehensive, advanced 4-day program for software engineers who want to develop production-grade AI agents with Anthropic's Claude Agent SDK. Tool-use orchestration, MCP server development, multi-agent patterns, prompt caching, and evaluation engineering.
4 Günadvanced
