How to add a hint in excel

How to add a hint in excel

Excel hints are awesome, especially when you are creating a worksheet for someone to use. Excel hints can be described as small windows that pop up when one selects a specific cell or hovers the mouse over it. These windows are accompanied by a specific message about that cell or what you should input into … Read more

How to add a footnote in Excel

How to add a footnote in Excel

Most people have encountered situations where they need to use an Excel spreadsheet. It is used to store, organize and manipulate data. You might have used it to track your revenues and expenditures in business, feed-in project details, and even budgeting. It is pretty simple to use it, more so if you are familiar with … Read more

How to do case sensitive lookup

How to do case sensitive lookup

A case-sensitive lookup can be done using an array of functions like INDEX, MATCH, and EXACT. Always remember that you need to enter the formula with the array of functions using the Control + Shift +Enter. Note that the EXACT function will always return TRUE if there are two similar strings. The same function turns … Read more

How to divide one cell to several cells

How to divide several cells by one cell

Microsoft excel, developed by Microsoft Corporation, is a spreadsheet for Windows, iOS, and Android that features graphing tools, calculation, and pivot tables. Excel is mainly utilized in organizing data in companies and businesses and also the financial analysis. Just like in other math operations, Excel provides different ways of the division of cells. One uses … Read more

How to present data in Excel

How to present data in Excel

Data are available to researchers in raw format. Excel is a powerful tool when it comes to data presentation. It enables its users to analyze, summarize and present these data through various ways available on the application at no cost. Excel has a variety of methods that can be used in presenting the data. However, … Read more

How to match and extract different columns in excel

How to match and extract different columns in excel

It is easy to extract and match multiple columns in excel, and we will talk about how we can do this swiftly and effortlessly. To fetch data from given cells in a column, we will need a combination of INDEX function, SMALL function, COLUMNS function, IF function, Row function to create an excel formula. There … Read more

How to insert into Excel – Tables, Illustrations, Charts, Links, Texts and Files

How to insert into Excel

Insert is a feature in Excel that allows users to add information from other sources or other excel features like graphs, tables, etc. This feature plays a vital role in the modification of any excel workbook. It is a feature that you may find yourself using every time you're on excel, and therefore it is … Read more

How to send Bulk Emails using excel

How to send Bulk Emails using excel

It is possible to send thousands of e-mails to multiple recipients. To achieve this, a third-party app called Microsoft outlook is used. This method will help you minimize the time required to send e-mails to the same recipients. Therefore, you need to install this app on your device to send e-mails to many people. Just … Read more

How to make a small number in Excel

How to make a small number in Excel

If you are an avid user of Microsoft Office, then you have an idea of small numbers. Most users sometimes wonder why a particular feature may be in one Microsoft Office application and missing in another one. In this case, the small number is one of them. When working with Ms. Word, it is easier … Read more

How to lock cells in Excel – Complete Guide

How to lock cells in Excel

Other than the read-only, which prevents editing, typing, commands, and proofing marks accidentally, another protective feature that excel has is the locking of cells. This feature in the excel spreadsheet prevents the change of any data or formulas hosted in these cells that are locked. The user who locked cells can unlock them if there … Read more