- 55
- 677 759
Anser's Excel Academy
Canada
เข้าร่วมเมื่อ 23 ต.ค. 2015
Welcome to my TH-cam channel dedicated to helping you master Microsoft Excel! Whether you're a beginner looking to build a strong foundation or an experienced user seeking advanced techniques, this channel is your ultimate resource.
With a focus on comprehensive Excel tutorials, I cover a wide range of topics to empower you with the knowledge and skills to tackle any spreadsheet challenge. From basic functions to complex formulas, data analysis to visualization, macros to automation, I've got you covered.
Stay up-to-date with the latest Excel versions, including Excel 365, Excel 2019, and Excel Online. Discover time-saving shortcuts, productivity hacks, and expert strategies to maximize your efficiency and productivity.
Whether you're a student, professional, entrepreneur, or simply an Excel enthusiast, this channel is your go-to destination for all things Excel. Get ready to excel with Microsoft Excel like never before!
With a focus on comprehensive Excel tutorials, I cover a wide range of topics to empower you with the knowledge and skills to tackle any spreadsheet challenge. From basic functions to complex formulas, data analysis to visualization, macros to automation, I've got you covered.
Stay up-to-date with the latest Excel versions, including Excel 365, Excel 2019, and Excel Online. Discover time-saving shortcuts, productivity hacks, and expert strategies to maximize your efficiency and productivity.
Whether you're a student, professional, entrepreneur, or simply an Excel enthusiast, this channel is your go-to destination for all things Excel. Get ready to excel with Microsoft Excel like never before!
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
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!
This is superb. i was in assumption that this can only achieve by adding the activeX or form control in sheet
If I have to put multi- select dropdown from cell A2 to A500, the what will be the VBA code? Pls suggest
where is the code?
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
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?
It worked thanks!!!
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.
Just like the topic your instructions are fuzzy too
my excel doesnt have unique formula what do i do?
nevermind its okay now. thanks for this tutorial!
Where is the descripton box
Your videos are amazing. I really like it. I am a new subscriber to your channel. Can I talk with you Anser?
Can i talk with u plz
Great video. Practical and thorough.
Glad you liked it!
Thank you so much! this example actualy work!
You're welcome!
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!
How to apply to an entire column?
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.
i tried this for my google sheets, but it's not working :( could you help on this sir?
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
Hi! How to insert a hiperlink in a cell consists of several sentence?
very helpful ! clear and well explained
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.
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.
@@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?
@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.
Thanks, Helped
Hi Sir, can we have a collaboration?
Sometimes a simple search on youtube is more helpful than using ChatGPT
Agreed!
@@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?
Irrespective pdf/excel/word how can I save the attachments
nice
THANK YOU AAAAH 🎉
Are you using Excel 365? I couldn't find the option of going full screen.
Yes, I used Excel 365 for this video, the desktop version.
Hi, it does not work. my formula: =(SUM(INDIRECT(A48&"!"&"k249"))) and this returns, #ref! I have tried with and without sum function.
How to do date range of >30 days <60 days?
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
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.
I have analyzed your TH-cam channel and found out some problems, do you want to talk about it for a while?
Can you search the data validation box?
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.
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.
I keep getting a Value error
All I get is #VALUE! On every line.
Genius
This has been helpful
How do I delete the extra selections if I accidentally listed too many in the box
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.
Thank you. Very helpful!
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?
thanks for sharing this video - should this work on MacBook Pro excel? I couldn't get it to work...
Mine isnt working :/ i ve tried everything
Thank you mate!
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.
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.
I had the same issue. This code worked for me: If Not Intersect(Target, Range("D2:D" & Rows.Count)) Is Nothing Then
@@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"
I got it to work with this: If Not Intersect(Target, Range("D1:D300")) Is Nothing Then
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.
Thank you brother ❤❤
thanks !!
Why the hyperlink does work with me hyperlink(Contact"#",B2,"!A1),"go to sheet")
How do we make it so every cell in a column has this same ability?
Yes i need this too, for 1000's of lines! Cant be adding them through "OR ...OR..."
Please suggest how to switch back to the Table of Contents.
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.
Thanks 👍
Apku kacchu malum nehin one button then click all excel sheet how can open fully autometical.