Tag Archives: microsoft
Highlight active row – wrong formula?
Hi everyone!
I want to highlight the active row in Excel, but I receive an error by my formula? I don’t know what is wrong by my formula. Does anyone know?
See image below.
Hi everyone! I want to highlight the active row in Excel, but I receive an error by my formula? I don’t know what is wrong by my formula. Does anyone know?See image below. Read More
What are the advantages of the Microsoft Azure cloud platform?
Microsoft Azure offers a comprehensive suite of cloud computing services that can empower your business in many ways. Here are some of the key advantages:
Scalability and Cost-Effectiveness: Azure lets you scale your resources (storage, compute power) up or down based on your needs. This eliminates the upfront cost of buying and maintaining physical servers, and you only pay for what you use.
Security and Compliance: Azure prioritizes robust security with features like encryption, threat detection, and compliance certifications. This ensures your data is protected and adheres to industry regulations.
Integration and Flexibility: Azure integrates seamlessly with existing Microsoft products like Office 365 and Active Directory. It also offers a wide range of services, from virtual machines to artificial intelligence tools, giving you the flexibility to build the solutions you need.
Reliability and Disaster Recovery: Azure’s global infrastructure is designed for high availability and redundancy, minimizing downtime and ensuring consistent access to your applications and data. Disaster recovery services allow you to quickly restore operations in case of an outage.
Advanced Analytics: Azure provides powerful analytics tools that can help you gain insights from your data and make better business decisions.
Hybrid Cloud Capabilities: Azure allows you to create hybrid cloud environments, where you can combine on-premises infrastructure with cloud resources. This flexibility gives you the best of both worlds.
Microsoft Azure offers a comprehensive suite of cloud computing services that can empower your business in many ways. Here are some of the key advantages: Scalability and Cost-Effectiveness: Azure lets you scale your resources (storage, compute power) up or down based on your needs. This eliminates the upfront cost of buying and maintaining physical servers, and you only pay for what you use. Security and Compliance: Azure prioritizes robust security with features like encryption, threat detection, and compliance certifications. This ensures your data is protected and adheres to industry regulations. Integration and Flexibility: Azure integrates seamlessly with existing Microsoft products like Office 365 and Active Directory. It also offers a wide range of services, from virtual machines to artificial intelligence tools, giving you the flexibility to build the solutions you need. Reliability and Disaster Recovery: Azure’s global infrastructure is designed for high availability and redundancy, minimizing downtime and ensuring consistent access to your applications and data. Disaster recovery services allow you to quickly restore operations in case of an outage. Advanced Analytics: Azure provides powerful analytics tools that can help you gain insights from your data and make better business decisions. Hybrid Cloud Capabilities: Azure allows you to create hybrid cloud environments, where you can combine on-premises infrastructure with cloud resources. This flexibility gives you the best of both worlds. Read More
Formula returning the incorrect value
I am trying to lookup the value in cell A2 in column H and return a Yes if that value is in Column H and a No if it is not. I have tried using the below formulas, but it keeps returning “No” on values I can clearly see are in Column H. I have tried to change the formatting of both columns, but still no luck.
=IF(COUNTIF(H:H,A2)>0,”Yes”,”No”)
=IF(ISNUMBER(MATCH(A2,H:H,0)),”Yes”,”No”)
I am trying to lookup the value in cell A2 in column H and return a Yes if that value is in Column H and a No if it is not. I have tried using the below formulas, but it keeps returning “No” on values I can clearly see are in Column H. I have tried to change the formatting of both columns, but still no luck. =IF(COUNTIF(H:H,A2)>0,”Yes”,”No”)=IF(ISNUMBER(MATCH(A2,H:H,0)),”Yes”,”No”) Read More
Feedback
Hello,
MSEdge is a good chromium derivative and I like the setting to pin URLs to the taskbar in Windows 10.
The only thing I’d like to mention is if I try to download a file, MSEdge freezes for a few seconds before the dialogue to choose a path where to store a file is shown (hard disk drive).
The memory issues seems to be solved and the integration of Copilot is working as intended.
Regards!
Hello, MSEdge is a good chromium derivative and I like the setting to pin URLs to the taskbar in Windows 10. The only thing I’d like to mention is if I try to download a file, MSEdge freezes for a few seconds before the dialogue to choose a path where to store a file is shown (hard disk drive). The memory issues seems to be solved and the integration of Copilot is working as intended. Regards! Read More
Show data from additional fields from a lookup column to the custom layout header
Hi,
I wanted to show data from additional fields from a lookup column to the custom layout header.
Example:
List 1:
Submit Round (text),
Deadline Date (date),
Result Date (date)
List 2:
Project (text),
Submit Round (lookup),
Deadline Date (additional fields from lookup),
Result Date (additional fields from lookup)
So, I want to configure the header format to show the Deadline Date and Result Date in the Header when the user selects a Submit Round.
Is it possible to achieve this by only custom the header of the Sharepoint list (I’m trying to avoid PowerApps)
Additional challenge: I want to create a new column by combining a lookup column with a Date column by creating a Calculated column but I got an error state the columns are defined as a data type that is not supported in formulas. is there a workaround?
I feel like it is the same problem that may have a similar solution to it.
Thank you.
Hi, I wanted to show data from additional fields from a lookup column to the custom layout header.Example:List 1:Submit Round (text),Deadline Date (date),Result Date (date) List 2:Project (text),Submit Round (lookup),Deadline Date (additional fields from lookup),Result Date (additional fields from lookup) So, I want to configure the header format to show the Deadline Date and Result Date in the Header when the user selects a Submit Round. Is it possible to achieve this by only custom the header of the Sharepoint list (I’m trying to avoid PowerApps) Additional challenge: I want to create a new column by combining a lookup column with a Date column by creating a Calculated column but I got an error state the columns are defined as a data type that is not supported in formulas. is there a workaround? I feel like it is the same problem that may have a similar solution to it. Thank you. Read More
How to open .nst file in outlook?
There is no manual method available to import NST files to PST. However, there are reliable and effective solutions available online. One such solution is the NST file to Outlook app, which has been recently introduced in the market. Additionally, the old but reliable utility, Advik OST to PST Converter, can also be used to copy NST files to PST with just a few clicks. After the conversion process, users will find the resultant file with accurate data integrity and folder structure. The user interface of the tool is easy to understand, making it suitable for both technical and novice users to transfer NST data to PST.
There is no manual method available to import NST files to PST. However, there are reliable and effective solutions available online. One such solution is the NST file to Outlook app, which has been recently introduced in the market. Additionally, the old but reliable utility, Advik OST to PST Converter, can also be used to copy NST files to PST with just a few clicks. After the conversion process, users will find the resultant file with accurate data integrity and folder structure. The user interface of the tool is easy to understand, making it suitable for both technical and novice users to transfer NST data to PST. Read More
125.0.2535.6
so, did you silently install another new release? this has to stop!
so, did you silently install another new release? this has to stop! Read More
Cross Workspace Queries – Possible in a central Sentinel instance you use Lighthouse to access?
Hi all,
Example scenario is that an MSSP accesses a clients Microsoft Sentinel instance via Azure Lighthouse for management, however, this customer also has lets say 3 further regions which will have Microsoft Sentinel deployed into them & they’re not feeding into the main instance due to networking costs.
How would they gain the relevant permissions (Log Analytics Reader / Contributor) to create cross workspace queries against the additional 3 Sentinel instances for said client from the main instance they currently manage? Would an Azure Lighthouse connection between the core tenant of the MSSP and the additional Sentinel instances, with just the required role, allow them to then action cross workspace queries within the clients central instance they already have access within?
Thanks,
Hi all,Example scenario is that an MSSP accesses a clients Microsoft Sentinel instance via Azure Lighthouse for management, however, this customer also has lets say 3 further regions which will have Microsoft Sentinel deployed into them & they’re not feeding into the main instance due to networking costs.How would they gain the relevant permissions (Log Analytics Reader / Contributor) to create cross workspace queries against the additional 3 Sentinel instances for said client from the main instance they currently manage? Would an Azure Lighthouse connection between the core tenant of the MSSP and the additional Sentinel instances, with just the required role, allow them to then action cross workspace queries within the clients central instance they already have access within?Thanks, Read More
New on Azure Marketplace: April 1-9, 2024
We continue to expand the Azure Marketplace ecosystem. For this volume, 193 new offers successfully met the onboarding criteria and went live. See details of the new offers below:
Get it now in our marketplace
Age Estimation and Verification: Ondato offers an AI-powered age estimation and verification tool that provides age estimates in seconds without needing identity documents. The tool performs liveness and spoofing checks, creates a 3D map of the user’s face, and analyzes spatial coordinates to place the user in an accurate age group. It can be implemented in businesses that require age verification, such as content monetization platforms and online stores.
Airborne: Readymind offers a platform that streamlines software creation, management, and exploration through a unified user experience. It accelerates development processes by reusing templates from best practice projects, enhancing productivity, and ensuring adherence to industry-leading practices. With Airborne, software development becomes faster, more efficient, and better aligned with proven success models.
Amazon Ads to Power BI Connector: Dataddo’s no-code platform offers instant access to analytics by integrating Amazon Ads and over 300 other data sources directly into Microsoft Power BI. The platform handles all API changes, monitors and maintains data pipelines, and rapidly develops new connectors. It also offers quick setup and deployment, predictable pricing, and top-tier data security and compliance.
Apache Ant on Ubuntu Server 20.04 LTS: Apache Ant is a flexible Java library and command-line tool used for building Java and non-Java applications. Nuvemnest offers Microsoft Azure Virtual Machines with a customer-centric approach and future-ready technology to transform businesses in the cloud. Its team has extensive experience and expertise in cloud computing and Azure solutions.
Apache Ant on Ubuntu Server 22.04 LTS: Apache Ant is a flexible Java library and command-line tool used for building Java and non-Java applications. Nuvemnest offers Microsoft Azure Virtual Machines with a customer-centric approach and future-ready technology to transform businesses in the cloud. Its team has extensive experience and expertise in cloud computing and Azure solutions.
Apache Maven on Ubuntu Server 22.04 LTS: Apache Maven is a software project management tool used for building and managing projects in various languages. Nuvemnest offers Microsoft Azure Virtual Machines with a customer-centric approach and future-ready technology to transform businesses in the cloud. Its team of experts prioritizes customer satisfaction and implements the latest advancements for adaptability and sustainability.
Apache Subversion (SVN) on Ubuntu Server 20.04 LTS: Apache Subversion is an open-source version control system used for managing files and directories over time, tracking changes, and facilitating collaboration. Nuvemnest provides Microsoft Azure Virtual Machines with a customer-centric approach, future-ready technology, and expertise in cloud computing and Azure solutions.
APEX File Storage for Microsoft Azure – Customer-Managed (CA): Dell APEX File Storage for Microsoft Azure is a scalable storage solution designed for AI. It simplifies the journey to the cloud with common storage services across locations, creating a universal storage layer. APEX File Storage enables organizations to run the software they trust directly in Azure without retraining their staff or refactoring their storage architecture.
APEX File Storage for Microsoft Azure – Customer-Managed (EISI): Dell APEX File Storage for Microsoft Azure is a scalable storage solution designed for AI. It simplifies the journey to the cloud with common storage services across locations, creating a universal storage layer. APEX File Storage enables organizations to run the software they trust directly in Azure without retraining their staff or refactoring their storage architecture.
ArqSign: ArqSign is an electronic signature platform that simplifies processes, manages documents, and provides real-time notifications. It offers unlimited users, recipient verification via email and SMS access codes, and seamless integration with preferred tools using an all-in-one API solution. ArqSign streamlines workflows and elevates document management experiences while upholding the highest security and compliance standards.
Atlassian JIRA to Power BI Connector: Dataddo’s no-code platform integrates Atlassian JIRA and over 300 other data sources directly into Microsoft Power BI. The platform handles API changes, monitors and maintains data pipelines, and rapidly develops new connectors. Dataddo offers quick setup and deployment, and a predictable pricing model. The platform is compliant with global data privacy laws.
Azure Managed Service Consultancy Credits: Agisko offers tailored Microsoft Azure services that include bespoke project implementations, on-site support packages, and continuous operational assistance. Its team comprises three specialized roles to address the varied needs of Azure tasks, providing flexibility and timely support for both scheduled and urgent tasks, with a credit system for efficient service utilization.
Biometric Authentication: Ondato offers a cloud-based authentication mechanism for online services dealing with returning customers. It combines security with convenience, using biometric authentication to confirm user identities quickly and simply. The process only requires a device with a camera, ensuring efficient processes and protecting clients in case of forgotten or stolen login details or lost devices.
Blue Ocean – Smart Cloud Insights: Blue Ocean is a SaaS platform for Microsoft Azure Cloud Insights that provides automated expert insights and a central view of categories such as cost and compliance. It requires minimal onboarding and allows customers to trigger data retrieval of a dashboard of their choice to take back control of their growing cloud cost and security requirements.
CentOS 9 Stream Generation 2: ProComputers offers a minimal ready-to-use CentOS 9 Stream Generation 2 Gold Image for developers to build and test appliances on top of. It includes Microsoft Azure Linux Agent, cloud-init, and Security-Enhanced Linux, and supports Accelerated Networking. All security updates available at the release date are included.
CentOS 9 Stream LVM-Partitioned: This offer from ProComputers is a minimal ready-to-use CentOS 9 Stream Gold Image with LVM partitioning, designed as a common base system for building and testing other appliances. It includes Microsoft Azure Linux Agent, cloud-init, and supports Accelerated Networking. Security-Enhanced Linux (SELinux) is enabled, and all security updates are included.
CentOS 9 Stream Minimal Generation 2: ProComputers offers a minimal ready-to-use CentOS 9 Stream Generation 2 Gold Image for developers to build and test appliances on top of. It includes Microsoft Azure Linux Agent, cloud-init, and Security-Enhanced Linux, and supports Accelerated Networking. All security updates available at the release date are included.
CentOS 9 Stream Minimal: ProComputers offers a minimal ready-to-use CentOS 9 Stream Gold Image with Microsoft Azure Linux Agent, cloud-init, and Accelerated Networking support. Root login is disabled, and only the user account specified at launch time is allowed to connect. All security updates available at the release date are included. ProComputers has over 10 years of experience working with Microsoft Azure.
CionSystems Auditor, Backup, and Recovery: This offer from CionSystems is a comprehensive solution to monitor, secure, and protect your Microsoft Entra ID, Microsoft Azure, and Microsoft 365 environments. With real-time threat monitoring and tracking of key user activities, administrator changes, and login activities, you can stay ahead of security threats and respond instantly to unauthorized changes.
Cloud Offer: WorkSpan’s Cloud Services Bundle includes infrastructure as a service (IaaS), platform as a service (PaaS), and software as a service (SaaS). It can be accessed through a web-based interface and offers scalability, reliability, and security features. It integrates with existing workflows and provides around-the-clock customer support. Regular monitoring and optimization ensure cost-effectiveness and efficiency.
CRM for AML and KYC Compliance: Ondato is a compliance platform that streamlines AML and KYC processes, integrating all essential tools in one central hub. It offers various tools for identity verification, AML monitoring, screening, and more. Ondato ensures efficiency through enhanced process automation, leading to reduced operating costs and minimizing the risk of penalties from regulatory authorities.
CubeCart: This offer from ATH Infosystems is an open-source e-commerce solution for small- to medium-sized businesses. It offers a user-friendly interface for managing products, orders, and customers, customizable themes and templates, built-in marketing and promotional tools, and robust security features.
Cyware Respond: Cyware’s Respond is a threat-informed platform that offers end-to-end incident management and automation. It connects assets, malware, vulnerabilities, threat actors, and incidents for intelligent orchestration. Respond leverages advanced machine learning-powered cyber fusion to reveal correlations among disparate data, creating a coherent threat picture. It provides predictive intelligence for preemptive and effective responses.
ecosystem.Ai Spend Personality: Understanding spend personalities involves recognizing patterns that reflect broader lifestyle choices, values, and priorities. This approach aligns with digital personalities and frameworks of social functionalism and social constructivism. This install from Ecogenetic includes a prediction server, workbench, notebooks, Client Pulse Responder, and Grafana for real-time data tracking.
Ejento AI: Complete Enterprise AI Toolkit: Data Science Dojo offers Ejento AI, an AI-led enterprise excellence toolkit that automates and optimizes business operations. It includes features such as personalized marketing, precision sales tools, instant smart support, and smart legal analysis. Ejento AI learns from existing data and can be interacted with via natural language.
Enable 365 Templates: This offer from Enable 365 simplifies the process of making Microsoft Office templates available in Microsoft Teams. The app’s template selector allows easy access to up-to-date templates from a central location, ensuring everyone uses the latest versions. All you need to do is gather the templates you want to make available and add the app to the relevant teams.
Engagy Comms Management Hub: This offer from Engagy streamlines the creation and management of Microsoft SharePoint Online intranet portals with a built-in template management system. Its information governance framework and automatic reminders ensure up-to-date content, while analytics integration provides insights into portal usage. Membership recertification policies enhance security, reducing administrative tasks and boosting end-user trust.
ERP system EAM Lite: From Information Technologies, EAM Lite is an ERP system that automates all services of an enterprise in an integrated approach, ensuring unity across information space and interfaces. It meets the standards of ERP, RCCP, and RCCP2, making all enterprise systems a single entity. EAM Lite also meets the standards and concepts of MRPII, MES, and APS.
ESG Consulting Dashboard: This offer from MobiCycle helps IT professionals and developers bridge IT prowess with ESG objectives to deliver fast, reliable, and repeatable reporting and analytics solutions. The dashboard empowers IT departments to align technological advancements with ESG goals, offering a pathway to sustainability that’s beneficial across cost savings, innovation, and compliance.
ESG Marketing Dashboard: This offer from MobiCycle provides a narrative that goes beyond numbers. It guides organizations in creating communication strategies that resonate with critical audiences and emphasize transparency and truth. The dashboard acts as a unifying force, bridging knowledge gaps within and between teams. It complements traditional dashboards by bringing a perspective in which data becomes a powerful narrative tool.
Etherpad: This offer from ATH Infosystems is an open-source collaborative real-time editor that allows multiple users to simultaneously edit a text document. It provides a simple and efficient platform for collaborative writing, note-taking, and brainstorming sessions. It includes built-in chat functionality, allowing users to communicate with collaborators within the editor interface.
Express.js on Debian 11: Express.js is a flexible Node.js web application framework with routing, middleware, and templating features. Apps4Rent offers a readymade Express.js on Debian 11 image for easy integration with Microsoft Azure. Azure experts are available around the clock for support. Open-source licenses are provided. Default ports include SSH, HTTP, and HTTPS.
Express.js on Debian 12: Express.js is a flexible Node.js web application framework with key functionalities like routing, middleware, and templating. Apps4Rent offers a readymade Express.js on Debian 12 image that simplifies integration with Microsoft Azure. The installation process is easy, and Azure experts are available around-the-clock for support. The product comes with open-source licenses and default ports for SSH, HTTP, and HTTPS.
Express.js on Ubuntu 20.04: Express.js is a flexible Node.js web application framework with routing, middleware, and templating features. Apps4Rent offers a readymade Express.js on Ubuntu 20.04 image for easy integration with Microsoft Azure. Azure experts are available around the clock for support. Default ports include SSH, HTTP, and HTTPS. Open-source licenses are provided.
Express.js on Ubuntu 22.04: Express.js is a flexible Node.js web application framework with routing, middleware, and templating features. Apps4Rent offers a readymade Express.js on Ubuntu 22.04 image for easy integration with Microsoft Azure. Azure experts are available around the clock for support. Default ports include SSH, HTTP, and HTTPS. Open-source licenses are provided.
Facebook Organic to Power BI Connector: Dataddo’s no-code platform integrates over 300 data sources, including Facebook Page Insights and Facebook Posts, directly into Power BI for instant access to analytics. The platform handles API changes, monitors and maintains data pipelines, and develops new connectors within 10 business days. Setup is quick and maintenance is streamlined, with a predictable pricing model based on the number of data flows.
Facilio Connected CMMS: This offer from Facilio streamlines maintenance operations and maximizes asset efficiency with features such as work order management, preventive maintenance, asset management, inventory management, reports and dashboards, mobile-first CMMS, and integrations. It offers scalable solutions, optimized performance, and enhanced productivity with predictive maintenance capabilities.
Generative AI Customer Support Agent: Trusting Social offers AI-powered virtual workers for customer-facing functions in the BFSI sector. Its generative AI chat agent, Alice, streamlines customer experiences, provides customized responses, and boosts human agents’ efficiency. Alice enables zero wait, instant responses, and remembers historical customer context.
GitLab: This offer from ATH Infosystems is an open-source DevOps lifecycle tool that offers a complete platform for collaboration, issue tracking, and CI/CD capabilities. It includes wikis, code snippets, and discussions for communication and knowledge-sharing while providing Git repository management with features such as code review, branching strategies, and merge requests to streamline the development workflow.
Google My Business to Power BI Connector: Dataddo’s no-code platform integrates Google My Business and over 300 other data sources directly into Microsoft Power BI, providing instant access to analytics and handling all API changes, monitoring and maintaining data pipelines, and rapidly developing new connectors. The platform offers quick setup and deployment, predictable pricing, and secure and compliant data handling.
HarePoint Analytics for SharePoint: HarePoint Analytics is a managed application for Microsoft SharePoint Online that provides comprehensive insights and analytics to enhance productivity and boost employee engagement. It offers deep integration with Micrsoft Power BI, ready-to-use dashboards, and scheduled email reports. Insights provided include user behavior analysis, search requests, content popularity, and performance dynamics analysis.
Icecast Streaming Server on Windows Server 2019: This offer from Virtual Pulse is a customizable and scalable server that allows for efficient streaming of audio and video content over the internet. It supports various formats and can handle high traffic and multiple listeners.
Instagram to Power BI Connector: Dataddo’s no-code platform offers instant access to over 300 data sources directly into Microsoft Power BI. The platform handles API changes, monitors and maintains data pipelines, and develops new connectors within 10 business days. Dataddo also offers streamlined setup and maintenance, predictable pricing, and secure and compliant data handling.
Jina Embeddings v2 Base (English): This offer from Jina IA is an open-source English embedding model supporting 8192 sequence length. It enables document clustering, classification, content personalization, vector search, and retrieval-augmented generation. The model has 137 million parameters and supports 8000 context length, resulting in richer embeddings and more accurate predictions.
Jina Reranker v1 Base (English): This offer from Jina AI is a neural text reranking model that enhances search results by prioritizing relevant documents. It handles queries up to 512 tokens and documents up to 8192 tokens. This reranking model ranks at the top compared to its competitors in terms of mean reciprocal rank (MRR), according to BIER, MTEB, LoCo, and an independent benchmark by LlamaIndex.
KNIME Business Hub – Basic Edition: KNIME Analytics Platform is a free and open-source tool. KNIME Business Hub is a commercial complement that enables collaboration and deployment of data science solutions across an organization. It provides a scalable environment for secure collaboration, sharing best practices, and deploying and monitoring analytical workflows. This suite of features helps organizations accelerate data-driven decision-making.
KNIME Business Hub – Standard Editon: KNIME Analytics Platform is a free and open-source tool. KNIME Business Hub is a commercial complement that enables collaboration and deployment of data science solutions across an organization. It provides a scalable environment for secure collaboration, sharing best practices, and deploying and monitoring analytical workflows. This suite of features helps organizations accelerate data-driven decision-making.
LangSmith: This offer from LangChain supports the development of large language model (LLM) apps with explainability, collaboration, testing rigor, and monitoring. It provides visibility into errors and bottlenecks, a prompt hub for collaboration, testing for quality and human feedback, and monitoring for cost, latency, and quality. No engineering experience required.
Levin Assets: This web-based asset management software complies with all asset control and reporting requirements, including historical cost and fair value per US GAAP and IFRS, local tax, and insurable values. It offers multiple depreciation methods and valuation books, as well as budget and project controls for assets under construction. It also promotes shared asset ID between departments and complies with statutory and international regulations.
Lighttpd on Ubuntu Server 20.04 LTS: Lighttpd is a fast, secure, and flexible web server with a low memory footprint and advanced features. Nuvemnest offers Microsoft Azure Virtual Machines with a customer-centric approach, expertise in cloud computing, and future-ready technology to transform businesses in the cloud.
Lighttpd on Ubuntu Server 22.04 LTS: Lighttpd is a fast, secure, and flexible web server with a low memory footprint and advanced features. Nuvemnest offers Microsoft Azure Virtual Machines with a customer-centric approach, expertise in cloud computing, and future-ready technology to transform businesses in the cloud.
Mocha on Debian 11: Mocha is a JavaScript test framework for Node.js with browser support, asynchronous testing, and test coverage reports. Apps4Rent offers a readymade Mocha on Debian 11 for easy integration with Microsoft Azure. It supports both synchronous and asynchronous code, detects and maps uncaught exceptions, and is open source. Azure experts are available around the clock for support.
Mocha on Debian 12: Mocha is a JavaScript test framework for Node.js with browser support, asynchronous testing, and test coverage reports. Apps4Rent offers a readymade Mocha on Debian 12 for easy integration with Microsoft Azure. It supports both synchronous and asynchronous code, detects and maps uncaught exceptions, and is open source. Azure experts are available around the clock for support.
Mocha on Ubuntu 20.04: Mocha is a JavaScript test framework that simplifies asynchronous testing and maps uncaught exceptions to specific test cases. Apps4Rent offers a ready-made Mocha on Ubuntu 20.04 for easy integration with Microsoft Azure. The installation can be verified with a simple command. Apps4Rent also provides support for deploying Mocha on Azure across different OSes.
Mocha on Ubuntu 22.04: Mocha is a JavaScript test framework for Node.js and browsers, supporting both synchronous and asynchronous code. Apps4Rent offers a ready-made Mocha on Ubuntu 22.04 image for easy integration with Microsoft Azure. The installation can be verified with a simple command, and Azure experts are available for support.
Network Scanning: Penetration Testing as a Service: CybeRapid is an on-demand penetration testing platform that provides real-time findings, expert consultation, and retesting on demand. It helps identify potential vulnerabilities and provides recommendations to address discovered issues. The platform allows users to consult with the specific expert assigned to their project in real time and adapt their security strategy immediately.
Nodetrax SaaS Metering: Nodetrax tracks all metering information for your SaaS offering with 99.9% reliability. By using the Nodetrax Metering service, you can also track the spending of lump sum private offers and their usage. Nodetrax’s SaaS offer supports multiple regions and integrates with multiple third-party applications, such as Salesforce.
NTT DATA Smart Management Platform for Healthcare: This NTT DATA platform leverages data from IoT devices, sensors, and medical equipment to provide better patient experiences. It uses predictive and diagnostic analytics, AI, and deep learning to optimize patient outcomes, enhance care quality, and reduce costs. It also helps facilities achieve critical business and operational benefits while ensuring security and compliance.
officeatwork 365: officeatwork 365 is a subscription service that provides access to a suite of apps designed to integrate seamlessly with Microsoft 365. It offers a cost-effective solution that grows with your needs, ensuring brand consistency and operational efficiency. The apps include Template Chooser, Content Chooser, Image Chooser, Slide Chooser, Designer, Wizard, Content Uploader, Mail Signature, Verifier, Formatter, and Smart Template.
pgAdmin: This offer from ATH Infosystems is an open-source administration and management tool designed for PostgreSQL and its related database systems, providing a user-friendly interface for efficiently managing databases, tables, queries, users, and more. It offers a flexible and intuitive interface for managing databases, monitoring server activity, and ensuring security.
Pina Earth – European Climate Projects: Pina Earth leverages the power of tech to enable effective climate action, including turning monoculture forests into mixed and climate-resilient ones. As a leading developer of certified climate projects in Europe, Pina Earth uses artificial intelligence and remote-sensing data to offer high-quality carbon removals to buyers.
Plausible: From ATH Infosystems, Plausible is an open-source, privacy-friendly analytics tool that provides website owners with insights into their site’s traffic and visitor behavior. It prioritizes simplicity, transparency, and data privacy, offering an alternative to traditional web analytics platforms without the use of cookies or personal data tracking. Users can customize their analytics reports and integrate the tool easily into their websites.
Redstor Cloud Backup for Microsoft 365: Redstor offers a backup and recovery solution for Microsoft 365 environments with AI malware detection and InstantData technology. It safeguards critical files and folders on various Microsoft platforms and allows for instant recovery without requiring disk space. The solution also includes retention policies and supports data sovereignty regulations.
RStudio Server on Debian 12: RStudio Server is an open-source, centralized R environment that can be deployed on a server and scaled to accommodate multiple users. It includes collaboration features and can integrate with version control systems like Git. Apps4Rent offers a readymade RStudio Server that can be easily installed and supported by Microsoft Azure experts.
Service Management Automation X: This offer from OpenText is an IT service management suite with machine learning and analytics capabilities. It includes out-of-the-box service management processes, self-service options, and codeless configuration. SMAX also offers automation, multi-tenancy, and deployment flexibility, resulting in lower ticket volumes, faster resolution times, and improved customer satisfaction.
Shift Technology Subrogation Decisions: This offer from Shift Technology uses AI to identify opportunities for cost recovery from third parties, generating actionable cases with insights. It improves on manual and rules-based processes, focusing on coverage, consistency, and precision. The expected results are reduced claim loss and improved deductible recovery, freeing the claims team to focus on resolving claims.
Shipsy: This AI-powered supply chain platform from Llama Logisol helps shippers and logistics companies save costs, reduce working capital, and improve customer experiences. The modular platform offers capabilities for domestic and international logistics, including logistics management, route planning, freight procurement, shipment tracking, and invoice reconciliation. Over 200 enterprises worldwide use its solutions.
Shopify to Power BI Connector: Dataddo’s no-code platform integrates Shopify and over 300 other data sources directly into Microsoft Power BI, providing instant access to analytics and handling all API changes, monitoring and maintaining data pipelines, and rapidly developing new connectors. The platform offers quick setup and deployment, predictable pricing, and secure and compliant data handling.
Sight Machine Factory Copilot on Microsoft Cloud for Manufacturing: This offer from Sight Machine centralizes manufacturing data into a single, AI-powered data estate, improving data management and decision-making processes. It combines Microsoft Azure OpenAI with Sight Machine’s Manufacturing Data Platform to extract and contextualize factory data in real time, enabling users to integrate datasets and run analytics on industrial data.
Smart Management Platform for Manufacturing Safety: This offer from NTT DATA is a comprehensive solution that helps manufacturers ensure worker safety while leveraging data from various sources. The platform uses sensors, edge computing, predictive and diagnostic analytics, AI, and deep learning to monitor and analyze data, providing real-time insights and enabling quick action.
SmartSpace.ai: This offer from SmartSpace is a plug-and-play infrastructure for enterprise deployment of generative AI as a managed service, emphasizing security, flexibility, and control. Its multi-model selection and configuration feature enables businesses to customize AI applications according to their specific needs, avoiding vendor lock-in. The platform provides intuitive tools for rapid development and deployment.
SoftEther VPN Server on Debian 10: Art Group offers this versatile solution for secure and efficient VPN connections with multi-protocol support, high performance, and scalability. SoftEther VPN Server on Debian 10 also provides easy integration with existing IT infrastructure, strong encryption and authentication mechanisms, dynamic DNS and NAT traversal support, and comprehensive logging and monitoring capabilities.
SoftEther VPN Server on Debian 10 Minimal: This offer from Art Group is a versatile solution that enables organizations and individuals to establish encrypted VPN connections effortlessly. It supports multiple VPN protocols, customizable security policies, and access controls to safeguard sensitive data. Businesses can leverage it to establish secure remote work environments, while individuals can use it to access personal files or connect to public Wi-Fi networks.
SoftEther VPN Server on Debian 11: This offer from Art Group offers protection and flexibility for remote workers and businesses seeking to fortify their network infrastructure. It seamlessly integrates with Debian 11, providing a stable and secure platform for establishing encrypted connections and circumventing online restrictions. The extensive feature set includes support for multiple protocols, high-speed connections, and dynamic routing capabilities.
SoftEther VPN Server on Debian 11 Minimal: SoftEther VPN Server on Debian 11 Minimal offers advanced encryption capabilities for secure remote access. It simplifies VPN deployment and offers intuitive controls and comprehensive security measures. Art Group’s preconfigured images are always up to date, reliable, and secure, and they monitor libraries and components for updates and vulnerabilities.
SoftEther VPN Server on Ubuntu 18.04 Minimal: SoftEther VPN Server on Ubuntu 18.04 Minimal is a VPN solution that provides organizations with a comprehensive toolkit for establishing secure connections over the internet. It offers customization options, comprehensive logging and monitoring, secure remote access, and scalability. Art Group packages images according to industry standards, ensuring they are always up to date, reliable, and secure.
Stella PHB (Precision Health Billing): This offer from Indio Technologies automates financial and administrative tasks in healthcare. Designed to automate and simplify a wide variety of financial and administrative tasks, it tracks income and costs, improving financial reporting and visibility. Stella PHB also charges a variety of healthcare services to billing, reducing administrative burden and minimizing billing errors.
Stripe to Power BI Connector: Dataddo’s no-code platform integrates Stripe and over 300 other data sources directly into Microsoft Power BI, providing instant access to analytics and handling all API changes, monitoring and maintaining data pipelines, and rapidly developing new connectors. The platform offers streamlined setup and maintenance, predictable pricing, and secure and compliant data handling.
Teams4PM Subscription: This offer from DigiOps is a cloud-based collaboration toolset for Microsoft Teams that centralizes work and project management. It includes a centralized dashboard app to manage all project data in one place and automates project intake and Teams channel creation. This app is a robust and collaborative option for organizations looking for a project management solution that fully leverages Teams.
TikTok to Power BI Connector: Dataddo’s no-code platform integrates TikTok and over 300 other data sources into Microsoft Power BI, providing instant access to analytics and handling all API changes, monitoring and maintaining data pipelines, and rapidly developing new connectors. The platform offers quick setup and deployment, predictable pricing, and secure and compliant data handling.
Twitter Ads to Power BI Connector: Dataddo’s no-code platform offers instant access to analytics by integrating Twitter Ads and over 300 other data sources into Microsoft Power BI. The platform handles all API changes, monitors and maintains data pipelines, and rapidly develops new connectors. It also offers quick setup and deployment, proactive monitoring, maintenance of data pipelines, and a predictable pricing model.
Ubuntu 22.04 Desktop: From Madarson IT, Ubuntu Desktop as a Service (DaaS) on Microsoft Azure offers a flexible, secure, and cost-effective solution for deploying and managing Ubuntu desktop environments in the cloud. It enables remote work, collaboration, and productivity with enhanced mobility, improved security, scalability, and simplified IT management. Madarson IT certified images are always up to date and secure.
Ubuntu 22.04 Desktop CIS Level 1: Madarson IT offers a Microsoft Azure-based virtual desktop with a pre-configured Ubuntu 22.04 desktop image and RDP access, hardened to address CIS Level 1 compliance needs. This enhances mobility, security, scalability, and simplifies IT management while improving collaboration and productivity. Madarson IT certified images follow industry standards and are always up to date and secure.
Ubuntu 22.04 Desktop CIS Level 2: Madarson IT offers a Microsoft Azure-based virtual desktop with pre-configured Ubuntu 22.04 desktop image and RDP access, hardened to address CIS Level 2 compliance needs. The solution enhances mobility, security, scalability, and simplifies IT management while improving collaboration and productivity. Madarson IT certified images follow industry standards and are always up to date and secure.
Ubuntu 23.04 Desktop: Ubuntu Desktop as a Service (DaaS) on Microsoft Azure offers a flexible, secure, and cost-effective solution for deploying and managing Ubuntu desktop environments in the cloud. It enables remote work, collaboration, and productivity with enhanced mobility, improved security, scalability, and simplified IT management. Madarson IT offers up-to-date, secure, and industry-standard certified images for easy access.
Ubuntu 23.04 Desktop CIS Level 1: Madarson IT offers a Microsoft Azure-based virtual desktop with a pre-configured Ubuntu 23.04 desktop image, RDP access, and CIS Level 1 compliance. The CIS controls are internationally recognized cybersecurity best practices that map to many established standards and regulatory frameworks. The virtual desktop enhances mobility, security, scalability, and simplifies IT management while improving collaboration and productivity.
Ubuntu 23.04 Desktop CIS Level 2: Madarson IT offers a Microsoft Azure-based virtual desktop with a pre-configured Ubuntu 23.04 desktop image and RDP access. It is hardened to address CIS Level 2 compliance needs, providing advanced security measures and controls. The solution enhances mobility, security, scalability, and IT management while improving collaboration and productivity. Madarson IT’s certified images are up to date and secure.
Ubuntu 23.10 Desktop: Ubuntu Desktop as a Service (DaaS) on Microsoft Azure offers a flexible, secure, and cost-effective solution for deploying and managing Ubuntu desktop environments in the cloud. It enables remote work, collaboration, and productivity with enhanced mobility, improved security, scalability, and simplified IT management. Madarson IT offers certified images for easy access.
Ubuntu 23.10 Desktop CIS Level 1: This Microsoft Azure-based virtual desktop comes pre-configured with an Ubuntu 23.10 desktop image, RDP access, and hardened to address the Center for Internet Security (CIS) Level 1 compliance needs. It enhances mobility, improves security, simplifies IT management, and enables collaboration and productivity. Madarson IT certified images are always up to date.
Ubuntu 23.10 Desktop CIS Level 2: Madarson IT offers a Microsoft Azure-based virtual desktop with a pre-configured Ubuntu 23.10 desktop image and RDP access, hardened to address CIS Level 2 compliance needs. Implementing CIS Level 2 benchmarks can help organizations improve security posture and protect against threats. The solution enhances mobility, security, scalability, and simplifies IT management while improving collaboration and productivity.
VennU VM: Medcurio offers a lightweight infrastructure for healthcare providers to access and automate their data in real time. VennU is easy to install, configure, and maintain, and has a transparent security model to grant and track access to data. With codeless APIs, change detection, and transparent security, VennU allows for easy integration with existing EHR systems and advanced automation.
Virtual Branch: This offer from Ondata is an innovative tool that provides personalized customer interaction via video calls, mitigates security risks, and ensures compliance. It allows clients to be serviced by any employee regardless of location and saves on human resources. Virtual Branch addresses the pains of physical branches and serves clients digitally.
WAMP on Windows Server 2019: WampServer is a Microsoft Windows web development environment that allows creation of web applications with Apache2, PHP, and a MySQL database. Nuvemnest provides Microsoft Azure Virtual Machines with a customer-centric approach, expertise in cloud computing, and future-ready technology to transform businesses operations in the cloud.
WampServer on Windows Server 2019: WampServer is a Microsoft Windows web development environment that allows creation of web applications with Apache2, PHP, and MySQL. Nuvemnest offers Microsoft Azure Virtual Machines with a customer-centric approach, future-ready technology, and expertise in cloud computing and Azure solutions. Its services prioritize customer needs and align with business objectives.
Wireguard VPN Server on Rocky 9: This offer from Tidal Media provides a fast, secure, and user-friendly VPN connection with modern cryptography and a simple design. It outperforms IPSec and OpenVPN in speed tests and guarantees steady, dependable connections despite network disturbances. Its streamlined codebase simplifies the review process, making it easier to identify and mitigate potential vulnerabilities.
Wireguard VPN Server on SUSE 15 SP5: This offer from Tidal Media is an open-source VPN protocol that provides efficient encryption, kernel integration, strong security, dynamic routing, and efficient resource utilization. Its minimalist design philosophy reduces the likelihood of vulnerabilities and makes it easier to audit for security flaws. Its lightweight nature reduces resource consumption, making it suitable for a diverse range of hardware configurations.
Xero to Power BI Connector: Dataddo’s no-code platform integrates Xero and over 300 other data sources directly into Microsoft Power BI, providing instant access to analytics and handling all API changes, monitoring and maintaining data pipelines, and rapidly developing new connectors. The platform offers streamlined setup and maintenance, predictable pricing, and secure and compliant data handling.
YouTube to Power BI Connector: Dataddo’s no-code platform offers instant access to analytics by integrating over 300 data sources, including YouTube Analytics and YouTube Video, directly into Microsoft Power BI. The platform handles API changes, monitors and maintains data pipelines, and develops new connectors within 10 business days. Dataddo also offers quick setup, proactive monitoring, and predictable pricing based on the number of data flows.
Go further with workshops, proofs of concept, and implementations
Data Analysis Infrastructure Support for Microsoft Fabric: 6-Week Proof of Concept: This System Exe service uses Microsoft Fabric to set up a data analysis platform for clients, with optional training and support. It promotes democratization of data usage by consolidating data and analysis services into one platform. It also offers support for clients to build their own data analysis platform. Available only in Japanese.
Ipricity Concierge Powered by ChatGPT API: 1-Month Implementation: This Japanese service stores internal documents in Microsoft Azure Data Lake Gen2 and creates indexes using Azure Functions and Azure AI Search for retrieval. It also generates search queries and answers from chat messages using Azure OpenAI Service. This service is only available in Japanese.
AI and ML PoC/Technology Validation: 6-Week Proof of Concept (IN): Atlas Systems offers AI and ML expertise combined with Microsoft Azure capabilities to create proofs of concept tailored to unique business challenges. Deliverables include a working PoC, a detailed report, and strategies for scaling and integrating the PoC into broader production environments.
AI and ML PoC/Technology Validation: 6-Week Proof of Concept: Atlas Systems offers AI and ML expertise combined with Microsoft Azure capabilities to create proofs of concept tailored to unique business challenges. Deliverables include a working PoC, a detailed report, and strategies for scaling and integrating the PoC into broader production environments.
AI Playground for Executives: 4-Hour Workshop: This offer from DAIN Studios is designed to introduce non-technical stakeholders to AI through interactive demos and easy-to-understand information. The aim is to demystify AI and inspire participants to think of their own AI-driven use cases. The Playground can be experienced in person or online and can be customized based on customer preferences.
Azure VMWare Solution: 1-Month Implementation: This offer from LanTec delivers a private cloud infrastructure powered by VMware within Microsoft Azure. Benefit from the flexibility and scalability of Azure while harnessing the robustness of VMware technology. Expert guidance is provided throughout the process, from assessment to deployment. Contact the team to schedule a consultation and start your cloud journey.
Chat with Your Data: 6-Hour Workshop: Learn to create, deploy, and manage AI-powered applications with ease through Data Integrity Services’ workshop training on Microsoft Azure AI Studio Playground. Gain practical experience in customizing system messages, data integration, and retrieval-augmented generation. Emphasizing data privacy and responsible AI usage, this workshop is your gateway to becoming an AI innovator in your field.
Comprehensive AI Solution Deployment: Atlas Systems offers custom AI solutions that integrate smoothly with existing IT infrastructure and business workflow. It provides full project lifecycle management, adoption support, and post-deployment optimization services. Deliverables include a fully integrated AI solution, complete project documentation, and post-deployment support.
Copilot Extensions with Gen AI: 4-Hour Scoping Workshop and 4-Week Pilot Plugin Development: This Saxon workshop guides businesses in integrating Microsoft Copilot with Azure services. It includes integration with existing business applications and deeper insights into organizational data. The workshop is tailored to the needs of the business and is aimed at decision makers, AI development teams, IT managers, and security and compliance officers.
DevOps: 3-Day Workshop: Microsoft Azure-based DevOps implementation minimizes deployment risk, enabling development teams to focus on features while allowing product owners to manage releases. Valence offers a three-day, on-site workshop to develop DevOps architecture and roadmap for CMMI goals, containerization, release management, and test-driven development. Price is subject to change based on customization.
Digital Backpack: This offer from Telelink Business Services is a comprehensive learning platform that supports remote, in-person, and hybrid teaching models. It offers a vast collection of educational content, tools for assignment management, and a communication hub for teachers, students, and parents. Incorporated with Microsoft Teams, the platform utilizes Azure Kubernetes Services and Entra ID for secure authentication.
EHR in Azure Discovery: 4-Hour Workshop: CDW Healthcare offers this Microsoft Azure discovery workshop for healthcare organizations to explore the benefits of Azure for their EHR systems. The workshop covers reliability, scalability, automation, cost optimization, security, and more. It encourages healthcare professionals to leverage Azure’s capabilities to transform their EHR systems and improve patient outcomes.
EHR to Azure: Optimum Healthcare IT offers EHR on Microsoft Azure migration services. The program includes six phases: Initiate & Discovery, Design, Implementation, Test, Deploy, and Close-Out. It has decades of healthcare IT leadership experience and a custom governance structure to ensure alignment between leadership and the complex work being accomplished.
Full-Scale AI: 2-Month Implementation: Atlas Systems offers custom AI solutions that integrate smoothly with existing IT infrastructure and business workflow. It provides full project lifecycle management, adoption support, and post-deployment optimization services. Deliverables include a fully integrated AI solution, complete project documentation, and post-deployment support.
Gen AI for Education Exploration: 90-Minute Workshop: Talk Think Do offers a free 90-minute workshop to educate on Microsoft Azure OpenAI and its benefits for education organizations. The workshop covers topics such as service isolation, data governance, and model selection. Following the workshop, Talk Think Do provides a cost estimate and proposal for a custom generative AI model.
Gen AI in Practice: 1-Day Workshop: This Dain Studios workshop helps organizations understand and implement generative AI tools and applications. Participants will gain a holistic understanding of the technology and learn how to apply it across their workflow. The workshop includes an inspirational immersion, practical introduction and application, and a wrap-up discussion on current limitations and risks.
Gen AI Exploration: 90-Minute Workshop: Talk Think Do offers a free 90-minute workshop to provide practical experience of generative AI and inform use cases for Microsoft Azure OpenAI solutions. The workshop covers service isolation, data governance, security, model selection, and best practices. Following the workshop, Talk Think Do provides a ballpark cost, plus a discovery and proof-of-concept proposal.
GitHub Copilot: 4- to 6-Week Proof of Concept: Xebia’s GitHub Copilot PoC helps development teams building Microsoft Azure applications speed up the process and embrace best practices. The program includes hands-on support, guidance, and training, with an extended version available for more in-depth learning. The PoC does not require prior experience with generative AI.
Microsoft Purview Data Catalog for Analytics and AI: 12-Week Implementation: Sullexis’ service addresses common analytics pain points. The implementation includes a customized data glossary, structured data catalog, organized data map, and tailored governance playbook. The service also provides guidance for defining a charter, policies, and framework for data governance, including data quality initiatives.
Legacy to Azure and On-Prem Migration: 3-Day Workshop: summ-it offers comprehensive application migration services to help businesses adapt to changing market needs by moving their legacy applications to modern, scalable, and efficient platforms on Microsoft Azure. The process involves assessing the existing infrastructure, selecting appropriate Azure services, modernizing the application, migrating data, testing, and monitoring. This offer is available in Poland.
Migrate and Modernize Applications on Azure: 3-Day Workshop: This Ralliton program helps organizations learn about cloud migration and application modernization. Participants gain an understanding of Microsoft Azure cloud services, create a strategic migration plan, and get experience in migrating and modernizing applications. It’s recommended for IT professionals, developers, system architects, and business stakeholders.
Nerdio Manager for Enterprise on Microsoft Azure Virtual Desktop: 3-Day QuickStart: Coretek offers a purpose-built Microsoft Azure landing zone to optimize remote workforces while controlling costs and delivering a secure experience. It provides a new, isolated Azure subscription, a single Azure VPN, and a host pool for up to 25 users. Coretek can help assess, design, deploy, optimize, and manage adoption for organizations of any size.
NIS2-Toolkit: Road to Compliance in 6 Months: DTX and Bluebird & Hawk have partnered to create the NIS2 toolkit, aimed at helping IT service providers and consultants become NIS2 compliant. The toolkit includes process descriptions, implementation guidelines, compliance policies, IT templates, and best practices for safe working, identity management, and endpoint protection.
Reporting and Analytics Dashboard: 4-Week Proof of Concept: Kopius offers scalable reporting and analytics solutions to provide insights for better decision-making. It reviews business requirements, identifies data sets, develops mock designs, and deploys a Microsoft Power BI dashboard on Microsoft Azure with up to three pages based on two data sources.
Reporting and Analytics: 4-Week Power BI Dashboard: Kopius creates a Microsoft Power BI dashboard on Microsoft Azure to showcase their benefits. The dashboard will have up to three pages and use up to two data sources. The solution will be deployed into the customer’s Azure subscription. Kopius has the technical expertise, user experience, and business acuity to implement scalable reporting and analytics solutions.
Slalom Fabric Monitoring Accelerator: This Microsoft Fabric monitor offers visibility into complex data landscapes, enabling better enterprise data governance, streamlined self-service reporting, and easier administration of workspaces, apps, and licenses. The accelerator includes custom Python code, pre-configured semantic models and reports, and a two-hour use case identification workshop.
Contact our partners
Fabric Data Utilization Support
.NET Application Modernization
AdActa Cloud Archiving Service
AI and Machine Learning: 1-Hour Briefing
AI Agents for Healthcare RCM Billing Automation
Smart Payment Record Application
App Library for Deployment Systems
Azure Cloud Strategy: 4-Week Assessment
Azure IoT Services: 1-Day Assessment
Azure Migration Services: 1-Week Assessment
Azure OpenAI Assessment and PoC
Copilot for Microsoft 365: Implementation
Data Scoring as a Service – CSAM Text and Link Detection
Developer-Centric Enterprise Dynamic Application Security Testing (DAST)
ePLDT Talkbot Solution: 1-Month Proof of Concept
Experience.com: Elevate Your Online Reputation
EY Accelerated Analytics Modernization
Fabric Graph Manufacturing Offering with Power BI
Generative AI Services with Azure OpenAI
Hitachi Application Reliability Center: Consulting Services
HYAS Protect for Microsoft Sentinel
KPI Partners Gen AI Assessment
Microsoft E5 Optimization Analysis
NashTech Data Solutions Accelerator
oneclick PaaS – VDI and DaaS Provisioning
Pexip Connect for Microsoft Teams
PRIME Healthcare Provider Data Validation
RStudio Server on Ubuntu 22.04
TCS Generative AI Enterprise Playground on Azure
Video Social Listening for Brands
This content was generated by Microsoft Azure OpenAI and then revised by human editors.
Microsoft Tech Community – Latest Blogs –Read More
Introducing Snowflake Arctic in Azure AI model catalog
We are excited for the next milestone in our expanded collaboration with Snowflake: hosting their innovative open source large language model (LLM), Snowflake Arctic, in Microsoft Azure AI. This collaboration underscores our commitment to pushing the boundaries of AI technology and providing our customers with state-of-the-art tools that drive innovation, efficiency, and transparency.
Expanding Collaboration in Large Language Models
Arctic represents the pinnacle of with its unique Dense-Mixture-of-Experts (MoE) hybrid transformer architecture that activates 50% or fewer tokens than comparably sized models. This model is designed to deliver unparalleled efficiency and intelligence, making it ideally suited for the complex needs of modern enterprises. Arctic excels in a variety of tasks, including SQL code generation, sophisticated instruction following, and complex data analysis, positioning it as a leading tool for developers and businesses looking to leverage AI for real-world applications.
Snowflake has long been a valued partner of Microsoft. Our collaboration includes the introduction of Snowflake on Azure, a powerful integration that combines Snowflake’s industry-leading data platform with Azure’s robust capabilities enabling customers to manage diverse data sets seamlessly within a single system. Building on this foundation, we’ve co-developed a data connector that integrates the Snowflake’s platform with Azure Machine Learning. This joint development accelerates the entire machine learning model lifecycle, from data preparation to deployment, enabling faster and more efficient AI innovations.
The integration of Arctic into the Azure AI model catalog not only expands our selection of models but also enhances our ability to meet diverse enterprise demands. Arctic is optimized for high performance across multiple benchmarks, setting new industry standards for both speed and resource efficiency.
Enhancing transparency in Enterprise AI
Snowflake’s decision to release Arctic under an Apache 2.0 license spurs innovation, allowing developers and researchers to frictionlessly use, fine-tune, and share model improvements back to the community. This open source innovation aligns with a core goal of Microsoft Azure: to promote an expansive development community for all developers both on and off of the Microsoft Azure platform.
On Azure, Arctic will be accessible alongside a vast array of AI models, giving users the freedom to choose and integrate the technologies and tools like prompt flow and Semantic Kernel that best fit their needs. This flexibility is crucial for building customized solutions that are both powerful and scalable.
“I’m excited about our partnership with Microsoft and the integration of Snowflake Arctic into Microsoft Azure,” said Baris Gultekin, Head of AI at Snowflake. “By making Arctic’s state-of-the-art technology available on Azure AI model catalog, we are not only advancing the open source AI model landscape but also ensuring that diverse enterprise demands are met with the highest standards of efficiency and adaptability. This collaboration enables businesses to harness the full potential of AI, fostering an environment of growth and innovation across industries.”
Enhanced Security, Compliance, and Safety
As with all our offerings, the security and compliance of our users’ data is paramount. Arctic’s integration into Azure ensures that enterprises can deploy cutting-edge AI capabilities within the secure confines of Azure’s globally recognized compliance and governance frameworks, all while benefiting from Arctic’s high token efficiency and performance. This security-first approach ensures that our customers can innovate confidently, knowing their data is protected by rigorous security measures. In addition, developers can use Azure AI Content Safety to detect harmful user-generated and AI-generated content in applications, facilitating the development of safer AI applications.
A Future Built on Innovation and Openness
Looking forward, the addition of Snowflake Arctic to Azure AI is just the beginning. We are committed to continuously enhancing our AI offerings, ensuring that our customers have access to the most advanced and efficient models and tools in the market. This collaboration represents a significant step forward in our journey to build an AI-infused future where technology not only amplifies human potential but also fosters a culture of openness and collaboration across industries.
Getting Started with Arctic on Azure
We invite developers, data scientists, and businesses to explore the possibilities with Arctic in Azure AI Studio model catalog. To learn more about the new models visit Snowflake’s press release and the announcement blog.
Microsoft Tech Community – Latest Blogs –Read More
Microsoft Graph API returns no data or unexpected errors for Viva Learning
Hello,
I’m exploring options to create a custom learning management system for my company. The first thing I would like to do is to pull data from Microsoft Viva Learning via the Microsoft Graph API, for example to see which courses the employees have completed. The next step will be to write that data on a SharePoint site.
I’m using the C# Microsoft Graph quick start example as a base, so I can make use of the Microsoft Graph SDK for C#. This is a .NET 7 project, so I upgraded it to a .NET 8 project with the latest versions of the packages:
Azure.Identity version 1.11.2Microsoft.Graph version 5.49.0
For authentication, I have 2 different clients in my code:
ApplicationGraphClient which is using a ClientSecretCredential with a client secret provided by my administratorUserGraphClient which is using an InteractiveBrowserCredential, so that I can log in with my own account
The following permissions have been given to the app by the administrator:
application permissionsUser.Read.AllLearningAssignedCourse.Read.AllLearningContent.ReadWrite.AllLearningSelfInitiatedCourse.Read.AllSites.ReadWrite.Alldelegated user permissionsUser.Readoffline_accessLearningAssignedCourse.ReadLearningContent.ReadWrite.AllLearningSelfInitiatedCourse.ReadLearningProvider.ReadWriteSites.ReadWrite.All
According to the docs, it’s possible to list the learning course activities both for the signed-in user, but also for any user by ID. However, in both cases, I’m getting an empty collection as a result, despite the facts that I’ve completed several courses in Viva Learning. There is no error or exception.
in UserGraphClient:await graphClient.Me.EmployeeExperience.LearningCourseActivities.GetAsync(); // returns an empty collectionin `ApplicationGraphClient:await graphClient.Users[myUser.Id].EmployeeExperience.LearningCourseActivities.GetAsync(); // returns an empty collection
My administrator also made me a knowledge admin, so I have access to the admin tab of Viva Learning in Teams, and I’m able to export the course activity data for my user. The exported Excel file does contain the expected completed courses.
I’ve also tried to get all the learning activities for all the employees, with a top 10 limit, but this fail with an unknown error and code 404, so I suppose it’s implemented in the SDK but not supported by the API.
In ApplicationGraphClient:
await graphClient.EmployeeExperience.LearningCourseActivities.GetAsync(config =>
{
config.QueryParameters.Top = 10;
});
Lastly, I’ve tried to list the learning providers using both the UserGraphClient and ApplicationGraphClient, and in both cases I get the error message “Insufficient privileges to complete the operation.“. As you could see above, I do have the delegated LearningProvider.ReadWrite permission, so it should at least work for my signed-in user.
Thank you in advance for your help.
Hello, I’m exploring options to create a custom learning management system for my company. The first thing I would like to do is to pull data from Microsoft Viva Learning via the Microsoft Graph API, for example to see which courses the employees have completed. The next step will be to write that data on a SharePoint site.I’m using the C# Microsoft Graph quick start example as a base, so I can make use of the Microsoft Graph SDK for C#. This is a .NET 7 project, so I upgraded it to a .NET 8 project with the latest versions of the packages:Azure.Identity version 1.11.2Microsoft.Graph version 5.49.0 For authentication, I have 2 different clients in my code:ApplicationGraphClient which is using a ClientSecretCredential with a client secret provided by my administratorUserGraphClient which is using an InteractiveBrowserCredential, so that I can log in with my own account The following permissions have been given to the app by the administrator:application permissionsUser.Read.AllLearningAssignedCourse.Read.AllLearningContent.ReadWrite.AllLearningSelfInitiatedCourse.Read.AllSites.ReadWrite.Alldelegated user permissionsUser.Readoffline_accessLearningAssignedCourse.ReadLearningContent.ReadWrite.AllLearningSelfInitiatedCourse.ReadLearningProvider.ReadWriteSites.ReadWrite.All According to the docs, it’s possible to list the learning course activities both for the signed-in user, but also for any user by ID. However, in both cases, I’m getting an empty collection as a result, despite the facts that I’ve completed several courses in Viva Learning. There is no error or exception.in UserGraphClient:await graphClient.Me.EmployeeExperience.LearningCourseActivities.GetAsync(); // returns an empty collectionin `ApplicationGraphClient:await graphClient.Users[myUser.Id].EmployeeExperience.LearningCourseActivities.GetAsync(); // returns an empty collection My administrator also made me a knowledge admin, so I have access to the admin tab of Viva Learning in Teams, and I’m able to export the course activity data for my user. The exported Excel file does contain the expected completed courses. I’ve also tried to get all the learning activities for all the employees, with a top 10 limit, but this fail with an unknown error and code 404, so I suppose it’s implemented in the SDK but not supported by the API.In ApplicationGraphClient: await graphClient.EmployeeExperience.LearningCourseActivities.GetAsync(config =>
{
config.QueryParameters.Top = 10;
});Lastly, I’ve tried to list the learning providers using both the UserGraphClient and ApplicationGraphClient, and in both cases I get the error message “Insufficient privileges to complete the operation.”. As you could see above, I do have the delegated LearningProvider.ReadWrite permission, so it should at least work for my signed-in user. Thank you in advance for your help. Read More
Electronic Signatures in Excel
Hi, Having difficulties — and looking for a proper fix please.
I have an Excel workbook saves as a template. It uses multiple calculations and conditional formatting to ensure that the spreadsheet is completed properly. Within this, on one sheet, is a ‘Signature Line’, which will (or should) indicate that the final saved document has been completed and “signed off”.
In practice, this is not working for the end-user. We have the following issues:
The Electronic Signature is calculated for the whole workbook, rather than the individual sheet. Whilst this is really annoying, I can ‘fudge’ a workaround for this (although it is a really ugly ‘kludge’).The standard, default, method of opening a spreadsheet involves the automatic recalculation of all formulas (and thus destroying integrity), irrespective of whether the cell contents have changed. This has the effect of invalidating any previously applied signature. To counter the problems in (2), I have tried changing the template Calculation Options to ‘Manual’, and re-saving the template. Re-opening either the template or a .xlsx workbook saved from the template appears to remember the ‘Manual Calculation’ setting — however, this (currently) does not fix the problem, and I still am getting an ‘Invalid signature’ message — despite being mentioned as a fix in multiple online support pages.I don’t know why, but occasionally this setting to ‘Manual’ appears to revert to ‘Automatic’ on occasions. I have not discovered what causes this.I cannot use any VBA code to ‘fix’ this problem, because VBA is declared by my organisation to be a security issue, and is globally disabled.Likewise, I cannot disable the full internal recalculation behaviour with a registry key change (eg: FullCalcOnLoadOldFile = 0)As a side issue (but currently unable to test), I also need a solution to the problem described here: Excel digital signatures – Microsoft Community Whilst a certificate may expire, and not be valid for signing new documents, it should still verify that a signature on an historical document has a valid signature based upon the date it was originally signed (and not today’s date).
Some of the community posts documenting this problem are many years old — and none appear to have been properly and comprehensively answered anywhere.
Is there a “fix” that I can apply that will actually work (for users other than me)?Are there plans to properly patch Excel so that Electronic Signatures will work and validate as expected in future?
Many thanks.
Resources referred to (all without success):
Add or remove a digital signature for Microsoft 365 files – Microsoft SupportDigital Signatures become invalid after upgrading to MS Office 2010 – Microsoft CommunityI have used a digital signature in a excel file, However when I got – Microsoft CommunityInvalid signature – Microsoft CommunityExcel Workbook File Digital Signature Errors – Microsoft CommunityM365 excel invalid digital signature – Microsoft CommunityDocument contains invalid signatures error if opening digitally signed in newer version Excel file – Microsoft 365 Apps | Microsoft Learn
Hi, Having difficulties — and looking for a proper fix please. I have an Excel workbook saves as a template. It uses multiple calculations and conditional formatting to ensure that the spreadsheet is completed properly. Within this, on one sheet, is a ‘Signature Line’, which will (or should) indicate that the final saved document has been completed and “signed off”. In practice, this is not working for the end-user. We have the following issues:The Electronic Signature is calculated for the whole workbook, rather than the individual sheet. Whilst this is really annoying, I can ‘fudge’ a workaround for this (although it is a really ugly ‘kludge’).The standard, default, method of opening a spreadsheet involves the automatic recalculation of all formulas (and thus destroying integrity), irrespective of whether the cell contents have changed. This has the effect of invalidating any previously applied signature. To counter the problems in (2), I have tried changing the template Calculation Options to ‘Manual’, and re-saving the template. Re-opening either the template or a .xlsx workbook saved from the template appears to remember the ‘Manual Calculation’ setting — however, this (currently) does not fix the problem, and I still am getting an ‘Invalid signature’ message — despite being mentioned as a fix in multiple online support pages.I don’t know why, but occasionally this setting to ‘Manual’ appears to revert to ‘Automatic’ on occasions. I have not discovered what causes this.I cannot use any VBA code to ‘fix’ this problem, because VBA is declared by my organisation to be a security issue, and is globally disabled.Likewise, I cannot disable the full internal recalculation behaviour with a registry key change (eg: FullCalcOnLoadOldFile = 0)As a side issue (but currently unable to test), I also need a solution to the problem described here: Excel digital signatures – Microsoft Community Whilst a certificate may expire, and not be valid for signing new documents, it should still verify that a signature on an historical document has a valid signature based upon the date it was originally signed (and not today’s date).Some of the community posts documenting this problem are many years old — and none appear to have been properly and comprehensively answered anywhere. Is there a “fix” that I can apply that will actually work (for users other than me)?Are there plans to properly patch Excel so that Electronic Signatures will work and validate as expected in future? Many thanks. Resources referred to (all without success):Add or remove a digital signature for Microsoft 365 files – Microsoft SupportDigital Signatures become invalid after upgrading to MS Office 2010 – Microsoft CommunityI have used a digital signature in a excel file, However when I got – Microsoft CommunityInvalid signature – Microsoft CommunityExcel Workbook File Digital Signature Errors – Microsoft CommunityM365 excel invalid digital signature – Microsoft CommunityDocument contains invalid signatures error if opening digitally signed in newer version Excel file – Microsoft 365 Apps | Microsoft Learn Read More
How capable is CoPilot really
I am 1 week into using Copilot.
I got ambitious and asked it to do the following.
After defining 5 projects in detail including Name, Due Dates, Effort; I asked copilot to find all the relevant information on these projects which were all very recent and then perform the following tasks.
1. Create OneNote pages for each project with detailed notes, links, images and ideas for each project.
2. Block out my calendar in 2 hour blocks with some other restraints to complete the projects on time.
CoPilot managed to impressively fail in all of this.
All I got was a reworded, rehash of what I had already told it basically so I can go and do the work myself.
I then thought it was the way I had written the prompt and trying both CoPilot and then ChatGPT 4 to write me a suitable prompt, I generally got even worse results.
I then simply tried to get a summary of information on one of my projects written into a OneNote page, I did this through Copilot in OneNote and I got the following response…
“I’m sorry, but I am not able to access your emails or SharePoint. I am a chat-based AI Assistant and my capabilities are limited to the chat box. Is there something specific you are looking for that I can help you with.”
Right now, CoPilot seems about as useful as Siri!! Apart from word salad it cannot seem to produce anything of use?
I really hope it is just me, as I really want to get the most out of it, but already feeling like I spent $500+ on 12 months of frustration.
I am 1 week into using Copilot.I got ambitious and asked it to do the following.After defining 5 projects in detail including Name, Due Dates, Effort; I asked copilot to find all the relevant information on these projects which were all very recent and then perform the following tasks.1. Create OneNote pages for each project with detailed notes, links, images and ideas for each project.2. Block out my calendar in 2 hour blocks with some other restraints to complete the projects on time. CoPilot managed to impressively fail in all of this.All I got was a reworded, rehash of what I had already told it basically so I can go and do the work myself. I then thought it was the way I had written the prompt and trying both CoPilot and then ChatGPT 4 to write me a suitable prompt, I generally got even worse results. I then simply tried to get a summary of information on one of my projects written into a OneNote page, I did this through Copilot in OneNote and I got the following response…”I’m sorry, but I am not able to access your emails or SharePoint. I am a chat-based AI Assistant and my capabilities are limited to the chat box. Is there something specific you are looking for that I can help you with.” Right now, CoPilot seems about as useful as Siri!! Apart from word salad it cannot seem to produce anything of use? I really hope it is just me, as I really want to get the most out of it, but already feeling like I spent $500+ on 12 months of frustration. Read More
Excel formula
how to select top 10 contractor name from 51 territory on the basis of their volume lifting in Excel formula
how to select top 10 contractor name from 51 territory on the basis of their volume lifting in Excel formula Read More
How fix QuickBooks 2024 keeps crashing after update windows 11/10?
Troubleshooting Solutions: QuickBooks 2024 keeps crashing
Experiencing frequent crashes in QuickBooks 2024 can be frustrating. Here are some troubleshooting steps to address this issue:
Update QuickBooks: Ensure that your QuickBooks software is updated to the latest version. Updates often include bug fixes and performance improvements that can resolve crashing issues.
Check System Requirements: Verify that your computer meets the system requirements for running QuickBooks 2024. Inadequate hardware or outdated drivers may lead to instability and crashes.
Run QuickBooks in Compatibility Mode: Try running QuickBooks in compatibility mode for an earlier version of Windows. Right-click the QuickBooks shortcut, go to Properties > Compatibility, and select a compatible operating system.
Check for Software Conflicts: Identify any conflicting software that may be causing QuickBooks to crash. Temporarily disable antivirus, firewall, or other security software, as well as any third-party applications running in the background.
Review Event Viewer Logs: Check the Windows Event Viewer for error messages related to QuickBooks crashes. This can provide insights into the underlying cause of the issue, such as faulty modules or system errors.
Repair QuickBooks Installation: If QuickBooks continues to crash, repair the installation. Go to Control Panel > Programs and Features, select QuickBooks, and choose Repair. This can fix any corrupted files or settings that may be causing the crashes.
Disable Hardware Acceleration: Disable hardware acceleration within QuickBooks settings. Go to Edit > Preferences > Desktop View and uncheck the option for “Enable hardware acceleration.”
Test in Safe Mode: Boot your computer into Safe Mode and see if QuickBooks still crashes. If it doesn’t, the issue may be caused by a third-party application or driver. Restart your computer normally after testing.
Check for Data Corruption: Verify the integrity of your company file using the built-in Verify Data utility in QuickBooks. If errors are detected, use the Rebuild Data tool to repair them.
Contact QuickBooks Support: If none of the above solutions resolve the issue, contact QuickBooks customer support for further assistance. They can provide advanced troubleshooting steps or escalate the issue to their technical team for investigation.
By following these troubleshooting solutions, you should be able to diagnose and resolve the QuickBooks 2024 keeps crashing issue. Remember to regularly backup your company file to prevent data loss in case of unexpected crashes.
Troubleshooting Solutions: QuickBooks 2024 keeps crashing Experiencing frequent crashes in QuickBooks 2024 can be frustrating. Here are some troubleshooting steps to address this issue: Update QuickBooks: Ensure that your QuickBooks software is updated to the latest version. Updates often include bug fixes and performance improvements that can resolve crashing issues.Check System Requirements: Verify that your computer meets the system requirements for running QuickBooks 2024. Inadequate hardware or outdated drivers may lead to instability and crashes.Run QuickBooks in Compatibility Mode: Try running QuickBooks in compatibility mode for an earlier version of Windows. Right-click the QuickBooks shortcut, go to Properties > Compatibility, and select a compatible operating system.Check for Software Conflicts: Identify any conflicting software that may be causing QuickBooks to crash. Temporarily disable antivirus, firewall, or other security software, as well as any third-party applications running in the background.Review Event Viewer Logs: Check the Windows Event Viewer for error messages related to QuickBooks crashes. This can provide insights into the underlying cause of the issue, such as faulty modules or system errors.Repair QuickBooks Installation: If QuickBooks continues to crash, repair the installation. Go to Control Panel > Programs and Features, select QuickBooks, and choose Repair. This can fix any corrupted files or settings that may be causing the crashes.Disable Hardware Acceleration: Disable hardware acceleration within QuickBooks settings. Go to Edit > Preferences > Desktop View and uncheck the option for “Enable hardware acceleration.”Test in Safe Mode: Boot your computer into Safe Mode and see if QuickBooks still crashes. If it doesn’t, the issue may be caused by a third-party application or driver. Restart your computer normally after testing.Check for Data Corruption: Verify the integrity of your company file using the built-in Verify Data utility in QuickBooks. If errors are detected, use the Rebuild Data tool to repair them.Contact QuickBooks Support: If none of the above solutions resolve the issue, contact QuickBooks customer support for further assistance. They can provide advanced troubleshooting steps or escalate the issue to their technical team for investigation.By following these troubleshooting solutions, you should be able to diagnose and resolve the QuickBooks 2024 keeps crashing issue. Remember to regularly backup your company file to prevent data loss in case of unexpected crashes. Read More
Something went wrong: Invalid arguments when accessing the Sharepoint list (online)
Hi everyone,
Since few days I am observing an issue when I am accessing a Sharepoint list (in this case UserManagement). Like when I navigate to that specific Sharepoint site I get the following issue:
Some of my colleagues are also facing the same issue while accessing the sharepoint list:
So what might be the problem and the cause for this issue.
In some cases after refreshing the page I was able to see the records again, but sometimes it tends to fail as well.
Regards,
Sidhant
Hi everyone,Since few days I am observing an issue when I am accessing a Sharepoint list (in this case UserManagement). Like when I navigate to that specific Sharepoint site I get the following issue: Some of my colleagues are also facing the same issue while accessing the sharepoint list:So what might be the problem and the cause for this issue. In some cases after refreshing the page I was able to see the records again, but sometimes it tends to fail as well. Regards,Sidhant Read More
Pull data from another excel document
I have 2 excel documents (not work sheets). ABC.xls, PQR.xls and XYZ.xls.
I want to automatically pull the data from ABC and PQR to XYZ. Is there any way?
All three documents are saved in same share point location in my computer.
Unfortunately, i cannot make it as multiple sheets in same document.
Can it be done by Power BI?
I have 2 excel documents (not work sheets). ABC.xls, PQR.xls and XYZ.xls. I want to automatically pull the data from ABC and PQR to XYZ. Is there any way?All three documents are saved in same share point location in my computer.Unfortunately, i cannot make it as multiple sheets in same document. Can it be done by Power BI? Read More
Entra ID protection – Integration into Defender XDR
Hi everyone,
is it possible to integrate this into Defender? Or is there a hunt or Cloud App Policy that will trigger an Alert in Defender Portal?
BR
Stephan
Hi everyone, is it possible to integrate this into Defender? Or is there a hunt or Cloud App Policy that will trigger an Alert in Defender Portal? BRStephan Read More
Coding suggestion with my personal GPT using Open AI
We have created our private GPT using our documents in Azure Open AI and Open AI Search. Now I would like it should search my documents (which it is doing) but I would also like to it should write down code in any language as per my prompt. Do you think it will be still Private to the company or for code it is going to the internet?
We have created our private GPT using our documents in Azure Open AI and Open AI Search. Now I would like it should search my documents (which it is doing) but I would also like to it should write down code in any language as per my prompt. Do you think it will be still Private to the company or for code it is going to the internet? Read More
SUM Employees using condition formula
HI
I have an issue with one formula. I created a formula to know the number of projects i have within a FY
Definition of project:
IF SAME CUSTOMER, IF SAME COUNTRY and Same GO Live Date = 1, otherwise 0
I custom sorted my file with Customer, Country and Go lIve Date and used the formula below comparing previous row.
=IF(B2<>B3,1,IF(AND(B2=B3,BE2<>BE3),1,IF(AND(B2=B3,D2=D3,BE2=BE3),0,1)))
I have a column called Contract EE (Employees) and I have been asked to filter projects with max 50employees, 100 employees and + 100 employees but I am struggling to add this SUM in my formula. Any help? What I need is the image below showing number of employees for every count of “1” using the formula with the 3 conditions.
Client NameCIDCountryContract EEOps Forecast & ActualsNum of Projects EE SizeCustomer A010002United States209/1/202203 conditions = 1 Project300Customer A010002United States2809/1/20221Customer B010022Sweden405/1/20241 40Customer C010038Egypt604/1/20241 60Customer D010047Singapore337/1/20221 33Customer E010072Spain13/1/20241 1Customer F010109Austria758/1/20221 75Customer G010109Brazil2006/1/202303 conditions = 1 Project358Customer G010109Brazil1506/1/20230Customer G010109Brazil86/1/20231
HI I have an issue with one formula. I created a formula to know the number of projects i have within a FY Definition of project:IF SAME CUSTOMER, IF SAME COUNTRY and Same GO Live Date = 1, otherwise 0 I custom sorted my file with Customer, Country and Go lIve Date and used the formula below comparing previous row. =IF(B2<>B3,1,IF(AND(B2=B3,BE2<>BE3),1,IF(AND(B2=B3,D2=D3,BE2=BE3),0,1))) I have a column called Contract EE (Employees) and I have been asked to filter projects with max 50employees, 100 employees and + 100 employees but I am struggling to add this SUM in my formula. Any help? What I need is the image below showing number of employees for every count of “1” using the formula with the 3 conditions. Client NameCIDCountryContract EEOps Forecast & ActualsNum of Projects EE SizeCustomer A010002United States209/1/202203 conditions = 1 Project300Customer A010002United States2809/1/20221Customer B010022Sweden405/1/20241 40Customer C010038Egypt604/1/20241 60Customer D010047Singapore337/1/20221 33Customer E010072Spain13/1/20241 1Customer F010109Austria758/1/20221 75Customer G010109Brazil2006/1/202303 conditions = 1 Project358Customer G010109Brazil1506/1/20230Customer G010109Brazil86/1/20231 Read More