Home » Blog » Page 62
Microsoft Excel Guides
Google Sheet guides
Productivity resources
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 […]
Some data analysts like to present their data in a very aesthetic way and therefore they use colorful themes to differentiate one type of data from others. In such cases […]
