Microsoft Training in Matosinhos

This instructor-led training in Matosinhos guides advanced professionals in building enterprise knowledge management systems using Microsoft 365. Participants will design SharePoint repositories, automate workflows via Power Automate, and visualize data through Power BI dashboards to enhance collaboration.

This instructor-led training in Matosinhos focuses on deploying and securing enterprise endpoints using Microsoft Intune. Participants will learn to configure enrollment, compliance, and application management across Windows, macOS, iOS, and Android. It is perfectly suited for IT professionals seeking unified security and practical, hands-on expertise.

This instructor-led, live training in Matosinhos (online or onsite) targets beginner to intermediate business users seeking to improve their productivity and digital collaboration through Microsoft Teams, OneDrive, and Outlook.

Upon completing this training, participants will be able to:

• Create, manage, and utilize teams and channels effectively in Microsoft Teams.
• Utilise tags, mentions, and app integrations in Teams to streamline communication workflows.
• Store, organise, and securely share files in OneDrive by adhering to best practices.
• Restore documents via version history and engage in real-time file collaboration.
• Employ Outlook for advanced email management and shared calendar scheduling.

This instructor-led live training in Matosinhos (online or onsite) is designed for beginner to intermediate users who wish to improve team productivity and streamline daily workflows using Outlook, OneDrive, Teams, Planner, and Forms.

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

• Organise and manage communication effectively with Outlook.
• Store, share, and collaborate on files using OneDrive.
• Conduct meetings, chats, and team collaboration with Microsoft Teams.
• Plan and track tasks efficiently using Microsoft Planner.
• Create and analyse online surveys and quizzes with Microsoft Forms.

This instructor-led, live session, available Matosinhos online or onsite, is crafted to support participants in their study for the Microsoft Azure Data Engineer certification exam (DP-203).

The training delves into the essentials of Azure data services, explaining their role in processing, storing, and managing data within the cloud. It guides participants in building data processing solutions with Azure Data Factory, Azure Stream Analytics, and Azure Databricks, as well as managing NoSQL databases via Azure Cosmos DB.

This instructor-led, live training in Matosinhos (online or on-site) is designed for beginner-level leadership teams seeking to effectively manage and coordinate tasks using Microsoft Planner and related tools, ultimately driving improved productivity and collaboration across the organization.

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

• Effectively create, manage, and monitor tasks and projects using Microsoft Planner, enhancing team coordination and project visibility.
• Organize and prioritize individual tasks, share task lists, and collaborate on tasks using Microsoft To Do.
• Utilize Microsoft Loop components for real-time collaboration, integrating them seamlessly into projects and meetings, and enhancing communication and information sharing among team members.
• Design and manage custom lists tailored to specific project needs, automate workflows, and integrate Lists with other Microsoft 365 tools for more efficient task tracking.

This instructor-led, live training in Matosinhos (online or onsite) is aimed at beginner-level business professionals who wish to gain the skills necessary to utilize Teams, Word, and Excel effectively in a management context.

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

• Gain a comprehensive understanding of Microsoft 365
• Navigate and utilize Microsoft Teams for communication, collaboration, and project management.
• Develop proficiency in creating, formatting, and managing Word documents.
• Use Excel for data entry, manipulation, and analysis.
• Explore how to integrate Microsoft 365 applications for seamless workflows.

This instructor-led, live training in Matosinhos (online or onsite) is designed for intermediate-level IT professionals seeking to manage and secure their organisation's IT infrastructure using Microsoft 365.

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

• Deploy and manage Microsoft 365 services, including Intune, MDM, and Autopilot.
• Configure and enforce security policies using Windows Defender and other Microsoft 365 security tools.
• Monitor and troubleshoot devices and applications within a Microsoft 365 environment.
• Understand and implement compliance and data protection measures in Microsoft 365.
• Manage Microsoft 365 security services such as Microsoft Secure Score, Exchange Online Protection, Safe Attachments, and Safe Links.
• Implement compliance solutions using Microsoft Purview, data loss prevention, and sensitivity labels.

This live, instructor-led training in Matosinhos (online or onsite) is tailored to assist participants in preparing for the Microsoft Azure Developer Associate (AZ-204) certification examination.

The curriculum addresses the principles of developing Azure solutions, encompassing Azure compute, storage, and security capabilities. It delivers a thorough introduction to Azure development, detailing the essential tools and services required for building, testing, and deploying applications.

This instructor-led, live training in Matosinhos (online or onsite) is aimed at intermediate-level IT professionals who wish to manage and secure an organization's IT environment using Microsoft 365.

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

• Deploy and manage Microsoft 365 services such as Intune, MDM, and Autopilot.
• Configure and enforce security policies using Windows Defender and other Microsoft 365 security tools.
• Monitor and troubleshoot devices and applications within a Microsoft 365 environment.
• Understand and implement compliance and data protection measures in Microsoft 365.
• Apply best practices for Microsoft 365 administration and security.

This instructor-led live training, offered in Matosinhos (either online or on-site), aims to equip participants with the necessary knowledge to succeed in the Microsoft Azure Administrator Associate (AZ-104) certification exam.

The training addresses the competencies needed for the management of Azure resources, including the handling of Azure virtual machines, various storage solutions, and Azure network configurations.

Excel is a popular spreadsheet program developed by Microsoft. It is used to store, organize, and analyze data in tabular format. Here are some key features and functions of Excel: 1. Spreadsheets: It consists of worksheets, where each sheet is a grid composed of cells arranged in rows and columns. It allows the creation of multiple sheets within a single file, enabling the organization of different data sets. 2. Calculations and Formulas: It enables performing various mathematical, statistical, and logical calculations using formulas. It has a wide range of built-in functions, such as SUM, AVERAGE, MAX, MIN, IF, VLOOKUP, etc. 3. Data Formatting and Appearance: It provides tools for formatting data, including changing fonts, colors, and styles, as well as creating charts, pivot tables, and diagrams. 4. Sorting, Filtering, and Grouping: It allows sorting data according to specified criteria. It enables filtering data to display only selected information. It offers the ability to group data based on requirements. 5. Data Analysis: Tools for performing advanced analyses, such as scenario analysis, trend analysis, forecasting, and creating macros. 6. Data Sharing: It allows sharing and collaborating on data in real-time, enabling multiple users to work on the same data simultaneously. 7. Task Automation: It allows creating macros and automating 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 creation, budgeting, scheduling, data management, and many other applications.

Designed for data analysts looking to leverage advanced VBA in Excel for task automation, this instructor-led, live training in Matosinhos is available online or onsite.

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

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

This instructor-led live training in Matosinhos (online or onsite) is designed for 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 Matosinhos (online or onsite) targets 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.