12 Tricks you absolutely MUST KNOW if you create FORMULAS in EXCEL.
👩💻 👇 BE PART OF THE NEW GENERATION OF EXCEL EXPERTS
Register now and secure exclusive benefits:
👊🤓 https://smartprosoluciones.com/
________________________________
12 Tricks/Tips You MUST Know if You Create Formulas in Excel 😁, which I imagine your answer is Yes 😅.
Tell me, which of these TIPS did you not know? 😁
00:00 INTRO
00:15 TIP #1: Organize the Formula into Parts
02:21 TIP #2: Use the [TAB] key to quickly type the Function name.
03:07 TIP #3: Write a formula in a cell WITHOUT COVERING other cells while typing.
04:38 TIP #4: Before deleting a cell, check if it has other cells that depend on it.
07:29 TIP #5: Quickly identify where the error is in a formula.
08:34 TIP #6: Identify the different arguments of the function you wrote.
09:54 TIP #7: Evaluate or test only a part of the formula.
10:53 TIP #8: Lock/fix the movement of a reference.
12:35 TIP #9: Fix/restricte the movement of a reference to a column or row.
14:52 TIP #10: Fix/restricte the movement of a range to a column or row.
17:03 TIP #11: Assign names to recurring cells.
19:32 TIP #12: Access the help manual for the function you're using.
Did you like it? Support me with a LIKE 👍.
Want a Summary? Don't have much time? See a summary here:
https://smartprosoluciones.com/12-tru...
_________________________________________________________________
LET'S STAY CONNECTED! 😁:
Instagram and Facebook: @SMARTpro Academy
► Instagram: / smartproacademy
► Facebook: / smartproacademy
_________________________________________________________________
Would you like to know your current Excel skill level? Take our free test:
https://maraton.smartprosoluciones.co...
_________________________________________________________________
Want to take your Excel skills to the next level and stand out from the crowd of professionals? Great news! You have the option to take our live online courses or in-person courses in Panama. Visit our website for more information.
https://www.smartprosoluciones.com/cu...
-----------------------------------------------------------------------
💡💻 Get the Microsoft 365 version of Excel:
https://click.linksynergy.com/fs-bin/...
🎥💻 I use this program to produce and edit my videos: https://techsmith.z6rjha.net/c/273772...