Excel For Fresher In Tamil

Sdílet
Vložit
  • čas přidán 12. 09. 2024
  • Welcome to Excel Guru Tamil! In this ultimate Excel tutorial for freshers, we cover everything you need to know to master Excel from beginner to advanced level in one video. This comprehensive guide is perfect for anyone looking to improve their Excel skills for personal or professional use.
    Excel Shortcut and Supportive Doc Download : drive.google.c...
    Excel Startup Screen: Understanding the Excel startup interface 1:43
    Excel Interface: Detailed explanation of Toolbar, Ribbon, 5:34
    Excel Ribbon: How to add Tabs, Groups, and Commands 7:04
    Excel Interface : Sheet, Name Box, Formula Bar, Other options 10:12
    Excel Shortcut Keys: Essential shortcuts to boost productivity 18:30
    Excel Table Creation: Creating and formatting tables in Excel 22:52
    Excel Pivot Table: How to create and use pivot tables 27:03
    Excel Formula Syntax: Basics of writing formulas in Excel 35:40
    Relative, Absolute, Mixed Range: Understanding different types of cell references 37:43
    Match, Count, Max, Min Formula: Using basic formulas for data analysis 44:42
    If, Iferror, Ifna Formula: Conditional formulas for advanced data handling 53:18
    Lookup Formula: Mastering Vlookup and Hlookup for data retrieval 58:58
    Sum, Sumif, Sumifs Formula: Summing data with conditions 1:03:44
    Text Functions: Using Trim, Upper, Lower, Proper, Concatenate, Substitute, Len, Left, Right, Mid 1:07:56
    Excel Chart Creation: Creating various types of charts for data visualization 1:17:30
    Print Page Setup: Setting up your worksheet for printing 1:21:41
    Conclusion: Summary of key points and further learning tips 1:25:15
    This video is your one-stop solution to becoming proficient in Excel. Whether you're a complete beginner or looking to brush up on advanced techniques, this tutorial has got you covered.
    Dynamic Vlookup Formula: • Dynamic VLOOKUP Formul...
    Lookup Function: • Excel Lookup Functions...
    All Text Functions : • Master All Text Functi...
    If you find this video helpful, please like, comment, and subscribe to Excel Guru Tamil for more Excel tutorials and tips.
    Follow us for more Excel tips and tricks:
    Instagram: / excel_guru_tamil
    Twitter: / excelgurutamil
    Facebook: / sritechtalk
    #ExcelTips #ExcelTutorial #ExcelGuruTamil #ExcelForBeginners #AdvancedExcel #ExcelSkills #ProductivityHacks #MicrosoftExcel #SpreadsheetTips #ExcelShortcuts #DataAnalysis #ExcelCharts #ExcelFormulas

Komentáře • 11

  • @m.duraipandithenmozhi8162

    Respected sir Vanakkam,Thanks.
    Please give a demo video on how to make billing software...
    Please give sir.

    • @ExcelGuruTamil
      @ExcelGuruTamil  Před 27 dny

      Thank you! Please check this video sir....czcams.com/video/LQ6GVn1R_JY/video.html

  • @AntonyAmbrose-qd3lz
    @AntonyAmbrose-qd3lz Před měsícem +1

    Good 👍

  • @m.duraipandithenmozhi8162

    Nalla Explains Sir,Vanakkam
    Your Channel subscriber M.Duraipandi(male)
    Senior Learner Citizen.

  • @safron8004
    @safron8004 Před měsícem +1

    Bro filer formula excel 2007 la illa atha eppati use panrathu
    My req : Set of staff name & Work day schedule output day wise like Tuesday working staff details

    • @ExcelGuruTamil
      @ExcelGuruTamil  Před měsícem +1

      Excel advanced version ila apdina ....Google spreadsheet use pannunga bro romba effective ah irukum and filter formula va free ah use pannalam

    • @safron8004
      @safron8004 Před měsícem

      @@ExcelGuruTamil thanks bro

  • @garivalagan8456
    @garivalagan8456 Před 20 dny

    ப்ரோ.. எண் கடைக்கு excel ஸ்டக். பில்லிங்.. சாப்ட்வேர் வேணும் ப்ரோ...