Data with Maari
Data with Maari
  • 88
  • 33 399
Consolidate in Excel in Tamil | Consolidate & Clean Multiple Excel Workbooks in One Pivot Table
🚀 How to Consolidate Data from Multiple Files in a Folder in Excel | Power Query Tutorial 🚀
Perfect for beginners and intermediate users. Watch now and make your data management more efficient!
🔔 𝐒𝐮𝐛𝐬𝐜𝐫𝐢𝐛𝐞 𝐭𝐨 𝐨𝐮𝐫 𝐜𝐡𝐚𝐧𝐧𝐞𝐥 𝐟𝐨𝐫 𝐦𝐨𝐫𝐞 𝐄𝐱𝐜𝐞𝐥 𝐭𝐮𝐭𝐨𝐫𝐢𝐚𝐥𝐬:
www.youtube.com/@UCsfjEqKtwDRDZ-D2L2uN6UA
⬇️ 𝐃𝐨𝐰𝐧𝐥𝐨𝐚𝐝 𝐭𝐡𝐞 𝐟𝐢𝐥𝐞 𝐈 𝐮𝐬𝐞𝐝 𝐢𝐧 𝐭𝐡𝐞 𝐯𝐢𝐝𝐞𝐨 𝐟𝐫𝐨𝐦 𝐡𝐞𝐫𝐞:
📌 𝐖𝐡𝐚𝐭 𝐘𝐨𝐮’𝐥𝐥 𝐋𝐞𝐚𝐫𝐧:
In this video, you’ll learn how to consolidate data from multiple Excel files stored in a single folder using Power Query. We’ll guide you through every step to quickly combine data from different files into one central workbook, perfect for managing reports, sales data, or any recurring data tasks.
✨ 𝐄𝐱𝐚𝐦𝐩𝐥𝐞 𝐒𝐲𝐧𝐭𝐚𝐱:
Power Query makes it easy! We’ll use the following simple steps:
Get Data -- From Folder
Combine and Transform Data with Power Query
Close & Load to bring data into Excel
📊 𝐖𝐡𝐲 𝐖𝐚𝐭𝐜𝐡 𝐓𝐡𝐢𝐬 𝐕𝐢𝐝𝐞𝐨?
If you work with multiple files that have the same structure and want to automate consolidation without manual copy-pasting, this video is for you! We’ll show you how to save time and keep your data up-to-date, even as you add new files.
🎓 𝐖𝐡𝐨 𝐈𝐬 𝐓𝐡𝐢𝐬 𝐅𝐨𝐫?
This tutorial is ideal for Excel beginners, data analysts, and anyone looking to automate data consolidation tasks. It’s especially useful for those in reporting roles or managing large volumes of similar data across multiple files.
📌 𝐊𝐞𝐲 𝐇𝐢𝐠𝐡𝐥𝐢𝐠𝐡𝐭𝐬:
File Setup: How to arrange files in a folder for consolidation.
Using Power Query: Steps to access, import, and transform data from multiple files.
Transformations: Filter, clean, or add new columns directly in Power Query.
Load Data to Excel: Options for loading as a Table, Pivot Table, or Pivot Chart.
Automatic Refresh: How to update data instantly when new files are added.
📢 𝐃𝐨𝐧'𝐭 𝐅𝐨𝐫𝐠𝐞𝐭 𝐭𝐨 𝐋𝐢𝐤𝐞, 𝐒𝐡𝐚𝐫𝐞, 𝐚𝐧𝐝 𝐒𝐮𝐛𝐬𝐜𝐫𝐢𝐛𝐞!
If you found this video helpful, please give it a thumbs up and share it with your friends. Subscribe to our channel for more Excel tutorials and updates!
👍 𝐋𝐢𝐤𝐞, 𝐒𝐮𝐛𝐬𝐜𝐫𝐢𝐛𝐞, 𝐚𝐧𝐝 𝐇𝐢𝐭 𝐭𝐡𝐞 𝐁𝐞𝐥𝐥 𝐈𝐜𝐨𝐧 𝐭𝐨 𝐬𝐭𝐚𝐲 𝐮𝐩𝐝𝐚𝐭𝐞𝐝 𝐰𝐢𝐭𝐡 𝐨𝐮𝐫 𝐥𝐚𝐭𝐞𝐬𝐭 𝐄𝐱𝐜𝐞𝐥 𝐭𝐮𝐭𝐨𝐫𝐢𝐚𝐥𝐬 𝐚𝐧𝐝 𝐭𝐢𝐩𝐬!
#excel #exceltutorial #excelformula #exceltutorial #tamil #exceltricks #excelfunctions #excelformulas #exceltamil #exceltips #dataanalysis
#exceltutorialtamil #endlessknowledge
Переглядів: 14

Відео

NETWORKDAYS Function in Excel in Tamil | How to Calculate Working Days in Excel & Exclude ANY Days
Переглядів 7612 годин тому
🚀 Master NETWORKDAYS in Excel | Calculate Business Days Easily! 📅 🚀 Perfect for beginners and intermediate users. Watch now and make your data management more efficient! 🔔 𝐒𝐮𝐛𝐬𝐜𝐫𝐢𝐛𝐞 𝐭𝐨 𝐨𝐮𝐫 𝐜𝐡𝐚𝐧𝐧𝐞𝐥 𝐟𝐨𝐫 𝐦𝐨𝐫𝐞 𝐄𝐱𝐜𝐞𝐥 𝐭𝐮𝐭𝐨𝐫𝐢𝐚𝐥𝐬: www.youtube.com/@UCsfjEqKtwDRDZ-D2L2uN6UA ⬇️ 𝐃𝐨𝐰𝐧𝐥𝐨𝐚𝐝 𝐭𝐡𝐞 𝐟𝐢𝐥𝐞 𝐈 𝐮𝐬𝐞𝐝 𝐢𝐧 𝐭𝐡𝐞 𝐯𝐢𝐝𝐞𝐨 𝐟𝐫𝐨𝐦 𝐡𝐞𝐫𝐞: docs.google.com/spreadsheets/d/1RQ7L9lYPpU-nT8N1ZWdx3oloSFhBDR6I/edit?usp=drive_...
VLOOKUP with MATCH Function in Excel in Tamil | How to use MATCH Formula with VLOOKUP in Excel |
Переглядів 100День тому
🚀 Master VLOOKUP with MATCH in Excel | Dynamic Lookups Made Easy 🚀 In this tutorial, learn how to supercharge your Excel skills by combining the powerful VLOOKUP and MATCH functions! With this method, you can create dynamic lookups that easily adjust when your data changes, perfect for working with multiple columns or varying lookup ranges. We’ll walk you through step-by-step with real-world ex...
Excel CONCAT Function in Tamil | Concatenate Excel Tutorial | How to use CONCAT function in Excel
Переглядів 17014 днів тому
🚀 CONCAT Function Complete Guide: Mastering Text Concatenation in Excel/Google Sheets! 🚀 Welcome to our comprehensive guide on the CONCAT function! Whether you're a beginner or looking to sharpen your skills, this video covers everything you need to know about combining text in Excel and Google Sheets. 🔔 𝐒𝐮𝐛𝐬𝐜𝐫𝐢𝐛𝐞 𝐭𝐨 𝐨𝐮𝐫 𝐜𝐡𝐚𝐧𝐧𝐞𝐥 𝐟𝐨𝐫 𝐦𝐨𝐫𝐞 𝐄𝐱𝐜𝐞𝐥 𝐭𝐮𝐭𝐨𝐫𝐢𝐚𝐥𝐬: www.youtube.com/@UCsfjEqKtwDRDZ-D2L2uN6U...
How to Add Leading Zeros in Excel in Tamil | Add a Zero In Front of a Number in Excel
Переглядів 9014 днів тому
🚀 Add Leading Zeros in Excel | Quick Guide 🚀 Perfect for beginners and intermediate users. Watch now and make your data management more efficient! 🔔 𝐒𝐮𝐛𝐬𝐜𝐫𝐢𝐛𝐞 𝐭𝐨 𝐨𝐮𝐫 𝐜𝐡𝐚𝐧𝐧𝐞𝐥 𝐟𝐨𝐫 𝐦𝐨𝐫𝐞 𝐄𝐱𝐜𝐞𝐥 𝐭𝐮𝐭𝐨𝐫𝐢𝐚𝐥𝐬: www.youtube.com/@UCsfjEqKtwDRDZ-D2L2uN6UA ⬇️ 𝐃𝐨𝐰𝐧𝐥𝐨𝐚𝐝 𝐭𝐡𝐞 𝐟𝐢𝐥𝐞 𝐈 𝐮𝐬𝐞𝐝 𝐢𝐧 𝐭𝐡𝐞 𝐯𝐢𝐝𝐞𝐨 𝐟𝐫𝐨𝐦 𝐡𝐞𝐫𝐞: docs.google.com/spreadsheets/d/1JgxR_cQx1F2AMGjp7STJ6-RT6gSuE8ya/edit?usp=drive_link&ouid=1050551339313...
Slicers in Excel in Tamil | How to Use Slicers in Excel in Tamil | Slicers in Excel Pivot Table
Переглядів 20621 день тому
🚀 Complete Guide to Slicers in Excel 🚀 Welcome to our channel! In this video, we present a Complete Guide to Slicers in Excel-a powerful feature that enhances your data analysis experience. 🔔 𝐒𝐮𝐛𝐬𝐜𝐫𝐢𝐛𝐞 𝐭𝐨 𝐨𝐮𝐫 𝐜𝐡𝐚𝐧𝐧𝐞𝐥 𝐟𝐨𝐫 𝐦𝐨𝐫𝐞 𝐄𝐱𝐜𝐞𝐥 𝐭𝐮𝐭𝐨𝐫𝐢𝐚𝐥𝐬: www.youtube.com/@UCsfjEqKtwDRDZ-D2L2uN6UA ⬇️ 𝐃𝐨𝐰𝐧𝐥𝐨𝐚𝐝 𝐭𝐡𝐞 𝐟𝐢𝐥𝐞 𝐈 𝐮𝐬𝐞𝐝 𝐢𝐧 𝐭𝐡𝐞 𝐯𝐢𝐝𝐞𝐨 𝐟𝐫𝐨𝐦 𝐡𝐞𝐫𝐞: docs.google.com/spreadsheets/d/1suA7uP07bCyWjR0CEGDo663PxJ1_...
HOW TO USE VLOOKUP ACROSS MULTIPLE SHEETS IN EXCEL IN TAMIL | VLOOKUP IN MULTIPLE SHEETS IN EXCEL
Переглядів 25721 день тому
🚀 How to Use VLOOKUP Across Multiple Sheets in Excel | Step-by-Step Guide 🚀 📊 In this video, learn how to use VLOOKUP across multiple sheets in Excel! 🚀 Whether you're working with large datasets or need to pull information from different sheets, this tutorial will show you how to easily fetch data with VLOOKUP. We’ll go through: 🔔 𝐒𝐮𝐛𝐬𝐜𝐫𝐢𝐛𝐞 𝐭𝐨 𝐨𝐮𝐫 𝐜𝐡𝐚𝐧𝐧𝐞𝐥 𝐟𝐨𝐫 𝐦𝐨𝐫𝐞 𝐄𝐱𝐜𝐞𝐥 𝐭𝐮𝐭𝐨𝐫𝐢𝐚𝐥𝐬: www.youtube....
IFS FUNCTON IN EXCEL IN TAMIL | HOW TO USE THE IFS FUNCTION IN EXCEL | IFS FUNCTION IN EXCEL
Переглядів 116Місяць тому
🚀 Excel IFS Function Complete Guide: Master Multiple Conditions 🚀 In this video, we will dive deep into the IFS function in Excel, which allows you to evaluate multiple conditions in a single formula without nesting multiple IF statements. Learn how to simplify complex decision-making logic by applying the IFS function in various real-world scenarios. Perfect for beginners and intermediate user...
WORKDAY FUNCTION IN EXCEL IN TAMIL | HOW TO USE WORKDAY FORMULA IN EXCEL | DATE FUNCTIONS IN EXCEL
Переглядів 65Місяць тому
🚀 Master the WORKDAY Function in Excel: Calculate Working Days with Ease! 🚀 In this video, we'll dive into the WORKDAY function in Excel! Learn how to quickly calculate working days, excluding weekends and holidays, between two dates. Whether you're managing project deadlines or tracking work schedules, this function can save you time and effort. 🔔 𝐒𝐮𝐛𝐬𝐜𝐫𝐢𝐛𝐞 𝐭𝐨 𝐨𝐮𝐫 𝐜𝐡𝐚𝐧𝐧𝐞𝐥 𝐟𝐨𝐫 𝐦𝐨𝐫𝐞 𝐄𝐱𝐜𝐞𝐥 𝐭𝐮𝐭𝐨𝐫𝐢...
DATEDIF FORMULA IN EXCEL IN TAMIL | DATEDIF FUNCTION EXCEL | CALCULATE DIFFERENCE BETWEEN TWO DATES
Переглядів 71Місяць тому
DATEDIF FORMULA IN EXCEL IN TAMIL | DATEDIF FUNCTION EXCEL | CALCULATE DIFFERENCE BETWEEN TWO DATES
COUNTIFS FUNCTION IN EXCEL IN TAMIL | HOW TO USE COUNTIFS FORMULA IN EXCEL IN TAMIL | #excel #learn
Переглядів 41Місяць тому
COUNTIFS FUNCTION IN EXCEL IN TAMIL | HOW TO USE COUNTIFS FORMULA IN EXCEL IN TAMIL | #excel #learn
EXCEL CONDITIONAL FORMATTING IN TAMIL | SCHOOL STUDENT MARK WITH CONDITIONAL FORMATTING IN EXCEL
Переглядів 131Місяць тому
EXCEL CONDITIONAL FORMATTING IN TAMIL | SCHOOL STUDENT MARK WITH CONDITIONAL FORMATTING IN EXCEL
Data Cleaning in Excel in Tamil | Cleaning Data in Excel in Tamil | Excel Tutorials for Beginners
Переглядів 90Місяць тому
Data Cleaning in Excel in Tamil | Cleaning Data in Excel in Tamil | Excel Tutorials for Beginners
SUMIFS FORMULA IN EXCEL IN TAMIL | HOW TO USE SUMIFS FUNCTION IN EXCEL IN TAMIL
Переглядів 66Місяць тому
SUMIFS FORMULA IN EXCEL IN TAMIL | HOW TO USE SUMIFS FUNCTION IN EXCEL IN TAMIL
MS EXCEL PIVOT TABLE IN TAMIL | HOW TO USE PIVOT TABLES IN EXCEL - A STEP-BY-STEP GUIDE IN TAMIL
Переглядів 100Місяць тому
MS EXCEL PIVOT TABLE IN TAMIL | HOW TO USE PIVOT TABLES IN EXCEL - A STEP-BY-STEP GUIDE IN TAMIL
FILTER FUNCTION IN EXCEL IN TAMIL | HOW TO USE FILTER FUNCTION IN EXCEL | EXCEL FILTER FORMULA#excel
Переглядів 632 місяці тому
FILTER FUNCTION IN EXCEL IN TAMIL | HOW TO USE FILTER FUNCTION IN EXCEL | EXCEL FILTER FORMULA#excel
EXCEL 3 TYPES OF AVERAGE FUNCTIONS IN TAMIL | EXCEL FUNCTION IN TAMIL | EXCEL FORMULAS IN TAMIL
Переглядів 692 місяці тому
EXCEL 3 TYPES OF AVERAGE FUNCTIONS IN TAMIL | EXCEL FUNCTION IN TAMIL | EXCEL FORMULAS IN TAMIL
IF AND FUNCTION IN EXCEL IN TAMIL | IF WITH AND FORMULA IN EXCEL IN TAMIL | AND FORMULA IN EXCEL
Переглядів 412 місяці тому
IF AND FUNCTION IN EXCEL IN TAMIL | IF WITH AND FORMULA IN EXCEL IN TAMIL | AND FORMULA IN EXCEL
VLOOKUP IN EXCEL IN TAMIL | HOW TO USE VLOOKUP FORMULA | HOW TO USE VLOOKUP FUNCTION IN TAMIL #excel
Переглядів 2292 місяці тому
VLOOKUP IN EXCEL IN TAMIL | HOW TO USE VLOOKUP FORMULA | HOW TO USE VLOOKUP FUNCTION IN TAMIL #excel
INDEX & MATCH FUNCTION IN EXCEL IN TAMIL | HOW TO USE INDEX & MATCH EXCEL FORMULA IN EXCEL IN TAMIL
Переглядів 1342 місяці тому
INDEX & MATCH FUNCTION IN EXCEL IN TAMIL | HOW TO USE INDEX & MATCH EXCEL FORMULA IN EXCEL IN TAMIL
HOW TO CREATE SEARCH BOX IN EXCEL IN TAMIL | SEARCH BAR IN EXCEL TO FIND ANYTHING | #excel #tamil
Переглядів 1032 місяці тому
HOW TO CREATE SEARCH BOX IN EXCEL IN TAMIL | SEARCH BAR IN EXCEL TO FIND ANYTHING | #excel #tamil
TEXT FUNCTIONS IN EXCEL IN TAMIL | EXCEL FUNCTION IN TAMIL | EXCEL FORMULAS IN TAMIL #learn #excel
Переглядів 452 місяці тому
TEXT FUNCTIONS IN EXCEL IN TAMIL | EXCEL FUNCTION IN TAMIL | EXCEL FORMULAS IN TAMIL #learn #excel
EXCEL 4 TYPES OF COUNT FUNCTION IN TAMIL | EXCEL FUNCTION IN TAMIL | EXCEL FORMULAS IN TAMIL| #excel
Переглядів 792 місяці тому
EXCEL 4 TYPES OF COUNT FUNCTION IN TAMIL | EXCEL FUNCTION IN TAMIL | EXCEL FORMULAS IN TAMIL| #excel
Excel Conditional formatting in Tamil | Excel Tutorials for Beginners | Highlight Cells Rules #excel
Переглядів 922 місяці тому
Excel Conditional formatting in Tamil | Excel Tutorials for Beginners | Highlight Cells Rules #excel
EXCEL 4 TYPES OF SUM FUNCTIONS IN TAMIL | EXCEL FUNCTION IN TAMIL | EXCEL FORMULAS IN TAMIL| #excel
Переглядів 7052 місяці тому
EXCEL 4 TYPES OF SUM FUNCTIONS IN TAMIL | EXCEL FUNCTION IN TAMIL | EXCEL FORMULAS IN TAMIL| #excel
EXCEL IF CONDITION IN TAMIL | IF FUNCTION IN EXCEL | IF FORMULA IN EXCEL WITH MULTIPLE CONDITIONS
Переглядів 5502 місяці тому
EXCEL IF CONDITION IN TAMIL | IF FUNCTION IN EXCEL | IF FORMULA IN EXCEL WITH MULTIPLE CONDITIONS
EXCEL BASIC FUNCTIONS IN TAMIL | EXCEL BASIC FORMULAS IN TAMIL | EXCEL FOR BEGINNERS IN TAMIL
Переглядів 1852 місяці тому
EXCEL BASIC FUNCTIONS IN TAMIL | EXCEL BASIC FORMULAS IN TAMIL | EXCEL FOR BEGINNERS IN TAMIL
EXCEL TERMINOLOGY IN TAMIL | BASICS CONCEPTS IN TAMIL | EXCEL TERMINOLOGY INTRODUCTION IN TAMIL
Переглядів 1702 місяці тому
EXCEL TERMINOLOGY IN TAMIL | BASICS CONCEPTS IN TAMIL | EXCEL TERMINOLOGY INTRODUCTION IN TAMIL
நம்ப ஏன் Excel கண்டிப்பா தெரிஞ்சிகணும் (WHY LEARN EXCEL IN TAMIL) 10 REASONS IN TAMIL தமிழில்
Переглядів 2423 місяці тому
நம்ப ஏன் Excel கண்டிப்பா தெரிஞ்சிகணும் (WHY LEARN EXCEL IN TAMIL) 10 REASONS IN TAMIL தமிழில்
EXCEL INTRODUCTION IN TAMIL | EXCEL BASICS FOR BEGINNERS | EXCEL TUTORIAL FOR BIGINNERS IN TAMIL
Переглядів 1713 місяці тому
EXCEL INTRODUCTION IN TAMIL | EXCEL BASICS FOR BEGINNERS | EXCEL TUTORIAL FOR BIGINNERS IN TAMIL

КОМЕНТАРІ

  • @rajivsivalingam5266
    @rajivsivalingam5266 16 днів тому

    Make video how to create dashboard with vba

  • @AyizuuEditzz
    @AyizuuEditzz 20 днів тому

    Eppadi bro excel free ahh download pannurathu

    • @DatawithMaari
      @DatawithMaari 20 днів тому

      Share your mail id bro, I'll guide you.

  • @AyizuuEditzz
    @AyizuuEditzz 20 днів тому

    Broo plz help bro

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

    Super bro keep it up 👍

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

    Week 🤔

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

      Hi, please refer below 👇 mentioned link ua-cam.com/users/shortsLfuSRgthvok?si=bJjngI-Oo99XnD_4

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

    Hii sir, Enakku oru nabar vaaram orumurai amount katti bill vaanguvaaru, antha bill number ovvorumuraiyum vera vera sir, one year ku avar kattina bill number aah line aaah entry pottal athu ethachum double entry, athavathu same bill number two time vanthurukka entru check panna ethavathu easy vali eruka niraya bill

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

    Aiya oru cell la lengthy text with numbers iruku, enaku athula last ah irukura 2 text with numbers mattum filter pannanum, panna mudiyuma

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

      Yes, we do. I'll share the answer.

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

      I have text in cell like A1 cell ("Datawithmaari81234567890") To extract the last two text characters and all numbers from the string in cell A1, FORMULA =RIGHT(TEXTJOIN("", TRUE, IF(ISERR(VALUE(MID(A1, ROW(INDIRECT("1:" & LEN(A1))), 1))), MID(A1, ROW(INDIRECT("1:" & LEN(A1))), 1), "")), 2) & TEXTJOIN("", TRUE, IF(ISNUMBER(VALUE(MID(A1, ROW(INDIRECT("1:" & LEN(A1))), 1))), MID(A1, ROW(INDIRECT("1:" & LEN(A1))), 1), "")) Output is ri81234567890

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

    Ctrl+h.

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

      Yes, This another option or Method.

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

    Amazing... you are making our life at office so simple❤

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

      @@dofikutti Thanks for your valuable feedback ❤️.

  • @VijayVijay-ju7hq
    @VijayVijay-ju7hq 2 місяці тому

    Bro your class really but please when you teach any topic close-up or you do zoom

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

      @@VijayVijay-ju7hq Sure Broo. Upcoming videos I'll do zoom in zoom out