Course library

Gen Z’s strengths (technology, creativity, speed) and how to leverage them. Gen Z vocabulary. How to motivate Gen Z — purpose, flexibility, growth, and impact beyond the company first, money and benefits second. Giving feedback and assigning tasks. An interview with Lucie Ráčková (Forbes 30 Under 30).

4 leadership styles (directive, consultative, consensus-based, delegating) clearly explained, with guidance on when to use each. Consultation and consensus in practice. When it’s better to delegate, and to whom. Four interactive model situations with feedback.

Model situations set in a manufacturing environment (shipping hall, warehouse). 4 leadership styles (directive, consultative, consensus-based, delegating) clearly explained, with guidance on when to use each. Consultation and consensus in practice. When it’s better to delegate, and to whom.

The satisfaction pyramid: the factual, procedural, and personal levels. How to increase client satisfaction.

• Introduction to Microsoft 365
• Setting up Microsoft 365
• Microsoft 365 on mobile devices

• Introducing Microsoft Copilot AI
• Copilot AI in Microsoft Word
• Copilot AI in Microsoft Excel
• Copilot AI in Microsoft PowerPoint
• Copilot AI in Microsoft Outlook
• Copilot AI in Microsoft Teams
• Agents in Microsoft Copilot

Chapter 1: Getting to know MS Access

• MS Office versions – boxed vs. 365 vs. online
• Getting around the MS Access environment
• View options
• Basic environment settings

Chapter 2: Access basics

• Parts of MS Access
• What is a DB
• DB design rules
• Primary and foreign keys

Chapter 3: Tables

• Creating tables and entering data
• View types and working with them
• Table design
• Data types and their options

Chapter 4: Queries

• Relationships
• Creating a query
• Query types
• Advanced queries

Chapter 5: Forms

• Creating a form
• View types
• Editing forms
• Subforms

Chapter 6: Reports

• Creating a report
• View types
• Editing reports

Chapter 7: Macros

• Creating a macro

Chapter 8: Code

• Writing VBA code

• Advanced formatting (preserving, clearing, and conditional formats, custom formats)
• Extended copy and paste
• Formulas – principles and relative/absolute references
• Selected functions – logical, text, date, math, conditional calculations
• Protecting worksheets and workbooks
• Working with databases – smart tables, sorting, filters, text to columns
• PivotTables and PivotCharts
• Microsoft Copilot in Excel

Chapter 1: Forms

• Form controls
• Source data for form controls
• Formulas for forms
• Form security
• Data protection
• Inserting objects from other applications
• Linking controls to macros

Chapter 2: Introduction to macros

• Recording a macro
• Running a macro
• Editing a macro
• Assigning a macro to an object

Upon completion, participants will be able to:

Create, set up, and edit forms in MS Excel.

• Differences between recording and programming macros
• Relative and absolute recording with usage examples
• Running macros via keyboard shortcuts, buttons, and toolbars
• VBA Editor – navigating the code, branching, and conditions
• Creating custom functions and their limitations
• User dialogs (MsgBox, InputBox)
• Handling runtime errors and macro security
• Sharing macros with users via PERSONAL.XLS

• Introduction to the cloud environment and Office 365 services
• Communication via Outlook Web App (email, calendar, contacts, tasks)
• Collaboration features in Teams
• Word, Excel, PowerPoint, and OneNote online apps
• OneDrive personal storage and file sharing
• Getting around SharePoint Online and document management
• Setting up document libraries, folder management, versioning, and external sharing
• Overview of other services

• Introduction to MS Outlook and the basics of the interface
• Creating and sending emails, message options, flags, categories, creating a signature
• Calendar events, meetings, rooms, resources, and shared calendars
• Creating contacts and distribution lists
• Assigning and tracking tasks
• User rules, Automatic Replies (Out of Office), Quick Steps
• Delegation and access permissions
• Mail security, digital signatures, and encryption
• MS Exchange profile configuration and data archiving
• Public folders

Day 1 – Architecture and data model:

• Power BI ecosystem, workflow, connectors, navigator
• Power Query transformations, data cleansing, unpivot, merging
• Data modeling, relationships, dimensions, fact table, star schema
• Basic DAX, calculated columns vs. measures, aggregations, filter context

Day 2 – Analysis, visualization, and distribution:

• CALCULATE function, time intelligence, VAR/RETURN
• Storytelling, choosing charts, interactivity, formatting
• Slicers, filters, drill-through, tooltips
• Publishing, dashboards, Row-Level Security, data refresh

Chapter 1: Getting to know MS PowerPoint

• Difference between MS Office on-premises and MS Office 365
• Getting around the MS PowerPoint environment
• View options
• Basic environment settings
• Basic file types
• Launching and closing, creating a new presentation

Chapter 2: Working with text

• Outline and its advantages
• Text boxes
• Text formatting
• Lists in text boxes

Chapter 3: Working with pictures and other graphic objects

• Inserting pictures from a file
• Clip art
• Editing pictures
• Tables and charts
• Diagrams

Chapter 4: Working with multimedia

• Audio
• Video
• Photo album

Chapter 5: Unifying the presentation

• Replacing fonts
• Headers and footers, slide numbers
• Themes and masters
• Presentation template

Chapter 6: Preparing the presentation for display

• Slide transitions
• Object animations
• Slide timing

Chapter 7: Printing the presentation

• Printing individual slides
• Printing handouts
• Printing notes

Chapter 8: Exporting the presentation

• Saving to PDF and exporting slides
• Packaging the presentation for CD

Upon completion, participants will be able to

• Navigate the MS Office PowerPoint environment
• Create, save, and open presentations
• Insert and work with text, graphic, and multimedia objects
• Create a consistent look and presentation templates using themes and masters
• Set slide transitions and object animations
• Copy slides between presentations, adapting the design to either one
• Prepare handouts for printing presentations
• Export presentations to other formats

• Getting to know Microsoft Teams
• Teams and channels in Microsoft Teams
• Organizing meetings in Microsoft Teams
• Attending a meeting in Microsoft Teams
• Collaboration and sharing in Microsoft Teams
• Apps and extensions in Microsoft Teams

• Introduction to MS Teams (versions, interface, view options, settings)
• Teams basics – permissions, user types, data sharing
• Chat and personal messages
• Creating teams, managing members, team settings, and team chat
• Calendar, viewing events, and organizing meetings
• Calling – making calls, view options, adjustments
• Sharing files via OneDrive and SharePoint, managing permissions
• Other tools and service integrations

• Chapter 0 – Knowledge alignment: basic work with documents, typing rules, inserting objects
• Chapter 1 – Text formatting adjustments: keeping/copying/clearing formatting, tabs, indentation
• Chapter 2 – Working with styles and templates: existing styles, custom styles, copying, templates
• Chapter 3 – Reusing objects: AutoText, custom headers/footers, Quick Parts
• Chapter 4 – Working with tables: creating, formatting, converting, sorting, repeating rows
• Chapter 5 – Numbered items: notes, cross-references, captions, lists, table of contents, index
• Chapter 6 – Editing longer documents: find, sections, columns, revisions, translation
• Chapter 7 – Mail merge: envelopes, labels

• Getting around MS Word and setting up the environment
• Working with files (creating, saving, opening, searching)
• Basics of working with documents and text
• Formatting text and paragraphs – fonts, paragraphs, bullets, numbering
• Inserting objects (pictures, shapes, SmartArt, equations, symbols)
• Page layout, spell checking, and print preparation
• Introduction to styles, headers and footers, page numbering

• Knowledge alignment: text formatting rules, style basics, Quick Parts, building blocks, sections
• Outline view: outline tools, subdocuments, master documents, formatting large documents
• Special headers and footers: AutoText in headers, chapter-based headers, multi-section documents
• Special templates: color schemes, preparing building blocks, form fields, document automation
• Workshop: assistance with participants' own templates and documents

• Sparklines
• Creating charts
• Chart design
• Chart formatting
• Screenshot and Screen Clipping
• Shapes
• SmartArt
• Themes
• Spell check
• Track Changes
• Notes and comments
• Arranging windows
• Splitting a workbook with split panes
• Workbook views
• Headers and footers
• Page Setup
• Microsoft account
• Workbook properties
• Workbook protection
• Inspecting a workbook
• Version management
• Using templates
• Compatibility
• Sharing a workbook
• Introduction to macros
• Recording a macro
• Editing a macro
• Macro security
• Digitally signing macros