Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Introduction It is likely you have heard of Version Control Systems (VCS), or source control if you write or track code for a project. A Version Control System serves primarily as a host and a tool for tracking how a project develops. With VCSs, developers are able to compare and track changes between files, track commits, make proposals, view the history of projects, and revert to previous versions. Software teams and developers need a good VCS to implement DevOps, continuous delivery and maintain productivity. Git, SVN, Mercurial, and Perforce are a few of the most popular version control systems. You ... Read More
Introduction The right repository hosting service is critical to the success of a development project. The hosting of your code is crucial to your productivity, and it plays a key role in your work. Since repository hosting services affect development team productivity, choosing the right one can be challenging. The hosting of your code is crucial to your productivity, and it plays a key role in your work. Since repository hosting services affect development team productivity, choosing the right one can be challenging. Git repositories are often located remotely, unlike when working on personal projects. While there are numerous ways ... Read More
Introduction With git remote set-url, you can change the URL of a Git remote repository. Use this command to change the remote URL of the repository you want to change. This command accepts two arguments: the name of the remote repository and the URL of the new repository. Do you have any experience changing the name of a remote Git repository? Do you intend to move a remote repository into a different location? The URL of a Git repository will be changed by both of these operations. Your remote repository will become unreachable if this occurs. There is no need ... Read More
Have you ever thought of creating complex animations using CSS, well in JavaScript also there are some libraries which helps in creating animation and tasks that CSS also cannot perform. AS CSS animations are limited in functionality on the other hand JavaScript libraries are fast and reliable So, this article we will be learning about some of the best JavaScript animation libraries using which you can create animations in JavaScript. Let’ see some of the JavaScript animation libraries. Anime.js Anime.js is known as lightweight animation library which s use to animate HTML, JavaScript objects, CSS selectors and DOM attributes, arrays ... Read More
In this article, we will learn how to remove the table formatting in an excel file without losing the data. Sometimes the table formatting may hide some parameters based on some conditions and that may get lost while copy-pasting the data from one sheet to another. Let’s have a look on the steps to clear table formatting. The formatting of a table can be removed using the following options − By using Convert to Range under Table Tools By using Clear Table Design under Table Design By using Clear Formats under Editing Convert to Range feature This feature ... Read More
In this article, we will learn how to remove data restrictions applied on a cell of a worksheet. Many times we encounter an error saying “The value you entered is not valid. A user has restricted values that can be entered into this cell.” This is because, the worksheet designer has applied some data validation in the sheet for specific data values only. We will use two methods to remove the data restrictions from a worksheet as following − Using Data Validation Option under Data Tools Using Paste Special to delete data validation rules Let’s see the steps ... Read More
When we work on multiple excel files, almost all excel application has a feature of keeping last few opened files in history. The list get displayed in Recent Pane whenever we open an excel file to quickly access any of those files without searching into machine. Sometimes we need to clear such long list of workbooks from the Recent pane. This article will help you how to make the recent document lists disappear. We will use the following methods to clear the recent pane − Remove any document from recent pane through right-click Remove the recent pane with Clear ... Read More
In this article we will learn how to update the pivot table data after updating the details of source table. In many cases, whenever we update the source data as per the requirement the old data still appears in the filter of pivot table dropdown options. This may create confusion for the end user who will view the data table and pivot table. To resolve this issue we can use the following steps. Step 1− We have taken a sample data for creating the Pivot Table as following − Step 2− Now, if we update any value in the ... Read More
In this article we will learn to remove filters while opening/closing or saving a worksheet. Because whenever a filter is applied in the worksheet it gets saved along with the file and remain as is until manually removed. They filters may be misinterpreted as missing data in the worksheet. The filters can be removed automatically after applying some Visual Basic codes in the respective worksheet. The following are the VBA codes to be incorporated for this task. Clear filters while opening a workbook Clear filters while saving a workbook Clear filters while closing a workbook Clear filters while ... Read More
JavaScript's Location object provides access to the current URL's components. One can think of this object as a read-only window into the current location. There are two properties of the Location object that are often confused: host and hostname. Location.host The host property returns the hostname, port number, and protocol of the current URL. For example, if the current URL is "http://example.com:8080/path/to/page.html", the value of host would be "example.com:8080". Advantages of using location.host There are also a few advantages to using location.host over location.hostname. First, it is more specific. If you need the port number or protocol, you can be ... Read More