Found 2044 Articles for Microsoft Technologies

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 More

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 More

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 More

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 More

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 More

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 More

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 More

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 More

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 More

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