10 benefits of Excel Formula Tooltips - Function Argument ScreenTips |

Learn the powerful uses of formula tooltips in #excel.
#formulas are easy to type and troubleshoot using these function screentips or tooltips.
Contents 📚
00:08 - [01] - Learn what the function does
00:31 - [02] - Function Parameters
00:50 - [03] - Optional parameters
00:55 - [04] - Repeat parameter
01:06 - [05] - Current Parameter
01:31 - [06] - Function Help
02:15 - [07] - Parameter Hyperlinks
03:13 - [08] - View selection results
03:57 - [09] - Insert selected formula result (F9)
04:51 - [10] - Move the tooltip
Related videos 📺
Amount to Words Excel Macro for India - 16 parameter Function - • Amount to Words Excel ...
Three must have add-ins for Excel - • Three must have add-in...
4 ways to open multiple Excel files instantly - • 4 ways to open multipl...
Scanned PDF or picture to Excel data - • Scanned PDF or picture...
Buy Dr Nitin's latest book
-----------------------------------------
Efficiency Best Practices for Microsoft 365
130 best practices everyone must know
Work Smarter, Grow Faster
s.efficiency36...
Dr Nitin Paranjape is the pioneer in maximizing work efficiency in a modern work scenario.
Dr Nitin's Office Masterclass
----------------------------------------------
hi.switchy.io/mms
Online Courses by Dr Nitin Paranjape
--------------------------------------------------------------
Pivot Table Advanced - s.efficiency36...
Excel to Power BI - swiy.io/uxlpbi
Learn more from 1000+ blog articles by Dr Nitin Paranjape
Efficiency 365 blog: efficiency365....
LinkedIn : / nitinparanjape
Twitter : / drnitinp
Production
--------------------
Music and Effects: elements.envat...
Created using Adobe Premiere: www.adobe.com/...
AI based captions: videoindexer.ai (Microsoft service)

[@ajaym2016]

Excellent tip and useful info. Hidden gems given some serious forethought.

[@efficiency365]

Thanks @ajaym2016
Check out my popular Excel videos
How to enter and edit Excel Formulas - Back to Basics - ua-cam.com/video/rtDlORLmjlE/v-deo.html
Excel Green Marks - Error Checking - Best Practices - ua-cam.com/video/XeLtlzd9lRY/v-deo.html
Excel Best Practices - Part 1 of 3 - Data Management - ua-cam.com/video/rr_1ha6g6lc/v-deo.html
Excel Best Practices - Part 2 of 3 - Formulas - ua-cam.com/video/kz_zAvMINAk/v-deo.html
Excel Best Practices - Part 3 of 3 - Analytics - ua-cam.com/video/JNR5yx_Pg4A/v-deo.html
10 Excel Settings You Must CHANGE! - ua-cam.com/video/vXrrXdKyJFk/v-deo.html
Automatic data clean up with Excel Flash Fill - ua-cam.com/video/N3p_x_lXT_c/v-deo.html
Instant Excel Audit, Comparison and Analysis - Inquire - ua-cam.com/video/cDdvUZxOUis/v-deo.html
Six powerful Excel Navigation Shortcuts - ua-cam.com/video/bR-yMbGPq50/v-deo.html
Handle millions of rows in Excel - Slow to fast - ua-cam.com/video/93h7rRsLF7Y/v-deo.html
Convert crosstab to tabular - Unpivot - Excel Power Query - ua-cam.com/video/mTtOtZH-nNM/v-deo.html
Cheers.
Doc

[@canirmalchoudhary8173]

All are nice feature.

[@efficiency365]

Simple things. Experienced Excel users will know these things.
But it is important to teach this from the beginning... to avoid mistakes and trial and error.