Miscellaneous Articles: Excel and Google Sheets

An Excel Workbook may contain multiple sheets or tabs and while working on different parts of data we need to quickly switch between tabs in excel. Using the shortcut to switch tabs is a more effective way instead of switching the sheets by clicking on the right and left arrow....

When we need to apply certain formatting style, copy a range of data, select different ranges of data to insert Excel Charts, then selecting multiple cells becomes vital. We can select a range of cells, adjacent and nonadjacent, specific cells, multiple rows and columns using different techniques. Figure 1. Selecting...

When we keep on adding data, formulas, images to the worksheets, the size of the file increases and it makes the file slow to respond and difficult to send it to others. We can compress file to reduce its size using the various techniques. Figure 1. Compressing Files How to...

In powerpoint presentation, if we need to show the data in the spreadsheet then we need to close or minimize our powerpoint and switch to the spreadsheet. But we can insert excel data into powerpoint to show spreadsheet without exiting powerpoint presentation. Figure 1. Inserting Excel File Into Powerpoint How...

A workbook may contain multiple worksheets to add various data sets in the current workbook. We can easily insert new worksheet in a workbook when we want to maintain a separate set of data like Products, Customers or Sales by months, etc. There are different ways to insert a new...

We can quickly navigate to different worksheets of the same workbook by linking worksheets with specific cells of a sheet. To link a cell to a worksheet we add a hyperlink between the content of a cell to the cell reference of another worksheet. In this way, we quickly jump...

Heat map is a graphical representation of data on a color scale. It gives us a comparative view to understand the pattern in the data set. We create a heatmap with conditional formatting using built-in color scale rules. Figure 1. Heat Map How to Make a Heat Map Suppose we...

Heat map is a graphical representation of data on a color scale. It gives us a comparative view to understand the pattern in the data set. We create a heatmap with conditional formatting using built-in color scale rules. Figure 1. Heat Map How to Make a Heat Map Suppose we...

We may need to move or copy a worksheet as a backup. In this scenario, we can move or copy the sheet to another workbook or create a duplicate sheet in the same workbook. There are some quick methods to achieve this task. Figure 1. How to Copy a Sheet...

The watermark is an image used in the background of the worksheet labeled as copy, draft, confidential or a picture of the logo. The Excel 2010 and later versions do not have built-in watermarks, therefore we need to learn how to add and delete a watermark using the Header &...