Excel Sheets don’t Support Bookmarks
12 ways to fix your broken Excel formula
I always name ranges in Excel and you should too
How to use the INDIRECT function in Excel
How to create a Drop-Down List from a Column of Data in Excel
How to turn a Screenshot into Excel Data
I use custom number formatting instead of conditional formatting in Excel
5 Microsoft Excel hacks that could blow your mind
Mastering Microsoft Excel’s tools is a never-ending process, even for those who have used the program at work or at home for decades. With this in mind, here are some of my favorite Excel hacks I’ve picked up over the years that you can take away and use to speed up your spreadsheet workflow.
[mai mult...]Turn Off Windows recall to protect your privacy
Recall is an AI-driven feature that allows your operating system to “remember” what you’ve done, where you placed files, and other activities. It does that by saving snapshots of your desktop once every five seconds, then lets you search for information from those snapshots using natural language to help you remember what you were doing. Don’t remember where you saw that recipe for bolognese? You can just ask Recall.
Recall has been the subject of controversy since it was first announced due to the potential security and privacy concerns. It also eats up a respectable amount of storage—you’ll need at least 50GB free for Recall to work, and it’ll automatically disable itself once your PC’s free space drops below 25GB.
Microsoft claims the data is only processed locally (which is true, it works without an internet connection), but I’m still not a fan of having yet more of my data processed and analyzed.
[mai mult...]