How to add a pdf to Excel

How to insert a macro in Excel

You can watch a video tutorial here. Macros in Excel are programs that are written in a language called VBA (Visual Basic for Applications).  These programs are written to automate […]

How to lock tabs in Excel

You can watch a video tutorial here.

How to lock a tab in Excel

You can watch a video tutorial here.

How to link sheets in Google Sheets

You can watch a video tutorial here.

How to link cells from one sheet to another in Excel

You can watch a video tutorial here.

How to keep the zero in Excel

You can watch a video tutorial here. When you type a number on a worksheet that starts with a zero, Excel ignores the leading zeroes and displays only the digits […]

How to keep a column fixed in Google Sheets

You can watch a video tutorial here.

How to invert columns in Excel

You can watch a video tutorial here.

How to invert a column in Excel

You can watch a video tutorial here.

How to insert multiple columns in Google Sheets

You can watch a video tutorial here. Google Sheets is a useful spreadsheet application in which the worksheet is formatted as rows and columns. When you have a table of […]

How to find a link in Excel

You can watch a video tutorial here.

How to extract data from Excel based on criteria

You can watch a video tutorial here.

How to do random sampling in Excel

You can watch a video tutorial here. Random sampling is a method of selecting samples at random, from a population. Suppose you have 200 students that take a class and […]

How to do nested if statements in Excel

You can watch a video tutorial here. Excel is widely used for calculations due to the several arithmetic operators and functions that it has. One of the most versatile functions […]