- 37
- 35 869
Excel Mavericks
India
เข้าร่วมเมื่อ 15 เม.ย. 2022
We teach complicated things of Excel the easy way.
We teach for free the secrets of data analytics and data presentation through Excel with our advanced level Tutorial videos of Microsoft Excel. Along the way, we provide many handy Excel tips and tricks, quizzes to self-test your skill, 1-to-1 problem solving in Excel and end-to-end report and dashboard preparation training in Excel right from the scratch.
For business enquiries: (Customized data analysis, data insights, report and dashboard preparation, your brand advertisement, sponsorships): email to brainquisitive@gmail.com
If you have a problem related to data, we have a solution!
We teach for free the secrets of data analytics and data presentation through Excel with our advanced level Tutorial videos of Microsoft Excel. Along the way, we provide many handy Excel tips and tricks, quizzes to self-test your skill, 1-to-1 problem solving in Excel and end-to-end report and dashboard preparation training in Excel right from the scratch.
For business enquiries: (Customized data analysis, data insights, report and dashboard preparation, your brand advertisement, sponsorships): email to brainquisitive@gmail.com
If you have a problem related to data, we have a solution!
Make this Calendar for Eternity in Microsoft Excel | SEQUENCE function
In this video you will learn about creating an automatic calendar for eternity. This you can use for any year, change years automatically.
This is a nice excel application you can learn without coding with the SEQUENCE function of Excel
Tags:
sequence function in excel
sequence function
automatic calendar in excel
This is a nice excel application you can learn without coding with the SEQUENCE function of Excel
Tags:
sequence function in excel
sequence function
automatic calendar in excel
มุมมอง: 102
วีดีโอ
Searchable Dropdown and Dependent Dropdown in Excel
มุมมอง 119หลายเดือนก่อน
In this video we will show you how to make a Searchable Dropdown and Dependent Dropdown in Excel. In the process you will learn how to look for a value from a table with more than one criteria. The following functions are taught in this video: INDEX, MATCH, FILTER, SORT, UNIQUE, SEARCH, ISNUMBER, IFERROR. Also, you will see a practical application of the data validation feature in this video. L...
Automatic Organization Chart from Staff List | Organization Chart in Excel
มุมมอง 412หลายเดือนก่อน
In this video we will show you how to create an Organization Chart in Excel directly from the Staff List in a complete automatic process. To accomplish this task we will take the help of a Free Excel Add-in from Microsoft, named Microsoft Vision Data Visualizer. We will show you in steps and detailed guide how to create the data table and how to generate the organization chart from the staff li...
How to Create an Excel Dashboard | Excel Dashboard Templates Free in the Link
มุมมอง 1.1K2 หลายเดือนก่อน
Get the practice file to download - shorturl.at/pAfpU Dashboards are useful for data visualization. In this video you will learn how to create an interactive excel dashboard step by step. We will use the sales data of a company to create a multi functional dashboard in Excel. From this excel dashboard design one can get an insight to the business and generate visual reports in seconds. We have ...
Compare Data with a TORNADO Chart in Microsoft Excel
มุมมอง 2942 หลายเดือนก่อน
Download the practice file here: docs.google.com/spreadsheets/d/12MQlkSFp4IdxqrrNYbirhCuN7g8f_P03/edit?usp=drive_link&ouid=107629943813678771518&rtpof=true&sd=true In this video you will learn about creating a Tornado Chart in Excel. Tornado Charts are not default chart in Microsoft Excel. You need to learn the step that are required to create a tornado chart. Here we will use the SORT() functi...
Data Validation in Excel | How to Make your data entry form Error-proof?
มุมมอง 2232 หลายเดือนก่อน
In this video you will learn about data validation in Microsoft Excel for date type of data. Along with the main topic you will also learn about "Define name" and "Name manager" features and "WEEKDAY" function. Also you would like to insert custom message box without VBA coding and learn to provide tooltips for users in Excel for your viewers. data validation in Excel data validation of date ty...
Interactive To Do List in Excel | No VBA!
มุมมอง 7562 หลายเดือนก่อน
Download practice file: docs.google.com/spreadsheets/d/1L3YR1jyiUBti4pzc-sx0gyIczpvqJo9O/edit?usp=drive_link&ouid=107629943813678771518&rtpof=true&sd=true In this video you will learn how to create an interactive to do list in Excel, that is too without any VBA coding. In the to do list, the user will be able to check completed tasks, get a timestamp of the time when the task is completed, and ...
Create Male-Female Infographic Chart in Excel
มุมมอง 2442 หลายเดือนก่อน
In this video you will learn about Male-Female infographic charts and how to create Male-Female infographic charts from the scratch in Microsoft Excel. This is a tutorial where we will show you every step from scratch so that you can learn it well. Keywords: Infographic charts in Excel Advanced charts in excel Advanced excel charts male female chart in excel excel male female chart
Create a Speedometer Chart in Excel | Gauge Chart in Excel
มุมมอง 9273 หลายเดือนก่อน
In this video you will learn about creating a speedometer chart (which is also known as a gauge chart) in Microsoft Excel from scratch. No VBA code is required to make this. You will see how to integrate two donought charts and one pie chart in to one speedometer chart and use it for a single parameter performance display for any of your data representation. Keywords: excel speedometer chart sp...
Interactive Search Bar in Microsoft Excel | Search Box in Excel without Code! Excel Search Box!!
มุมมอง 19K3 หลายเดือนก่อน
In this video we will show you how to create a search bar in excel using the SEARCH() function in combination with FILTER(), ISERROR() and NOT() functions. We will show you step-by-step every detail so that you can make it yourself. You will learn to create and use Interactive Search Box in Excel in this tutorial. No VBA Code is required to make this. search box in excel search bar in excel exc...
Interactive Pivot chart with Multiple Slicers in Microsoft Excel
มุมมอง 5983 หลายเดือนก่อน
In this video you will learn to create interactive pivot chart and slicers that will make the data reporting fun for you. In this quick and easy tutorial of Excel features we will teach you the slicers, how to insert pivot charts, slicers in excel, format them, select multiple fields of a slicer, have multiple slicers for the same pivot chart or pivot table, and many more. With this tutorial, y...
Remove line breaks Automatically while copying text to Microsoft Excel
มุมมอง 1023 หลายเดือนก่อน
Remove line breaks Automatically while copying text to Microsoft Excel
How to Create a Month wise and Cumulative Sales Chart in Microsoft Excel with Dotted Projection Line
มุมมอง 1134 หลายเดือนก่อน
How to Create a Month wise and Cumulative Sales Chart in Microsoft Excel with Dotted Projection Line
Create Data Entry Form in Excel | Automatically Save Data Through Excel Macro | No VBA Code Required
มุมมอง 6K4 หลายเดือนก่อน
Create Data Entry Form in Excel | Automatically Save Data Through Excel Macro | No VBA Code Required
Create Your Own Customized Tab and Commands in Excel | Advanced Excel Tutorial
มุมมอง 4775 หลายเดือนก่อน
Create Your Own Customized Tab and Commands in Excel | Advanced Excel Tutorial
Mastering Chart Axis in Excel | Remove gap between grid and value in Month-wise Value Charts
มุมมอง 325 หลายเดือนก่อน
Mastering Chart Axis in Excel | Remove gap between grid and value in Month-wise Value Charts
Create a customized Report in Microsoft Excel from a Big List with FILTER and SORT Functions
มุมมอง 3495 หลายเดือนก่อน
Create a customized Report in Microsoft Excel from a Big List with FILTER and SORT Functions
Make a Dynamic To-Do List in Microsoft Excel | Checkboxes
มุมมอง 1285 หลายเดือนก่อน
Make a Dynamic To-Do List in Microsoft Excel | Checkboxes
Combine Multiple Excel Files and Automatically Update the Combined File
มุมมอง 5755 หลายเดือนก่อน
Combine Multiple Excel Files and Automatically Update the Combined File
Import data directly from any website! Make a map for geographical data
มุมมอง 1086 หลายเดือนก่อน
Import data directly from any website! Make a map for geographical data
Excel Basic Operations Revisited | Report Card Project
มุมมอง 476 หลายเดือนก่อน
Excel Basic Operations Revisited | Report Card Project
If I wanted to combine data from multiple tables how would I go about doing that?
thank u, bro, u very good
Ohh great
Thanks, pls check out our other videos, hope you will enjoy
Hi Bro, thanks a million. I learned a lot.
Thanks for your appreciation
What if we want the search to be exact otherwise, you don’t want it to show up. For example, what if you just all results of 35 without search box providing all results with 35 (like 35000 in salary) in it.
Reason why I ask is that I’m using your tool for multiple columns with #s. But I want just a specific # but if I type it out, it searches and provides results that contains the search # instead of just that specific one.
Hi I'm NOORUL AMEEN, From Tamilnadu... Nice this video... But I don't know Excel.. just small working in excel ... How learn this Excel & Formulas using the proper projects attached my maind ... If you don't mind guide me??
Share your Contact Number
What is the formula for the total # records found, pls?
Can you provide me this file Sir?
Thanks for the trick
Glad that you liked it
What if the excel has the =FILTERXML function alone. is there any other approach to completing the formula now that i am not getting =FILTER function
Hello bro. Enjoyed your video. If you can please create a automated dashboard for daily, weekly, monthly purposes for a company which includes, 1. Different locations, 2. Multiple sales people, 3. Multiple products under various product category 4. Customer ( data sheet, Accounts ( income, credit payments, etc) 4. Sales details dashboard with sales people performance and their monthly target archivments 5. Return goods ( product wise, category wise) 6. Total sales value, credit sales value, paid payments , unpaid payments ( area / sales person / customer wise) 7. Loading unloading sheet
Can you please share a sample data? our email id is brainquisitive@gmail.com
give access for the file, or direct share the sheet
Access given. Please Check now.
great
go ahead
very useful video . explanation is too good . thanks
Thank you. Another video on data validation will follow soon, for other data types.
your work is amazing sir
Many many thanks
well done bro
thanks a lot
Super baiya
Glad that you liked it.
Practice File download link included in the description for all our beloved viewers. Thanks a lot and keep supporting us! Download and open the file in MS Excel and NOT in Google sheets.
thanks
very good job bro upload videos like this these are very useful i watch your video at first time and now i am become your regular subscriber you have good talent i request you to please provide the practice files in the description
Thanks a lot. We will soon create a website for downloading the files. For now if you give your email id i can send the practice files immediately.
Link for downloading the practice file given now in the description.
@@excelmavericks thanks a lot 💓💓
Good job Bro
thanks for the compliment.
2:01 How to automate the task ID field 2:52 How to insert checkboxes 6:41 How to Add Timestamp 8:32 Auto-updating balance task pane
thanks for your effort
I will be adding the time stamp feature to my current task list. Thank you for another great video
Glad that you liked it. Thanks for the encouraging words.
You have such a creative approach to using excel that I have not come across in many years. I look forward to a long and successful TH-cam channel!
Thanks a lot for your compliment.
Such a cool and fun way to showcase data. I love this.
Thanks a lot.
Such a great tool and I am very excited about the no VBA. I understand the VBA is very powerful but I do not have the head for coding. Excel formulas on the other hand, I love. Thank you so much for sharing. This is the first video from you I have come across and you have 1 more subscriber now.
Thanks a lot for your appreciation. Stay with us.
How about if no =FILTER?
Without FILTER function it is possible to do this with VBA. Later We will some time post this video
Can this be shared with other people so that they can enter the data and can you protect the data sheet. Thanks
Of course this can be done. Just you need to protect the cells from Review tab.
Hi! it was very helpful and really was looking for something like this for a long time!! Thanks a lot!!! just two question - 1. what if I want to see return value for only a few columns of a specific table instead of the full table? for example - in your table I want to see only designation and salary from accounts department, no other info. 2. How should I modify the formula or structure of the search button if I want to search multiple values instead of one; for example what if I want to search for 2 or more designations (manager and officer) in your table? thanks in advance!
Hi , sorry for the late response. to answer your query, no.1 : you can select which columns to display with the FILTER function by using a CHOOSE function inside the FILTER no.2 : in the practice sheet, insert another search box, link its input search text to cell O2, then change the search formula in the B6 cell as the following:(mark the * operator between tow NOT() functions) =FILTER( MyTable, NOT(ISERROR(SEARCH(N2, MyTable[First Names] & "*" & MyTable[Designation] & "*" & MyTable[Department] & "*" & MyTable[State of Living]))) * NOT(ISERROR(SEARCH(O2, MyTable[First Names] & "*" & MyTable[Designation] & "*" & MyTable[Department] & "*" & MyTable[State of Living]))), "" ) Tell me if that helps!
Nice explanation, thanks for easy guide
We try to make videos easy to follow. Thanks for your kind words.
No matter which position now you are in & number of subscribers you have...Mark my words..YOU & YOUR CHANNEL WILL REACH HIGHEST POINT...1. Very Good Knowledge on TOPIC 2. Simple and Clean Presentation 3. Selection GOOD topics ....makes you different from others . Hoping to see you in bright side of the WORLD. Thank You
No matter which position now you are in & number of subscribers you have...Mark my words..YOU & YOUR CHANNEL WILL REACH HIGHEST POINT...1. Very Good Knowledge on TOPIC 2. Simple and Clean Presentation 3. Selection GOOD topics ....makes you different from others . Hoping to see you in bright side of the WORLD. Thank You
Excellent
Thanks for your compliment. Stay with us for further useful videos to come.
Dear thanks for great search function which i am looking since many days you made my day, i have a question can we make same search function within the sheet please make the video and i hope you got my question thanks again
Thanks for the compliment. Yes of course we can make the search function within the sheet, only thing is that the columns should be different for the search results from the columns containing the raw data.
@@excelmavericks okay understand thank you dear and keep it up and bless you
Thank you
Welcome. It's our pleasure that you liked this video. May please suggest topics for further posts in this channel.
👌लाजवाब
Thanks for the compliment.
Can I have your file because Excel in Dutch have different formulas ...
Yes sure please send a mail to brainquisitive@gmail.com
Good one. Very nice.
Thanks for the compliment.
Super hero sir❤❤
Thanks for your compliment.
GREAT !!! Thanks ..
Our pleasure! Stay with us for more useful videos in this channel.
Thanks for the video! If my cell has >1 words, for example “Assistant Manager” or “Vice President” or “Head of Department”, will the search function works for the second or third word?
Yes definitely it will work.
Need the practice file❤
Please send a mail to brainquisitive@gmail.com
Please provide practice file
Please mail from your mail id to brainquisitive@gmail.com
Super Baiya, Very useful Thanks .
Thanks for your compliment.
wow, simply superb.
Glad you liked it. Please keep watching us for more useful videos of Microsoft Excel to come.
@@excelmavericks Now I have become a fan of you.
helpful video on excel chart to solve this specific problem.
Thanks for your compliment.