Help me recreate a TB to import into Caseware. I have 7 entities, and 3 (4 for revnue) sub mappings. How do I recreate the trial balance for import? I need to pull for example columns 1) revenue 2) contract or non contract sales 3) sales or sales - freight 4) Intercompany or Labor or Gadgets

How do I create a formula to pull a list out that says for entity A) here's the revenue accounts, sub groupings, then sub groupings of that, and sub grouping of that -

I plan to add lead codes/import

Can anyone concur the following, working on multimedia editor (Video) (4-6 YOE) requisition:
1. The average rate for freelancer - ₹700-1200 per hour
2. The average compensation package for a full time editor: 7-9 LPA

Grateful for any inputs.

Do friends ever dump you onto your therapist or psychiatrist or dismiss your valid, normal feelings as “oh did you tell your doctor about this?” I feel like they’re just shitty friends delegating off.

Seen a few posts on people not having/hating on parents with kids. What is your rationale? I for one am excited to have 3 kids running around in the future! Anyone else?

Best bachelor party cities?

Is Capgemini a good place for a recent grad to learn more and solidify skills in statistics and machine learning? Would I be able to work on different projects? Good experience to get into big tech?

I'm moving my firm to a non hourly model. I want to encourage efficiency and discourage the work your life away model.

For litgation we're thinking past pleadings and MTDS then X, Discovery than Y, SMJ motions then Z trial then Q.

What are your thoughts on this ? What are my issues here. I think the hardest one is to predict discovery. But I also think we can outsource some of this to cheeper labor and lean on our tech to not actually have to review everything.

So fed up with my practice and not looking to stick around for typical below-market compensation in October.

Which big 4 firms or MM have the best FDD comp. so far? Excl. A&M (I know their comp., over half our practice has quit to go there lol)

Where does ZS offer MBA program as part of advanced career programme and how much amount is sponsored by ZS? And after how many months post working with ZS one will be eligible for it ?

I am defending an eviction for a client who has given possession of the property (as of Nov. 30). Plaintiff’s complaint has one claim – possession. They did request relief for attorney’s fees. NJT/Final Hearing commenced 10/27, was only 30 min and was therefore continued to 12/20. Plaintiff had counsel at that time but they are no longer represented.  I want to file something notifying Court that Plaintiff claim is now moot, making sure that judgment is not entered that hurts (cont'd)..

Penn or draftkings?

Can H1B visa holders own rental property? If so, can you self manage or do you have to get a property manager? (House would be bought through personal loan, not an LLC, so wondering whether USCIS could deem self managing as unauthorized employment? How would they find out?)

What is personal independence??
Why Pwc asked me to fill all investment details for me and my dependant.
Can anyone please help me on this ??

@pwc

Has anyone taken the SHRM-SCP? Any study suggestions and impressions of the test?

When you hear the title “consumer product manager” vs “product marketing manager”what job responsibilities do you assume each person has? Or do they seem the same? There has been some confusion internally for a new team/role and wanted to get a check from all of you on perception!

I am looking for Service Virtualization roles
Tool: Devtest/CA Lisa
Exp: 7.5y

Hi Fishes
how's the recession going
is it over so i can think about job change

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

Best websites to get more of a handle on Excel as a beginner-intermediate?

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

Would anyone be willing to teach me vlookup?

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks