Resources  
  • How To Add Jetpack Compose In Existing Kotlin ProjectMar 27, 2024. This article guides you through the step-by-step process of integrating Jetpack Compose into your existing Kotlin Android project.
  • Solid Principle in C# : A Quick Reference with ExampleMar 24, 2024. These principles guide object-oriented design for more understandable, flexible, and maintainable software. The Single Responsibility Principle suggests a class should have only one reason to change, such as a User class handling user properties but not user persistence.
  • Create Bulk Variables in Azure DevOps Variable Groups with CLIMar 22, 2024. Learn how to automate the process of adding multiple variables to a Variable Group in Azure DevOps using the Azure DevOps CLI and Microsoft Excel. This article provides a step-by-step guide to streamline the process and avoid manual data entry.
  • How to Add Controls in AG-Grid In AngularMar 17, 2024. AG-Grid, a powerful library for Angular, allows easy integration of data grids. Follow these steps to set up, customize, and enhance AG-Grid in your Angular application.
  • Save specific Email to Excel File using Azure Logic App Mar 12, 2024. Azure Logic Apps is a cloud-based service that streamlines business processes. This guide details how to automate moving specific emails to Excel in OneDrive seamlessly using Azure Logic App workflows.
  • Auto-Populate Azure Pipeline Variables and ConnectionsMar 11, 2024. In this article we will discuss how deployment settings file can be used to auto-populate environment variables and connection references in target environment.
  • Top 10 VPNs in 2024Mar 11, 2024. While some VPNs excel in speed, others prioritize features or affordability. Here's a list of some of the top contenders in 2024.
  • How to Add Customize Download Timer Button in BloggerMar 07, 2024. This article provides a guide on adding a customized download timer button on Blogger, offering increased convenience and control to users. It discusses the benefits of such a button, including scheduled downloads, prevention of disruptions, improved user experience.
  • A Comprehensive Guide to Nullable Reference Types in C# 10Mar 07, 2024. Explore a comprehensive guide to leveraging nullable reference types in C# 10 by Ziggy Rafiq, providing detailed explanations, code examples, and best practices for improving code safety and robustness. Learn how nullable reference types enable developers to catch null-related bugs at compile time, reducing the likelihood of runtime errors and enhancing code quality.
  • Add Company Email Signatures and Disclaimers in Microsoft 365Mar 05, 2024. Explore methods to Create and Add Company Email Signatures and Disclaimers in Microsoft 365. Get the best guides to add Email Signatures and Disclaimers in Microsoft 365 in easy steps.
  • Exploring the Export Functionality within SharePoint ListsMar 04, 2024. The Export feature in SharePoint Lists facilitates exporting list data to formats like Excel or CSV, aiding data analysis and sharing. It enhances collaboration by enabling users to extract and manipulate data conveniently.
  • Bulk Add Terms, Term Sets, and Groups with PowerShell in SharePointFeb 29, 2024. This blog post provides step-by-step instructions on process of executing PowerShell scripts to import term store metadata elements into SharePoint, automating the creation and management of taxonomy structures.
  • Automating Excel data to SharePoint Lists with Power AutomateFeb 28, 2024. In this article, we will discover seamless automation of Excel data migration to SharePoint Lists using Power Automate. Streamline your workflows, enhance productivity, and ensure data integrity with this efficient solution.
  • How to Add Additional Domain Controller in ServerFeb 28, 2024. Deploying additional domain controllers increases the redundancy, which results in even greater resilience and higher availability.
  • How to Create CSV File from Excel Spreadsheet Feb 27, 2024. Explore methods to Create CSV File from Excel Spreadsheet. Get the best solutions to carte or save CSV files from Excel Spreadsheet in easy steps.
  • Create an Excel Template and Upload It to the LibraryFeb 26, 2024. In this article, Here, you'll find instructions on how to create and use an Excel template for various tasks, ensuring a blank starting point for your projects.
  • Async Patterns in MVC Controllers for Efficiency or Adding Unnecessary Complexity?Feb 22, 2024. Explore the necessity of async patterns in MVC controllers—unveiling the intricacies of conventional and alternative coding styles
  • How to Create a SharePoint List Directly from ExcelFeb 13, 2024. Learn to seamlessly migrate Excel data to SharePoint lists. Enhance collaboration and data management with this step-by-step guide.
  • How to Add Highlighted Image Slider in BloggerFeb 13, 2024. Enhance your Blogger blog with a highlighted image slider. Learn how to customize your blog layout by adding an interactive image carousel using widgets or plugins for a visually appealing browsing experience
  • Excel Formula: Generate Random Dates and Extract Day, Month, Year, QuarterFeb 05, 2024. This article shows how to Generate Randomised Dates and Extract Day, Month, Year, and Quarter using a Single Formula in Excel. Explore advanced Excel formulas using the LET function and dynamic arrays to generate 100,000 rows of randomized dates.
  • PowerApps Save as CSV from Export to ExcelJan 29, 2024. In this article, we will learn how to export a report in CSV format using PowerApps and Power Automate. Create a SharePoint list, connect data sources, and build a flow to export data to a CSV file.
  • Null Handling in C# Using Null-Conditional and Coalescing OperatorsJan 25, 2024. In C# programming, null handling is a critical consideration for robust and error-resistant code. This brief guide introduces two powerful operators, the null-conditional operator (?.) and the null-coalescing operator (??), designed to streamline null-related challenges.
  • PowerApps Save as CSV or Generate Report from CSV/ExcelJan 24, 2024. I often come across where the business wants to have a report in excel format. But the question is could we save as csv using PowerApps. Then with the help of Power Automate we can. There is a lot of requirements which could be achieved in PowerApps with the help of Power Automate.
  • How to Add ESLint to an Vue.jsJan 02, 2024. Learn how to enhance code quality and adhere to standards in your Vue.js application by adding ESLint. Follow this guide to set up ESLint and customize configurations for your project.
  • Write the Data to Excel TemplateDec 29, 2023. Learn the art of writing data into Excel templates in C# with this step-by-step guide. Create an ASPX page, use libraries like Newtonsoft.Json, and implement the Factory Pattern effortlessly.
  • Adding Nuget Packages/Dependent Assemblies into Microsoft D365 CRM PluginDec 28, 2023. Adding Nuget Packages into Microsoft D365 CRM Plugin.
  • How to Add Popup Image in Blogger SitesDec 25, 2023. Here are some steps for adding a responsive pop-up image with a link in Blogger
  • Manage Azure Subscription Owners: Add and Remove User AccessDec 22, 2023. Giving and taking away elevated privileges inside the Azure environment is what it means to designate and remove a user as an Owner of an Azure subscription. An owner has complete control over the subscription, including the ability to regulate resources, configurations, and user access.
  • How to Add Christmas Effects to Your WebsiteDec 21, 2023. Add a visual effect of falling snowflakes to your website. Unlock the festive spirit on your website! Learn the hassle-free method to add Christmas effects to your Google Blogger site. Follow six simple steps and witness the magic unfold seamlessly.
  • How to Add a Popup for DELETE a Record in Power AppsDec 15, 2023. This step-by-step guide walks you through configuring a canvas app in Power Apps. Learn how to create screens, galleries, and dialogs while implementing functionality like deletion and user access management.
  • Adding Report Pages as Custom Tooltips in Power BIDec 13, 2023. Adding Report Pages as Custom Tooltips.
  • Advanced Conditional Formatting: Turn On & Off Cell Color with CHECKBOXES in ExcelDec 12, 2023. This article shows how to create advanced conditional formatting in Excel and using the new checkboxes to turn on and off the applied cell colors.
  • Using Date Function in Data Validation in ExcelDec 10, 2023. Learn how to use Excel's DATE function for effective data validation. Set criteria for a date column to ensure entries fall within a specific range, enhancing accuracy and data quality.
  • Adding Multi-Language Support to Flutter AppsDec 04, 2023. In this article, you will learn how to add multi-language support to your Flutter app. You will explore the steps for setting up language assets, creating language files, and implementing the necessary localization logic. By providing seamless translation and support for a global audience, you can enhance the user experience of your Flutter mobile application.
  • How to Create Sample Maven Project by Adding TestNG Nov 28, 2023. Learn how to create a Maven project and add TestNG dependencies in Eclipse. Follow steps like configuring Maven settings, specifying project coordinates, and adding dependencies for efficient project development and execution.
  • VSTACK Append in Excel with Total RowNov 24, 2023. In the article, Explore the power of Microsoft Excel with the LET, VSTACK, and HSTACK functions. This article guides you through creating complex formulas for dynamic data combination and summarization across multiple tables.
  • How to Create Active Directory Domain ServicesNov 23, 2023. This article guides readers on solving the Two Sum problem in Java. It illustrates a straightforward implementation using nested loops to find indices of two numbers in an array that sum up to a target. The provided Java code efficiently tackles this common coding challenge.
  • Streamlining Azure DevOps Management with ExcelNov 22, 2023. In the dynamic landscape of software development, effective project management is non-negotiable. Microsoft Azure DevOps emerges as a powerhouse, offering a suite of tools covering the entire software development lifecycle. Among its array of features, the integration of Excel Connector proves to be a game-changer, empowering teams to manage projects more efficiently by leveraging the familiar and flexible environment of Excel.
  • How to Add Syncfusion Stock Chart in Vue.jsNov 21, 2023. This article will teach us how to add a Syncfusion stock chart in the Vue.js application.
  • Value Types vs Reference Types in C#Nov 18, 2023. This comprehensive guide delves into the fundamental concepts of C# data types, distinguishing between value types and reference types. Covering characteristics, pros and cons, key differences, and best practices, it offers insightful recommendations for optimal programming.
  • Learn to Add Role Assignment to Service BusNov 09, 2023. Learn to Add Role Assignments to the Service Bus. The steps you have provided seem to outline the process for adding roles to Azure Service. This can be a crucial aspect of managing access and permissions within the Azure environment, ensuring that the right users have the appropriate level of access to the required resources. Assigning roles helps in controlling the actions that users can perform within the service.
  • Efficient Data Integration using HSTACK & XLOOKUP FunctionsNov 07, 2023. This article effectively explains how to integrate data from different sources using Excel's HSTACK and XLOOKUP functions. The step-by-step breakdown and the clear demonstration with sample data make it easy for readers to understand and implement the data integration process seamlessly.
  • Register your app with Azure ADNov 07, 2023. Learn to register your application to the Azure Entra ID. This article provides a concise and clear guide for adding App Registration to Azure Entra ID and creating a client secret. The step-by-step instructions are easy to follow, making it convenient for readers to understand and implement the process.
  • Create Excel Charts (Waterfall, Funnel, Treemap, etc) with JavaOct 30, 2023. This article explains how to create waterfall chart, funnel chart, treemap chart, box and whisker chart, sunburst chart, and histogram chart in Excel with Java.
  • How We Can Add Setup Project in Window Service?Oct 27, 2023. In this article, we will see how we can add a Windows services installer. You can combine your service with any required files, registry entries, and configurations into a single installation package using this installer. The setup project makes it easier to deploy your Windows service.
  • Types of Errors in JavascriptOct 26, 2023. Explore the diverse landscape of JavaScript errors, from syntax and reference issues to type, range, and logical errors, in this comprehensive guide to better understand, identify, and address coding issues.
  • Creating a Calendar Table in Excel Power Query and its BenefitsOct 20, 2023. This blog is based on Creating a Calendar Table in Excel Power Query
  • Read And Upload Excel Data To Oracle TableOct 18, 2023. In the realm of data management and integration, the process of reading and uploading Excel data to an Oracle table involves multiple fundamental steps. First, the data needs to be read from an Excel file, which might contain various types of information such as numbers, texts, or dates. This data is typically organized in rows and columns.
  • ClosedXML Excel Printing settingsOct 06, 2023. This article will describe all the printing settings available in CloseXML excel library.
  • Python in Excel Data Analysis using the New PY FunctionOct 04, 2023. This article delves into performing Data Analysis using the new Python in Excel PY function
  • Dependency Injection And Service Lifetime in ASP.NET CoreSep 18, 2023. Dependency injection And Service Lifetime in ASP.NET Core With Realtime example
  • Excel Sheet Generation in .NET Core 6 Web API and Angular 15Sep 04, 2023. By implementing this approach, you create a hassle-free way for users to generate and download Excel sheets from your web application, improving data reporting and export capabilities. This can be particularly useful in scenarios where users need to work with tabular data in Excel format without manual data entry or complicated procedures.
  • Console Application Add, Mul, Div, SubSep 01, 2023. adding, subtracting, multiplying and dividing of three numbers which will be entered by the user
  • IoT Success with AzureAug 25, 2023. Unlock Azure IoT Success: Best Practices for Seamless Implementation. From defined objectives to compliance, explore how to excel in IoT projects within the Azure ecosystem for transformative outcomes.
  • Learn to add API Permissions in Azure App RegistrationAug 22, 2023. Learn to add API Permissions in Azure App Registration. API permissions to an Azure App Registration is an important step when you want to allow your application to access and use specific APIs or services in Azure. Here's a step-by-step guide on how to add API permissions to an Azure App Registration.
  • Passing an argument by reference in C#Aug 20, 2023. This article contains useful information about how to use ref keyword in your C# program with the proper and easy to understand example.
  • Add Row in Excel using Power AutomateAug 18, 2023. Streamline Excel Data Input: Automate with Power Automate and Microsoft Forms. Learn how to effortlessly add rows to Excel using these tools, enhancing data management and efficiency.
  • Learn to add a Custom Domain in Azure Active DirectoryAug 16, 2023. Discover how to integrate a custom domain into Azure Active Directory and establish it as the primary AD. Enhance user authentication and streamline business operations using tailored domains in Microsoft Azure.
  • Convert Excel Data Into DataTableAug 08, 2023. Learn to leverage the .NET Excel framework for effortless handling of Microsoft Excel files in your .NET applications. Discover conversion techniques, API integration, and practical implementation for data manipulation.
  • Adding a Digital Signature to a PDF Using a PFX File And iTextSharp in C#Aug 08, 2023. In this article we learn how to add a digital signature to a PDF Using a PFX file and iTextSharp In C#
  • How To Work with JSON in SQL Server?Aug 08, 2023. In this article, we will learn about How To Work with JSON in SQL Server
  • Adding Highlighted Content Web part in SharePoint Online PageJul 26, 2023. The Highlighted Content Web Part in SharePoint Online allows dynamic display of content from various sources, including document libraries and SharePoint sites. Use of Highlighted Content Web part.
  • Adding Users to Active Directory using PowerShell ScriptsJul 24, 2023. Managing user accounts in Active Directory becomes seamless with PowerShell, a robust command-line tool. Learn how to add, modify, and delete users, streamlining administrative tasks for enhanced efficiency and automation.
  • How To Add Authentication In ASP.NET Core 6 MVC Project Using Identity?Jul 11, 2023. In this article, We will be learning how to add authentication in ASP.NET 6 Using Identity service.
  • How to Add Tooltip in React ApplicationJul 11, 2023. This article demonstrates how to implement tooltips in a React application using Material UI. It covers the prerequisites, setting up a React project, installing Material-UI, creating a tooltip component, and showcasing the functionality through code examples. The article provides a detailed guide on adding tooltips to enhance user interactions in React applications using Material UI.
  • How To Add Audio And Video To HTML?Jul 03, 2023. In this article, we will learn how to add audio and video tags in an HTML document.
  • Add HTML Rich Text Editor to PowerApps FormsJun 29, 2023. The problem statement discusses the issue of default text fields appearing instead of rich text fields in PowerApps forms. The approach outlines steps to replace the text field with a rich text editor and save formatted data.
  • Extracting Text from Images using Azure OCR and Match in an Excel Sheet using PandasJun 22, 2023. The concept revolves around enabling the police to capture a snapshot of a vehicle's license plate and quickly retrieve the corresponding information from a database. In this particular scenario, an Excel sheet serves as the database for storing and accessing the relevant details.
  • How to Add Material-UI in React?May 30, 2023. This article provides a step-by-step guide on how to add Material-UI to a React application. It begins by listing the prerequisites, which include familiarity with HTML, JavaScript, and Bootstrap, as well as having Node.js installed.
  • How to Add Security Headers to Your Website Using .htaccessMay 18, 2023. Want to know how to add security headers to your website using .htaccess? Read this blog and add content security policy header in wordpress site.
  • How To Add Multimedia Content With HTMLMay 13, 2023. I will describe how to use media tags to make your web page more attractive and interactive.
  • Export To Excel In Angular Using ExcelJSMay 11, 2023. Export To Excel In Angular Using ExcelJS
  • Adding Tags for Azure VMMay 02, 2023. Learn how to add tags to an Azure VM
  • Highlight Cells Using Conditional Formatting in Excel in JavaApr 26, 2023. This article provides a comprehensive guide on using Conditional Formatting in Excel spreadsheets using Free Spire.XLS for Java library. It covers six examples of how to highlight cells using conditional formatting, including highlighting duplicate values, highlighting top/bottom 3 values, highlighting values above/below average, highlighting values between two numbers, highlighting every other row/column, and adding data bars to a cell range. The article also includes step-by-step instructions on how to install the Free Spire.XLS for Java library, prerequisite knowledge, and code examples for each of the six examples. By the end of the article, readers will have a solid understanding of how to apply conditional formatting to their Excel spreadsheets using Java.
  • How To Use Reference And Borrowing In Rust?Apr 25, 2023. references and borrowing in rust, rust, references in rust
  • Generating Dynamic Documents From Existing TemplateApr 24, 2023. Generating dynamic documents (PDF/WORD/EXCEL/POWERPOINT) from the existing template.
  • Add ChatGPT Functionalities Within Visual Studio CodeApr 24, 2023. Add ChatGPT Functionalities Within Visual Studio Code.
  • Add ChatGPT functionalities within Visual StudioApr 21, 2023. Add ChatGPT functionalities within Visual Studio
  • 8 Ways to Protect Excel Files in JavaApr 21, 2023. Microsoft Excel also offers users many other ways to protect Excel files. This article will introduce 8 ways to protect Excel files using Java.
  • Creating PowerPoint Add-in using VSTOApr 14, 2023. This article explains how we can create PowerPoint Addin using VSTO and how to access the PowerPoint objects like slides/shapes
  • Outlook (2): Add a QQ email account to OutlookApr 11, 2023. This article will discuss how to Add a QQ email account to Outlook
  • How To Export HTML Table In Excel Using jQueryApr 11, 2023. We will see How to export an HTML table in Excel by using jquery
  • Export To Excel In Angular 12Apr 10, 2023. In this article, I am going to demonstrate how to export a set of data into an Excel sheet using Angular 12.
  • How To Add Date Time Tick To File Name Before Upload In Document Library Using Power AutomateApr 07, 2023. In this blog, we will see how to append date time tick in file name using Power Automate.
  • How To Add Custom Authentication In BlazorApr 06, 2023. Authentication is an essential aspect of web applications, and the Blazor server comes with built-in support for authentication. However, in some cases, you may need to implement custom authentication for your application
  • How To Read Excel File In Next JS ApplicationMar 27, 2023. In this article, we learn how to read Excel file in React JS application.
  • How To Add Font, FontWeight To Text In SwiftUIMar 24, 2023. In this article, we are going to explore the Text component in SwiftUI. We will also know how to use Text view modifiers.
  • Convert Excel To Data Table In ASP.NET Core Using EP PlusMar 13, 2023. In this article, we are going to talk about how you can convert excel to DataTable using the EPPlus package in Asp.Net Core MVC application. You can also use this method in any .Net project not only .Net Core MVC.
  • How To Add Comments To A Gatsby BlogFeb 21, 2023. In this tutorial, we'll learn to add a comments section to your Gatsby.js blog
  • Reference Types Are Not Passed By Reference!Feb 20, 2023. This article will help you to understand what are the real differences between reference and value types and how reference types behave under the hood
  • Add Charts To Visualize Your Django Polling-App DataFeb 17, 2023. Add charts to your Django polling app to make it more elegant & to get valuable insights of the poll.
  • How To Create An Add-in In Outlook Using ASP.NETFeb 08, 2023. In this article, we will learn, how to create a simple Add-in in Outlook using ASP.NET and C#.
  • How To Customize Table In Oqtane ModuleFeb 08, 2023. In this article, I'm going to explain, how we can add use a new column in the table of the Oqtane custom module
  • Learn To Add C# 11 To WinForms Solution .NET 4.7.2Feb 02, 2023. Learn how to enable C# 11 to your existing WinForms app using .NET 4.72 and above.
  • Import Excel Data To SharePoint Online Using PowerShellFeb 02, 2023. In this article, we will go through how to import Excel File Data (.xlsx) to SharePoint online list using PnP PowerShell command.
  • Add And Verify Your Custom Domain In Azure Active DirectoryJan 31, 2023. This article will guide you on how to add a custom domain name and verify it for use with your Azure Active Directory,
  • How To Add Primary Key To Existing Table In SQLJan 30, 2023. In this article, you will learn how to add primary key in an existing table.
  • C# Convert Excel To DataTableJan 20, 2023. In this article, we will discuss how to convert Excel data to Datatable using ExcelPackage in C#.
  • Create SharePoint Groups And Add Users To A SharePoint Online Site Or Subsite Using Power Automate FlowDec 29, 2022. In this article, we will see how we can create a flow in Power Automate to create SharePoint groups and add users to a SharePoint site or subsite. In our scenario we have a SharePoint online list at root site collection level. When a new item is added to this list, one SharePoint subsite is created within root site collection. This list has all the details like subsite Title, Description, Owners, Members etc as shown in below screenshot. Our flow will take the Title of subsite and create 2 SharePoint groups. One for subsite owners and other for subsite members.
  • How To Create Azure Active Directory Groups And Add MembersDec 28, 2022. Azure Active Directory (Azure AD) is a cloud-based identity and access management service. This service helps your employees access external resources, such as Microsoft 365, the Azure portal, and thousands of other SaaS applications.

About Adding-an-Excel-Reference

NA

OUR TRAINING