Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Articles by Pradeep Kumar
1,035 articles
How to add country/area code to a phone number list in Excel?
In this tutorial, you will learn how to format phone numbers with country code using three simple methods. Method 1: Using Format for Phone Number with Country Code You need to take the following actions to be able to add a country code to the Formatted Number column. Step 1 Select the phone number from the range of cells C1:C7. Step 2 Press ctrl+1. When Format cells dialog box opens, choose Custom and type +1 (000) 000-0000, then click OK. Result Finally, the outcome with country codes in the Formatted Number cells are shown in ...
Read MoreHow to Convert Time to Decimal Hours /Minutes/ Seconds in Excel?
A decimal hour is a time that is represented as a number. In Excel, you may have needed to convert the given time to decimal values at times. If we try to do this task manually, then it can be a time-consuming process. We can use the faster approach mentioned in this article. We can solve this task using the formulas supported in Excel. Read this tutorial to learn how you can convert time to decimal time in Excel. Converting Time to Decimal Hours in Excel Here we will use the formula to get any one of the values, then ...
Read MoreHow to Convert Numbers to Words in Indian Rupees in Excel?
When we need to convert numbers to words in Indian rupees in Excel, it can be a time‑consuming process if we do it manually as we need to type the large numbers. We can complete this time-consuming process much more quickly by using the VBA application. Even though the VBA code will be lengthy, we can use this process if there are many values to convert. Read this tutorial to learn how to convert numbers to words in Indian rupees in Excel. Converting Numbers to Words in Indian Rupees in Excel Here we will create a new VBA module, then ...
Read MoreHow to Add Quotes around Numbers or Text in Excel
Have you ever wondered how you can add quotes to the text or words in Excel? Adding quotes is similar to adding symbols as prefix and suffix to the words. It can be done using the "format" function in Excel. In this tutorial, we have provided a detailed step-by-step explanation of how you can add quotes around numbers or text in Excel. Adding Quotes around Text using "Format Cells" Option You can use the "Format Cells" option in Excel to add quotes around numbers or text. It is simple process. Step 1: Let us suppose we have an Excel sheet ...
Read MoreHow to calculate standard error of the mean in Excel?
This same standard error would be a crucial statistic that serves as a parameter. But are you able to determine it throughout the process of sampling and distribution. A standard error of measurement, often known as the SEM, is indeed a statistical measurement which also provides an approximation of the difference between both the sample mean of the data and the actual population mean. You are aware that the Standard Error is equal to the Standard Deviation divided by the Square Root of the Total Number of Samples; hence, we can convert this into an Excel formula by writing Standard ...
Read MoreHow to Count Unique Values in a Filtered Column in Excel?
Powerful spreadsheet software like Excel provides a variety of features to alter and analyse data. Finding the number of distinct values in a filtered column is a typical task that can be helpful when working with huge datasets. Excel data filtering enables you to focus on particular subsets of your data by only displaying rows that match specified criteria. The ordinary COUNT function, however, merely counts the visible cells, including any duplicates, when a column is filtered. We need to use a different strategy in order to precisely count the unique values in a filtered column. In this article, we'll ...
Read MoreHow to Replace All After/Before Specific Character or Space in Excel?
Excel is a robust spreadsheet programme that provides a wide range of functions to successfully modify and organise data. One frequent task is to change the text in cells based on specific parameters. In order to show you how to carry out these substitutions successfully, we will lead you through step-by-step instructions and examples throughout this lesson. We will also go through how to use these functions with dynamic formulas to handle texts of various lengths. You will have the knowledge and abilities necessary to confidently edit text in Excel at the end of this session, boosting your data processing ...
Read MoreHow to Replace Accented Characters With Regular Characters in Excel?
Diacritical marks, often known as accented characters, are frequently employed in a variety of languages to denote particular phonetic or linguistic nuances. To make data processing and analysis easier, there are times when you might need to remove certain accents and convert them to their regular counterparts. You will be given step-by-step directions on how to carry out this activity in Microsoft Excel in this tutorial. You will have a strong understanding of how to use built-in Excel functions, formulae, and other practical ways to replace accented characters with regular characters by the end of this session. So let's get ...
Read MoreHow to Replace # Formula Errors With 0, Blank or Certain Text in Excel?
You understand how annoying it may be if you've ever run into the dreaded "#" formula errors in your Excel spreadsheets. When there are problems with cell references, mathematical operations, or even data types within your calculations, these errors frequently happen. Fortunately, Excel offers numerous ways to elegantly address these mistakes, improving the presentation of your data and avoiding interruptions to your calculations. Whether you are an experienced Excel user or are just starting started, learning these error-handling strategies can improve your spreadsheet abilities and allow you to produce workbooks that are more robust and presentable. By the time ...
Read MoreHow to Repeat the Last or Previous Action in Excel?
Powerful spreadsheet programmes like Excel are frequently used for data analysis, calculations, and information organisation. You might conduct repetitive tasks while using Excel or find that you need to undo and redo some actions. Excel's ability to repeat your most recent action or even go back to one you recently undid is one of its most helpful features. This can help you save time and effort so you can concentrate on other things and organise your workflow. In this tutorial we will look at the easiest way possible to complete the task. So, whether you are an Excel novice or ...
Read More