3 ms·
The First Rule of Microsoft Excel–Don’t Tell Anyone You’re Good at It
- canadianfella 5y agoI like being valued at work. I disagree with this.
- phonon 5y agohttps://archive.is/Mrybd https://archive.is/Mrybd
- ksaj 5y agoWhen I do forensic gigs, I use Excel for inspecting and presenting timelines. When you colour-code the entries, and then sort them by different metrics (eg: computer file MAC times, plus external coinciding timed events known to the investigation) you get a really good idea of what was happening in and around any of the suspicious activity points. What activities preceded a file's existence? What preceded the last time it was accessed? It's not perfect since that evidence is pretty volatile, but every file has at least one part of that puzzle, and the picture is greatly improved by comparing the different timeline views. It's not the usual purpose for Excel, but one it (any spreadsheet, really) is surprisingly good at. As per the article: I'm merely sorting colour-coded rows by other colour-coded columns, and seeing how they group up. I'm definitely not "the Excel guy."