Anyone have any experience working with total duration numbers for training and leveraging that data in PowerBI?
I have a report that has the time an associate spends in a course and I cannot figure out how to have it show as duration only.
When I try to use some of the time format options and then import the file into PowerBI, it is showing an error for the data in that column.

I’ve been supply chain consulting for 6 years. Is there a logical pivot in to a tech or non tech role at a FAANG that is worth the career shift?

I have extensive SQL background but not much else that is technically related other than solution architecture.

Does program management make sense as a career shift?

Ortho PA in CT with 1 yr of experience. My time is split between OR and office. Coming up on contract negotiations and wondering what people in the specialty make ( even better if you have similar experience).

Team is already talking about eating hours. My utilization is down cause I was in unassigned for a month in Dec/Jan. What's worse pissing off the partner or having a low utilization? -staff 1

Unrelated to work, but what's the expectation on getting your realtor a gift after buying your first home? What would be some examples on what to give them other than a nice handwritten card?

any freelance Sr, ACD or CD ads looking for a cw partner in Chicago? Would love to have a few ads if I come across FL team needs.

Who is hiring Human Capital and Learning Development roles right now?

How much salary provides by Techm? if they provides basis on my previous salary or directly as per the band and expectations?
my yoe - 10.8
CTC - 16.33 with VP and 13.5 is fixed
Getting offer from other company - 24 Fixed

Expecting from Techm - 28 Fixed

Colleagues, if any of you are interested in helping severely disabled combat veterans get homes adapted for their disabilities, let me know. My wife recently started working for former NFL linebacker Jared Allen and his foundation. We're trying to figure out how to leverage the power of the big consulting firms to help our brothers and sisters in need.

Any local/boutique consulting firm in the northern Virginia area? (specifically Salesforce)

Are employers withdrawing i140 after employee quit even if the I140 was approved 3 years back. Wife is on H4EAD what is the impact if I140 is withdrawn?

How are the projects related to .Net,.NetCore and .Net azure in IBM ? Can we easily get after joining IBM ?

Hi guys. I have a query with regards to the Income tax proof submission.

So I have claimed exemptions on the following-
1) HRA
2) 5 year term deposit(fixed deposit) under Section 80C
3) Interest on education loan under Section 80E

I have also provided previous employment details.

Guys I didn't know that we have to submit declaration forms as well. Can you please tell me which are the declaration forms that I would need to fill and submit??

Thanks in advance :)

Partners, I imagine some of you are older. Do you remember a time of instability such as this in history? How has the media changed over the decades? How are you thinking about the times if at all?

Hi All, I am currently working at Accenture Strategy at Analyst level, I am under-designated and underpaid and my practice will present my promotion case in Aug while the results will be announced in Nov.
I have two offers in hand and am confused which one would be best for my profile ( I am a CS engg with 2.5 years experience prior MBA and 4 years in CPG, e-com consulting). Offers I have -

1. HealthifyMe - Strategy, 45 lpa
2. Amazon Sr Program Manager, 45 lpa
Is there a scope for negotiation?

I have no talent for awards work. What should I do?

B1 to B2 , how much hike will get in cg, eligibility criteria?

Which is going to most likely hurt my career more in the long run... a job in pharma or a job in-house on the client side?

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.

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

Would anyone be willing to teach me vlookup?

Anyone use power query before? My goal is I have multiple look up values in one cell (separated by comma) and I need it to look up those values and return values from another table which also may have multiple values (separated by comma) anyone know how to do that? I played around with power query today but it wasn’t giving me what I wanted

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

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

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

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

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭