{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/4d3869c56adf45e198a144f400fd25b7\" frameborder=\"0\" width=\"1920\" height=\"1440\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1440,"width":1920,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1440,"thumbnail_width":1920,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/4d3869c56adf45e198a144f400fd25b7-00001.gif","duration":188.02,"title":"1. Excel and Sheets Settings","description":"In this video, I provide important tips to avoid errors while modeling in Sheets and Excel. I explain a quirky behavior where the settings sometimes default, and I show you how to ensure your options are set correctly. I demonstrate the steps for both Google Sheets and Excel, including enabling iterative calculation and setting maximum iterations and thresholds. By following these instructions, you can prevent issues like formulas not updating or calculations getting stuck. Make sure to watch the video for a smooth modeling experience."}