Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
A binary heap is a specialized tree-based data structure that satisfies the heap property, where the key of each node is either greater than or equal to (in a max heap) or less than or equal to (in a min heap) the keys of its children. In this program, we utilize a linked list to represent the binary heap. In this article, we will learn how to develop the Golang program to implement a binary heap using a linked list. Here we are going to use four different methods singly linked list, doubly linked list, custom node struct, and slice-based ... Read More
Red Black Tree is a self-balancing binary search tree with additional properties that ensure a balanced tree structure and efficient operations. The delete operation in a Red Black Tree involves rearranging the tree and maintaining the Red Black Tree properties after removing a node. Here we are going to use three different methods:deleteNode method, delete method, and successor transplant method along with examples to elaborate the concept. In this article, The Golang program implements the deletion operation in a Red Black Tree data structure using Golang. Syntax func (t *RedBlackTree) Delete(key int) The Syntax "func (t *RedBlackTree) Delete(key int)" ... Read More
CSV (Comma−Separated Values) is a plain text file format used to store tabular data. It is a widely supported and commonly used format for exchanging data between different applications, particularly in spreadsheet software like Microsoft Excel, Google Sheets, and others. When working with CSV files, it's essential to be mindful of the delimiter used, handle special characters appropriately, and ensure data integrity and consistency. Steps to Export Excel Data to CSV To export Excel data to CSV (Comma−Separated Values) format, you can follow these steps: Method 1: Save As CSV Step 1: Open the Excel file containing the data you ... Read More
Excel is a powerful tool that offers a variety of functions for data manipulation and analysis. Supposing you have a lot of pictures in your workbook and want to save them to a specific folder at a time, usually, you can copy and paste the pictures one by one manually for saving, but it is time−consuming to copy and paste them repeatedly like this. Here, I will introduce you some tips to solve this job. With the Excel built−in Save As function, you can save a workbook as Web Page to save all pictures including charts, shapes and other objects ... Read More
Excel is a powerful tool that offers a variety of functions for data manipulation and analysis. Here we will first create a formula for excluding values in one list from another list in the Excel. Let us see the process that how we can achieve it. These are the steps that need to be followed. Step 1 Place your List 1 in one column and List 2 in another column. Let's assume List 1 is in column A, starting from cell A2, and List 2 is in column B, starting from cell B2. Step 2 In cell C2 (adjacent to ... Read More
Excel is a powerful tool that offers a variety of functions for data manipulation and analysis. Here we will first create a formula using the VBA application and then use it to complete the task. So, let us see a simple process to exclude certain cell or area from printing in Excel. Step 1 Consider an Excel sheet where you have a list of sentences as shown in the below image. On current visible worksheet, right click on sheet name tab to load Sheet management menu. Select View Code, Microsoft Visual Basic for Applications window pops up. Or you can ... Read More
Excel is a powerful tool that offers a variety of functions for data manipulation and analysis. To exclude specific cells in a column from a sum in Excel, you can use the SUM function along with the subtraction operator (−) to exclude those cells. Let us see a simple process to know how to exclude cells in a column from sum in Excel. Step 1 Consider an Excel sheet where you have a list of sentences as shown in the below image. Now, first click on an empty cell and enter the formula as =SUM(A2:A9) and click enter to get ... Read More
Excel is an effective tool for organising and analysing data, and it provides a number of formatting choices to let you change how the data is shown. However, it can be a little challenging to display negative time values, and they might not show up as you would expect by default. Negative time values can appear while tracking project delays, figuring out time discrepancies, or keeping track of schedule changes. Making sure that negative time values are appropriately and visibly shown in your Excel worksheets is crucial. You will learn how to appropriately format negative time values in Excel by ... Read More
Microsoft Excel is a sophisticated programme that allows users to efficiently organise, analyse, and manipulate data. When working with big workbooks including several sheets, the ability to delete certain sheets if they are no longer required can be useful. This tutorial will teach you how to create a simple VBA (Visual Basic for Applications) code that checks for the presence of a specific sheet in an Excel workbook and deletes it if it is detected. Deleting a Specific Sheet if It Exists in a Workbook Here we will first create a VBA module and then run it to complete ... Read More
With the help of Excel's auto−filters, you can swiftly sort and filter data in a spreadsheet. However, occasionally being able to see the filtering criteria that have been used on a specific column can be helpful. You can better comprehend and examine your data with the use of this information. This tutorial will show you how to simply check and review the filtering requirements by displaying or showing the auto filter criteria in Excel. It will provide you the knowledge and skills to fully utilize Excel's filtering features, regardless of your level of Excel proficiency. In order to successfully ... Read More