Soluții

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...]

Your Excel charts are hard to read

Excel’s default charts often make data harder to read, with distracting gridlines, awkward spacing, and attention-grabbing colors. That’s why I have a quick cleanup routine to transform basic charts into more professional-looking visuals in minutes.

[mai mult...]

How to fix it when Windows, your router, and Chrome are all using different DNS servers

Changing your DNS server used to feel straightforward. Pick Google, Cloudflare, Quad9, or whatever else. Type in some IP addresses. Call it a day.

Unfortunately, modern PCs don’t always make it all that simple, and that can throw a big wrench into the state of your connection. Your router may be handing out one DNS server, all the while your OS uses another. Meanwhile, your browser may switch to encrypted DNS all on its own. How do you make sense of this mess? Put an end to all the fighting and streamline it all.

DNS is no longer just one setting

DNS is one of those things that sounds like it should only exist in one place, namely, the PC. You type in a DNS provider, your PC asks that provider where websites live, and you’re golden. Never have to think of it ever again. If only it were that simple …

Modern networks are different, and a DNS can sit at several different layers. Your router can hand out DNS servers to every device on your network through DHCP. Meanwhile, your PC can still ignore that (because why not) and use its own DNS settings. Your browser can step right in with private DNS and do its own thing. It’s a mess, and it creates contradictions.

This isn’t the end of the world, but it does make troubleshooting annoying. You may think you changed your DNS server for your whole network, but you only changed it for your router. Similarly, you might think your PC is using your router’s DNS server, but Windows may have a manual setting buried in the adapter options.

Your router’s DNS only works if devices listen to it

Changing DNS on your router is the cleanest option (in theory). It lets you manage the whole network from one place, so it does make sense.

To change DNS on your router, simply log into its admin page or app, and then dig for settings like Internet, WAN, DHCP, or LAN DNS. Enter your preferred primary and secondary DNS servers there, and you’re all sorted. Again, in theory.

The problem is that your router is usually making a recommendation rather than handing out orders here. If your PC, phone, browser, VPN, or anything else are already configured to use something else, well, tough luck, your router’s DNS preference may not stay.

TP-Link Dual-Band BE6500 Gaming Router

Supported standards 802.11.be, 802.11ac, 802.11ax, 802.11g, 802.11n
Speeds 6500 Megabits Per Second

This TP-Link router is one of my favorites to recommend to readers. It’s a Wi-Fi gaming router with two 2.5GbE ports, strong wired/wireless performance, and a lot of extra features.

Windows DNS can override your router

Things get even more “fun” once your operating system enters the chat. Your router may be handing out the DNS server you carefully picked, only for Windows to say “no thanks” and keep using its own settings instead. This is especially true if you’ve changed those settings at some point in the past, so if you’re like me and you like to play around with random stuff on your PC, you never know what you’ll end up with.

This can also happen per adapter, which means your Ethernet connection and your Wi-Fi connection might not even be using the same DNS setup. Oh, joy.

To change DNS in Windows, head to Settings > Network & Internet, pick your active connection, open the DNS assignment settings, and switch from automatic to manual.

That’s useful when you only want one PC to use a different provider, but it’s also the exact reason router-level DNS changes don’t always do what you’d expect.

Stop falling for these 3 common Wi-Fi and Ethernet myths

These Wi-Fi and Ethernet myths are holding back your home network

And your browser may bypass both the router and the OS

As if all of this mess wasn’t enough, your browser can be the final boss in this whole setup, coming in with its very own DNS settings.

Chrome, Edge, and Firefox all have some version of secure DNS, which usually means DNS-over-HTTPS. That can be a great privacy feature, but it also means your browser may use a different DNS path than the one configured on your router/OS.

To fix this, open your browser’s settings and search for DNS or Secure DNS. In Chrome or Edge, this is usually tucked under privacy settings.

[mai mult...]