Soluții
How to quickly fix CSV files in Excel using Power Query
Web apps love exporting CSV files, but they don’t always play nice with Excel. Leading zeros disappear, dates break, and text fields merge together. Most people waste time fixing these problems manually, even though Excel includes a built-in Power Query tool that automatically cleans and reshapes messy data in seconds.
[mai mult...]Auto-Excluding Folders from Time Machine via Terminal
Time Machine’s graphical interface lets you exclude folders one at a time by dragging them into the “Exclude these items” list, but this quickly becomes tedious if you have many cache folders, build directories, or virtual machine files that don’t need backing up. The tmutil command-line tool gives you far more precise and scriptable control, which is especially valuable for developers dealing with things like node_modules, Docker volumes, or Xcode’s DerivedData folder — all of which can balloon your backup size without adding any real value.
Personal Digital Vault with an Encrypted .dmg File — no extra encryption Apps
Disk Utility, an app most people only associate with formatting USB drives, actually has a genuinely powerful and underused feature: it can create an encrypted disk image that functions as a password-protected virtual vault, using the same AES-256 encryption standard as full-disk FileVault. This is a great alternative to paid encryption apps if you just need a secure place for sensitive documents, tax records, or private photos.
[mai mult...]Custom Keyboard ahortcuts for any Menu Command
Most people don’t realize this, but macOS has a built-in, completely free way to assign a custom keyboard shortcut to literally any menu command in any app — even ones Apple didn’t originally give a shortcut to. This is genuinely useful if you find yourself repeatedly reaching for the mouse to click something like “Export As,” “Merge All Windows,” or a deeply nested Preferences item.
[mai mult...]Create a RAM Disk in Terminal — Instant Scratch Disk for Photo/Video Editing
A RAM disk is a virtual drive built entirely from your Mac’s memory instead of your SSD. Since RAM is dramatically faster than even the fastest NVMe storage, this trick can meaningfully speed up apps that constantly read/write temporary files — think Photoshop’s scratch disk, Premiere Pro’s media cache, or DaVinci Resolve’s render cache. It’s especially useful on Macs with 16GB+ of RAM where you can spare a few gigabytes without impacting overall performance.
[mai mult...]