How to count cells that contain only N character

Excel is a powerful and very helpful Microsoft program for data analysis and documentation. OK is a spreadsheet program with many columns and rows, and sometimes we need to know…

Comments Off on How to count cells that contain only N character

How to send Bulk Emails using excel

It is possible to send thousands of emails to multiple recipients. To achieve this, a third-party app called Microsoft outlook is used. This method will help you minimize the time…

Comments Off on How to send Bulk Emails using 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…

Comments Off on How to make a small number in Excel

How to lock cells in Excel – Complete Guide

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…

Comments Off on How to lock cells in Excel – Complete Guide

How to turn data into a line graph in excel

When you're working on data on excel, you may wish to convert it into a chart. Line chart/graph is one of the common and most frequent methods of representing data…

Comments Off on How to turn data into a line graph in excel

How to change excel info PDF

1. Open your workbook. 2. Go files tab and click Save As. 3. Select browse. 4. Select PDF from the drop-down list. 5. GO to options. 6. Here, you have…

Comments Off on How to change excel info PDF

How to graph two lines in Excel

Drawing a graph that comprises two lines in excel is possible. One of the advantages of using excel as your spreadsheet is that you can display two unique data sets.…

Comments Off on How to graph two lines in Excel

How to extract date from a text string in Excel

At times you might find yourself working with spreadsheets that have jumbled up data. For example, a single cell holding up all of your information instead of distributing it among…

Comments Off on How to extract date from a text string in Excel

How to search for a phrase in Excel

When working on an excel workbook, you may need to search for a particular phrase within the sheet. Going through the excel document word to word looking for that phrase…

Comments Off on How to search for a phrase in Excel

How to Remove Characters in Excel Cells

Formulas are key in getting things done in excel. One can apply formulas to manipulate texts, work with dates and time, count and sum with criteria, create dynamic ranges, and…

Comments Off on How to Remove Characters in Excel Cells