Related Posts
Pretty sure everyone knows I’m stoned rn
Guys there’s this boot camp that I came across that trains people to get jobs in Top consulting firms and has a fee plan wherein you pay once you get placed. I just wanted to know if someone here has any experience with this ?
https://docs.google.com/spreadsheets/d/e/2PACX-1vQuKa3k-rG3emxJcfbidCjC0Su85E_BKqW9cTeFZMY4xg4LnUVxOLrpcETqf7d-iEePlFh6lJ1knwwD/pubhtml
Additional Posts in Excel Genius
How useful are Macros and VBAs for tax prep?
Anyone have a good source to learn sql
Everyone: Excel is a smart app
Excel:

Would anyone be willing to teach me vlookup?
New to Fishbowl?
unlock all discussions on Fishbowl.



Under formulas, there is calculation option. There is a drop down to turn your calcs to manual. Maybe that will stop the threads
Alt m x m
Mentor
Alt f+t to open options window -> Formulas -> Set workbook calculation to “Manual”. Now, for your workbook to calc you’ll have to press F9.
Remove any formulae that use columns in that table, eg vlookups. There may be ways to optimise the formulae, eg vlookup approx match = false is very slow, or changing the structure a lot, eg using pivot tables and getpivotvalue.
Thank you everyone so it’s on manual calculation now. Does anyone know the difference between manual and automatic calculation? Like how will this affect my work or will it?
If you are sorting and filtering the data to investigate the raw data, you wouldn’t need to calculate unless you’ve changed calculation columns or any aggregating sheets