Microsoft Excel’s new import functions make handling numbers easier

Excel now supports IMPORTTEXT and IMPORTCSV functions that load external text and CSV files as dynamic arrays, making it ...
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 ...
Windows Report

Excel Gets New Import Functions for Faster Data Loads

Microsoft adds IMPORTTEXT and IMPORTCSV to Excel, letting users pull text files directly into the grid with simple formulas.
How-To Geek on MSN

Excel's UNIQUE function can't skip columns—unless you use this trick

Nest CHOOSECOLS inside UNIQUE to extract non-adjacent columns, and use INDIRECT for interactive header dropdowns.
IEEE

Development of pMUT Linear Array Included with Fresnel Zone Plate Focusing Function

Abstract: We have proposed a method to focus an ultrasonic beam transmitted from piezoelectric micromachined ultrasonic transducer (pMUT) array based on the principle of phase-type Fresnel Zone Plate ...