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.
Continue reading →
Like this:
Like Loading...
Filed under ACL, Audit, Blogging, Certification, Data Analytics, Employment, Excel, Free, Free Download, How to..., Security, Technology
Tagged as acl, Audit, basic, best, blog, cisa, coffin, computed field, conditional, data analytics, downloads, dying, excel, flash fill, free, little experience, nail, popular, post, skyyler, study guide, teach yoursef, user access
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.)
Continue reading →
Like this:
Like Loading...
Filed under ACL, Data Analytics, How to..., Scripting (ACL), Written by Skyyler
Tagged as acl, bypass, check, computed, conditional, conventions, duplicates, ESCAPE, fail, field, first, found, ignore, invalid, log, pause, review, script, second line, test, unable
In ACL, a conditional computed field (CCF), is basically a regular computed field with some fireworks.
It looks and acts much like a regular computed field, but has some extra parts that do some extra work. Fortunately, the extras are NOT complicated, and after reading this post, you will find that will you use CCFs frequently.
So what’s the difference?
Continue reading →
Like this:
Like Loading...
Filed under ACL, Audit, Data Analytics, How to..., Scripting (ACL), Written by Skyyler
Tagged as acl, add, boot camp, CCF, character, column, computed field, conditional, country, customer, c_, default, expression, format, formula, function, length, manual, region, sales, script, skyyler, start, string, SUBSTR, syntax, text, tip, type, video, what is