Pradeep Kumar has Published 1035 Articles
Pradeep Kumar
943 Views
We have two numbers and a value, and we want to determine whether or not the value is in between the two numbers that we have been provided. In order to proceed with this topic, we need to utilise the AND logical operator in a way that satisfies both of ... Read More
Pradeep Kumar
287 Views
If you have a huge worksheet that already has some formulas in it, and you now want to find out or check to see if any of the cells include formulas, you can do any of those things. Checking If Cells Contain Formulas with Function Excel provides a variety of ... Read More
Pradeep Kumar
2K+ Views
Excel's Pivot Chart does not allow users to modify the data source it uses. Having said that, you may come across situations where you will need to alter the data source of a pivot chart. This tutorial will show you how to alter the data source of a pivot chart ... Read More
Pradeep Kumar
607 Views
Excel is a program that everyone should be familiar with, whether they are students, company owners, or just those who enjoy looking at charts and graphs. How to modify the X-Axis, which is commonly referred to as the horizontal axis, is consistently one of the most popular concerns concerning Excel. When ... Read More
Pradeep Kumar
5K+ Views
This tutorial will walk you through the steps of using Excel's Paste Special tool to make rapid changes to the numbers in a data range in Excel 2013 and 2016. You will learn the Excel instructions on how to do operations such as adding, subtracting, multiplying, and dividing on a ... Read More
Pradeep Kumar
544 Views
Excel cells always have comments added to them so that we can attach useful supplementary data. The shape of the comment box is predefined as a square, however you can change its shape, which we are going to explain in this tutorial. Changing the Shape of a Comment Box in ... Read More
Pradeep Kumar
338 Views
Consider that you have received a data in Microsoft Excel sheet with all the strings in uppercase. Now for you to read it easily you can change all uppercase strings to lowercase in a Microsoft excel sheet. The methods given in this tutorial can be used to change the uppercase ... Read More
Pradeep Kumar
6K+ Views
Minutes and seconds are more basic units for measuring rotation than degrees. Using minutes when measuring rotation helps us analyse the values more accurately and efficiently. We can convert decimal degrees into degrees, minutes, and seconds using the VBA application, as it can’t be completed directly in Excel. This tutorial ... Read More
Pradeep Kumar
2K+ Views
You might occasionally have needed to convert a decimal number in Excel into another format, such as binary, octal, or hexadecimal. In general, decimal numbers have a base of 10 from 0 to 9, binary numbers have a base of 2 from 0 to 1, octal numbers have a base ... Read More
Pradeep Kumar
3K+ Views
You can search for something in your worksheet using the Find and Replace tools in Excel. Perhaps you're looking for a certain number or a text string to replace. You have the option of locating the object that was searched for as a point of reference or substituting it with ... Read More
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP