It’s a familiar situation for every Excel user: you open the Conditional Formatting Rules Manager and discover that the neat little rule you created has somehow multiplied into dozens—or even hundreds—of fragmented copies. The formatting that once worked now behaves unpredictably.
[mai mult...]How to create a “dead man’s switch” on your Android phone
In movies, you’ll sometimes see characters grapple with a “dead man switch.” If someone doesn’t push a button or enter a password every few hours (or days), it triggers a self-destruct sequence or sends out a secret message. I’ve always found that concept really cool, so I built one with an app on my Android phone.
[mai mult...]The fastest ways to find files from the command-line on Linux
How to add Emojis to Excel
Stop wrestling with text in Excel: these 8 tools are game-changers
Stop using Excel data bars—REPT makes faster in-cell charts
4 Ways to rearrange Data in Excel
Excel is a great tool for presenting and analyzing information, but frustrations arise when the data isn’t appropriately laid out. Re-typing the data into the preferred layout takes time and is certain to result in errors. Luckily, there are ways to rearrange data in just a few simple steps.
[mai mult...]How to use Pictures and Icons as Chart Columns in Excel
Excel offers many different chart types—including column and bar graphs—to present your data. However, you don’t have to settle for the preset column and bar layouts. Instead, you can swap these for thematic pictures or icons to make your chart catch everyone’s eye.
[mai mult...]How to crop Pictures in Microsoft Word, Excel, and PowerPoint
Whether you want to focus on a particular part of a picture, remove distracting detail from the edges of a graphic, or reshape an image to fit a specific layout, the Crop tool in Microsoft Word, Excel, and PowerPoint is a useful and versatile feature.
[mai mult...]Why Excel files get huge, and the 5 fixes that shrank mine from 50MB to 2MB
I used to think a 50MB Excel file meant I had a lot of data. I was wrong. It actually meant my workbook was a cluttered mess of hidden caches and ghost data. I managed to reclaim my storage and speed by cutting that file down to 2MB.
[mai mult...]