Home » Blog » Page 51
Microsoft Excel Guides
Google Sheet guides
Productivity resources
You can watch a video tutorial here.
You can watch a video tutorial here. A lookup table contains a master list of values that are usually associated with a key. The key is used to ‘lookup’ the […]
In this tutorial we will learn how we can use Excel’s built-in functions to determine the column index number. The following methods can be used to determine the column index in […]
Microsoft Excel is one of the best numeric data calculation software produced by Microsoft and it gained popularity around the globe due to its calculations performing speed and data manipulations […]
In this tutorial we will learn how to change the cell size in Microsoft Excel. This minimum height of row is 0 and maximum 409. The default value is 8.43 […]
In this tutorial we will learn how to merge first and last name in Excel by using the Text join function. =TEXTJOIN(delimiter, ignore_empty, text1, [text2, …]) This function allows us […]
In today’s tutorial, we’ll learn how to copy paste shapes in google sheet. Google drawing tools assist us in copy pasting the drawings. Google Drawings is a virtual board that […]
In this tutorial we will learn how to convert numbers in millions in Microsoft Excel. In some cases we have a big number having many digits , we want to […]
You can watch a video tutorial here. Google sheet is popular in the world due to its fast numeric data manipulation by built-in tools and functions.The major feature is its remote […]
In this tutorial we will learn how to use go to function in Excel and what it does. Basically GO TO is dialogue box which allows you to quickly select […]
Google sheet is the best tool for numeric data calculations and it is famous among the population due to its online working facility. It has almost all the built-in functions […]
Microsoft Excel is a basic software for numeric data calculation the data is stored in rows and columns. When we work on business analysis and calculations, we need to find […]
In this tutorial we will learn how to apply formulas to the entire column in Google sheet. We can only apply one formula at a time to the entire column […]
Microsoft Excel is a world’s powerful mathematical calculations tool. It can manipulate data in millions of different ways. Most of the time we need to add data from different sheets […]
