Amos Gikunda 
Sometimes while working with large Excel documents you may need to extract a certain text from a specific cell. It is one of the common tasks for people working with text data. Luckily, Excel offers its users easier ways of extracting texts. You can do so using text formulas or other in-built Excel features. Let's … Read more
When you have numbers stored as texts in excel, it can lead to incorrect or unexpected calculations and error results. To avoid making such mistakes in your workbook, you will need to convert the texts into numbers. For any excel user, knowing the different ways of how to convert unwanted texts into numbers can come … Read more
When working with excel, our work should be neat, appealing, and orderly. To achieve this, we have to put page numbers in our work. It's very easy and possible to add pages numbers in the sheet's headers or footers. The user can also decide the sections that are the right part, the left part, or … Read more
At times, your worksheet may include blank or unwanted pages. There will be no need to print out all pages hence the need to delete the extra unwanted ones. It is easy to delete unwanted pages in Microsoft Excel. All you need to do is follow the below-listed guidelines, and you will be good to … Read more
When one is working on PowerPoint may wish to insert an Excel spreadsheet into it. However, to new users, this may sound like a big or impossible task which is not the case. In this article, we shall discuss some of the ways that can be used to insert Excel spreadsheets into the PowerPoint software. … Read more
Sometimes when working with excel, you may find that your workbook contains jumbled-up data of texts and numbers. Such data may be hard to read or understand hence the need for a separation. Luckily, it is possible to separate texts and numbers in excel using the different features and functions it offers. Here, we give … Read more
If you have a list of names in your Excel spreadsheet, you can arrange them alphabetically. You can either sort the list in ascending or descending order. A sorted list is easier to locate for any name. In this article, we shall discuss some of the methods that can be used to sort excel lists … Read more
Microsoft Office 365 is software aid in office work that offers more improved features in comparison to other office software. Being that we are living in the age that everything is computerized, having Microsoft 365 will be a wise decision and will simplify work for you. Excel 365 is one of the tools in Microsoft … Read more
Since Excel is a spreadsheet application, a label is a text in a cell, describing data in the rows or columns surrounding it. For one to create and print the mailing labels, you must first prepare the worksheet data in Excel, and then use Word to configure, organize, review, and print the mailing labels. Procedure … Read more
Yield to maturity (YTM) in excel is a function in excel that gives back the yield to maturity of a bond when given its current price, Principal amount and coupon rate, and payment frequency in a year. It can also be understood as the return a debt holder gets by investing in security at its … Read more