How-To Geek on MSN

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

Counting non-empty cellsThe COUNTBLANK-COUNTA conflict (and how to fix it)Summary: Choosing the right counting functionIn ...
How-To Geek on MSN

How to do math in Excel without formulas

The fix for the disposable formula habit in Excel is already on your screen. At the very bottom of your Excel window is a ...
Computerworld

How to use Excel formulas and functions

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions. One of the ...

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

Discover how to calculate EPS in Excel with easy formulas. Master this key financial indicator to enhance your investment strategies and analysis.
Electronic Design

Excel Formula Calculates Standard 1%-Resistor Values

The Excel cell formula below calculates the nearest standard 1%-resistor value without using a lookup table or macro. Type or electronically paste the text below into any cell (other than A1). The ...
Geeky Gadgets

Learn to Count Excel Cells by Color Like a Pro : SUM & COUNT Cells By Color

Have you ever stared at a colorful Excel spreadsheet, wondering how to quickly calculate totals or counts based on cell colors? It’s a common frustration for anyone managing large datasets. While ...