Duration: 8 hours
Skills You’ll Gain:
Basic handling of cells and worksheets
Inserting and managing images and other objects
Using Find & Replace within the workbook
Understanding and interpreting data types (number, text, date)
Basic formatting of numeric and text cells
Sorting and filtering data
Page setup and creating print-ready views
Confident use of cell references
Applying basic functions (e.g., SUM, AVERAGE, COUNT, IF)
Efficient data entry and using AutoFill
Identifying and correcting common errors
Practical Outcomes:
Create clear, structured, presentation-ready spreadsheets
Perform calculations and data analysis independently
Speed up daily tasks with accurate, organized data
Prepare Excel documents ready for printing or sharing
Duration: 6 hours
Skills You’ll Gain:
Preparing source data for pivot tables
Creating and managing pivot tables
Sorting, filtering, and grouping pivot table fields
Inserting and using calculated fields
Grouping dates and numeric data
Creating pivot charts
Refreshing and maintaining pivot tables
Practical tips for effective pivot table use
Practical Outcomes:
Quickly summarize and analyze large datasets
Create clear, fast, presentation-ready reports
Analyze data by period, category, or owner
Refresh pivot tables independently with new data
Duration: 6 hours
Skills You’ll Gain:
Choosing the right chart type for different data sets
Creating column, line, bar, pie, and combination charts
Building and customizing pivot charts
Formatting charts (colors, labels, axes, legends)
Creating dynamic charts that adapt to data changes
Visualizing time-based and category-based data
Managing and maintaining charts
Practical tips for clear, easy-to-read, and uncluttered charts
Practical Outcomes:
Presenting data visually in a clear and efficient way
Creating presentation-ready, management-friendly charts
Easily identifying trends, deviations, and proportions
Keeping charts up to date when new data is added
Duration: 4 hours
Skills You’ll Gain:
Independently solve typical Excel interview tasks
Create pivot tables and charts in an interview scenario
Apply commonly used functions while solving tasks
Clean and prepare data for test exercises
Implement simple efficiency-boosting solutions under time pressure
Practical Outcomes:
Approach Excel-based interviews with confidence
Solve tasks faster and in a more structured way
Understand what the interviewer is really looking for
Reduce stress and maintain control during tests
Duration: 6 hours
Skills You’ll Gain:
Keyboard shortcuts and key combinations
Format Painter and conditional formatting
Flash Fill and pattern-based data recognition
Efficient use of pivot tables
Data validation and dynamically expanding drop-down lists
Use of modern Excel functions and dynamic arrays
Error handling and data-checking techniques
Practical Outcomes:
Significantly faster work with fewer manual steps
Fewer errors in data entry and analysis
Clearer, more stable, and easier-to-maintain spreadsheets
Semi-automated Excel solutions without macros
Duration: 6 hours
Skills You’ll Gain:
Text functions for automation
Fast data cleaning using formulas and built-in tools
Automatic text and status outputs
Advanced use of conditional formatting
Automatic highlighting of errors, deviations, and critical values
Refreshing pivot tables and pivot charts when data changes
Using dynamically expanding ranges for analyses and reports
Data validation to prevent incorrect or missing data entry
Practical Outcomes:
Creating semi-automated tables that react to data changes
Automatic alerts, warnings, and status indicators
Fewer errors and shorter review time by reducing manual work
Quick refresh of reports and analyses after loading new data
Duration: 8 hours
Skills You’ll Gain:
Review of core Excel functions closely tied to advanced analysis
Complex formulas and logical solutions
Dynamic arrays and new Excel functions
Advanced cell formatting and custom number formats
Conditional formatting at an advanced level
Data cleaning and preparation for analysis
Practical tips for effective pivot table use
Building dynamic dashboards
Data validation for error-free entries
Formula auditing and error handling
Additional advanced Excel capabilities
Practical Outcomes:
Create professional, interactive dashboards that summarize data at a glance
Ensure faster, error-free data entry and reporting
Quickly identify and fix formula issues, preventing mistakes
Apply advanced Excel techniques to streamline and automate analyses
Duration: 4 hours
Skills You’ll Gain:
Quick navigation of Word interface, ribbons, and toolbars
Basic file management: open, save, close
Text and paragraph formatting, applying styles
Tabs, bullet points, numbering, and simple sorting
Inserting and arranging images, objects, and symbols
Creating and editing basic tables
Find, replace, and quick navigation within documents
Print settings and page layout management
Practical Outcomes:
Create fast, organized, error-free documents
Format and edit text efficiently using shortcuts
Use simple tables and basic functions in everyday work
Arrange images and objects professionally for presentation-ready materials
Duration: 4 hours
Skills You’ll Gain:
Navigating the PowerPoint interface, ribbon, and Quick Access Toolbar
Creating, saving, and managing presentations
Adding and formatting slides and text
Applying themes, layouts, and basic styles
Inserting and arranging images, shapes, icons, and SmartArt
Creating and customizing charts for simple data visualization
Using transitions and basic animations
Preparing presentations for printing or sharing
Practical Outcomes:
Quickly create professional, presentation-ready slides
Efficiently format objects and text
Support storytelling with visual design
Confidently produce presentations for meetings, pitches, or training