Online Microsoft Training in Portugal

This live, instructor-led training in Portugal equips advanced professionals with the skills to build enterprise knowledge management systems using Microsoft 365. Learners will design SharePoint repositories, automate workflows using Power Automate, and visualize data through Power BI dashboards to enhance collaboration.

This instructor-led, live training in Portugal (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 Portugal (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 Portugal (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 Portugal (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 Portugal (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 instructor-led, live training in Portugal (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 Portugal (online or onsite) is designed for beginner to intermediate 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 Portugal (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 Portugal (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 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.