Microsoft Training in Porto

This instructor-led training in Porto 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 Porto 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 Porto (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 Porto (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 training in Porto (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 Porto (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 Porto (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 Porto (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 Porto (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.

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.

This instructor-led, live training in Porto (online or onsite) is designed for data analysts who wish to acquire skills in 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.

This instructor-led live training in Porto (online or onsite) is designed for beginner to intermediate business analysts and data analysts who wish to use Excel for data analysis and reporting in their projects and tasks.

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

• Utilize Excel formulas and functions to perform calculations and manipulate data.
• Employ Excel data analysis tools, such as PivotTables, What-If Analysis, and Forecasting, to summarize and visualize data.
• Create and customize data visualizations using Excel charts and graphs.
• Apply Excel data validation and conditional formatting to ensure data quality and highlight key insights.
• Use Excel data import and export capabilities to connect with external data sources and share data effectively.

This practical, hands-on course offers a comprehensive introduction to Microsoft SharePoint Online, demonstrating how contemporary organizations can harness its power for collaboration, document management, process automation, and seamless integration within the Microsoft 365 ecosystem. Participants will delve into SharePoint’s essential capabilities—including document libraries, lists, permissions, and site architectures—while gaining initial experience with automation tools such as Power Automate and Power Apps.