Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
With the help of Excel, you can show data in a way that is both aesthetically pleasing and simple to comprehend. When you want to illustrate how various categories fit together to form a broader whole, stacked bar/column charts are especially helpful. In this tutorial, we'll show you step−by−step how to use Excel's built−in capabilities to create a stacked bar/column chart. You don't need any prior Excel or data visualisation knowledge to follow along because we'll start with the fundamentals and work our way up to more complex strategies. You will have a firm grasp on how to make ... Read More
A heap dump is a snapshot of the memory more specifically the Java heap memory of a Java process at a certain point in time. It contains information about the Java objects and classes. Heap dumps are useful when we need to debug memory problems such as memory leaks, high memory consumption, and out of memory errors. Java provides several ways to capture these heap dumps that we are going to explore in this article. Ways to Capture Java Heap Dumps The following ways can be used to capture Java heap dumps: ... Read More
Excel is a strong data−organization and analysis tool, and hidden worksheets are frequently encountered when working on complicated spreadsheets. These hidden worksheets can occasionally be confusing and have an impact on the general functionality of your Excel document. This tutorial will walk you through the process of discovering and deleting hidden worksheets in Excel. This tutorial will equip you with the knowledge and techniques you need to clean up your workbook or simply delete superfluous sheets. By the end of this course, you will understand how to detect and remove hidden worksheets in Excel, allowing you to manage and ... Read More
Unicode is an international character set that encompasses a vast range of characters, symbols, and scripts from many languages across the globe. Java programming language, being platform-independent, has built-in support for Unicode characters, allowing developers to create applications that can work seamlessly with diverse languages and scripts. In Java, the char data type is used to store Unicode characters, and character literals are used to represent these characters in the source code. A character literal is a single Unicode character enclosed in single quotes (' ') and can be assigned directly to a char variable. Algorithm Step 1 ... Read More
If one is a Java developer and has worked with the Java SSL/TLS, one may have encountered the terms trustStore and keyStore. These two files are used to store cryptographic keys and certificates. Till Java 8, the default format for these files was JKS. With the release of Java 9, the default format changed to PKCS12. Here, JKS is a Java specific format, whereas the PKCS12 is a language independent format. In this article, we will discuss the difference between trustStore and keyStore in Java. trustStore vs keyStore trustStore It is a file ... Read More
Being a Java developer, one might have encountered some design patterns that help us in structuring our code and make it more reusable and maintainable. Two of these design patterns are the State pattern and the Strategy pattern. The use case of these design patterns is almost the same. However, they are different from each other in many ways. In this article, we are going to explore the differences between state and strategy design patterns in Java. State vs Strategy Design Pattern State Design Pattern The State pattern is a behavioral design pattern that allows an object ... Read More
Both RMI and DCOM are the technologies that serve to enable distributed object computing. The RMI is a Java-based technology, DCOM, on the other hand, is developed by Microsoft. Although they are built for the same purpose by two technical market giants, there exist some significant differences in terms of design, implementation and usage. We are going to compare and list some differences between RMI and DCOM in this article. RMI vs DCOM Distributed Objects To understand the differences between RMI and DCOM, it is necessary to understand distributed object computing as both terms come under the same umbrella. ... Read More
If you've ever worked with huge datasets or received a spreadsheet with empty columns, you know how time−consuming and irritating manually removing them can be. Fortunately, Excel has a robust set of tools and functions that can assist in automating this process. Whether you're a novice or a seasoned Excel user, this tutorial will teach you how to rapidly clean up your spreadsheets and improve your data analysis workflow. It is critical to comprehend the relevance of empty columns with headers. Empty columns can clog your data, making it difficult to understand or visualise. By deleting these unnecessary columns, you ... Read More
Blank cells that disturb the continuity of your data are typical in every data analysis or spreadsheet management operation. These empty cells can stymie calculating, sorting, and filtering procedures, as well as making your data appear disorganised and inconsistent. Fortunately, Excel has numerous quick methods for deleting these blank cells and shifting the data up, allowing you to keep your spreadsheet's integrity and consistency. This lesson will walk you through the step−by−step process of efficiently handling blank cells, whether you are a newbie or an experienced Excel user. In this tutorial, we will look at different methods for removing blank ... Read More
If you've ever come across a spreadsheet with empty cells all over it and yearned for a means to clean it up, you've come to the correct place. Delete these blank cells and move the data to the left to improve not just the visual appeal of your spreadsheet but also its usefulness and readability. We will walk you through the process of quickly eliminating empty cells in Excel and rearranging the surrounding data to fill in the gaps in this tutorial. Whether you're a novice or a seasoned Excel user, this tutorial will help you organise your data and ... Read More