How-To Geek on MSN

The 4 Excel find and replace tricks I use to save hours

Click "Format" next to the Replace With field, and select the correct number format in the Number tab (in this case, ...
How-To Geek on MSN

Don't trust Excel's COUNTA function to count non-blank cells—here's a better method

In most counting scenarios in Excel, COUNTBLANK reliably counts blank cells, and COUNTA reliably counts populated cells.
Investopedia

How to Calculate Gross Profit Margin in Excel for Business Success

Claire Boyte-White is the lead writer for NapkinFinance.com, co-author of I Am Net Worthy, and an Investopedia contributor. Claire's expertise lies in corporate finance & accounting, mutual funds, ...
Investopedia

Calculate Earnings Per Share (EPS) in Excel: Simple Steps Explained

Claire Boyte-White is the lead writer for NapkinFinance.com, co-author of I Am Net Worthy, and an Investopedia contributor. Claire's expertise lies in corporate finance & accounting, mutual funds, ...