A vulnerability scanner like Nessus or Qualys will record the MAC address of every computer it finds. But Qualys doesn’t output the MAC address in a nice column format. It mixes a lot of other data into the cell. So I had to figure out how to extract a MAC address from Excel data to give an infrastructure team an inventory they wanted.
Office
Anything related to Microsoft Office
Countif example: Data analysis with Excel
The lowly Countif function is one of the most useful tools for data analysis you’ll find in Excel and other spreadsheets. It’s also not all that well understood, I find. Knowing how to use it sure has made my job much easier since 2013, so I think there’s a chance it will help you too. Here’s a Countif example to show you how to use it.
How to create a stacked bar chart in Excel
My boss’ management is clamoring for metrics. They want to know, at a glance, what we’re doing and how far along we are. Sounds like a job for stacked bar charts in Excel to me. So here’s how to create a stacked bar chart in Excel.
Figuring out a way to track our progress was fairly easy. Figuring out how to make Excel display that chart in a meaningful fashion… Well, that took about five hours. I’ll try to make it easier for you than it was for me.
Read more
How to accept all changes in Word
Every couple of months or so, we have to collaborate at work on a Microsoft Word document and submit it without all the distracting markup in it. And it seems like it always takes four of us half an hour to re-figure out how to accept all changes in Word and remove the comments. This applies to Word 2007 and all newer versions.
Sometimes I also find the tracked changes and other markup causes weird problems, and the fastest way to make them go away is to get rid of the markup.
So I figured it might help someone. This is something that either takes you 30 seconds or 30 minutes. If you don’t do this every day, it’s likely to take too long. This is for those of you who can’t do it in less than 30 minutes.
Read more
Convert HTML to Word
There are at least two different ways to convert HTML to Word, depending on what you have to work with. I will assume you have your own reasons for wanting to make the conversion, such as needing more formatting options. Here’s how to make the conversion quickly and easily.
To do this, you only need Word and possibly a Web browser. You won’t need any additional tools or software to make the conversion work.
How to superscript in Excel
Sometimes you may need to superscript text in Excel, such as to display an exponent. But the superscript option is good at hiding. Here’s how to superscript in Excel.
As with many complex programs, there’s more than one way to superscript in Excel. That doesn’t help you much when you can’t find it, of course. This tricks works in Excel for Office 365, Excel 2016, Excel 2013, Excel 2010, and Excel 2007. In other words, every version of Excel with the ribbon.
Read more
Uses of Microsoft Excel
Microsoft Excel is one of the most popular pieces of software ever. Many job descriptions cite familiarity with Excel as a requirement, or at least desirable. But no one was born knowing it. So let’s take a look at some uses of Microsoft Excel.
Remove the last octet of an IP address in Excel
Maybe I’m the only one who ever has to do this, but here’s how to remove the last octet of an IP address in Excel using one (relatively) simple formula, not a series of calculations.
Why is Publisher hyphenating my words?
Why is Publisher hyphenating my words? That’s probably one of the most common questions I hear about Microsoft Publisher. There’s a good reason for it, but I understand if you want to disable it. So I’ll answer both questions.
Find words in all caps in Word
Sometimes it’s helpful to be able to find words in all caps in Word. Microsoft Word, that is. This helps you find all the acronyms so you can make sure you spelled them out or explained them properly.
Double-checking acronyms is especially important when writing government proposals, which require you to spell out acronyms on first usage. If you’ve never written a proposal, be glad, smile, and nod. Many acronyms make good index material, so this trick helps when you’re writing an index. Also, acronyms are frequently jargon, so making sure you explain them adequately is just part of good writing. Or, if you’re a fan of high quality typography, you might want to find them all so you can set them in small caps for improved aesthetics and readability.
Here’s how you do it.