Here’s a look back at the most popular blog posts of 2021 according to the number of times readers opened those posts. It’s been a long time since I’ve done a best blogs post…
Some of these posts are oldies, and yet they are still pulling in plenty of traffic. Check out the list, and see if you missed any of them, especially new readers.
Filed under ACL, Audit, Blogging, Certification, Data Analytics, Employment, Excel, Free, Free Download, How to..., Security, Technology
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.
Filed under Audit, Data Analytics, Excel, How to...
Here’s a list of my basic data analytic procedures for Excel.
As I add more posts to the series, I’ll update this list.
I created this series because:
1) I often get asked by new AND EXPERIENCED auditors how to do these tasks,
2) when I review workpapers, I realize too many auditors are not aware of these functions,
Filed under Audit, Data Analytics, Free, How to..., Security
ITauditSecurity 