How-To Geek on MSN

6 Functions That Changed How You Use Microsoft Excel

Use Excel for web or the Excel for Microsoft 365 desktop app for the latest Excel features, including the newest dynamic ...

How to filter data in Microsoft Excel to organize and sort your spreadsheet

You can filter data in Excel based on either certain parameters in columns or over the whole sheet, and you can later ...

How to alphabetize data in an Excel spreadsheet by column or row, and by using shortcuts

You can alphabetize data in an Excel spreadsheet by row or column using the "Sort" feature, or through the "Data" and "Home" tabs.
How-To Geek on MSN

How to Use the DROP Function in Microsoft Excel

One of the most underused lookup and reference functions in Microsoft Excel is the DROP function. This powerful yet simple ...

Secret Excel Features That Turn Beginners Into Data Pros Overnight

Discover the 4 Excel features that are changing data management forever—PivotTables, Power Query, Excel Tables, and Dynamic Arrays!
GitHub

data explorer: reusing same sort/filter clears pinned rows

This is likely a minor bug, but worth mentioning. When the sort/filter state changes, the pins are cleared (which is expected). However, when the sort/filter states don’t actually change (we open and ...
IEEE

A robust and automated algorithm that uses single-channel spike sorting to label multi-channel Neuropixels data

Abstract: This paper describes preliminary work towards an automated algorithm for labelling Neuropixel data that exploits the fact that adjacent recording sites are spatially oversampled. This is ...