Microsoft Office Trainings

Discover our educational content

Microsoft Excel

By learning short and practical ways with Microsoft Excel training, you will discover how to work efficiently and quickly in your business processes.

Basic Excel Training

2 Days

You will be able to have all the basic knowledge of Excel. By receiving training on familiarizing yourself with the interface and mastering the main logic of Excel, you will be able to easily make calculations in your business life and make the most of your time.

Module 1: Introduction
Module 2: Cell Operations
Module 3: Page Operations
Module 4: Page Layout and Print Settings
Module 5: Table Format
Module 6: Basic Data Analysis
Module 7: Conditional Formatting
Module 8: Pivot Table
Module 9: Formulas (Functions)
Module 10: Graphics

Intermediate Excel Training

2 Days

With this training, you will take your Excel use to a professional level. In our Intermediate-Advanced Training, you will specialize in shortcuts, complex analyzes and reporting that increase your productivity.

By taking the art of Data Analysis, Pivot Table reporting and formula writing to the next level, you will gain the ability to use Excel to its full potential, thanks to conditional formatting, data validation and other powerful features.

Module 1: Introduction
Module 2: Cell and Page Operations
Module 3: Data Analysis
Module 4: Pivot Table
Module 5: Conditional Formatting and Data Validation
Module 6: Protection, Security and Sharing
Module 7: Formulas (Functions)
Module 8: Graphics
Module 9: Page Layout and Print Settings

Advanced Excel Training

2 Days

Thanks to this training, you will be able to establish a closer and more efficient collaboration with Excel and reach an advanced level in data analysis, reporting and problem solving. You will easily create Excel formulas, analyze your data and discover new dimensions of reporting.

Module 1: Introduction
Module 2: Cell and Page Operations
Module 3: Data Analysis
Module 4: Pivot Table
Module 5: Conditional Formatting
Module 6: Data Validation
Module 7: Security and Sharing and Collaboration
Module 8: Formulas (Functions)
Module 9: Graphics

Expert Excel Training

2 Days

By understanding all the Excel functions, features and intended uses you need, you will be able to find the right solution whenever you need it. You will be able to benefit from all the possibilities of Excel, from data analysis to visualization, from macros to VBA programming. With the use of advanced formulas and expressions, you will reach the level of making complex calculations specific to your problems. By mastering Pivot Tables, Data Models, chart types and visualization techniques, you will be able to prepare impressive reports and analyses.

Module 1: Productivity and Data Analysis
Module 2: Pivot Table
Module 3: Dynamic Format, Validation and Display
Module 4: Advanced Formula Techniques and Sequence Formulas
Module 5: Dynamic Operations with Data Visualization and Form Tools
Module 6: Dynamic Operations with Macros

Excel Macro Training

4 Days

This training; It will allow you to further expand the power of Excel with the VBA programming language. You will be able to facilitate features such as user-friendly interfaces, smart formulas, data validation rules and automatic reporting by coding them. You will be able to increase your productivity by automating repetitive tasks and time-consuming processes.

Module 1: Macros Overview
Module 2: Getting to Know the Visual Basic for Applications (VBA) Window
Module 3: Operators
Module 4: Getting to Know Procedures
Module 5: VBA Programming Structures
Module 6: Introduction to Programming with Excel
Module 7: Error Checking
Module 8: Functions (KTF)
Module 9: User Form and Features
Module 10: VBA Sample Applications
Module 11: Excel Database Operations

Training on Retrieving Data from the Web with Excel

3 Days

With the Training on Importing/Sending Data from the Web with Excel, you will be able to perform analyzes by quickly pulling data from your local websites into Excel.

Module 1: Introduction to Education
Module 2: Understanding and Using Dom Document Elements
Module 3: Internet Explorer Object
Module 4: Form and Login Procedures
Module 5: Managing Website Status Events
Module 6: Standard VBA Information
Module 7: Data Extraction Procedures
Module 8: Image and PDF Transactions
Module 9: XML DomDocument

Dashboard Excel Training

2 Days

By specializing in data visualization and reporting; You will be able to support decision makers more effectively and gain a competitive advantage. You'll be able to visualize your data with clear charts, pivot tables, maps and diagrams.

Module 1: What is Dashboard?
Module 2: Excel Functions to Use
Module 3: Table Structures and Slicers
Module 4: Interactive Modeling Process
Module 5: Creating and Using Graphics
Module 6: Creating and Understanding a Dataset
Module 7: Report Domination with Form Controls and ActiveX
Module 8: Graphic Modeling Frequently Used in Dashboards
Module 9: A Sample Dashboard Project

Microsoft Word

Behind every powerful document lies the best use of Word. With Word training, you will gain all the knowledge and skills you need to produce critical content in the fastest, most efficient and effective way. By making effective use of tables, images, figures and other visual elements, you will enrich your documents, strengthen your arguments and influence readers more deeply.

Basic Word Training

1 Days

With basic Word training, you will be able to work on your documents quickly. You will be able to enrich your content by adding graphics and visual shapes.

Module 1: Word Overview
Module 2: Document Control
Module 3: Formatting Procedures
Module 4: Version Management and Text Operations
Module 5: Ensuring Document Accuracy
Module 6: Working with Tables
Module 7: Adding Graphical Objects
Module 8: Print Settings

Advanced Word Training

2 Days

You will be able to make your content look more professional by enriching your texts with advanced document techniques.

Module 1: Defining and Applying Styles
Module 2: Advanced Document Techniques
Module 3: Letter Labels and Envelope Printing
Module 4: Working with Templates
Module 5: Customizing Word
Module 6: Collaboration
Module 7: Document Protection and Tracking
Module 8: Working with Graphical Objects
Module 8: Exchanging Data with Other Programs
Module 8: Print Settings
Module 8: Version Management and Text Operations

Microsoft PowerPoint

With PowerPoint training, you will have all the knowledge and skills you need to make your presentations more effective. You will be able to easily attract the attention of your readers and listeners with strong headings, subheadings, punctuation marks and page layout. By using techniques such as animation, transition effects and timing; You will be able to create a more professional, memorable presentation experience. By using visuals effectively, you will be able to strengthen your narratives and influence your audience more deeply.

Basic PowerPoint Training

1 Days

With this training, you will learn the rules to be considered in presentations and you will be able to add visual, audio or graphic objects.

Module 1: Introduction
Module 2: Creating a New Presentation
Module 3: Watching Presentations
Module 4: Slide Essentials
Module 5: Advanced Report Options
Module 6: Working with Pictures and Shapes
Module 7: Working with Audio and Videos
Module 8: Working with Tables
Module 8: Outline

Advanced PowerPoint Training

2 Days

You will be able to impress yourself with your presentations by discovering the rich features of PowerPoint. Now you will be able to design unique presentations with effective animations and interesting effects.

Module 1: Working with Animations
Module 2: Duplicating and Editing Presentations
Module 3: Managing Presentations
Module 4: Working with Graphics
Module 5: Word Art & Smart Art
Module 6: Working with Templates, Slide Masters
Module 7: Advanced Presentation Options
Module 8: Saving the Presentation for Different Digital Media
Module 9: Collaboration
Module 10: New Features Coming to Office 2016 and Office 365

Microsoft Outlook

In our trainings where you will learn how to use Microsoft Outlook's Mail, Calendar, Contacts, Tasks and Notes, you will be able to use your Outlook as an assistant. You'll discover Outlook's capabilities for your business planning, meeting management, appointment tracking and more.

Basic Outlook Training

1 Days

You will be able to easily learn how to perform your e-mail transactions using Outlook.

Module 1: First E-Mail Transactions
Module 2: Formatting Emails
Module 3: Using the People Section
Module 4: E-Mail Message Options
Module 5: Management of Emails
Module 6: Printing Email Messages
Module 7: Managing Contacts
Module 8: Creating a List of Tasks
Module 8: Organizing a Meeting

Advanced Outlook Training

2 Days

With this training, you will be able to add or categorize reminders for yourself in Outlook to use your time more efficiently.

Module 1: E-Mail Transactions
Module 2: Editing Message Options
Module 3: Archive Options
Module 4: Editing Calendar Options
Module 5: Monitoring RSS
Module 6: Task Management
Module 7: Using Personal Folders
Module 8: Managing Contacts
Module 9: Creating a List of Tasks
Module 10: Organizing a Meeting

Microsoft Teams

With Microsoft Teams training, you will discover the easiest methods to manage your business processes under one roof, collaborate in common work areas, and work more efficiently.

Microsoft 365 Training

1 Days

Teams Cloud Storage (OneDrive, SharePoint overview)
Accessing Old Versions of Collaborated Files
Forms Training, Live Demo and Teams Integration (Form Creation, Personalization, Settings, Use within Teams)
Planner Training, Live Demo and Teams Integration (Creating a Plan, Assigning Tasks, Filtering, Reporting, Transferring Tasks to Outlook, Exporting to Excel)
OneNote Training, Live Demo and Teams Integration

Teams Training – All Levels

1 Days

Receiving and filtering notifications from the “Activity” panel
Communication from the “Chat” panel, sending urgent/important messages, organization chart
File sharing and file collaboration experience
Teams/Channels, team types and scenario-based explanation (At this stage, people in training will be included in the team and an interactive training will be started.)
Add Microsoft Office apps as tabs to Teams (Forms, Planner, Excel overview)
Creating a meeting and things that can be done during the meeting (Background changing, creating meeting notes, Whiteboard feature, recording the meeting, technical limitations, inviting participants at the time of the meeting, chat experience)
Overview of the “Files” panel
Search features and filtering, saving messages, translation features
Teams Settings overview

MICROSOFT 365 TRAININGS

Support your employees' careers with Microsoft Office certification programs