Just transferred to Forensics from audit and i feel like I do not have the excel skills. My excel skills were good in audit but I feel like I have to know VmA and macros to be part of this team. What should I target to learn first? I feel dumb

like
Posting as :
works at
You are currently posting as works at

“Unlock VBA and macro” course on Udemy is my recommendation. If you know how to create a Macro with a loop and if statement then you can build on that. The rest can be Google as you move up to more complex stuff.

likehelpful

I think what EY1 suggested is good, to be totally honest some of my staff don’t know any of that and they do just fine. It’s all very project dependent.

like

What’s a use case for vba ? Why not use power query?

Just search in Success Factors and Udemy. There are hundreds of excel courses. Not to mention YouTube videos out there too.

Related Posts

Hi everybody ! I’ve been working in Dubai for the past 6 months as a Marketing Manager in a Web 3 firm. Coming back to the US due to visa status, I’m looking for a similar position in the Crypto Industry. Due to the very technical nature of the industry and market sentiment, there are only software engineers being hired and no marketing :/ any recommendations to go into those technical Industries as a marketer ?

like

Insights on OC&C?

Culture in the offices -New York or Boston, project teams?
Base and bonus for 3-4 years of experience?
Career progression model?
prestige and ability to exit to corp strat?

like

Thoughts on voila? Good exit for consultants ?

like

Anyone move from a Big 4 to Big 3? How long were you at Big 4 before moving? And how’d you manage the transition?

When do you know it's time to move on? Recent leadership changes shifted my role in a way I don't like. Do I wait it out? (I have 3 months until I vest) Or do I move on?

like

Has anyone transitioned from PA to a PhD in Accounting? What is the PhD like? And how did you know it was the right decision/time?

like

What kinds of opportunities are there for senior managers trying to get out of public accounting? Going from mid sized firm to industry. Been through one too many busy seasons. I’m done!

Been in consulting for 4 years now out of undergrad, want to get into construction/project management. Best way without going back to school for another degree? MechE undergrad FYI.

like

I currently work as a referral coordinator and a portion of my job duties entails writing appeals for essential medications denied by drug companies etc. In general I really enjoy this portion of advocacy in my job and this is a newly discovered passion of mine
I would like to use this job as a stepping job into further advocacy work to gain experience, but would like to step more into advocacy work.. I have a ba in youth development- I’m looking for advice suggestions! Any ideas are appreciated

like

I have 10 years of experience. Mostly in Unix, C++ and Visual C++ and MS SQL. I developed interest in cloud computing as like many others and was able to clear AWS Cloud Practitioner, AWS Solution Architect Associate and Professional, AWS Security. Along with these I was able to clear 8 Azure certifications as well: 3 fundamentals, Azure Security, Azure Developer, Azure DevOps and Azure Architect.
Now my main question, can I try to switch on Cloud Architect or some other similar cloud roles?

Any idea how the career progression, hike would be for business analysts in deloitte USI with the role designation as Consultant

I'm hearing that family law attorneys are swamped right now! If you need to outsource your drafting to keep up with your caseload, let me know. I practiced family law for a few years before switching to contract work, so I can jump right in with no training.

like

Any participants in the HoH Fellowship as they transitioned? I am an active duty CWO2/USMC (10 years) with 12 months of service left.

like
like

Advice on taking and passing the SPHR exam?

likehelpful

I’m interested in reaching for a position as manager for a local retailer, but I hate having to play the bad guy. How can I become more comfortable with fulfilling that role?

like

Are there practice exams for the BA cert? If so where can I find them

like

This is my first job in a large corporate company, and I’m trying to gauge how long it normally takes to move from entry level to another internal position in the insurance industry. I have been applying internally for a year now and I am wondering if this is normal or if my company is just slow? I am a top performer, with great metrics, and I have some wonderful connections I’ve made who support me. I just can’t seem to move up. How long did it take you to move up? How many tries did it take?

like

About to turn 30 and I really can't see my self doing IT audit for much longer. What are my exit ops?? M2 6yoe, sec+ and CISA.

#yallhiring

likefunny

More Posts

2 questions:

1. Amongst all the big PA firms, who has the strongest forensic service line?

2. CAMS or CFE or CFF?(already a CPA).

Thank you!

like

I am almost done with FNP and I am so sick of patients now. I've been in healthcare for almost 20 years and it is what I know, but the pandemic has burnt me out so much. What about corporate wellness jobs? Has anyone gone there? Or gotten a job for a federal agency (not the VA, I don't want to work with patients)? How does one "break into management" if you're over 40?

like

Have majority of us started our teenage years in retail?

like

How long do I have until I have to accept/reject an offer if the offer letter doesn’t say? What are good stall tactics? HELP I’m still in callbacks

like

Why is Tax filled with Karen’s? Everyone so prestigious. I hate it.

like

Best way to hit a savings goal for a down payment? I’m 50k short 😫

Managers, how did your first year as manager go?

like

What does a perfect customer support experience look like beyond having the issue(s) resolved? Does follow-up add to that experience?

like

Which are the top consulting firms in UK to have great mentorship, learning and development as an entry level business/data analyst

like

Anybody looking for a US Open grounds pass for Sunday? Also food recos for flushing?

like

Is it easy to cross the 200k tc mark in sales engineering?

like

Hi Folks,
How's WLB in
Honeywell Connected Enterprise? Any idea?

Hello All,
Could you please help me know what will be in-hand salary for 18 lakh fixed pay?

like

How does your significant other handle your relapse? I’m 5 years sober overall but relapsed / slipped recently and my spouse isn’t speaking with me. I know alcoholism is hard on loved ones but I’ll do your spouse cut you off? How to deal with it?

like
like

Newer homeowner. Garbage truck didn’t pickup our garbage on trash day. Company said to leave it on the curb and they’d get it by today. Some neighbor moved our can next to our house and garbage missed again.

Happy to have my first real suburb experience.

like

Just some holiday nonsense. . What should I order? 🤨

Post Photo
like

I’m applying for the solution engineer role at Salesforce with 2 YOE in Deloitte’s salesforce practice at the SC level leading Salesforce discovery and implementations. What level of solution engineer should I target? Associate SE, SE, Senior SE?

like

I was the one who posted about my husband giving me a few months to train my dogs before we had to discuss rehoming at least one. Specifically, one of them growled at home a lot. And then I've posted recently about the same dog having jaw surgery.

Well, after the jaw incident, my husband was the one who had to go pick her up from the hospital and transport her to the surgeon, then back home. Since then, she's been by his side obeying commands, and not growling.

And she looks like Hannibal...

Post Photo
likeuplifting

Can I tell my employer than I’m not going to do additional responsibilities out of the scope of my job description without the appropriate pay? They asked for GIFs in my job description but now they’re asking for video editing, motion design, and 3d modeling and 3d animation. I can do this but I should be compensated for all of that right?

like

Additional Posts in Fraud and Forensics

I was told getting CFE could increase my earing potential by 17%, has this been anyone else's experience?

funny

I recently passed the CFE and was looking into the CAMS next. Any suggestions on how to best prepare for the CAMS? I’ve been mostly reviewing the index cards that come with the prep material.

like

How does the comp look for a Senior Associate in Financial Crimes at KPMG?

like

How similar is forensic accounting to audit? I don’t like auditing at all and trying to see if switching to forensic is a better route to go? I’ve heard ppl saying it’s completely different and less technical than audit, others tell me it’s very similar hence they recruit a ton from audit.

like

2 questions:

1. Amongst all the big PA firms, who has the strongest forensic service line?

2. CAMS or CFE or CFF?(already a CPA).

Thank you!

like

I’d like to work for the FBI either as a Special Agent or Professional Staff as a Forensic Accountant. I am currently a Senior Forensic Accountant at a public accounting firm but we mainly handle commercial damage calculations, business valuations, and SOME investigations that one might think of as “was there fraud? We’re not sure, please Mr. Forensic Accountant can you take a look at our QBs?”
Question: is this experience preferable to the FBI? Or do they prefer the AML professionals? CPA + CFE

like

Interested in this line of work. For former auditors? How bad is not having materiality?

likehelpful

How is Deloitte’s AML practice? Can anyone share some insight? ~4 years in forensics, 1 of which was primarily AML. Considering switch

like

What are the differences between Guidehouse Defense and National Security verticals? Thanks!

Any recommendations on certifications similar to CFE, but focuses on systems or data to identify fraud?

like

I’m an Audit S1 and I am looking to work in Forensic accounting at a Big 4 and eventually the FBI (my dream job). Does anyone have advice on switching from Audit to Forensics? I’ve seen formal rotations offered for Deal but at my firm they don’t offer that in Forensics. Anything helps! Thanks

like

Salary for S1 Forensic EY ? Is it under assurance

like

Has anyone heard whether Forensics is participating in layoffs this week too? Or if they will soon?

likehelpful

Anyone done work on AML risks for companies accepting crypto payments?

What are common exit opportunities from the Big 4 working in forensics and do the external salaries stack up against those of Big 4? Looking to leave as either a senior or a manager.

like

Is 180k possible for an EY forensic Tech M3 in NYC?

like

Anyone with the ABV or other valuation credentials? I’m interested to see how many actually use valuation skills on their forensic engagements and if getting a credential is worth it.

like

what does EY hire manager 1s at in tier 3 cities? currently at $110K and hoping to land a role around $130K. Or are they closer to the $110K to $120K range in LCOL/MCOL?

How much do Senior Managers 1 in Forensics make? Areas like GA, FL, NC, TX?

like