How to remove unwanted characters in Ms Excel How to remove unwanted characters in Ms Excel

The TRIM function returns a string with extra spaces , starting spaces and ending spaces removed. The CLEAN function removes nonprintable c...

Read more »

How to use words and number of words on Excel formulas or data How to use words and number of words on Excel formulas or data

This example describes how to count the number of words in a cell . 1a. The TRIM function returns a string with extra spaces, start...

Read more »

How to calculate the sum Product in MS Excel How to calculate the sum Product in MS Excel

To calculate the sum of the products of corresponding numbers in one or more ranges, use Excel's powerful SUMPRODUCT function . ...

Read more »

How to Copy Exact formula in Excel How to Copy Exact formula in Excel

When you copy a formula, Excel automatically adjusts the cell references for each new cell the formula is copied to. For example, ce...

Read more »

How to Play with DateDif formula in Ms Excel How to Play with DateDif formula in Ms Excel

To get the number of days, weeks or years between two dates, use the DATEDIF function . The DATEDIF function has three arguments. ...

Read more »

Uses of Rand andRandbetween formula in Ms Excel Uses of Rand andRandbetween formula in Ms Excel

Excel has two useful functions when it comes to creating random numbers . The RAND and RANDBETWEEN function. Rand The RAND function cr...

Read more »

How to change negative number into zero using Max formula in Ms Excel How to change negative number into zero using Max formula in Ms Excel

A clever Excel trick to change negative numbers to zero but leave positive numbers unchanged. Below you can find two columns with numbers...

Read more »

Researchers Create World’s Fastest Organic Transistor Researchers Create World’s Fastest Organic Transistor

Transparent transistors on this postage-stamp size glass have speed characteristics rivaling some forms of silicon transistors. The devic...

Read more »

New System Converts Sun’s Energy into Hydrogen Fuel New System Converts Sun’s Energy into Hydrogen Fuel

A new system designed by researchers at UNC and NC State converts the sun’s energy into hydrogen fuel and stores it for later use. Solar ...

Read more »

How to make a Time Sheet in Excel How to make a Time Sheet in Excel

This example teaches you how to create a simple timesheet calculator in Excel. Cells that contain formulas are colored light yellow. If you...

Read more »

How to Calculate the Days of the Year in Excel How to Calculate the Days of the Year in Excel

An easy formula that returns the day of the year for a given date. There's no built-in function in Excel that can do this. 1. Enter t...

Read more »

How to Count Blank/Nonblank Cells in Excel How to Count Blank/Nonblank Cells in Excel

This example shows you how to count the number of blank and nonblank cells in Excel. 1. The COUNTBLANK function counts the number of blan...

Read more »

How to Sum onle the Largest Numbers in Excel How to Sum onle the Largest Numbers in Excel

This example shows you how to create an array formula that sums the largest numbers in a range. 1. We use the LARGE function. For example...

Read more »

How to Sum Every nth Row in Excel How to Sum Every nth Row in Excel

This example shows you how to create an array formula that sums every nth row in Excel. We will show it for n = 3, but you can do this for ...

Read more »

how to Separate Strings in Ms Excel how to Separate Strings in Ms Excel

This example teaches you how to separate strings in Excel. The problem we are dealing with is that we need to tell Excel where we want ...

Read more »
 
Top