Can I make formulas auto-update as I add/update data in my spreadsheet? Right now, the only way I can make it update is by clicking into the cell and pressing enter.

Hey HAVAS, how's it going?

KPMG Recruiters are the most unprofessional of the Big Four.

Change my mind.

Any 🐠 here follow the r/formuladank subreddit , I just joined and oh my gosh its hilarious. I laughed so much on all the meme’s they post in there

At what point in your career would you consider moving from consulting to industry? Looking at the sustainability strategy side of things

I joined an agency about 2 months ago and every single day I get more responsibilities, to the point that I don't even know what my actual job title is. I'm frustrated, to say the least.

Can anyone share their experience on mettl test in brillio. Regarding setup, questions and everything.

Cleared technical rounds in 2 companies but didnt got offer because of 90 days notice period. Feeling sad 🙁

Any interview experience at paytm and PayU for data science role

Recommendations on the best podcast, book, or other medium to learn more about “entrepreneurship through acquisition”?

What are some natural ways to increase progesterone? I see things online but want to know what actually worked.

Hi,

What is the salary range of a Technical Writer with 5.6 years of experience?

Thanks in advance.

Has anyone gone through Pathrise? What was your experience?

I closed on a new build a few weeks ago and now the same home is available for much less with the builder offering all appliances, additional credits, and buy down of the rate. Is there anything I can do to get now? It seems unfair that I paid more and didn't get the incentives.

Spouse made reservations for my birthday at n/Naka that will probably be cancelled due to the LA County news about extending stay-at-home 😭😷

Looking for a FA preferably a CFP to join our team in Columbus Ohio.

I joined pwc sdc bangalore as a fresher right after my college (my very first job). I was scrolling the bowl, I noticed a lot of people switching jobs from different companies to pwc. Is that even I would encounter some day, or I should stick in here and grow smoothly.Don't get me wrong,I'm trying to align myself.I asked my one year seniors from college, they told people struggle to reach big4.Y u even asking this.. Please pardon me if I sound stupid.Please guide me as ur younger brother, how should I proceed. Please.

I have a principal with ZERO sped experience or knowledge observing and rating me. I got all distinguished last year from my AP. He gave me all basics & 2 unsat. He’s told us to not worry about goals

For the foodies out there, post pics of your creations during quarantine! :)

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

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)

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

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.

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

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

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

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?

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

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

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

How do I compare two sheets to make sure they are identical?

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.

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

Still don't have xlookup. #fomo

Would anyone be willing to teach me vlookup?