You don’t need a USB flash drive—your old phone is a better portable file server

Buying a new phone leaves you with an older one that is pretty much useless unless you trade it in. No one really needs a second phone unless it is for work. Once you’ve moved your contacts and photos over, it’s easy to forget the old phone is still useful when repurposed. It won’t lose any of the features that make it such a good mini computer, and you should take advantage of that.

[mai mult...]

Stop opening your browser for these 8 tasks, the terminal does them better

The terminal looks like an unassuming (sometimes intimidating) black box and feels like it’s only meant for pros or experts. It’s not as inscrutable as it seems though. Anybody can learn to use it and get stuff done. Once you get the hang of it, you’ll often find yourself launching a terminal instead of opening a new browser tab. That’s because the terminal is faster, reliable, and never shows ads.

[mai mult...]

9 Microsoft Excel tools that make Google Sheets users jealous

There’s no doubt that Google Sheets has closed the gap on a ton of everyday spreadsheet tasks. However, Microsoft Excel still offers a handful of specialized power tools that set it apart. From automated data cleaning to heavy-duty optimization and brilliant layout tricks, these features are a big reason Excel still leads in many workflows.

Managing messy data imports from external sources usually turns into a nightmare of manual copying, scrubbing, and sorting. Excel handles this through Power Query, its built-in data transformation tool. You can plug it directly into PDFs, local folders, or massive corporate databases, slap a few filters on it, and watch it strip out errors and reformat the entire dataset automatically.

Google Sheets doesn’t have an equivalent integrated, low-code extract-transform-load (ETL) workflow for cleaning data before it hits your grid, leaving you stuck with tedious manual approaches, bloated formulas, or custom scripting just to keep your information uniform.

[mai mult...]