System Center Data Protection Manager (DPM) Backup and Recovery Training Course

This instructor-led, live training in Portugal (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.

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.

Acquire fundamental Microsoft Excel competencies through this introductory programme located in Portugal. The curriculum addresses data input, styling, formulas, functions, tabular structures, and visualisation techniques, establishing a solid base for practical data analysis and reporting.

This instructor-led live training, offered in Portugal (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.

This live, instructor-led training in Portugal (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, conducted in Portugal either online or on-site, is tailored to assist participants in their preparation for the Microsoft Azure Solutions Architect Expert (AZ-305) certification exam.

The course addresses advanced cloud computing concepts and Azure services. It provides a comprehensive insight into Azure solutions architecture, covering its underlying principles, components, and services. Participants will also learn how to architect and deploy Azure solutions in accordance with best practices and industry standards.

This instructor-led, live training in Portugal (delivered online or onsite) aims to equip participants with the necessary knowledge to pass the Microsoft Azure DevOps Engineer certification exam (AZ-400).

The program explores core DevOps concepts and their integration into the Azure platform. It focuses on leveraging Azure DevOps for managing source code, establishing build and release pipelines, and adopting continuous integration and continuous delivery (CI/CD) standards.

This instructor-led, live training session, offered Portugal either online or on-site, is specifically crafted to assist participants in preparing for the Microsoft Azure Security Engineer Associate (AZ-500) certification exam.

The program addresses a wide range of Azure security disciplines, including the management of identity and access, platform-level protection, safeguards for data and applications, and operational management practices.

This instructor-led, live training in Portugal (online or onsite) is designed to help participants prepare for the Microsoft Azure Fundamentals (AZ-900) certification exam.

The course covers the basic concepts of cloud computing and Azure services. It provides a comprehensive introduction to Azure, including its architecture, pricing and support, and the most commonly used Azure services.

This instructor-led, live session, available Portugal 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.