Anser's Excel Academy
Anser's Excel Academy
  • 55
  • 677 759
Discover the 1 Simple Trick to Auto-Populate Cells in Excel
In this informative video, we present a comprehensive step-by-step guide on how to auto-populate data using data validation techniques. Viewers will learn the essential methods to streamline their data entry processes, ensuring accuracy and efficiency. This tutorial is perfect for beginners and experienced users alike, providing valuable insights into optimizing spreadsheet functionality. Join us as we explore practical examples and tips to enhance your data management skills.
I hope you enjoy this video as much as I enjoyed making it. Thank you for taking the time to watch it!
#2025 #excel #exceltips #exceltutorial #msexcel #microsoftexcel #developer #DataValidation #SpreadsheetTips #AutoPopulate #ExcelTutorial #SpreadsheetSkills #datavalidationforautopopulate #ExcelBasicsTutorial #ExcelTutorialforBeginners #MicrosoftExcel #datavalidation #AnsersExcelAcademy #advancedexcel
มุมมอง: 46

วีดีโอ

Summing Across Worksheets Made Easy with This One Simple Trick
มุมมอง 19814 ชั่วโมงที่ผ่านมา
Learn how to effectively sum data across multiple worksheets in Excel, even when rows do not line up. This tutorial provides a comprehensive guide on using Excel formulas to consolidate data seamlessly. Discover solutions for common issues like when the sum across multiple sheets is not working and how to adjust formulas for inconsistent row structures. Topics include: ● Using the SUM function ...
Can You REALLY Send WhatsApp Messages from Microsoft Excel 2025?
มุมมอง 22821 ชั่วโมงที่ผ่านมา
This video tutorial will guide you through the seamless process of sending WhatsApp messages directly from your Excel sheet! Say goodbye to manual messaging tasks and hello to efficiency as we demonstrate step-by-step instructions for integrating this powerful tool into your workflow. Whether you’re a business owner, marketer, student, professional, entrepreneur, or simply an Excel enthusiast, ...
Consolidate Multiple Excel Sheets with Power Query's Append Function!
มุมมอง 11Kวันที่ผ่านมา
Learn how to consolidate multiple Excel tables quickly and efficiently using Power Query's powerful Append function! In this step-by-step tutorial, we’ll show you how to combine data from different tables into one, saving time and eliminating manual errors. Whether you're managing large datasets or just getting started with Power Query, this guide will help you master the Append feature and sim...
How to Combine Excel Files from a Folder Dynamically in Power Query!
มุมมอง 64K14 วันที่ผ่านมา
How to combine multiple Excel files into one dynamic master table using Power Query! In this step-by-step tutorial, we’ll show you how to handle unformatted tables, clean up messy data, and create a consolidated file that automatically updates whenever changes are made to the source files. Whether you're managing shipment reports or any other dataset, this guide will save you hours of manual wo...
How to Create a Budget vs Actual Chart in Excel (Step-by-Step Tutorial)
มุมมอง 7362 หลายเดือนก่อน
Learn how to create a Budget vs Actual chart in Excel with this step-by-step tutorial! This unique floating bar chart clearly highlights the difference between budgeted and actual values, making it easier to visualize performance. Perfect for tracking sales, expenses, or any financial data. Watch now and improve your Excel charting skills! LOVE this Video? Click “$ Thanks” to show your SUPPORT....
EASILY Lookup Values from Another Worksheet in Excel!
มุมมอง 8337 หลายเดือนก่อน
In this tutorial, learn how to use Excel's INDIRECT function to lookup a range in another worksheet and sum that range in your main worksheet. This powerful function allows you to dynamically reference data from different sheets, making your calculations more efficient and flexible. Watch step-by-step as we demonstrate how to implement this feature in your own Excel projects.
The BEST Way to Create a Weekly Sales Chart in Excel!
มุมมอง 15K8 หลายเดือนก่อน
Explore the creation of a Weekly Sales Chart and Dashboard in Excel to efficiently monitor your business's daily performance. This tutorial will guide you through setting up a user-friendly format for inputting sales data and creating a Consolidated Sheet for effective data analysis, or for a KPI Dashboard. Additionally, learn to design a dashboard that provides a quick overview of your sales d...
How to SUMIF Across MULTIPLE Spreadsheets in Excel!
มุมมอง 4.7K8 หลายเดือนก่อน
Check out Anser's Excel Academy's latest video where we explore how to effectively combine SUMIF and INDIRECT functions in Excel for managing dynamic ranges effortlessly. Whether you're new to Excel or an experienced user, this tutorial equips you with the skills to enhance your data analysis. By the end, you'll master creating flexible spreadsheets, saving time and boosting your data analysis ...
CONSOLIDATE Data from MULTIPLE Tables into ONE PivotTable in Excel!
มุมมอง 10K8 หลายเดือนก่อน
This video will offer a comprehensive walkthrough on establishing data relationships between multiple tables in Excel. This process involves connecting datasets based on common fields or keys, enabling seamless analysis across related tables. Additionally, the tutorial will demonstrate how to leverage Power Pivot, a powerful Excel feature, to generate pivot tables. Power Pivot extends Excel's f...
How to Compare Two Data Tables and Identify Similar Entries!
มุมมอง 11K8 หลายเดือนก่อน
In this comprehensive Excel tutorial, we delve into the intricacies of comparing two data tables to unearth similar data entries. Whether you're a seasoned Excel user or just starting out, this step-by-step guide will equip you with the skills to efficiently compare large datasets with ease. You'll learn the importance of accurately comparing data tables and utilizing Excel's powerful functions...
How to Create a Pivot Table from Multiple Sheets in Excel!
มุมมอง 2K8 หลายเดือนก่อน
Unlock the full potential of Excel with our comprehensive tutorial on creating PivotTables from multiple worksheets and workbooks. This tutorial is perfect for data engineers, business analysts, and anyone interested in business intelligence and data science. Master this skill and level up your data analysis game! Whether you're a beginner or an experienced user, this step-by-step guide will de...
Combine Files with Different Headers in Excel Power Query!
มุมมอง 3.9K9 หลายเดือนก่อน
Learn how to combine files with different headers in Excel Power Query. This tutorial will show you how to merge data even when the headers don't match perfectly. Master this skill and streamline your data processing! Combining data from various Excel files can be challenging if their table headers don't match, potentially leading to missing data issues. In this advanced Power Query tutorial, y...
Dynamic Excel Drop-Down List in Excel that Updates Automatically!
มุมมอง 6K9 หลายเดือนก่อน
In this Excel tutorial video, we'll explore the process of creating a dynamic drop-down list that updates itself seamlessly. Excel Drop Down lists offer a swift alternative for data entry, enhancing efficiency and reducing errors. Additionally, we'll uncover a fascinating feature allowing customization of colors for each option. Leveraging drop-down lists with functions like the INDIRECT functi...
Keep DATA VALIDATION Drop Down Buttons ALWAYS VISIBLE in Excel!
มุมมอง 17K9 หลายเดือนก่อน
In this tutorial, learn how to keep your excel drop-down list arrow always visible, making data validation a breeze! No Macros, VBA, or complicated setups required. We'll show you a simple method using formatting and formulas to achieve this. With our step-by-step guide, you'll master the technique to keep your drop-down list arrow visible at all times, using a Forms Combo Box Control. Whether ...
AUTOMATED Expiration Alerts with Conditional Formatting in Excel!
มุมมอง 9K9 หลายเดือนก่อน
AUTOMATED Expiration Alerts with Conditional Formatting in Excel!
Unleash the Power of Data Relationships with Power Pivot in Excel!
มุมมอง 1.4K9 หลายเดือนก่อน
Unleash the Power of Data Relationships with Power Pivot in Excel!
Excel Simplified: Effortless PDF to Excel Conversion! (In 2 Minutes)
มุมมอง 4389 หลายเดือนก่อน
Excel Simplified: Effortless PDF to Excel Conversion! (In 2 Minutes)
Combine Excel Files with Power Query - EFFORTLESS Excel Data Cleaning in Minutes!
มุมมอง 6909 หลายเดือนก่อน
Combine Excel Files with Power Query - EFFORTLESS Excel Data Cleaning in Minutes!
Excel Power Query: Revolutionize Your Data Analysis!
มุมมอง 1.6K10 หลายเดือนก่อน
Excel Power Query: Revolutionize Your Data Analysis!
How to Create Searchable Dropdown Lists in Excel | No VBA!
มุมมอง 23K10 หลายเดือนก่อน
How to Create Searchable Dropdown Lists in Excel | No VBA!
How to Create A MULTI-SELECT Drop-Down List in Excel!
มุมมอง 93K10 หลายเดือนก่อน
How to Create A MULTI-SELECT Drop-Down List in Excel!
How to SUM Dynamic Ranges in Excel with SUMIF and INDIRECT!
มุมมอง 2.8K10 หลายเดือนก่อน
How to SUM Dynamic Ranges in Excel with SUMIF and INDIRECT!
How to lookup Values Using XLOOKUP and INDIRECT!
มุมมอง 2.4K10 หลายเดือนก่อน
How to lookup Values Using XLOOKUP and INDIRECT!
Create DYNAMIC Dropdown Lists in Excel that Automatically Update!
มุมมอง 2.7K10 หลายเดือนก่อน
Create DYNAMIC Dropdown Lists in Excel that Automatically Update!
How to Use the VSTACK Formula to Combine Tables in Excel!
มุมมอง 1.9K10 หลายเดือนก่อน
How to Use the VSTACK Formula to Combine Tables in Excel!
How to Perform INDEX & MATCH with MULTIPLE Criteria in Excel!
มุมมอง 13K10 หลายเดือนก่อน
How to Perform INDEX & MATCH with MULTIPLE Criteria in Excel!
COMBINE Data from Different Workbooks! - Excel Power Query
มุมมอง 2.1K11 หลายเดือนก่อน
COMBINE Data from Different Workbooks! - Excel Power Query
Boost Your Productivity with Excel: Create Tabs Automatically!
มุมมอง 1.6K11 หลายเดือนก่อน
Boost Your Productivity with Excel: Create Tabs Automatically!
Excel Power Query: How to Perform Fuzzy Merge for Data Cleaning!
มุมมอง 2.9K11 หลายเดือนก่อน
Excel Power Query: How to Perform Fuzzy Merge for Data Cleaning!

ความคิดเห็น

  • @sk2122
    @sk2122 13 ชั่วโมงที่ผ่านมา

    This is superb. i was in assumption that this can only achieve by adding the activeX or form control in sheet

  • @sardhashakti
    @sardhashakti 16 ชั่วโมงที่ผ่านมา

    If I have to put multi- select dropdown from cell A2 to A500, the what will be the VBA code? Pls suggest

  • @annamarieretzer8449
    @annamarieretzer8449 3 วันที่ผ่านมา

    where is the code?

  • @ElectricDave719
    @ElectricDave719 3 วันที่ผ่านมา

    Is there a way to just count the number of expired variables instead of highlighting? I’m using this to try to mark how many items are unavailable for a calibration program

  • @juliebrenier7838
    @juliebrenier7838 8 วันที่ผ่านมา

    This is amazing thank you so much! I got the code to work for multi-select as well as updated code to allow for removal. Cannot figure out how to allow for more than one column. I have multiple columns with different data validation lists that need to offer multi-select. Any suggestions?

  • @jvnaveen8872
    @jvnaveen8872 8 วันที่ผ่านมา

    It worked thanks!!!

  • @TravisDeskins
    @TravisDeskins 10 วันที่ผ่านมา

    no matter what I do my file is always corrupt, its functional from the source and email, just not after power automate saves it, I have tried using the base64tobinary function as well and it still fails.

  • @suboomdeb3572
    @suboomdeb3572 10 วันที่ผ่านมา

    Just like the topic your instructions are fuzzy too

  • @arisrkive
    @arisrkive 11 วันที่ผ่านมา

    my excel doesnt have unique formula what do i do?

    • @arisrkive
      @arisrkive 11 วันที่ผ่านมา

      nevermind its okay now. thanks for this tutorial!

  • @vinodhinisharath8182
    @vinodhinisharath8182 12 วันที่ผ่านมา

    Where is the descripton box

  • @anikdasdigital
    @anikdasdigital 13 วันที่ผ่านมา

    Your videos are amazing. I really like it. I am a new subscriber to your channel. Can I talk with you Anser?

    • @anikdasdigital
      @anikdasdigital 13 วันที่ผ่านมา

      Can i talk with u plz

  • @leo_tra
    @leo_tra 15 วันที่ผ่านมา

    Great video. Practical and thorough.

    • @ExcelWithAnser
      @ExcelWithAnser 14 วันที่ผ่านมา

      Glad you liked it!

  • @BogdanFlorea-q9d
    @BogdanFlorea-q9d 20 วันที่ผ่านมา

    Thank you so much! this example actualy work!

  • @maxsegal2044
    @maxsegal2044 21 วันที่ผ่านมา

    wtf how is this a solution? It doesnt spill to adjacent cell BUT it duplicates the text if it's too short for the cell!

  • @deyannasteele1697
    @deyannasteele1697 22 วันที่ผ่านมา

    How to apply to an entire column?

    • @ExcelWithAnser
      @ExcelWithAnser 22 วันที่ผ่านมา

      Start by copying the data validation rule from the cell where the dropdown is already set up. You can do this by selecting the cell, pressing Ctrl + C, or right-clicking and choosing "Copy." Next, highlight all the rows in the column where you want the dropdown to appear. This can be done by clicking and dragging over the cells or selecting the entire column. Once highlighted, right-click and choose "Paste Special," then select "Validation" to apply the dropdown rules to all the selected cells.

  • @anastasiadewi401
    @anastasiadewi401 24 วันที่ผ่านมา

    i tried this for my google sheets, but it's not working :( could you help on this sir?

    • @ExcelWithAnser
      @ExcelWithAnser 21 วันที่ผ่านมา

      Hi there, I'm not too sure how this can be achieved in Google Sheets, but here's a resource you can check out: support.google.com/docs/thread/153136644/google-sheet-hyperlink?hl=en

  • @МихаелаПенева-с6р
    @МихаелаПенева-с6р 25 วันที่ผ่านมา

    Hi! How to insert a hiperlink in a cell consists of several sentence?

  • @sameergulamhussein9770
    @sameergulamhussein9770 25 วันที่ผ่านมา

    very helpful ! clear and well explained

  • @jpglaspie
    @jpglaspie หลายเดือนก่อน

    Great tip!!! Can you show multiple cells? Can you reference a range of cell? Doing a single cells for 300 cells repetitive seems like alot. Just started doing this so very green at this.

    • @ExcelWithAnser
      @ExcelWithAnser 22 วันที่ผ่านมา

      start by copying the data validation rule from the cell where the dropdown is already set up. You can do this by selecting the cell, pressing Ctrl + C, or right-clicking and choosing "Copy." Next, highlight all the rows in the column where you want the dropdown to appear. This can be done by clicking and dragging over the cells or selecting the entire column. Once highlighted, right-click and choose "Paste Special," then select "Validation" to apply the dropdown rules to all the selected cells.

    • @markfagan5434
      @markfagan5434 12 วันที่ผ่านมา

      @@ExcelWithAnser I tried exactly what you just described. The standard (single item select) validation copied over, but not the multi-select. Do you have further guidance for multi-select validation on a range of cells?

    • @markfagan5434
      @markfagan5434 12 วันที่ผ่านมา

      @MattiaScassellati has a solution in the comment thread below. To recap: Replace If Target.Address = "$G$2" Then With If Not Intersect (Target, Range("G1:G300")) Is Nothing Then This solultion works. The only issue is the error checking still flags if multiple selections are made. The work around would be to deselect the error checking, and do without it.

  • @travelwithuk0do
    @travelwithuk0do หลายเดือนก่อน

    Thanks, Helped

  • @ErinQin-qk5us
    @ErinQin-qk5us หลายเดือนก่อน

    Hi Sir, can we have a collaboration?

  • @YT_Praful
    @YT_Praful หลายเดือนก่อน

    Sometimes a simple search on youtube is more helpful than using ChatGPT

    • @ExcelWithAnser
      @ExcelWithAnser 22 วันที่ผ่านมา

      Agreed!

    • @YT_Praful
      @YT_Praful 21 วันที่ผ่านมา

      @@ExcelWithAnserI used this macro in a file, but later I split the file into multiple files based on the data in a specific column. After splitting, the macro stopped working in the new files. What could be the possible reason?

  • @supportive_guru
    @supportive_guru หลายเดือนก่อน

    Irrespective pdf/excel/word how can I save the attachments

  • @nasrnasr4537
    @nasrnasr4537 หลายเดือนก่อน

    nice

  • @Sugar14melon
    @Sugar14melon หลายเดือนก่อน

    THANK YOU AAAAH 🎉

  • @thesolitarymage5995
    @thesolitarymage5995 หลายเดือนก่อน

    Are you using Excel 365? I couldn't find the option of going full screen.

    • @ExcelWithAnser
      @ExcelWithAnser 21 วันที่ผ่านมา

      Yes, I used Excel 365 for this video, the desktop version.

  • @kevincecchini
    @kevincecchini หลายเดือนก่อน

    Hi, it does not work. my formula: =(SUM(INDIRECT(A48&"!"&"k249"))) and this returns, #ref! I have tried with and without sum function.

  • @alexandram7421
    @alexandram7421 หลายเดือนก่อน

    How to do date range of >30 days <60 days?

  • @vkas6608
    @vkas6608 หลายเดือนก่อน

    As we select each time, the drop down list disappears, is there any way to create a form where options are given on screen and users just have to click options

    • @ExcelWithAnser
      @ExcelWithAnser 22 วันที่ผ่านมา

      One way to achieve this is by designing an interactive form using checkboxes or buttons. In Excel, you can insert checkboxes by going to the Developer tab (you might need to enable it first via Excel Options) and selecting Insert > Form Controls > Checkbox.

  • @MdRuhulAmin-h4p
    @MdRuhulAmin-h4p หลายเดือนก่อน

    I have analyzed your TH-cam channel and found out some problems, do you want to talk about it for a while?

  • @oshomaoshoma2740
    @oshomaoshoma2740 2 หลายเดือนก่อน

    Can you search the data validation box?

  • @westerncivilization
    @westerncivilization 2 หลายเดือนก่อน

    Your bumper music is whack. Also, this works for a single cell. You can't copy this to another cell and have it work. Now I need to make the target a variable.

    • @westerncivilization
      @westerncivilization 2 หลายเดือนก่อน

      Use this: If Target.Address = ActiveCell.Address Now you can copy and paste within a sheet, and do this trick all day long. Copy the entire code for each sheet.

  • @ninas.2724
    @ninas.2724 2 หลายเดือนก่อน

    I keep getting a Value error

  • @fossilcrab
    @fossilcrab 2 หลายเดือนก่อน

    All I get is #VALUE! On every line.

  • @mikezhang8861
    @mikezhang8861 2 หลายเดือนก่อน

    Genius

  • @manded9590
    @manded9590 2 หลายเดือนก่อน

    This has been helpful

  • @Booster_pack
    @Booster_pack 2 หลายเดือนก่อน

    How do I delete the extra selections if I accidentally listed too many in the box

    • @ExcelWithAnser
      @ExcelWithAnser 22 วันที่ผ่านมา

      First, right-click on the cell with the dropdown, and select Data Validation from the context menu. In the Data Validation dialog box, under the Settings tab, you’ll see the list of options in the Source field. Simply edit this list by removing the extra options or adjusting the range of the source if it's pulling from a range of cells.

  • @fungaimaketo1216
    @fungaimaketo1216 2 หลายเดือนก่อน

    Thank you. Very helpful!

  • @manded9590
    @manded9590 2 หลายเดือนก่อน

    Thanks for your video... I do not have same results. I recreated your same data sheets and applied the formulas but it does not give same results right from the first step. Is there anything wrong?

  • @GreenTheChain
    @GreenTheChain 2 หลายเดือนก่อน

    thanks for sharing this video - should this work on MacBook Pro excel? I couldn't get it to work...

  • @Anabr
    @Anabr 2 หลายเดือนก่อน

    Mine isnt working :/ i ve tried everything

  • @abagiumario6922
    @abagiumario6922 2 หลายเดือนก่อน

    Thank you mate!

  • @rachelkulshrestha2704
    @rachelkulshrestha2704 2 หลายเดือนก่อน

    Hi Sir, I have Multiple Sheet(150) and I want to Pull Just Single data form a Cell for all Sheet, Could you help me with any Formula.

  • @milododds1
    @milododds1 2 หลายเดือนก่อน

    What if you need this functionality for multiple rows in the Column D? Yes I got it working for the first row ($D$2) but all of the rows below it won't work because the code is locked to $D$2, but I need it to go to the next row which is $D$3, $D$4 all the way down to 200+ rows in the D column. Basically I'm trying to replicate this multiple selection but for 200+ rows. I don't want to have to create the VB script 200 times. This is super cool and I bet I'm super close. Btw this is amazing code, thank you so much for creating this video. Really appreciate it.

    • @aidanmarler
      @aidanmarler หลายเดือนก่อน

      I had the same issue. This code worked for me: If Not Intersect(Target, Range("D2:D" & Rows.Count)) Is Nothing Then

    • @lauravanlyssel4793
      @lauravanlyssel4793 หลายเดือนก่อน

      @@aidanmarler where did you insert this part of the code? Is this used instead of "If Target.Address = "$G$2" Or Target.Address = "$G$3" Then"

    • @lauravanlyssel4793
      @lauravanlyssel4793 หลายเดือนก่อน

      I got it to work with this: If Not Intersect(Target, Range("D1:D300")) Is Nothing Then

    • @ExcelWithAnser
      @ExcelWithAnser 22 วันที่ผ่านมา

      Start by copying the data validation rule from the cell where the dropdown is already set up. You can do this by selecting the cell, pressing Ctrl + C, or right-clicking and choosing "Copy." Next, highlight all the rows in the column where you want the dropdown to appear. This can be done by clicking and dragging over the cells or selecting the entire column. Once highlighted, right-click and choose "Paste Special," then select "Validation" to apply the dropdown rules to all the selected cells.

  • @AshanKottegoda
    @AshanKottegoda 2 หลายเดือนก่อน

    Thank you brother ❤❤

  • @didlou34
    @didlou34 3 หลายเดือนก่อน

    thanks !!

  • @labdisoumia7842
    @labdisoumia7842 3 หลายเดือนก่อน

    Why the hyperlink does work with me hyperlink(Contact"#",B2,"!A1),"go to sheet")

  • @nocturnagray1894
    @nocturnagray1894 3 หลายเดือนก่อน

    How do we make it so every cell in a column has this same ability?

    • @Caman0
      @Caman0 3 หลายเดือนก่อน

      Yes i need this too, for 1000's of lines! Cant be adding them through "OR ...OR..."

  • @JUST....GAMING-WD
    @JUST....GAMING-WD 3 หลายเดือนก่อน

    Please suggest how to switch back to the Table of Contents.

    • @viktorb.oskarsson8879
      @viktorb.oskarsson8879 2 หลายเดือนก่อน

      Just ctrl click on the left arrow next to the sheets and you will go the far left and see the TOC sheet which you then just click on to go to.

    • @JUST....GAMING-WD
      @JUST....GAMING-WD 2 หลายเดือนก่อน

      Thanks 👍

  • @harekrushnanayak997
    @harekrushnanayak997 3 หลายเดือนก่อน

    Apku kacchu malum nehin one button then click all excel sheet how can open fully autometical.