Home » Microsoft Excel Guides » Page 55
You can watch a video tutorial here. When formatting tables in Google Sheets, you may need to merge cells to properly label the data and to make it look neater. […]
Microsoft Excel is one of the best tools which provides so many features to handle and manipulate versatile data with its efficient tools and functions. It also provides many built-in […]
As the title of today’s topic suggests, we are going to learn how to use Google Sheets to record and then re-use the macros. There are two types of macro […]
In today’s tutorial we are going to learn how to apply Accounting Format to numbers in Excel. Let’s take a look at the following sales dataset. We have the sales […]
You can watch a video tutorial here.
You can watch a video tutorial here. Excel is well suited for calculations and for creating and maintaining databases. Unlike word-processing applications where text is organized according to pages, Excel […]
You can watch a video tutorial here. Excel is a popular spreadsheet application in which the workspace is arranged as rows and columns in the form of a grid. Each […]
You can watch a video tutorial here. Google Sheets is a popular spreadsheet application in which the workspace is arranged in rows and columns. You may need to select multiple […]
You can watch a video tutorial here. The format of a spreadsheet in Excel is in the form of columns and rows. It is easy to select a single column […]
You can watch a video tutorial here. The format of a spreadsheet in Excel is in the form of columns and rows. You may need to select a row to […]
In this tutorial we will learn how to join the text in Microsoft Excel by using the Text join function. =TEXTJOIN(delimiter, ignore_empty, text1, [text2, …]) This function allows us to […]
In today’s tutorial we’ll learn how to add a meaningful text to the results obtained by a formula in Excel. Let’s take a look at the following sales dataset. We […]
In today’s tutorial we’ll learn how to calculate the sum of cells based on a text criterion in Excel. Let’s take a look at the following sales dataset. To use […]
