Microsoft Office Training in Belgrade

This instructor-led, live training in Belgrade (online or onsite) is aimed at This instructor-led, live training (online or onsite) is aimed at beginner-level to intermediate-level business professionals, educators, and marketers who wish to integrate DeepSeek with PowerPoint to automate and optimize their presentations.

By the end of this training, participants will be able to:

• Automate the creation of text-based content in PowerPoint slides using DeepSeek.
• Generate data-driven visuals and infographics powered by DeepSeek models.
• Use AI to summarize long reports and turn them into presentation-ready slides.
• Integrate DeepSeek with PowerPoint for streamlined, dynamic presentations.

Excel is a spreadsheet application designed for data entry, analysis, reporting, and automation.

This instructor-led, live training (available online or onsite) is tailored for users ranging from beginners to advanced levels who want to build confidence and proficiency in using Excel’s essential, intermediate, and advanced features.

Upon completing this training, participants will be equipped to:

• Work confidently with spreadsheets, formulas, and formatting techniques.
• Utilize intermediate tools such as tables, charts, and conditional logic effectively.
• Apply advanced functions, data analysis features, and automation methods.
• Create professional worksheets that support informed business decision-making.

Format of the Course

• Instructor-led demonstrations and guided explanations to ensure clear understanding.
• Extensive workbook exercises and hands-on practice to reinforce learning.
• Practical lab activities using real-world spreadsheet scenarios for practical application.

Course Customization Options

• For a customized version of this course tailored to your department’s specific workflows, please contact us to arrange the necessary adjustments.

This instructor-led, live training in Belgrade (online or onsite) is aimed at beginner-level to intermediate-level professionals who wish to master Microsoft Word, Excel, and PowerPoint for enhanced document creation, data analysis, and presentations.

By the end of this training, participants will be able to:

• Effectively create, format, and manage documents in Microsoft Word.
• Utilize Excel for data entry, analysis, and visualization.
• Design engaging and professional presentations in PowerPoint.
• Leverage collaboration features across Microsoft Office applications.

This instructor-led, live training in Belgrade (online or onsite) is aimed at anyone who wishes to learn and use the software and services available in the MS Office suite to enhance their work productivity.

By the end of this training, participants will be able to:

• Learn and use the different software in the MS Office suite.
• Enhance work productivity and collaborate effectively using MS Office tools and services.

This instructor-led, live training in Belgrade (online or onsite) is aimed at beginner-level to advanced-level data analysts who wish to use Excel to perform a variety of tasks such as data entry, formula creation, data analysis, and advanced automation.

By the end of this training, participants will be able to:

• Navigate Excel’s interface and perform basic data entry, formatting, and calculations.
• Apply advanced formulas, functions, and conditional formatting for data analysis.
• Create and manage pivot tables and charts for data visualization.
• Use tools like Power Query, Power Pivot, and perform data analysis.
• Automate tasks using macros and VBA to streamline workflows.

This instructor-led, live training in Belgrade (online or onsite) is aimed at MS Office users who wish to master the different tools and techniques of MS Office software and services.

By the end of this training, participants will be able to:

• Learn and master the different shortcut techniques in MS Office.
• Master macros and other Excel functions for faster worksheet manipulation.
• Use PowerPoint controls and advanced features for creating presentations.
• Quickly navigate and search through Outlook.

Microsoft Word is a robust word-processing application used for creating, formatting, and managing professional documents.

This instructor-led, live training (available both online and onsite) is designed for users ranging from beginners to advanced levels who want to develop comprehensive skills in creating, editing, formatting, and automating documents using Microsoft Word.

Upon completing this course, participants will be able to:

• Create professional documents with consistent formatting.
• Utilize intermediate features such as styles, templates, and collaboration tools.
• Apply advanced tools including mail merge, references, and automation.
• Enhance productivity by leveraging Word’s advanced layout and document management capabilities.

Format of the Course

• Engaging demonstrations and guided instruction.
• Extensive practical exercises and skill-building tasks.
• Real-time document creation and refinement in a live environment.

Course Customization Options

• If you need a customized version of this training, please contact us to discuss your specific requirements.

This instructor-led, live training in Belgrade (online or onsite) is aimed at anyone who wishes to master the fundamentals and features of Microsoft Word to become more productive at work.

By the end of this training, participants will be able to:

• Learn the basics of Microsoft Word to best support daily workday responsibilities for meeting notes, memos, etc.
• Work with different formatting features.
• Manage document collaboration.

The course participants will be able to effectively utilize primary data analysis tools like scenarios and pivot tables, leverage features for performing calculations on dates and text processing functions, and develop and customize macros to automate spreadsheet tasks according to their needs.

This course is designed for students who already possess a basic working knowledge of PowerPoint 2019 and are looking to explore its advanced features. The focus is on enhancing usability, ensuring robust security, fostering effective collaboration, and optimizing the distribution of presentations.

Excel is a popular spreadsheet program created by Microsoft. Jest used to store, organize and analyze data in tabular form. Here are some key features and functions of Excel: 1. Spreadsheets: It consists of sheets, where each sheet is an array consisting of cells arranged in rows and columns. It allows you to create multiple sheets in one file, which allows you to organize different data sets. 2. Calculations and Formulas: Allows you to perform a variety of mathematical, statistical and logical calculations using formulas. It has a wide set of built-in functions such as SUM, AVERAGE, MAX, MIN, IF, VLOOKUP, etc. 3. Data Formatting and Appearance: Provides tools for formatting data, including changing font, color, style, and creating charts, pivot tables and diagrams. 4. Sorting, Filtering and Grouping: Allows you to sort data according to specific criteria. Allows you to filter data to display only selected information. Possibility to group data depending on needs. 5. Data analysis: Tools for performing advanced analyzes such as scenario analysis, trends, forecasting, and creating macros. 6. Data Sharing: Enables real-time data sharing and collaboration, allowing multiple users to work on the same data simultaneously. 7. Task automation: Ability to create macros and automate tasks using the programming language VBA (Visual Basic for Applications). Excel is widely used in various fields, from business to science and education. Its comprehensive features enable data analysis, creation of reports, budgets, schedules, data management and many other applications.

This instructor-led, live training in Belgrade (online or onsite) is aimed at data analysts who wish to use advanced VBA in Excel for automating tasks.

By the end of this training, participants will be able to:

• Write an advanced object-oriented application
• Convert text files
• Use of external data sources
• Use external libraries

This instructor-led, live training in Belgrade (online or onsite) is aimed at data analysts who wish to use VBA in Excel for automating tasks.

By the end of this training, participants will be able to:

• Record and edit macros as required.
• Write procedures using data from the sheet.
• Create your own functions.
• Handle an event (opening worksheet cell update etc.) by means of the handler.
• Create a form.

This instructor-led, live training in Belgrade (online or onsite) is aimed at data analysts who wish to use VBA in Excel for automating tasks.

By the end of this training, participants will be able to:

• Record and edit macros as required.
• Write procedures using data from the sheet.
• Create your own functions.
• Handle an event (opening worksheet cell update etc.) by means of the handler.
• Create a form.

Data analytics plays a vital role in today's business environment. Throughout the course, we will concentrate on building practical skills for hands-on data analysis. The goal is to assist participants in providing evidence-based answers to key questions:

What has happened?

• processing and analyzing data
• creating informative data visualizations

What will happen?

• predicting future performance
• assessing the accuracy of forecasts

What should happen?

• transforming data into evidence-based business decisions
• optimizing processes and operations

The participants of the course will be able to perform various calculations efficiently and transparently, organizing and presenting their results effectively. They will also utilize multiple tools to streamline and speed up the creation of spreadsheets in Excel.

This instructor-led training (online or on-site) is designed for data analysts looking to leverage Excel for data analysis purposes.

By the end of this training, participants will be able to:

• Create spreadsheets using Excel.
• Visualize data through charts and graphs.
• Produce reports for sharing with team members.

Course Format

• Interactive lectures and discussions.
• A wealth of exercises and practice sessions.
• Hands-on implementation in a live-lab setting.

Customization Options for the Course

• To arrange a customized training session, please contact us to make arrangements.

During the training, we will explore financial analysis using the advanced features of Excel.

This course is designed for financial analysts, accountants, and anyone looking to enhance their spreadsheet skills in the realm of financial analysis.

This live instructor-led training (onsite or remote) will guide you through the most important tools of MS Excel. A combination of comprehensively prepared training materials and the expertise of the instructor will demonstrate the vast possibilities of excel spreadsheet use.
In compartision to other typical excel courses, this tarining will uncover many uniqe excel functionalities that will speed up and enhance your work.

Audience

Financial analysts, market analysts, managers, and accountants

Course Objectives

To streamline and automate various types of financial analysis using Microsoft Excel

This instructor-led live training (held either onsite or remotely) will walk you through the key aspects of Excel VBA. Through meticulously prepared materials and the instructor's expertise, you'll see how powerful task automation with VBA can be.

Course Format

• Interactive lectures and discussions.
• Practical implementation in a live lab environment.

Customization Options for the Course

• If you need a tailored training session, please reach out to us.

Course participants will learn how to create visually appealing and professional-looking documents using Microsoft Word. They will also gain the skills to efficiently perform a variety of calculations in a clear and organized manner, presenting their results effectively. Additionally, they will explore multiple mechanisms to streamline and speed up the creation of spreadsheets in Excel.

Upon finishing this course, you will be capable of creating and developing Excel worksheets and workbooks, enabling you to start analyzing important business data.
This course equips you with the ability to:

• Execute a variety of basic Excel commands
• Carry out worksheet calculations
• Create custom formulas
• Edit elements within a worksheet
• Apply formatting changes to cells
• Handle workbook properties

This 1 day course is designed for information workers who are using or will use Office 365. This course will provide students with the knowledge and skills to efficiently use Office 365 on a day-to-day basis. The course is designed with real world scenarios in mind. Students will learn how to use Outlook Online, Skype for Business, OneDrive for Business, SharePoint Online, and OneNote. At the end of this course students will be able to effectively navigate Office 365 and make use of all of the features of Office 365.

Welcome to Microsoft® Project® 2019/2021: Part 1. This course is designed to introduce you to the essential features and functions of Microsoft Project, enabling you to use it effectively and efficiently in practical scenarios. The course focuses on the crucial knowledge and skills required by a project manager to create a project plan using Project during the planning phase. In essence, if your supervisor assigns you to lead a project, this course will equip you with the ability to draft a comprehensive project plan using Microsoft Project and share it with your supervisor (and others) for review and approval.

Learning Objectives

By the end of this course, you will be able to construct basic project plans using Microsoft Project.

• You will:
• Understand project management concepts and navigate through Microsoft Project Professional.
• Create a new project plan.
• Add tasks to your project.
• Manage task relationships within the project.
• Manage project resources effectively.
• Finalize and complete a project plan.

Learning Objectives

In this course, you will acquire essential Word skills.

• You will:
• Navigate and execute common tasks in Word, such as opening, viewing, editing, saving, and printing documents, as well as customizing the application settings.
• Apply formatting to text and paragraphs.
• Perform repetitive operations more efficiently using tools like Find and Replace, Format Painter, and Styles.
• Enhance lists by sorting, renumbering, and personalizing list styles.
• Create and format tables to organize data effectively.
• Insert various graphic elements into a document, including symbols, special characters, illustrations, pictures, and clip art.
• Customize the overall appearance of a page through features such as page borders and colors, watermarks, headers and footers, and layout adjustments.
• Utilize Word's built-in tools to identify and correct issues related to spelling, grammar, readability, and accessibility.

TARGET AUDIENCE

This course is designed for students who aim to master basic Word 2019 skills, such as creating, editing, and formatting documents; inserting simple tables and lists; and using various techniques to enhance the appearance and accuracy of document content.

The course participants will be able to efficiently carry out a range of calculations in a clear and transparent manner, organize and present their results effectively, utilize various tools to streamline and speed up the creation of spreadsheets, and safeguard their calculations and results from unauthorized access.

Participants will have the opportunity to excel by creating, consolidating, and managing data in the most efficient manner. Various tools are designed to streamline workflows, significantly reducing the time required for tasks that were previously more cumbersome. These tools can also assist in designing applications capable of performing new and innovative tasks.

Course participants will learn how to create clear, professionally formatted documents, including all types of official correspondence. They will also gain a thorough understanding of the fundamental mechanisms that ensure the transparent flow of information in both brief and extensive documents.

Course participants will gain skills in automating the creation of complex documents, extracting data from databases, and preparing forms.

This course is designed for individuals who are already acquainted with the fundamentals of VBA and wish to expand their understanding and make more extensive use of the language's capabilities.

This training is designed for individuals who work with Microsoft Excel spreadsheets and are looking to enhance their skills and efficiency.

This course is tailored for users of Excel who are looking to create analyses and reports.

Please answer the following questions:

• Is your daily work in Excel an endless series of copy-paste commands?
• Are you wasting time on repetitive operations to prepare data for analysis?
• Do you know all the keyboard shortcuts in Excel, yet still feel unsatisfied with the results?
• Instead of focusing on data analysis, are you spending your time on tedious preparation tasks?
• Do you have to manually verify the accuracy of data obtained from various systems?
• Are you staying late at work or taking Excel files home because you can't complete them during the day?
• Is your job to prepare reports based on large datasets?
• Do you feel that working in Excel is a roundabout way to achieve results?

If you can answer YES to any of these questions, then it's time to put an end to this frustration. This training is designed for you.

Discover how you can speed up your daily tasks and maximize the potential of MS Excel.

WARNING

After completing the training, your life will change dramatically. Activities that once took the whole day will now take just a few moments. Are you ready for this transformation?

This course is designed to enhance the PowerPoint skills of participants through practical exercises complemented by relevant theory. It is suitable for a wide range of individuals, particularly presentation designers, as well as conference speakers and those who frequently give presentations in team meetings.

This course is designed for individuals who want to enhance their efficiency in PowerPoint, particularly in creating slides and mastering the fundamentals of presenting them.

The course is designed for sales teams and emphasizes utilizing PowerPoint’s features to enhance the sales process. It covers topics such as presenting data effectively, avoiding cluttered slides, and identifying key elements to highlight in a sales presentation.

Objective:

Enhancing the ability to create engaging presentations using PowerPoint and other tools.

Addressees:

Sales representatives, consultants, researchers, educators, managers, teachers, corporate employees, small and medium-sized enterprises (SMEs), and public institutions who face the challenge of presenting to a group, capturing their interest, and effectively communicating their message.

This instructor-led, live training in Belgrade (online or onsite) is aimed at beginner-level to intermediate-level business analysts and data analysts who wish to use Excel to perform data analysis and reporting for their projects and tasks.

By the end of this training, participants will be able to:

• Use Excel formulas and functions to perform calculations and data manipulation.
• Use Excel data analysis tools such as PivotTables, What-If Analysis, and Forecasting to summarize and visualize data.
• Use Excel charts and graphs to create and customize data visualizations.
• Use Excel data validation and conditional formatting to ensure data quality and highlight data insights.
• Use Excel data import and export features to connect to external data sources and share data with others.

This course delves into the essential aspects of Microsoft 365 administration, including tenant management, identity synchronization, and security and compliance measures.

In the section on Microsoft 365 tenant management, you will learn how to set up your Microsoft 365 tenant, covering organizational profiles, subscription options, component services, user accounts and licenses, security groups, and administrative roles. You will also explore configuring Office client connectivity and managing user-driven installations of Microsoft 365 Apps for enterprise deployments.

The course then moves on to an in-depth look at Microsoft 365 identity synchronization, focusing on Azure Active Directory Connect and Cloud Sync. You will learn how to plan and implement these directory synchronization options, manage synchronized identities, and handle password management using multifactor authentication and self-service password management.

Next, you will explore the realm of Microsoft 365 security management. This section covers common threat vectors and data breaches organizations face today, and how Microsoft 365’s security solutions mitigate these risks. You will be introduced to tools like Microsoft Secure Score and Azure Active Directory Identity Protection, as well as how to manage services such as Exchange Online Protection, Safe Attachments, and Safe Links. The course also covers various reports that monitor an organization’s security health and introduces threat intelligence through Microsoft 365 Defender, Microsoft Defender for Cloud Apps, and Microsoft Defender for Endpoint.

After gaining a solid understanding of Microsoft 365’s security suite, the course transitions to compliance management. This includes an overview of data governance aspects such as data archiving and retention, Microsoft Purview message encryption, and data loss prevention (DLP). You will delve deeper into topics like insider risk management, information barriers, and DLP policies, and learn how to implement these features using data classification and sensitivity labels.

Explore the essentials of Office 365 Management, including a comprehensive overview of its key components, strategies for transitioning an organization to Office 365, methods for configuring Office 365, and techniques for managing Office 365 ProPlus deployments.

Audience profile

This course is tailored for individuals aiming to achieve the Microsoft 365 Enterprise Admin role and who have already completed one of the Microsoft 365 role-based administrator certification paths.

Skills gained

• Understanding Office 365 overview
• Strategies for moving an organization to Office 365
• Methods for configuring Office 365
• Techniques for managing Office 365 ProPlus deployments

In this course, students will gain the skills needed to plan and execute an endpoint deployment strategy using modern deployment techniques and update strategies. The curriculum introduces key aspects of contemporary management, including co-management approaches and integration with Microsoft Intune. It delves into app deployment, management of browser-based applications, and essential security concepts such as authentication, identities, access control, and compliance policies. The course also explores technologies like Azure Active Directory, Azure Information Protection, and Microsoft Defender for Endpoint to ensure the protection of devices and data.

Audience

This course is designed for individuals who already have a fundamental grasp of Microsoft® Office Outlook® and are looking to explore its advanced features. These features will help them manage their email communications, calendar events, contact information, search functions, and other communication tasks more effectively.

In this course, you will start crafting engaging and dynamic multimedia presentations using PowerPoint 2019.

This one-day training session is tailored for SharePoint power users who act as site owners and/or Site Collection administrators.

Course objectives:

• Set up site navigation
• Review site activity reports
• Customize lists and libraries
• Manage Site Columns and Site Content Types
• Configure check out/in, content approval, and versioning
• Create and edit pages and web part pages

This one-day training session is tailored for individuals who utilize SharePoint as end-users and wish to delve into some of the tool's advanced functionalities. Attendees should consider this course if they need insights into features like team collaboration, document management, and social aspects of Microsoft SharePoint 2013.

The course is designed for

• SharePoint Site Owners and Users

Course Objectives:

• To manage sites and site collections effectively
• To add users and groups, and handle security at the site, list, folder, and item levels
• To incorporate and configure web parts
• To customize site options such as theme, title, description, and icon

This instructor-led, live training in Belgrade (online or onsite) is aimed at IT administrators who wish to use Office 365 as an administrator.

By the end of this training, participants will be able to:

• Answer the most common end-user support requests.
• Troubleshoot start up and version compatibility issues.
• Backup and fix damaged files.

This instructor-led, live training in Belgrade (online or onsite) is aimed at financial analysts and staff who wish to use Adaptive OfficeConnect in creating financial reports using Microsoft Office Excel, Word, and PowerPoint.

By the end of this training, participants will be able to build, create, and update financial reports in Microsoft Office Suite.

TARGET AUDIENCE

This course is designed for individuals who already have a foundational knowledge of Microsoft® Windows® and are looking to learn how to effectively use Outlook as an email client. The course covers essential skills such as managing email communications, organizing calendar events, maintaining contact information, and handling other communication tasks.

This instructor-led, live training in Belgrade (online or onsite) is aimed at marketeers who wish to create video content and presentations with Camtasia and PowerPoint.

By the end of this training, participants will be able to:

• Create video content and share it on a video hosting platform.
• Employ assets within Camtasia such as music and icons for interactive content.
• Save on costs by producing HQ videos with Camtasia and PowerPoint.

This course will equip you with the skills to effectively present financial information (numbers) using PowerPoint, going beyond mere presentation techniques. You will learn how to convey financial data in a more professional and polished manner.

This instructor-led, live training in (online or onsite) is aimed at beginner-level to intermediate-level developers who wish to use VSTO to create customized solutions for Microsoft Office applications.

By the end of this training, participants will be able to:

• Create add-ins and document-level customizations for Office applications.
• Access and manipulate the Office object model and its events.
• Create custom ribbons, task panes, and dialogs for Office applications.
• Use Windows Forms controls and .NET components in Office documents.
• Integrate Office applications with web services and databases.
• Deploy and secure Office solutions.