Home » Microsoft Excel Guides » Page 26
Comparing two dates in Excel means evaluating the relationship between the dates using different functions and operators to determine their relative position in time. It means evaluating whether the dates […]
In this tutorial we will learn how to combine names in excel with commas. To combine names we will use the CONCATENATE function. It allows users to combine names separated […]
In this tutorial we will learn how to color code in excel based on text. For this we use the Conditional Formatting option for coloring all cells containing the text […]
Adjusting column width in Excel is an essential aspect of formatting and organizing data within a spreadsheet. It involves resizing columns to accommodate the contents of the cells. This allows […]
Cell size adjustment is an essential aspect of working with Excel. When creating a spreadsheet, adjusting the size of cells allows you to fit more information into a single cell, […]
Here we have a dataset which contains three columns, the first column contains names of the Fruit, Second column which is Price($) will contain Price combined with $ and Third […]
You can watch a video tutorial here. We’ll show you how to display formulas in Excel, which is a useful technique for troubleshooting, auditing, and comprehending complex spreadsheets. Whether you’re a […]
In this tutorial, we’ll show you how to manually sort data in a pivot table. Here we have a dataset which contains 3 columns, First column contains NAMES, Second column […]
Table join is a process of combining two or more tables based on a common column. The resulting table contains data from both tables, arranged according to the matching values […]
In this tutorial we will learn how to add years in Microsoft Excel. Excel provides users with various options for adding years to a date, and one of the simplest […]
Adding the same text to multiple cells in a spreadsheet is a common task that can save time and improve the accuracy of data entry. By applying the same text […]
Adding text to multiple cells in Excel is a useful feature that can save time and effort when working with large amounts of data. Adding a text to multiple cells […]
Here we have an equation Y = 2X + 1 of which we will be plotting a graph using excel. In our dataset we have X values and Y values […]
Also known as Sharpe Index, it is used to calculate the performance of an investment considering all the related risks. It compares investments of different risk profiles against each other. […]
In spreadsheet applications, it is a frequent practice to include new text in cells as a way of updating information without replacing the entire cell content. When dealing with text […]
