How to highlight text in Excel

You can watch a video tutorial here. Microsoft Excel is one of the best numeric data calculation software produced by Microsoft and it gained popularity around the globe due to its […]

How to add Google sheets in Desktop

This feature is beneficial for those people who travel daily in remote areas where the internet connectivity is not available. They can work offline and they can use Google Sheets […]

How to create pie chart in Google Sheets

By this great feature we can easily present our LARGE data with the help of pie chart by the above-mentioned steps.

How to use Date formula in Google Sheets

Syntax of the formula Let’s see the syntax of the DATE function first to understand how to use this function properly without any errors. The syntax of the function is […]

How to spell check in Google Sheets

Google sheet does not run spelling checking by default, so, we have to initiate this process manually. After initiating the process Google Sheets asks you to start spell check in […]

How to edit cell shortcuts in Excel

Microsoft Excel allows users to format, organize and calculate data in a spreadsheet. By organizing data using Excel, data analysts and other users can make information easier to view as […]

How to calculate standard deviation in Google Sheet

There is a built-in formula for calculating standard deviation of a dataset in Google sheets. The formula to achieve this goal is given below.  =STDEV(value1, [value2, …]) In this formula, […]

How to Freeze Panes (multiple rows & columns) in Google Sheets

How to add bullets in google sheets

Google sheet is not a word processing software, therefore; it doesn’t offer many tools for text formatting. However, we often need to use bullets with our data to present it […]

How to add percentages in Excel

Excel is a very powerful tool to perform mathematical and statistical calculations on numeric data. It provides a variety of tools and functions to do so. In today’s tutorial we’ll […]

How to create sentence case in Excel

Microsoft Excel is a computational software tool which has many versatile tools for mathematical calculations. However, it doesn’t have many useful tools when it comes to text editing in Excel. […]

How to group different rows in google sheets

Google sheet is a powerful tool for data calculation and data manipulations. In the Google sheet data is being stored in rows and columns. Google sheet is enriched with a […]

How to subtract percentages in Excel

Excel is a very powerful tool to perform mathematical and statistical calculations on numeric data. It provides a variety of tools and functions to do so. In today’s tutorial we’ll […]

How to fix Excel Gridlines not showing issue

In this tutorial we’ll learn the process to fix the gridlines not visible or not shown in Excel by following these simple steps.

How to use CTRL+R in Excel

Let’s take a look at the following dataset in which we have the costs of different items and we wish to calculate the percent discount on each of them. We […]