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 powerful spreadsheet tool designed for entering data, analyzing information, generating reports, and automating workflows.

This instructor-led live training, available both online and onsite, is designed for users ranging from beginners to advanced practitioners who want to build confidence and master Excel’s core, intermediate, and advanced features.

After completing this training, participants will be ready to:

• Work confidently with spreadsheets, formulas, and formatting options.
• Leverage intermediate tools like tables, charts, and conditional logic.
• Apply advanced functions, data analysis capabilities, and automation strategies.
• Develop professional-grade worksheets that support informed business decisions.

Course Delivery Format

• Instructor-led demonstrations paired with guided explanations.
• Comprehensive workbook exercises and hands-on practice sessions.
• Practical lab activities based on real-world spreadsheet scenarios.

Customization Options

• To tailor the content to your department’s specific workflows, please contact us to arrange a customized version of this course.

This instructor-led, live training in Belgrade (online or onsite) targets beginner to intermediate-level professionals aiming to master Microsoft Word, Excel, and PowerPoint to improve document creation, data analysis, and presentation skills.

Upon completion of this training, participants will be able to:

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

Excel is a prevalent spreadsheet application utilized for organizing, analyzing, and automating data.

This instructor-led, live training (available online or on-site) targets intermediate Excel users who want to leverage Excel for inventory control, budgeting, reporting, and automation using real-world datasets.

Upon completion of this training, participants will be able to:

• Utilize formulas like SUMIF, IF, VLOOKUP, and SUMIFS for inventory and purchasing scenarios.
• Efficiently manage and analyze large datasets containing 5,000+ rows.
• Create and interpret pivot tables for monthly and cumulative tracking.
• Automate repetitive reporting tasks using macros.
• Monitor material purchases versus consumption using structured templates.

Course Format

• Interactive lectures and discussions.
• Extensive exercises and practice sessions.
• Hands-on implementation in a live lab environment.

Customization Options

• To request customized training for this course, please contact us to make arrangements.

This instructor-led, live training session Belgrade (available online or onsite) is designed for anyone wishing to learn and apply the software and services found in the MS Office suite to enhance their work productivity.

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

• Learn and utilize the various software applications within the MS Office suite.
• Boost work productivity and collaborate effectively using MS Office tools and services.

This instructor-led, live training in Belgrade (online or onsite) is designed for data analysts at beginner to advanced levels who intend to use Excel for various tasks such as data entry, formula creation, data analysis, and advanced automation.

By the conclusion 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 beginner-level to intermediate-level professionals who wish to enhance their productivity and efficiency by leveraging the advanced features of Excel and Google Sheets for data organization, analysis, and collaboration.

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

• Navigate and utilize the core features of Excel and Google Sheets.
• Perform data analysis and create actionable insights using advanced spreadsheet techniques.
• Collaborate in real-time using Google Sheets for seamless teamwork.
• Create reusable templates for reporting, tracking, and project management.

This instructor-led, live training in Belgrade (online or onsite) is designed for data analysts or anyone interested in learning how to leverage Excel to build data models for analytical purposes.

Upon completion of this training, participants will be able to:

• Utilize structured problem-solving tools to analyze and resolve various business challenges.
• Effortlessly navigate Excel's features and tools.
• Effectively set up, format, and present data.
• Comprehend the logical structure of Excel models and apply appropriate functions.

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

This instructor-led, live training (available online or onsite) targets users from beginner to advanced levels who aim to master the skills needed to create, edit, format, and automate documents in Microsoft Word.

Upon completing this course, participants will be able to:

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

Course Format

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

Customization Options

• For a tailored version of this training, please contact us to discuss customization options.

Participants in this course will learn to efficiently utilize advanced data analysis tools, such as scenarios and pivot tables. They will master features for performing calculations on dates and text-processing functions, and will gain the ability to create and customize macros to automate spreadsheet workflows.

Excel is a popular spreadsheet program created by Microsoft. It is 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 of cells arranged in rows and columns. Allows creating multiple sheets within a single file, facilitating the organization of different data sets. 2. Calculations and Formulas: Enables various mathematical, statistical, and logical calculations using formulas. Includes a wide range 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 sorting data according to specific criteria. Enables filtering data to display only selected information. Supports grouping data as needed. 5. Data Analysis: Tools for performing advanced analyses, such as scenario analysis, trend analysis, forecasting, and creating macros. 6. Sharing Data: Allows sharing and collaborating on data in real-time, enabling multiple users to work on the same data simultaneously. 7. Task Automation: Ability to create macros and automate tasks using the VBA (Visual Basic for Applications) programming language. Excel is widely used in various fields, from business to science and education. Its versatile features enable data analysis, report generation, budgeting, scheduling, data management, and many other applications.

Designed for data analysts seeking to leverage advanced VBA capabilities in Excel to automate workflows, this instructor-led training is available in Belgrade online or onsite.

Upon completion of this training, participants will be capable of:

• Developing advanced object-oriented applications
• Converting text files
• Integrating external data sources
• Utilizing 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) targets data analysts who wish to learn techniques for preparing data in Excel and visualizing it in Power BI.

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

• Understand the principles of data analysis, objectives of data analysis, and approaches for data analysis.
• Use DAX formulas in Power BI for complex calculations.
• Create and use visualizations and charts for particular analysis cases.
• Import with Power View to move from Excel based Power BI to independent Power BI.

Data analytics is a crucial tool in business today. We will focus throughout on developing skills for practical hands on data analysis. The aim is to help delegates to give evidence-based answers to questions:

What has happened?

• processing and analyzing data
• producing informative data visualizations

What will happen?

• forecasting future performance
• evaluating forecasts

What should happen?

• turning data into evidence-based business decisions
• optimizing processes

Streamline workflows and develop powerful desktop applications using VBA within Microsoft Excel and Access. This extensive VBA training program encompasses programming basics, object-oriented coding, SQL database structuring, user interface creation, debugging methods, error management, and sophisticated Excel analysis techniques via hands-on exercises — enabling analysts, financial experts, and developers to automate manual processes and harness advanced data management and reporting features.

Microsoft Excel is a robust spreadsheet application designed for organizing, analyzing, and visualizing data.

This instructor-led, live training, available either online or on-site, targets beginner-level data analysts seeking to leverage Excel for data analysis and reporting.

Upon completion of this training, participants will be able to:

• Create and manage spreadsheets within Excel.
• Format and organize data to enhance clarity and efficiency.
• Utilize formulas and functions to automate calculations.
• Visualize data through charts, tables, and conditional formatting.
• Collaborate and securely share workbooks using Microsoft 365.

Course Format

• Interactive lectures and discussions.
• Extensive exercises and practice sessions.
• Practical implementation in a live-lab environment.

Customization Options

• To request customized training for this course, please contact us to make arrangements.

This training course equips finance professionals with advanced spreadsheet techniques essential for financial analysis. Topics include lookup functions, search formulas, PivotCharts, conditional formatting, external data workflows, and securities analysis. The program explores practical methods for evaluating time value of money concepts, identifying market trends, constructing financial forecasting models, and utilizing Excel's comprehensive analytical toolkit for complex financial computations and reporting.

This live, instructor-led training session (available onsite or remotely) will walk you through the most essential tools of MS Excel. By combining thoroughly prepared training materials with the instructor’s expertise, participants will discover the extensive capabilities of Excel spreadsheets.
Compared to standard Excel courses, this training reveals a variety of unique functionalities designed to accelerate and improve your workflow.

Understanding how to analyze financial data in Excel empowers financial analysts and accountants with advanced methodologies for automating intricate calculations and generating reports. The course encompasses the fundamental principles of financial functions, INDEX-MATCH lookups, database queries, PivotTables, PivotCharts, and the integration of external data. It also delves into the application of Goal Seek, Solver, Analysis ToolPak, and VBA macros to streamline recurring workflows. This training enables professionals to convert raw data into actionable financial insights and precise forecasts, thereby supporting strategic decision-making.

This course expands on the core concepts introduced in the Microsoft® Office Excel® 2019: Part 1 training, guiding you toward the creation of sophisticated workbooks and worksheets that enhance your grasp of organizational intelligence. The capacity to analyze vast datasets, extract actionable insights, and effectively communicate these findings to key decision-makers forms the bedrock of high-performing organizations.

Learning Objectives

Upon successful completion of this course, you will be able to harness the power of data analysis and presentation to drive informed, strategic organizational decisions.

You will:

• Utilize various functions.
• Manage lists effectively.
• Analyze data efficiently.
• Visualize data through charts.
• Leverage PivotTables and PivotCharts.

Upon completing this course, you will gain the ability to create and develop Excel worksheets and workbooks, enabling you to start analyzing essential business data.
This course empowers you to:

• Utilize a variety of fundamental Excel commands
• Perform calculations within worksheets
• Construct custom formulas
• Edit elements within a worksheet
• Apply formatting changes to cells
• Manage workbook properties

This course provides the essential groundwork for Excel proficiency, enabling you to develop expertise in data manipulation. Excel empowers you to organize, calculate, analyze, refine, update, and present data in ways that guide organizational decision-making. Additionally, it streamlines these tasks, allowing you to complete them more efficiently and in significantly less time compared to traditional manual methods or general-purpose software.

Learning Objectives

After successfully completing this course, you will be capable of creating and developing Excel worksheets and workbooks to manage and analyze the critical data driving your organization's success.

• You will:
• Begin working with Microsoft Office Excel 2019.
• Execute calculations.
• Edit a worksheet.
• Format a worksheet.
• Print workbooks.
• Organize workbooks.

This course expands on the fundamental and intermediate concepts introduced in the Microsoft® Office Excel® Basic and Microsoft® Office Excel® Intermediate courses, designed to help you maximize your Excel proficiency. By mastering the ability to collaborate with colleagues, automate complex or repetitive tasks, and apply conditional logic to develop sophisticated formulas and functions, you will harness the full power of Excel. The deeper your understanding of how Excel can perform heavy lifting for you, the more time you can dedicate to extracting the insights you need from the vast data sets your organization produces.

Learning Objectives

Upon successful completion of this course, you will be able to conduct advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.

• You will:
• Work with multiple worksheets and workbooks.
• Share and protect workbooks.
• Automate workbook functionality.
• Use Lookup functions and formula auditing.
• Forecast data.
• Create sparklines and map data.

This one-day course is tailored for information workers who currently use or will soon start using Office 365. It equips students with the necessary knowledge and skills to utilize Office 365 efficiently in their daily workflows. Designed around real-world scenarios, the curriculum covers essential tools such as Outlook Online, Skype for Business, OneDrive for Business, SharePoint Online, and OneNote. Upon completion, participants will be capable of navigating Office 365 effectively and leveraging all its available features.

Learning Objectives

In this course, you will master the essential skills of Word.

• Key competencies include:
• Navigating the Word interface and executing standard tasks such as opening, viewing, editing, saving, and printing documents, as well as customizing application settings.
• Applying formatting to both text and paragraphs.
• Executing repetitive tasks efficiently through tools like Find and Replace, Format Painter, and Styles.
• Improving list management by sorting, renumbering, and customizing list styles.
• Creating and formatting tables.
• Inserting graphic elements into documents, including symbols, special characters, illustrations, pictures, and clip art.
• Refining the overall page appearance via page borders and colors, watermarks, headers and footers, and layout adjustments.
• Leveraging Word’s built-in features to identify and resolve issues related to spelling, grammar, readability, and accessibility.

TARGET AUDIENCE

This course is designed for learners aiming to acquire fundamental Word 2019 skills, such as creating, editing, and formatting documents, inserting simple tables and lists, and utilizing various techniques to enhance the visual appeal and accuracy of document content.

Participants in this course will learn to efficiently perform a wide range of calculations in a clear and transparent manner to organize and present their results. They will also master various techniques to streamline and accelerate the creation of spreadsheets, as well as protect their calculations and outputs from unauthorized access.

Participants will enhance their skills to optimally create, consolidate, and manage data. By utilizing specialized tools designed to streamline workflows, you can significantly reduce the time spent on tasks and design applications capable of performing new functions.

Participants will learn to create clean, professional documents, including various types of official correspondence. The course also covers leveraging basic mechanisms to ensure the clear and efficient flow of information in both short and long documents.

Master advanced document workflows with Microsoft Word's full feature set. Gain expertise in custom styles, mail merge from external databases, macro recording, and template creation. Participants will learn section-level layout control, dynamic tables of contents, indexes, hyperlinks, content controls, document comparison, and version tracking. This course equips professionals to build automated reporting systems, standardized enterprise templates, cross-referenced documents, and SharePoint-integrated workflows.

Gain mastery over Microsoft Excel through this comprehensive professional training course, designed to significantly boost your spreadsheet efficiency and overall productivity. You will acquire essential skills such as editing worksheets, managing workbooks, constructing complex formulas using powerful functions, formatting cells, designing professional charts and graphs, leveraging PivotTables and data lists, and manipulating graphic objects. This course is ideal for business analysts, accountants, data handlers, and office professionals looking to elevate their Excel proficiency from an intermediate to an expert level. Enhance your data analysis capabilities, streamline reporting workflows, and harness the full potential of Microsoft Excel to drive better decision-making and workplace productivity.

This instructor-led, live training in Belgrade (online or onsite) is aimed at beginner-level analysts who wish to use Excel VBA to automate repetitive work, clean and transform data, and improve reporting processes.

By the end of this training, participants will be able to: record and edit macros, write simple VBA procedures, work with Excel objects for reporting tasks, and debug basic automation solutions.

This instructor-led course equips participants with practical knowledge and hands-on experience utilizing Microsoft 365 applications for communication, collaboration, file management, and secure digital working practices. Participants will learn how to use core Microsoft 365 tools efficiently while adhering to organizational best practices for collaboration and information security.

Gaining mastery over PowerPoint goes beyond fundamental skills; it unveils the art of crafting polished, scalable presentations that truly captivate an audience. This course explores customizing slide and handout masters, designing custom templates, leveraging SmartArt for visual process mapping, and integrating deep Excel functionality for live-linked data dashboards and charts. It empowers professionals with advanced workflows using add-ins such as Office Timeline and Poll Everywhere, thereby accelerating the production of complex decks, streamlining review processes, and delivering high-impact business presentations.

Professionals aiming to create polished presentations can enhance their work by applying advanced slide design techniques that turn fundamental content into compelling visual narratives. This course explores the foundational principles of slide composition, the creation of charts and infographics, and image editing. It focuses on developing practical skills such as the strategic distribution of visual elements, highlighting key information, and customizing the workspace. Participants will gain actionable strategies for designing clean, impactful slides and delivering presentations with confidence through structured public speaking methods.

Objective:

Enhancing the capability to create visually appealing presentations using PowerPoint and other professional tools

Target Audience:

Sales representatives, consultants, academic and teaching staff, managers, corporate employees, SME owners, and public institution personnel who need to present in front of groups and engage their audience effectively

This instructor-led live training in Belgrade (online or onsite) is targeted at beginner to intermediate business analysts and data analysts seeking to utilize Excel for data analysis and reporting in their professional projects and tasks.

By the conclusion of this training, participants will be equipped to:

• Apply Excel formulas and functions for data calculations and manipulation.
• Use Excel data analysis tools, such as PivotTables, What-If Analysis, and Forecasting, to summarize and visualize data.
• Create and tailor data visualizations using Excel charts and graphs.
• Ensure data integrity and highlight insights through data validation and conditional formatting.
• Connect to external data sources and facilitate data sharing using Excel's import and export features.

This course addresses the essential components of Microsoft 365 administration, including tenant management, identity synchronization, and security and compliance protocols.

During the tenant management segment, participants will learn to configure their Microsoft 365 tenant, encompassing organizational profiles, subscription options, component services, user accounts, licenses, security groups, and administrative roles. The instruction then moves to configuring Microsoft 365 with a primary emphasis on Office client connectivity, followed by strategies for managing user-driven client installations of Microsoft 365 Apps for enterprise environments.

The course subsequently delves into Microsoft 365 identity synchronization, focusing on Azure Active Directory Connect and Connect Cloud Sync. Attendees will acquire the skills to plan and deploy these directory synchronization options, manage synchronized identities, and implement password management solutions in Microsoft 365 through multifactor authentication and self-service password management.

In the security management section, learners will investigate common threat vectors and data breaches prevalent in modern organizations. They will understand how Microsoft 365’s security solutions mitigate these risks and become familiar with the Microsoft Secure Score and Azure Active Directory Identity Protection. The curriculum covers the administration of Microsoft 365 security services, such as Exchange Online Protection, Safe Attachments, and Safe Links, along with reports that track organizational security health. The focus then shifts to threat intelligence, utilizing Microsoft 365 Defender, Microsoft Defender for Cloud Apps, and Microsoft Defender for Endpoint.

With a solid grasp of Microsoft 365’s security capabilities, the course examines the core elements of Microsoft 365 compliance management. This includes an overview of data governance aspects like data archiving and retention, Microsoft Purview message encryption, and data loss prevention (DLP). The instruction further explores archiving and retention, specifically addressing Microsoft Purview insider risk management, information barriers, and DLP policies. Participants will also learn to implement these compliance features using data classification and sensitivity labels.

Explore the fundamentals of Office 365 administration, covering essential Office 365 components, strategies for migrating an organization to Office 365, configuration procedures, and methods for managing Office 365 ProPlus deployment processes.

Audience profile

This training is intended for individuals aiming to become Microsoft 365 Enterprise Administrators who have already completed one of the Microsoft 365 role-based administrator certification paths.

Key skills acquired

• Comprehensive overview of Office 365
• Strategies for migrating an organization to Office 365
• Techniques for configuring Office 365
• Methods for managing Office 365 ProPlus deployments

In this course, participants will acquire the skills to plan and implement an endpoint deployment strategy utilizing modern deployment methods and update mechanisms. The curriculum introduces fundamental aspects of contemporary management, co-management frameworks, and Microsoft Intune integration. It addresses application deployment, management of browser-based apps, and critical security principles including authentication, identity management, access control, and compliance policies. Technologies such as Azure Active Directory, Azure Information Protection, and Microsoft Defender for Endpoint are examined to safeguard devices and data.

Audience

This course is designed for individuals who possess a fundamental knowledge of Microsoft® Office Outlook® and wish to learn how to leverage its advanced features to manage email communications, calendar events, contact details, search capabilities, and various other communication tasks.

This one-day training course is tailored for experienced SharePoint users who act as site owners and/or site collection administrators.

Course objectives:

• Configure site navigation
• View site activity reports
• Customize lists and libraries
• Work with Site Columns and Site Content Types
• Configure Check out/in, Content Approval and Versioning
• Create and modify pages and web part pages

This one-day training session is tailored for individuals who utilize SharePoint and wish to explore some of its more advanced capabilities. Participants should enroll in this course if they need to gain a deeper understanding of key functions such as team collaboration, document management, and the social features offered by Microsoft SharePoint 2013.

Who should attend?

• SharePoint Site Owners and users

Course objectives:

• Manage Sites and Site Collections
• Add users and groups and manage site, list, folder and item security
• Add and configure web parts
• Configure site options including theme, title, description and icon

This instructor-led live training in Belgrade (online or onsite) is tailored for marketing professionals who want to create video content and presentations using 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.
• Use assets in Camtasia, such as music and icons, to build interactive content.
• Cut costs by producing high-quality videos with Camtasia and PowerPoint.

Developing impactful financial presentations bridges the gap between intricate data and executive communication by leveraging PowerPoint. This course examines design techniques such as slide organization, treemap and sunburst visualizations, budget chart layouts, and streamlined reporting tables that underscore vital financial metrics. It equips participants with skills to master Excel integration for dynamic data, selectively highlight key figures, and craft confident financial narratives that secure stakeholder buy-in.