How-To Geek on MSN

How to use the MAP function in Microsoft Excel

Row precision vs. Aggregation errors: MAP is the best way to use "greedy" functions like AND or OR in a single, dynamic ...

Learn What GROUPBY Can Really Do in Excel : From Smart Sorting to Percent of Totals

Learn how GROUPBY passes both subset and full arrays into LAMBDA in Excel, letting you compute percent shares fast and explain results clearly.
Investopedia

How Do I Calculate Fixed Asset Depreciation Using Excel?

Steven Nickolas is a writer and has 10+ years of experience working as a consultant to retail and institutional investors. Charlene Rhinehart is a CPA , CFE, chair of an Illinois CPA Society committee ...
MUO on MSN

This might be the most underrated Excel function ever

If you've ever tried building a product catalog in Excel, you know the headache — images float over cells, they don't move ...
Investopedia

How to Easily Calculate Weighted Average in Excel

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, ...
Nature

Towards the dark side

How black is black? An ideally black material would absorb light perfectly at all angles for all wavelengths. Using arrays of carbon nanotubes, researchers based in New York have now engineered a ...
Nature

Carbon-nanotube photonics and optoelectronics

Single-walled CNTs possess outstanding electrical and thermal conductivities and enormous tensile strength, which make them an engineer's dream 1,2,3. Despite the fact that all nanotubes are based on ...