Logical Functions
One of the best thing in Excel is to compare data in different cells, using logical functions you can easily compare each cell that you want to compare and get the output that you need. In this lesson you will …
Excel Archive
Count and Sum Functions
Count and Sum are one of the most used functions in Excel. You can easily count or sum the content of the worksheet based on one or multiple criteria. There are 6 functions included in count and sum (Count, Countif, Countifs, …
Adding Password to Workbook and Worksheet
Adding password can prevent from unauthorized opening or modifying your Excel Workbook. But keep in mind that if you lose or forget your password it cannot be recovered and your workbook will be useless, so keep your password in a safe …
Printing Sheets
Now you have a workbook full of data and you want to have a hard copy of it. You’ve printed it and it looks like a mess. Excel worksheet doesn’t look exactly the same on what you see on the screen, …
Inserting and Deleting Rows and Columns
When creating your worksheet you cannot avoid making mistakes like omitting an entries. Although you can move the following rows and columns to leave an empty space where you can insert the omitted entries, it’s not an ideal method when using …