How to use the INFO function in excel

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 of worksheets available in open workbooks. Also, it provides information about the operating environment, such as OS version and OS. Description of the function INFO … Read more

How to consolidate Excel data

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 data means that you assemble data for easier updating. Therefore, using Excel's Consolidation tool, you can combine and summarize data from multiple files or sheets. … Read more

How to embed an Excel file into MS word

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 document, but instead, it transfers all the data on your worksheet. Embedding an excel file into a word document ensures when data in an excel … Read more

How to highlight duplicate values in Excel

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 to substantial problems. To avoid all these big problems, there is a need to learn how to locate and remove duplicate values. Finding duplicated words … Read more

How to Customize Ribbons in Microsoft 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, the ribbon contains groups, dialog launchers, command buttons, and tabs. Ribbon tabs include; Layout, View Insert, Design, Home, among others. With customization, it can occur … Read more

How to save Excel as a Read-only

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 updated without your permission. Most excel users are aware of the methods to follow when applying this option. If you are not well informed about … Read more

How to Separate Numbers and Texts in Excel

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 decipher what it means. It mostly happens when importing data from other systems that your Excel program cannot read. Such a scenario can be so … Read more

How to make an Inventory List 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 at the costs needed to acquire such software and give up. Without considering Microsoft Excel as a substitute, most retailers will end up giving up … Read more

How to update excel to the latest version

How to update excel to the latest version

There are new updates of excel from time to time. These latest versions of excel come along with new features and other additional settings that may be beneficial to excel users. Excel does not promote auto-update. Thus it's the responsibility of users to frequently check on the latest version and UpdateUpdate when necessary. To update … Read more