If you’re an auditor and you are not yet using Excel PowerPivot, you are missing the next greatest thing since spreadsheets arrived.
If you are NOT an auditor, and you don’t use PowerPivot, you’re in the same boat with the auditors mentioned above, and it is sinking.
In other words, if you use Excel, you should be learning Excel PowerPivot. It’s that big.
Let me explain why.
NOTE: I updated this post quite a bit with new info…
Continue reading →
Like this:
Like Loading...
Filed under Audit, Data Analytics, Excel, Free, Technology
Tagged as analysis, analytics, data, excel, filter, join, pivot table, powerpivot, ssis, VM
If you’re an auditor, you need data analytic skills or you will die.
Or put another way, if you don’t acquire them in the next 1-5 years, you will no longer be an auditor.
Pretty bold statement, isn’t it?
Continue reading →
Like this:
Like Loading...
Filed under Audit, Data Analytics, Employment, Free, Technology, Written by Skyyler
Tagged as Academy, acl, concatenate, data, ETL, extract, fuzzy, iia, isaca, join, lookup, MISTI, outlier, pattern, pivot, population, table, training, unstructured, validation
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.
Continue reading →
Like this:
Like Loading...
Filed under Audit, Data Analytics, Excel, How to...
Tagged as concatenate, excel, fast, flash fill, format, formula, help, join, microsoft, text to columns, video
Do you know the #1 reason auditors don’t do data analytics (DA) much?
It is so simple, so obvious, I hesitated to blog about it. Let me know if you agree.
Continue reading →
Like this:
Like Loading...
Filed under ACL, Audit, Data Analytics, Scripting (ACL), Technology, Written by Skyyler
Tagged as #1, analytics, clean, excel, filter, full population, inspect, join, pivot table, profile, reason, results, SALY, same as last year, time, transform, vlookup
As soon as you create an ACL script, you often have to add to it or edit it. There’s an easy way to do it.
Continue reading →
Like this:
Like Loading...
Filed under ACL, Data Analytics, How to..., Scripting (ACL), Written by Skyyler
Tagged as as, easy, edit, export, extract, field, first, import, join, records, script, table, ten, width
To make these posts easier to find (and link to), here’s a list of all the ACL posts on this blog in alphabetical order, and by most popular.
I’ll add other posts as they are written.
Continue reading →
Like this:
Like Loading...
Filed under ACL, Data Analytics, Top 10
Tagged as acerno, acl, AuditNet, bootcamp, builder, coderre, computed field, data analytics, error, expression, freeze, function, history, import, index, join, list, log, message, script, social networking, table layout, teach yourself, tips, Top 10, training, youtube
ACL is offering FREE training as part of their bootcamp series, which started in September 2011. The training consists of a video presentation that includes ACL demos. The best part is that you do NOT have to be a current ACL customer or even have a copy of ACL.
The purpose of the series, according to ACL, is to teach basic skills and deal with common problems that ACL users encounter. Each session lasts about 30-40 minutes, followed by a Q&A session. The bootcamp is led by Shane Grimm (see his blog comment here).
Continue reading →
Like this:
Like Loading...
Filed under ACL, Audit, Data Analytics, Free
Tagged as access, acl, bootcamp, cpe, data, free, join, log, relation, script, shane grimm, table, training, trick, troubleshoot, webinar
If you’re an ACL user, I sure hope you read your ACL project logs and approach the JOIN command carefully. I recently received a good reminder. For an explanation of ACL, see this post.
Continue reading →
Like this:
Like Loading...
Filed under ACL, Data Analytics, Written by Skyyler
Tagged as acl, audit command language, blank, error, join, log, matched, record, unmatched
Rerunning an ACL join command is much easier than most people realize. And everyone using ACL screws up joining two tables more often than he’ll admit.
It goes like this: You painfully select the primary keys, the secondary keys, the primary fields, and the secondary fields, enter the output table name, and run the join. The join ran successfully, but you forgot to add one primary field or to adjust the options on the More tab. Now you have to do it all again. Or do you?
Continue reading →
Like this:
Like Loading...
Filed under ACL, Audit, Data Analytics, How to...
Tagged as acl, command, easy, extract, field, fix, join, log, more tab, primary, rerun, secondary, set filter, table