How do I automate an import of data?
Everyday we get a fresh set of data in an excel file.
It has certain columns of info that we need to pull into our template, I basically do a copy paste every day. The number of rows may vary from day to day so need to make sure to grab all data from all rows.

Interviewing with EY and I accidentally referred to Deloitte in the interview 🤦🏽‍♂️

What’s ISO? Recruiter says it’s better than RSU but I’m trying to do my own research.

Hi all! Anyone know a good book on building time series big data pipelines? Particularly preprocessing and with Spark

I got an email about applying to be a summer instructor for Kode with Klossy. I'm looking to learn more about it from other teachers who have done it before?

Just wondering, how many qualified leads is your weekly quota as an Sdr/bdr?

Common annual performance review questions and answers?

Hallo, where did everyone shop for their wedding dresses in nyc (or farther out) and any tips on getting them? Any major or sample sales? Help a girl out please!

Which food delivery service is best for restaurant owners on the east coast and why?

What is the proper dress code as a realtor? I've never been the type to wear suits but I feel out of place if I don't wear them

Hi folks. It looks like there are a lot of great folks on here so thought to put a post about a referral either back to Big 4 consulting or a great industry role out of Southern CA.

11 years payer/provider exp with MBA and PMP mostly doing strategy and implementations. I am a program manager who oversees these full cycle deployments.

Seeking senior manager and up. Currently a senior program manager in consulting at Optum.

Any current or former Liberty Mutual employees? Can you give feedback about the company, pay, work/life balance, benefits, culture, management etc? Give me the good, the bad and the ugly lol. Thank you in advance!

It’s not white vs black, it’s everybody vs racists

Anyone try to sneak in a nap since WFH?

Is anyone else planning on running the Turkey Trot this year?

Anyone at Accenture able to refer?

#Hiring!
-Business Intelligence Analyst (Looker, Salesforce, Sales support)
-Senior Backend Engineer (Python, Agile Scrum)
-Senior Machine Learning Infrastructure Engineer (Infrastructure, CI/CD, Terraform)

Message me for details!

I have a client looking for a VP of Marketing & Growth. They are in the No Code Talent Marketplace Space and currently looking to raise Series A. They need a hands on leader who has experience in this space and raising Seed to Series A or Series A to Series B. IF you know anyone send them my way. We offer a 1k referral bonus for any successful full time hire!

why it feels lonely in this big city?

How can I pull the text before a certain set of characters?

Mac iWork Numbers question: is there a GPS co-ordinates function? Looking to pull location information & calculate distances between locations in the sheet.

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

Is there a way to import subscriber counts from YouTube channels and have the ability to refresh this data?

Is there a better tool than than Excel for making models? What do you use?

Just wanna say thank you to this group of beautiful people, always willing to help each other reach a solution!

Anyone have a easy formula to turn “2 years 6 months” into 2.5? Thanks!

Can anyone recommend a specific video on pivot tables?

Bit of a vague Q - but folks who do a volume of DD’s: what best practices for data cleansing & modeling do you employ? I’ve done several DD’s now and feel like a huge chunk of time is due to me re-creating the wheel / not being as smart as I could be in Excel.

If I’m creating a comp set and a row of numbers will not adjust the number of decimals no matter how many times I adjust it in the “format cells” window, what could be the reason for this and how can I get around it

Had an interesting issue this past week. Batch of client data looked normal in Excel, but when imported into our analysis software that we use for larger data sets and their manipulation (cont.)

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

What’s your Excel horror story (worst crash, worst mistake, worst there-was-a-way-to-do-this-quicker moment)? Extra points for self-shaming

Anyone work on a Mac and use parallels when in need of excel? If so, does it work or is it a big no-no? My work going forward will not primarily be excel, but I have to use it on weekly/monthly basis. Might also have to use some Power BI. Would love to go back to working on a Mac but excel has stopped me from buying one…

Hey guys, did you ever encounter the following problem & know a solution:
Whenever I reference another tab in any given formula in my model, XLS first calculates everything as it should be. However directly afterwards (or sometimes only after saving) the formula vanishes and only the resulting value is left. Hence, all automation etc in the xls does not work.

Any ideas what's happening and how I can solve it without rebuilding the whole model?

Not sure where this post belongs because I don’t think it’s an excel solution, but I want to be able to pull data from various direct datafeeds (and be able to pull in reports from say excel as well).

Once I get all the data in the same place I want to make sure all the data looks the same before I begin manipulating it (consolidating/mapping fields essentially)

What’s the right software to do this? Is it as simple as having direct feeds integrated with Access or is it something else entirely?

Hey all, for VBA what would the code be for searching for a specific value in column A and once that value is found go to the next row, do a loop that basically copies and pasted that value into Column C, the next row would then be copied and pasted in column D, then next to E, F, and G then back to C…. Until another specific value is found?

What are the top 5-10 Excel functions a consultant is expected to know?

I’ve got some lookups to do but inconsistent unique identifiers (names with Bob G01 vs Bob G1). More experienced fish, what’s the best way to perform look ups with this kind of unclean data? Got a few

Hi guys!

I need help with something: I recently started using xlookup in excel to automate recurring tasks (accounting) but I have found that my peers and supervisors have difficulties understanding how the numbers are pulled, which makes their understanding of the files difficult.

What would be the best way to convert the result of an xlookup cell to a reference to the found cell?

Is there any way that could be applied to all the xlookups in an excel file?

Thanks in advance!!