Excel Best Practices - Part 2 of 3 - Formulas - 2023

Understand how to learn and use relevant functions and manage formulas in Excel. #msexcel #excel #exceltips Content 🔖 00:00 - Intro 00:15 - Which functions do you need? 01:51 - How to learn a function? 03:33 - Edit formula in cells 03:51 - Selecting parameters the right way 05:08 - DO NOT hardcode values 06:19 - Use Styles to format formulas 07:09 - Use Formulatext function 07:16 - Managing Linked files 08:42 - Use Inquire for audit and links 10:12 - Incorporate new functions 11:46 - DAX functions 12:47 - Trace dependents 14:21 - Run formulas step by step 16:06 - Use Watch Window 17:12 - Error Checking - Green Marks 19:47 - Always use tables Buy Dr Nitin's latest book ----------------------------------------- Efficiency Best Practices for Microsoft 365 130 best practices everyone must know Work Smarter, Grow Faster https://s.efficiency365.com/bk Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario. Dr Nitin's Office Masterclass ---------------------------------------------- https://hi.switchy.io/mms Online Courses by Dr Nitin Paranjape -------------------------------------------------------------- Pivot Table Advanced - https://s.efficiency365.com/ptyt Excel to Power BI - https://swiy.io/uxlpbi Learn more from 1000+ blog articles by Dr Nitin Paranjape Efficiency 365 blog: https://efficiency365.com/blog LinkedIn :   / nitinparanjape   Twitter :   / drnitinp   Production -------------------- Music and Effects: https://elements.envato.com/ Created using Adobe Premiere: https://www.adobe.com/in/creativeclou... AI based captions: https://videoindexer.ai (Microsoft service)