Tag: Excel

  • Excel: Highlight duplicates

    Among my many areas of responsibility at work, is contacting all the users found in various data breach lists that our InfoSec team get their hands on (typically, these are the same lists that eventually make their way to HIBP). Not unsurprisingly, there is a significant amount of overlap between some of these lists, and […]

  • MS Office: Pin items

    Many companies, my employer included, uses spreadsheets on a more or less consistent basis in order to track such things as vacation planning and KPI reporting. For me, as an employee, keeping track of these spreadsheets can, from time to time, be a bit annoying. Much to my surprise, at some point in the past […]

  • Excel: Quickly remove blank cells

    From time to time, Excel worksheets fill up with blank cells interspersed among the content. While the judicious use of whitespace can be useful, it may also make reading the worksheet somewhat challenging. Luckily, Excel has a tool to help us get rid of the blank cells. Here’s how:

  • MS Excel: Create PDF of active worksheet

    I recently had a user call in and ask me how he could export the contents of a single worksheet to PDF while working in Microsoft Excel 2010. As I told him, that is a simple feat to achieve. Here is how:

  • Decrypting Windows’ Minidump files

    When a Windows computer crashes, it will, if possible, write a minidump-file (filetype *.dmp) to the hard drive. These files are usually located in %SYSVOL%\Minidump, and they are usually called something like Mini042809-01.dmp. The problem with these files is that they are not exactly easy to read; here’s a small extract of my last minidump: […]