itzmedinesh
itzmedinesh
  • 97
  • 237 186
Google Sheets Hyperlink: Everything You Need to Know in 2024
Hyperlinks in spreadsheets provide a convenient way to navigate between different sheets within the workbook, external documents, websites, or specific locations within the same document. In this video I explained some of the hyperlink types useful in the workplace.
==========================================================
Google Sheets for Beginners Playlist ⬇
▶️ ua-cam.com/play/PLUOkGMnKZ-08G9_ahZAAF9VcPEW-67CEo.html
==========================================================
Query Functions in Google Sheets Playlist ⬇
▶️ ua-cam.com/play/PLUOkGMnKZ-08Sn-FdUya2KOoD37aMO0MS.html
==========================================================
Google Apps Script Playlist ⬇
▶️ ua-cam.com/play/PLUOkGMnKZ-0-CVUx5x0mt05M7PeikxLhz.html
==========================================================
Google Forms - Tutorial for Beginners in Tamil⬇
▶️ ua-cam.com/video/19OvuMDg41o/v-deo.html
==========================================================
Google Drive - Tutorials for Beginners in Tamil⬇
▶️ ua-cam.com/play/PLUOkGMnKZ-0-igwozROvRCdNW0aaRM7D1.html
==========================================================
Data Validation Tutorial ⬇
▶️ ua-cam.com/video/WipyNumlOtw/v-deo.html
How to use Conditional Formatting in Google Sheet⬇
▶️ ua-cam.com/video/jwxpodB0-XE/v-deo.html
Sum Vs SumIFS Function Tutorial ⬇
▶️ ua-cam.com/video/cfuTTOyV0Kg/v-deo.html
Count Vs CountIFS Function Tutorial ⬇
▶️ ua-cam.com/video/NaI_uIx71SU/v-deo.html
Google Sheets - Highlight Duplicate Data in a Column or Row ⬇
▶️ ua-cam.com/video/PbPLkz38zfE/v-deo.html
How to Use VLOOKUP in Google Sheets in Tamil ⬇
▶️ ua-cam.com/video/YcNqeRXTWiU/v-deo.html
How to VLOOKUP from multiple Spreadsheet in Google Sheets in Tamil ⬇
▶️ ua-cam.com/video/mG8Twj3xM2w/v-deo.html
Named Ranges in Google Sheets in Tamil ⬇
▶️ ua-cam.com/video/sfoDEZzEAws/v-deo.html
How to Use Pivot Tables in Google Sheets in Tamil ⬇
▶️ ua-cam.com/video/OW8p9ErAhgM/v-deo.html
INDIRECT Function in Google Sheets and Excel in Tamil ⬇
▶️ ua-cam.com/video/y49W4bHWPSw/v-deo.html
How to use Google Drive - Tutorial for Beginners in Tamil | Part 1| ⬇
▶️ ua-cam.com/video/zgyc3yRRW1Q/v-deo.html
How to use ARRAYFORMULA function in Google Sheets in Tamil⬇
▶️ ua-cam.com/video/AFUZ7__PFi8/v-deo.html
How to Use Calculated Field in Pivot Tables in Google Sheets in Tamil ⬇
▶️ ua-cam.com/video/EavprRsUBZ0/v-deo.html
==========================================================
#hyperlinks #googlesheetstutorial #googlesheetstips
==========================================================
Переглядів: 295

Відео

How to calculate a weighted average in Google Sheets in Tamil
Переглядів 1659 місяців тому
The AVERAGE.WEIGHTED function finds the weighted average of a set of values, given the values and the corresponding weights. Google Sheets for Beginners Playlist ⬇ ▶️ ua-cam.com/play/PLUOkGMnKZ-08G9_ahZAAF9VcPEW-67CEo.html Query Functions in Google Sheets Playlist ⬇ ▶️ ua-cam.com/play/PLUOkGMnKZ-08Sn-FdUya2KOoD37aMO0MS.html Google Apps Script Playlist ⬇ ▶️ ua-cam.com/play/PLUOkGMnKZ-0-CVUx5x0mt...
7 Spreadsheet Formulas Working Professionals Should Know! | Tamil
Переглядів 39211 місяців тому
Learn 7 productivity tips in your Google Sheets which will improve your productivity in the workplace that too in Tamil. How to create Dropdown Multi-color Chips in Google Sheets in Tamil ua-cam.com/video/ltRdD2nub5w/v-deo.html Google Docs - Productivity Tips for Working with Tables ua-cam.com/video/BDypNF2u_Yo/v-deo.html Top 5 Google Docs New Features in Tamil | Productivity at work| ua-cam.co...
Age Calculation, Years of Service Formula in Google Sheets | Tamil
Переглядів 401Рік тому
Age Calculation, Years of Service Formula in Google Sheets in Tamil. In this video tutorial we'll cover how to calculate age from date of birth as of today using various formulas in Google Sheets, then we'll calculate years of service from hire date or simply between two dates, then we'll expand the formula by adding months or days in addition to years. DATEDIF Calculates the number of days, mo...
Find which cells contain FORMULA in Google Sheets in Tamil
Переглядів 367Рік тому
Find cells which contain FORMULA in Google Sheets in Tamil Google Sheets for Beginners Playlist ⬇ ▶️ ua-cam.com/play/PLUOkGMnKZ-08G9_ahZAAF9VcPEW-67CEo.html Query Functions in Google Sheets Playlist ⬇ ▶️ ua-cam.com/play/PLUOkGMnKZ-08Sn-FdUya2KOoD37aMO0MS.html Google Apps Script Playlist ⬇ ▶️ ua-cam.com/play/PLUOkGMnKZ-0-CVUx5x0mt05M7PeikxLhz.html Google Forms - Tutorial for Beginners in Tamil⬇ ...
Insert smart chips in your Google Sheets in Tamil
Переглядів 602Рік тому
Learn how to Insert smart chips in your Google Sheets in Tamil. How to create Dropdown Multi-color Chips in Google Sheets in Tamil ua-cam.com/video/ltRdD2nub5w/v-deo.html Google Docs - Productivity Tips for Working with Tables ua-cam.com/video/BDypNF2u_Yo/v-deo.html Top 5 Google Docs New Features in Tamil | Productivity at work| ua-cam.com/video/H8vkz-TCnRM/v-deo.html Google Sheets for Beginner...
How to create Dropdown Multi-color Chips in Google Sheets in Tamil
Переглядів 571Рік тому
Learn New Feature called chip in googlesheets with dropdownlist with #multicolor . Google Sheets for Beginners Playlist ⬇ ▶️ ua-cam.com/play/PLUOkGMnKZ-08G9_ahZAAF9VcPEW-67CEo.html Query Functions in Google Sheets Playlist ⬇ ▶️ ua-cam.com/play/PLUOkGMnKZ-08Sn-FdUya2KOoD37aMO0MS.html Google Apps Script Playlist ⬇ ▶️ ua-cam.com/play/PLUOkGMnKZ-0-CVUx5x0mt05M7PeikxLhz.html Google Forms - Tutorial ...
Create an Mobile App for free from Google Sheets using AppSheet | No Code | Tamil
Переглядів 15 тис.2 роки тому
Create an Mobile App for free from Google Sheets using AppSheet | No Code | Tamil
Google Docs - Productivity Tips for Working with Tables
Переглядів 3842 роки тому
Google Docs - Productivity Tips for Working with Tables
Top 5 Google Docs New Features in Tamil | Productivity at work|
Переглядів 5852 роки тому
Top 5 Google Docs New Features in Tamil | Productivity at work|
Moving Files to a Specific Google Drive Folder using Google Apps Script
Переглядів 3,7 тис.2 роки тому
Moving Files to a Specific Google Drive Folder using Google Apps Script
Export a list of your file details from Google Drive into Google Sheets using Apps Script in Tamil
Переглядів 6492 роки тому
Export a list of your file details from Google Drive into Google Sheets using Apps Script in Tamil
Google Sheets Apps Script Tutorial - Clear Contents( )
Переглядів 6272 роки тому
Google Sheets Apps Script Tutorial - Clear Contents( )
How to create Custom Functions in Google Sheets | Apps Script in Tamil
Переглядів 1,2 тис.2 роки тому
How to create Custom Functions in Google Sheets | Apps Script in Tamil
Delete Blank Rows without Apps Script in Google Sheets in Tamil
Переглядів 6172 роки тому
Delete Blank Rows without Apps Script in Google Sheets in Tamil
How to return true blanks cell from IF, VLOOKUP, IFERROR functions in Google Sheets in Tamil
Переглядів 4422 роки тому
How to return true blanks cell from IF, VLOOKUP, IFERROR functions in Google Sheets in Tamil
How to Find Day of the Week in Text using Dates in Google Sheets
Переглядів 3272 роки тому
How to Find Day of the Week in Text using Dates in Google Sheets
How to calculate Business Working Days in Google Sheets
Переглядів 1,4 тис.2 роки тому
How to calculate Business Working Days in Google Sheets
Running Total in Pivot Table in Google Sheets in Tamil
Переглядів 1 тис.2 роки тому
Running Total in Pivot Table in Google Sheets in Tamil
Google Sheets Charts / Graphs Tutorial in Tamil
Переглядів 1,2 тис.2 роки тому
Google Sheets Charts / Graphs Tutorial in Tamil
Hide or Delete Multiple Sheets Without Apps Script in Google Sheets in Tamil
Переглядів 6712 роки тому
Hide or Delete Multiple Sheets Without Apps Script in Google Sheets in Tamil
Google Sheets - Calculated Fields in Pivot Tables
Переглядів 7632 роки тому
Google Sheets - Calculated Fields in Pivot Tables
Get a UNIQUE List from Many Columns Using FLATTEN in Google Sheets
Переглядів 3902 роки тому
Get a UNIQUE List from Many Columns Using FLATTEN in Google Sheets
SUMPRODUCT, SUM IF from Other Spreadsheets - Google Sheets in Tamil
Переглядів 1,1 тис.2 роки тому
SUMPRODUCT, SUM IF from Other Spreadsheets - Google Sheets in Tamil
How to use Sparklines Function in Google Sheets in Tamil
Переглядів 3702 роки тому
How to use Sparklines Function in Google Sheets in Tamil
Build A Fully Functioning STOCK WATCHLIST With Live Data In Google Sheets in Tamil
Переглядів 1,9 тис.2 роки тому
Build A Fully Functioning STOCK WATCHLIST With Live Data In Google Sheets in Tamil
Custom Number and Currency Formatting in Google Sheets in Tamil
Переглядів 8922 роки тому
Custom Number and Currency Formatting in Google Sheets in Tamil
Google Forms - How to Apply Answer based questions in Tamil
Переглядів 5482 роки тому
Google Forms - How to Apply Answer based questions in Tamil
How to Create Form Sections in Google Forms in Tamil | Add section breaks to long forms
Переглядів 5592 роки тому
How to Create Form Sections in Google Forms in Tamil | Add section breaks to long forms
How to use Reverse VLOOKUP in Google Sheets || Right to Left VLOOKUP in Google Sheets in Tamil
Переглядів 4962 роки тому
How to use Reverse VLOOKUP in Google Sheets || Right to Left VLOOKUP in Google Sheets in Tamil

КОМЕНТАРІ

  • @T3Preethga
    @T3Preethga 8 хвилин тому

    Dear Bro, Very patiently nicely explained. This is a very difficult subject. Your efforts is highly appreciated. What is your good name and how to contact you in case of any doubts. Thanks

  • @jagannathana5805
    @jagannathana5805 5 днів тому

    Sooper

  • @accountmariyam
    @accountmariyam 9 днів тому

    THANKS SIR 😊

  • @vasanthpaul8064
    @vasanthpaul8064 22 дні тому

    Bro ithae video excel la epidi panrathu???

  • @Sathish_Kumar_S
    @Sathish_Kumar_S 28 днів тому

    Hi bro, I learnt Google script from your youtube videos, its very clear and helpful. Can you continue this series and upload more videos on Google app scripts. Especially Google app script projects ?

  • @krishnanmurga8571
    @krishnanmurga8571 29 днів тому

    Pro mobile use= purchase sales (price profit) small stock

  • @krishnanmurga8571
    @krishnanmurga8571 Місяць тому

    Full video ji

  • @MIS-s3m
    @MIS-s3m Місяць тому

    bro how to get specific cell range value with using query function for example i need first A column A12 value and balance column also

  • @shasha8251
    @shasha8251 Місяць тому

    This video is great start who ever wants to learn Google sheet

  • @MIS-s3m
    @MIS-s3m 2 місяці тому

    what is @param meaning brother

  • @414sasi
    @414sasi 2 місяці тому

    Ascending, descending order epdi panrathu nu video podunga bro

  • @azhagappansubramanian6692
    @azhagappansubramanian6692 2 місяці тому

    Sir L G Let me know How will find number of L. G brand sold out IN V LOOKUP

    • @itzmedinesh
      @itzmedinesh Місяць тому

      For that u need to use sum if or sum ifs function bro

  • @RaviShankar-do7bu
    @RaviShankar-do7bu 3 місяці тому

    if i required only 2 columns what is the procedure

    • @itzmedinesh
      @itzmedinesh Місяць тому

      That is not possible I believe

  • @jeyagovindh15
    @jeyagovindh15 3 місяці тому

    தினேஷ் அண்ணா... எனக்கு ஒரு ரிப்போர்ட் எடுக்கணும் google sheet -ல, ஒவ்வொரு நாளும் 200 வகையான பொருட்கள் வாங்குவோம், ஒரு பொருள் திரும்ப திரும்ப மற்ற நாட்களில் வாங்குவோம்,எனக்கு ஒரு பொருளின் கடைசியாக வாங்கிய விலை வருவதற்கு என்ன formula கொடுக்க. வேண்டும்... Ex.. Date Product kg amount 15 Apple 100 12 15 Lemon 20 75 16 Tomato 30 50 17 Apple 50 169 18 Tomato 25 48 19 Apple 20 135 இதில் ஆப்பிள் கடைசியாக வாங்கிய விலை வருவதற்கு என்ன formula கொடுக்க வேண்டும்.

    • @itzmedinesh
      @itzmedinesh Місяць тому

      Konjam work pannanum. Ippo Naan out of station I will think and get back to u

    • @itzmedinesh
      @itzmedinesh Місяць тому

      Use filter formula and sort by date. Check my video of filter formula

  • @Kowsikowsi-e5b
    @Kowsikowsi-e5b 3 місяці тому

    Sir filter eppadi remove panrathu... Filter potrathuku munadi namba eppadi maintain panomo appadi eppadi kondu varathu... Vara mataguthu sir...

    • @itzmedinesh
      @itzmedinesh Місяць тому

      There will be filter icon in top click on that or go to Data menu click filter and remove filter

  • @shabirmnm9755
    @shabirmnm9755 3 місяці тому

    Brother, ifs function adutha adutha rowsku apply aavuthu ok, athuve aduthadutha columns ku epadi apply panrathu?

  • @shabirmnm9755
    @shabirmnm9755 3 місяці тому

    Brother, ongada videos ellame best & very useful, Thank you so much

  • @gururaghavendran7794
    @gururaghavendran7794 3 місяці тому

    Can we create for school internal work.

  • @KVanathi
    @KVanathi 3 місяці тому

    Hi this chennal very useful

  • @ScholarshipNITT
    @ScholarshipNITT 4 місяці тому

    data is not visible

  • @techmono.....723
    @techmono.....723 4 місяці тому

    A +b

  • @techmono.....723
    @techmono.....723 4 місяці тому

    Sum function

  • @techmono.....723
    @techmono.....723 4 місяці тому

    Bro sum function a+b+c=total

  • @sivakumaarcs2319
    @sivakumaarcs2319 4 місяці тому

    commodity Tracker?

  • @Kiruthi-e5w
    @Kiruthi-e5w 4 місяці тому

    Bro Google drive ku backup necessary ahh?

  • @mohammedfarook5376
    @mohammedfarook5376 4 місяці тому

    How to Hide Formulas In Google Sheets

    • @itzmedinesh
      @itzmedinesh Місяць тому

      You cannot hide formula. Instead hide the row or column

  • @RakeshmusicschoolHosur
    @RakeshmusicschoolHosur 5 місяців тому

    Please Explain about the "Deploy "

  • @ArunKumar-qd7os
    @ArunKumar-qd7os 5 місяців тому

    ❤❤❤

  • @ArunKumar-qd7os
    @ArunKumar-qd7os 5 місяців тому

    Semma bro

  • @RakeshmusicschoolHosur
    @RakeshmusicschoolHosur 5 місяців тому

    Thanks Bro' .I'm using this formula to filter the Top five Gainers and Looser In my Portfolio /=ARRAY_CONSTRAIN(SORT({A3:D, ARRAYFORMULA(D3:D*100)},4,0),AB2,4) Top 5 Gainers Name Price Change% JCHAC Johnson Controls-Htch Ar Cndtng Ind Ltd ₹ 1,486.85 20.00% AEGISCHEM Aegis Logistics Ltd ₹ 716.85 13.77% FINCABLES Finolex Cables Ltd ₹ 1,283.75 12.21% BDL Bharat Dynamics Ord Shs ₹ 1,552.05 10.44% PARAS Paras Defence and Space Technologies Ltd ₹ 859.40 10.33%

  • @NaveenKumar-qg2vd
    @NaveenKumar-qg2vd 5 місяців тому

    Keep up the good work. I'm learning for data analytics and you have helped me a lot. Thanks a lot sir.

  • @edwinantonyraj7247
    @edwinantonyraj7247 5 місяців тому

    Thank you so much bro. Very useful

  • @vijayraguvaran2338
    @vijayraguvaran2338 5 місяців тому

    Contact details bro

  • @RakeshmusicschoolHosur
    @RakeshmusicschoolHosur 5 місяців тому

    Good job, can you please share the spread sheet template. It's very useful sir, please make a video about Google finance watch list.

  • @sivaramanvisvanathan
    @sivaramanvisvanathan 5 місяців тому

    SORRY BRO. PE MEANS PRICE EARNINGS RATIO. IT IS NOT PROFIT EARNING. PLEASE CORRECT YOURSELF.

  • @RakeshmusicschoolHosur
    @RakeshmusicschoolHosur 5 місяців тому

    This function is not working properly in Android phone, but I am able to do in the computer.please post a video for work sheet of Android phone

    • @itzmedinesh
      @itzmedinesh Місяць тому

      For mobile it would be different. I will try to make a video

  • @RakeshmusicschoolHosur
    @RakeshmusicschoolHosur 5 місяців тому

    Thanks for your support, it's very nice tips for me.

  • @chiru4565
    @chiru4565 5 місяців тому

    Bro nenga create panna script epadi download panradhu and already gmail la iruka draft epadi send panradhu

  • @kamalhugsyou
    @kamalhugsyou 5 місяців тому

    Excellent presentation

  • @CK-ef4yf
    @CK-ef4yf 6 місяців тому

    Not clear video 😮

  • @a.ram007krish
    @a.ram007krish 6 місяців тому

    thanks bro, i try already for market capital i million same like screener value but i didn't get same digit value some mismatch found ,google finance , let me know how to get screener market capital value

  • @ganeshm6053
    @ganeshm6053 7 місяців тому

    How to create monthly sheet into yearly sheet

  • @ksivadon394
    @ksivadon394 7 місяців тому

    bro i need to send certificate to whatsapp number to using apps scripts in google sheet

  • @iyappanm6288
    @iyappanm6288 8 місяців тому

    Can you upload Google sheets format

  • @rameshkathiresan6642
    @rameshkathiresan6642 8 місяців тому

    Hello sir I Need your contact number.

  • @Perumal_sathya-wv6np
    @Perumal_sathya-wv6np 8 місяців тому

    Unga content details send panna mudiuma I have doubt

  • @Perumal_sathya-wv6np
    @Perumal_sathya-wv6np 8 місяців тому

    Bro enaku webapp create pannanum