Artificial Intelligence in MS Office365: From Routine to Productivity (OFFAI)

AI - Artificial Intelligence, AI for Business

Tired of slow Excel sheets or typing in Word with two fingers? Discover how AI in Microsoft Office turns routine work into real productivity. Use Excel to build tables, analyses and charts quickly, let Word draft reports, and speed up slide creation.

Hands-on course covering Copilot and other AI tools for Excel, Word and PowerPoint, focused on data, text and visuals. Learn prompt design, automation and verification so AI becomes a reliable assistant that saves hours weekly.

Location, current course term



Brno + online (volitelně)
1/12/2026 - 1/13/2026 CZECH
Order 		3/9/2026 - 3/10/2026 CZECH
Order 		5/4/2026 - 5/5/2026 CZECH
Order
Praha + online (volitelně)
12/8/2025 - 12/9/2025 CZECH
Order 		2/2/2026 - 2/3/2026 CZECH
Order 		3/30/2026 - 3/31/2026 CZECH
Order
Custom Customized Training (date, location, content, duration)

The course:

Hide detail
  • Introduction to Artificial Intelligence
    1. What is AI
    2. How AI works and available tools for Excel, Word and PowerPoint
  • MS Copilot in Excel
    1. Introduction to Copilot in Excel
    2. What tasks it can solve and where it helps
    3. Practical usage scenarios for Copilot in Excel
    4. Creating a pivot table using AI
  • Using other AI tools to support Excel work
  • Working with data and formulas
    1. Data processing and generating formulas and functions
    2. How to generate a quick table from a prompt
    3. Designing a macro with AI and using it in Excel
    4. Optimizing existing formulas
  • Data analysis
    1. Predictive analysis and forecasting
    2. Deep data exploration in Excel
  • Reports and visualizations
    1. Creating charts with AI
    2. Visualizing data using AI tools
  • MS Copilot in PowerPoint
    1. Introduction to Copilot in PowerPoint
    2. What tasks it can solve and where it helps
    3. Practical usage scenarios for Copilot in PowerPoint
  • Using other AI tools to support PowerPoint work
  • Generating and creating presentations
    1. Generating an outline from a short brief
    2. Converting a text document (Word, notes) into a presentation
    3. Quickly generate a presentation with Gamma and then edit it in PowerPoint
    4. Generate or rework a presentation using other AI tools
  • Working with content and visuals
    1. Generating a presentation from a table using ChatGPT
    2. Quickly create engaging images for slides
    3. Generate a short humorous comic for a presentation
  • Edits and automation
    1. How to edit an image using AI for presentations
    2. Have AI prepare images for presentation use
    3. Generate slide text using AI
    4. Edit all slides in a presentation using a macro
  • Effective use of AI tools
    1. How to quickly get a summary from a presentation and overview
    2. How to generate a video for a presentation
  • MS Copilot in Word
    1. Introduction to Copilot in Word
    2. What tasks it can solve and where it helps
    3. Practical usage scenarios for Copilot in Word
  • Using other AI tools to support Word work
  • Creating and editing texts
    1. Have AI write an interesting article
    2. Have AI write an article in a humorous style
    3. Write a macro with AI to help with Word text work
  • Working with documents
    1. Quickly find information in a document
    2. Create a summary from a document
    3. Fix grammar in a document
    4. Dictate text into a document
  • Improvements and translations
    1. Ask AI to suggest edits for an article or text
    2. Translate a document
    3. Have a document read aloud in Word
  • Reports and sources
    1. Quickly create a report
    2. Search for citations and sources with AI assistance
  • Additional effective uses of AI tools with Excel, Word and PowerPoint
  • Practical AI usage scenarios
    1. Dictate a prompt to AI instead of typing
    2. Ask AI to write a step-by-step procedure for Excel, Word or PowerPoint
    3. Learn Excel, Word and PowerPoint quickly using study features
    4. Avoid repeating the same instructions to AI and work more efficiently
  • Verification and updates
    1. Verify current formula syntax with AI
    2. Check for news and updates for Excel, Word and PowerPoint
  • Managing many documents with AI (NotebookLM)
    1. Convert documents to PDF and query their content with AI
    2. Create an audio recording from a document
    3. Prepare notes from a document
    4. Create a quiz from a document
    5. Quickly extract information from multiple documents with citations
Assumed knowledge:
Basic knowledge of MS Word, Excel and PowerPoint.
Schedule:
2 days (9:00 AM - 5:00 PM )
Course price:
344.00 € ( 416.24 € incl. 21% VAT)
Language: