Microsoft's Excel blog walks through a common but tricky scenario for Excel: pulling out all the rows from a large spreadsheet that match particular criteria. It's detailed stuff, but much more useful than Microsoft's built-in help on the same topic.
Build A Master Detail View In Excel
Trending Stories Right Now
In the aftermath of Amazon Prime Day deals, one of the weirder insights we gathered from Lifehacker readers was that aside from your affinity for Coca Cola multipacks, you were pretty big on smart lighting. Because apparently everyone owns a Philips Hue smart lighting system now, we've decided to figure out how to get the best out of the most expensive light bulb you'll ever purchase.
Sometimes you want to watch Netflix, but need that watching to be on the discrete side. Or instance, maybe it would help if your computer’s screen looked like you were on a conference call talking to people in another office rather than watch The Office.