How to use the INFO function in excel

The INFO function is an inbuilt function found in excel and serves as an information function. It is used to display details like recalculation mode, excel version, and the number…

Comments Off on How to use the INFO function in excel

How to consolidate Excel data

Working with separate worksheets can be stressful, especially if they contain important data. You can quickly solve this issue by consolidating data from different worksheets in a master worksheet. Consolidating…

Comments Off on How to consolidate Excel data

How to embed an Excel file into MS word

Linking a file to the excel worksheet involves the same process as embedding an excel file into MS word. It does not only bring the selected data range into the…

Comments Off on How to embed an Excel file into MS word

How to highlight duplicate values in Excel

Duplicate values occur when a set of data appears on your sheet more than once on the excel sheet. Duplicate values may result in inconsistent data and can therefore lead…

Comments Off on How to highlight duplicate values in Excel

How to Customize Ribbons in Microsoft Excel

Microsoft Excel ribbon is the row of rows and tabs found at the top of the Excel window, enabling faster use and understanding of commands for easier task completion. However,…

Comments Off on How to Customize Ribbons in Microsoft Excel

How can I create a macro in Excel?

A macro helps to automate tasks that you do repeatedly in excel. Take it as an algorithm with a set of instructions to follow and can be run several times.…

Comments Off on How can I create a macro in Excel?

How to save Excel as a Read-only

We activate the Read-only feature in a workbook when we do not want any sensitive information modified by other end-users. The feature protects your whole workbook from being edited or…

Comments Off on How to save Excel as a Read-only

How to Separate Numbers and Texts in Excel

When working in Microsoft Excel, you may encounter a situation where a cell's text is all jumbled up. Such a cell will contain numbers and texts, making it hard to…

Comments Off on How to Separate Numbers and Texts in Excel

How to make an Inventory List in Excel

Any retailer, salesperson, and wholesaler have to have an inventory management system. Keeping track of stocks without the help of professional software can be very tedious. Most people will look…

Comments Off on How to make an Inventory List in Excel