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
-
Economics & Finance
MS Excel Articles
Page 91 of 119
How to calculate a future date based on a given date in Excel?
It is really helpful to perform calculations that involve dates whenever you are dealing with Microsoft Excel. It's possible that you'll need to compute a date in the future in Excel in order to determine when a bill is due or when you might anticipate earning income on an investment. Excel has a number of different date functions that can be used to perform mathematical operations on dates and times. This tutorial will walk you through the steps of calculating a future date in Excel depending on the data that you provide. In order to determine a date in the ...
Read MoreHow to break or split address into separated parts in Excel?
When dealing with addresses, it is sometimes helpful to have the individual components of the address broken out into their respective categories, such as the street address, the city, the state, and the zip code. You may find it simpler to filter, sort, and query the data in this way, as well as use it for a variety of other purposes. It would be helpful if you had one column that contained simply the state portion of the individual’s addresses in the event that you wish to sort people based on the state in which they are located. This post ...
Read MoreHow to break or split number into individual digits in Excel?
Occasionally we might need to separate the numbers from the text or obtain simply the numbers out of any input that contains both text and numbers. Excel has a variety of shortcuts that eliminate the need to manually do this task, making it possible to isolate integers from any dataset. In this tutorial, I will demonstrate a technique for separating nmbers in Excel by using formulas in a variety of circumstances. Break or Split Numbers into Individual Digits using Formulas in Excel In the following part, a formula will be presented that may be used in Excel to split chosen ...
Read MoreHow to break chart axis in Excel?
In situations when there are unusually large or small series or points in the source data, the chart's representation of the small series or points will not be exact enough. In situations like these, some users may desire to break the axis in order to achieve precision in both the tiny series and the large series at the same time. You will learn two different techniques to break chart axis in Excel by reading this post. Break Chart Axis with a Secondary axis in Chart in Excel Take, for instance, assuming that you have the data in two different ranges, ...
Read MoreHow to border every 5/n rows in Excel?
In Excel, the lines that make it up a cell’s border are referred to as boxes by maintain borders, we are able to frame any data and give it a defined boundary in an appropriate manner. You can highlight specific values by outlining summarized values or separating data into ranges of cells, additionally, you can place borders around individual cells. Adding borders is one of the greatest and easiest ways to make a spreadsheet seem attractive, and this is especially true if the spreadsheet is going to be printed. However, if you are consistent including new data in your spreadsheet, ...
Read MoreHow to border cells based on cell values in Excel?
In Excel, the lines that make it up a cell's border are referred to as boxes. By maintaining borders, we are able to frame any data and give it a defined boundary in an appropriate manner. You can highlight specific values by outlining summarized values or separating data into ranges of cells; additionally, you can place borders around individual cells. We might be familiar with the concept of adding colours for cells depending on the values of those cells; but, what about creating borders in Excel based on the values of the cells? Conditional formatting in Excel is discussed here, namely ...
Read MoreHow to bold text in checkbox in Excel?
The default setting for the text label of checkboxes is to use a normal font type. In this tutorial, we will see how you can bold the text that is inside the checkboxes that are located in your worksheet. Bold text in Checkbox in Excel You can use the following steps to change the text label of checkboxes so that they use a bold font style. Let’s understand step by step with an example. Step 1 Adding a checkbox in Excel can be done in the following steps. Navigate to the Developer Tab and select Form controls and click ActiveX ...
Read MoreHow to Bold a Part of a Text String in a Cell in Excel?
It's common practice to highlight individual cells in Excel, but sometimes you may want to highlight specific characters within a text string within a single cell, as illustrated. This post will show you how to bold specific portions of a string of text within a cell. You can make a partial text string bold in a cell by following the instructions below. Let’s understand step by step with an example. Step 1 In the first step, let's assume we have a sample data as shown in the below screenshot. Step 2 You can edit the cell you want to ...
Read MoreHow to avoid rounding errors while calculating in Excel?
When you are calculating some formulas in Excel, the result may be incorrect sometimes due of the rounding, and you may be wondering how to avoid making rounding errors while calculating in Excel. Avoid Rounding Errors while Calculating in Excel Let’s understand step by step with an example. Step 1 In the first step, let’s assume we have a product, sales and profit list for sample data as shown in the below screenshot for the same. Step 2 In the next step, we are trying to calculate the profit ratio using the below formula. Please checkout this screenshot ...
Read MoreHow to avoid #ref error while deleting the rows in Excel?
Excel will display a notice known as a #REF error (the "ref" stands for reference) if a formula makes reference to a cell that does not now exist. This is typically the result of removing cells that a calculation is referring to. A competent financial analyst will be familiar with locating and correcting #REF problems in Excel, which are discussed in greater detail below. Avoid #ref Error while Deleting the Rows in Excel When you refer a cell to another cell, the cell that you are referring to will display the #REF error if the row that the cell is ...
Read More