Text Functions
If you want to convert numbers to text or simple text manipulation in your worksheet,…
Date and Time Functions
Date and time are very important in Excel project, like in making a timesheet, you…
Cell Reference
A worksheet also known as the spreadsheet is composed of a box-like structure called a…
Logical Functions
One of the best thing in Excel is to compare data in different cells, using…
Count and Sum Functions
Count and Sum are one of the most used functions in Excel. You can easily…
Adding Password to Workbook and Worksheet
Adding password can prevent from unauthorized opening or modifying your Excel Workbook. But keep in mind…
Printing Sheets
Now you have a workbook full of data and you want to have a hard copy…
Inserting and Deleting Rows and Columns
When creating your worksheet you cannot avoid making mistakes like omitting an entries. Although you…
Cell Formatting
When we format cells in Excel, we change the appearance of the data inside the…
Formatting Text and Numbers
Formatting text and numbers in Excel makes it more presentable and readable to whoever use…