I have many DAT files that need to be converted to excel workbooks by using delimited. Does anyone know how to automate that process rather than having me convert each DAT file manually? Trying to save some time here as a newbie 😢

San Antonio food and things to do???

Journalism is the best job in the world but I feel like people are less likely to take my work seriously because I am female. So it's like they automatically think the only things I would be good at writing about are fluffy little human interest stories. I'm just a reporter like everyone else. Is there some way I can tell my supervisor that yes, I do like those stories, but I like being a serious reporter even more?

How do I explain the importance of a digital marketing function to a PE (Private equity) board member? Any recommendations on what to focus on or highlight would be highly appreciated!

Requirement for java backend 3.5 + years
aws service 4+ at CTS
Dm me for refferal

I understand a CofC is triggered in an equity deal, but is that also triggered in an asset deal (along with assignment, obviously)?

Advice for someone having their first annual review? I have been well exceeding my role and am going to negotiate for a higher pay raise.

Any thoughts on Sidley's London office? How sharp elbowed are the associates and how much do partners genuinely try and help you develop a career? Bonus points if you can provide insight on how the corporate and finance departments work with specialists on transactional matters. As a final ask, are they genuinely into D&I and flexible working efforts or is this predominantly lip service? Thanks in advance!

Has anyone else hit the airplane mode button on their laptop when they get asked a hard question by the client they simply cannot answer. Hoping someone else will answer while I get "reconnected".

Highest number of billable hours you have seen in a year?

Any good PM roles open? By good, I mean focused on PM activities and not covering down for unrealistic sales promises. Rapidly hitting my limit at my current org.

Hey fishes,
Are certifications important for hikes while switching companies?

Partners- joining a new firm next week at the manger level. Small group (~80 across US), what are some important things you think I should do to set myself up for success? I.e. what would impress you

Recommendations on how to simultaneously pay off student loans and invest?

With another Boeing 737 crashing, would it be wise to invest in Boeing Puts?

Hello IBMers,
IBM has offered me X amount ctc and i accepted it on portal....now got to know that market valuation for 10.3 yoe is greater than offered ctc....can i ask HR to increase the ctc and change the band...will they consider it?...not holding any counter offer as of now

Last year when Covid broke, I received a couple of interview calls but ignored them as I felt the organization kept me at work when other companies cut short their HR staff so I should be with them even if with no appraisal. But now, I was living in the fool's paradise when I am told to leave with no job offers in hand, car and home loan, dependent parents, expecting jobless spouse with a 3-year old kid.

I’m a simple guy. I see Mc🐝. I upvote.

Anyone have recommendations for CPAs based in Houston (or anywhere in Texas in the post pandemic world) who are familiar with working with BigLaw attorneys?

How useful are Macros and VBAs for tax prep?

Would anyone be willing to teach me vlookup?

Hey everyone! I am working on a report with the intention of updating the products that a specific customer uses. Currently, the data is arranged with the unique ID in Column A, and associated products in Column B. However, each product has its own row so company 1234 might have 5 rows and company 5678 might have 20. What I need to do is collect the product data for each unique company and put it into a single row, separated by a comma(s). I am at a crossroads, any suggestions?

What is the best online tool to pick up VBA?

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

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

Anyone know why a SUMPRODUCT cell would return to zero?

The error said ‘inconsistent formula’... (cont’d)

What would you consider "Advanced" or "Expert" level Excel usage?

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?

What's a simple way to explain data organization to people who don't use formulas very often? People on my team love creating many tabs instead of adding columns for recording the same type of data...

Anyone have suggestions on where to start learning how to program add-ins with office.js?

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

How can I add names/a legend to this chart? After I add names, I will want to distinguish between two types of companies via color (eg, old companies vs new). Any ideas? On a Mac if that matters

PowerQuery > PowerBI .. thoughts ?

What are your top Excel ninja tricks? Ones that few people know...

Top 3 most useful VBA macro codes you use everyday? Would you mind sharing the VBA code or a link showing the code? I’ll start (cont.)

Why don't recent grads know how to use excel?