Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
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
If you are running a YouTube channel, enabling the embedding option can allow your YouTube videos to play on a number of social media networking sites and redirect it to your YouTube channel so that you can increase the number of views and subscribers. The steps listed below can be used to update a YouTube video's setting so that embedding is permitted. Once this setting is changed, the YouTube video can be played on any website. How to Enable the Embedding of a YouTube Video or YouTube channel Step-1 − Go to the YouTube.com website. Sign in with your ... Read More
Are you interested in using YouTube but unsure of how to upload your first video on YouTube? If you used a smartphone to record, you can use an iPhone or Android device to upload the video directly to your YouTube channel. How? Read on. You'll need the official YouTube app on your phone in order to post a video to YouTube from an iPhone or Android device. If you haven't already, download and install the app on your iPhone or Android device. Steps to Upload a video using YouTube app Step-1 − Open the YouTube app on your mobile device ... Read More
Millions of people utilise the well-known video streaming service YouTube all across the world. In addition to online video viewing, you can download the videos to your device. Any video you've posted to your YouTube channel might be removed. You can alter an existing video but not replace it because any new video uploads will receive a new URL. View the detailed instructions for deleting your uploaded YouTube videos here. How to Delete YouTube Videos on Mobile YouTube App- Check out! In order to delete the YouTube videos from mobile device, you need to first download the YouTube studio ... Read More