How often do you use dynamic arrays? I’ve created a couple reports using them which summarize csv data into a nicer format, but everyone else who uses the workbook freaks out about them.

Hi Fishes,

Greetings for the day.

I am jobless from the past 7 months due to the recission. Need help. I am having 13 Years of experience into Internal audit, Internal Controls, SOX Compliance, Financial Risk, Risk Assessment, Risk Management, IT and Operational Risk Management. Kindly do refer me in case of any openings in your organization. I am open for Delhi NCR, Gurgaon, Pune and Bangalore location.

Is it true that people joining for Oracle practice at PWC AC Bangalore are on bench due to shortage of projects right now ?

Starting a new job at Applied Materials on Monday as a Manufacturing Engineer III. I’ve been out of college for 5 years and all of my work experience till now has been in R&D for start ups and small businesses . So not only is this a new experience for me going into such a large company but also a industry (semiconductors). Does anybody has tips or advices on what I should expect as a new hire and how I can set myself up for success? Thanks!

I thought I really wanted to be a chemical engineer but the reality of the day to day has been disappointing to say the least… is this a common sentiment for a first job? Do I just have to keep going to get somewhere interesting?

Hi everybody! 😊
I've been working as a Junior Analog Design Engineer for a year and half.
I received a proposal for a Senior Analog Designer role from Bosch in the same city where I am currently working.
Should I wait and build up a few more years of experience before accepting a Senior role or should I jump in and work to fill the gap?
Next year, there will be an important deadline for the project I'm working on and my resignation could be critical for the team, how would you deal with it?

Good recommendations for physical therapists in the area?

Curious to hear from the community, what is the best sales approach for enteprise? MEDDICC, MEDDPICC, Challenger Sale, Command of the message etc. Also, what approach do the major tech companies train their sales team on?

What's the longest vacation you've taken and where did you go? Thinking about capitalizing on my unlimited PTO and want some ideas.

Someone talk to me about Isobar and/or IA Collaborative. 👍👎❓

Anyone heard of Projective groups? Interested in finding out more about the firm.

Has anyone had their LCA location updated so they can work from a different remote work location than their home office city? Did your firm take care of the process for you?

Have you ever joined a firm purely based on how many POC would be in your practice area?

Can OSSI employee work from any Oracle office in India?

Guys for sap basis with2 yoe is there no openings

Need referrel pls help

I had this one night thing with a tourist from Brazil. I felt that he is my soulmate and I would marry this guy. He’s leaving the country tomorrow. I guess this is life haha.

Does anyone here work in the Middle East? I am seeking opportunities in the healthcare consulting space and would appreciate any leads.

Does anyone know if we get Verizon or Apple discounts through Accenture? If so, where do I find more info? Buying a new phone at the moment

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..

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”

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

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.

Would anyone be willing to teach me vlookup?

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.

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 😭

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

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!

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

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

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

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

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)