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)