If you’re a new IT auditor or want to become one, I’ve listed a number of my earlier posts for your consideration. If you’re an experienced auditor, here’s an overview of the profession through my eyes.
These posts will:
- Provide basic information regarding IT audit and security and links to other sources.
- Help you avoid some of the hidden pitfalls that control owners and auditors face.
- Give you ideas and approaches for some common and uncommon audits.
- Give you a few chuckles.
If you start at the top and read through each post, you’ll get a good taste of the positives and negatives of IT auditing. Since you can’t do it in one sitting, yoo could bookmark the list and work your way through it as you have time.
Since some of you are newer to the blog, I thought I’d bring a couple of my favorite posts to your attention.
Whether you script your projects or use menu commands, you need to review your ACL log carefully.
Good analysts review their results and the log as they work in ACL, after they think they are done, and have others review their log before the ACL project is relied upon.
(You can’t imagine the dumb mistakes my team and I found that saved us a lot of embarrassment later.)
You can easily use Excel’s Flash Fill tool to transform data fast, without formulas.
Did you catch that? Without formulas!
Flash Fill has been around a few years, but few people, including auditors, seem to be aware of it.
This tool is so easy to use, you could learn it AND teach it to your mom in 4 minutes. Really.
If you’re looking for a way to safely check URLs for bad content, Lenny Zeltser had a great list of free online tools for you.
As I explained in the last Excel post, you can check for blank and invalid data in Excel several ways.
In this post, I will focus on the insights and issues encountered by sorting each column from A to Z and then Z to A.
Sounds pretty simple, but I’m willing to bet you will be surprised to learn a thing or two…
For a list of the reasons why you must validate data before analyzing it, see Why You Must Validate Data.
You can check for blank and invalid data in Excel several ways.
Depending on the size of the file and your preferences, you can either scroll through the dropdown list, sort each column from A to Z and then Z to A, or apply a filter.
Sometimes, you need to use a combination of these methods.
It’s important to know how these methods treat data differently and to be aware of their limitations.