- Видео 30
- Просмотров 26 577
Excel Ideas
Индия
Добавлен 15 апр 2022
This is a channel to make you better in Excel.
We teach for free the secrets of data analytics and data presentation in Excel with our advanced level Tutorial of Microsoft Excel. Along the way, we provide many handy Excel tips and tricks, 1-to-1 problem solving in Excel and end-to-end dashboard preparation training from scratch.
If you need Excel for your day to day work this channel will be super-useful for you.
Please support us by liking and sharing our videos if you have really liked it.
For business enquiries: (Customized data analysis, your brand advertisement, sponsorships):
Write to brainquisitive@gmail.com
We teach for free the secrets of data analytics and data presentation in Excel with our advanced level Tutorial of Microsoft Excel. Along the way, we provide many handy Excel tips and tricks, 1-to-1 problem solving in Excel and end-to-end dashboard preparation training from scratch.
If you need Excel for your day to day work this channel will be super-useful for you.
Please support us by liking and sharing our videos if you have really liked it.
For business enquiries: (Customized data analysis, your brand advertisement, sponsorships):
Write to brainquisitive@gmail.com
Data Validation of Dates in Microsoft Excel | Make your data entry form Error-proof
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.
Keywords:
data validation in Excel
data validation of date type data
checking date entry for errors
data validation in excel drop down list
data validation in excel tutorial
where is data validation in excel
Keywords:
data validation in Excel
data validation of date type data
checking date entry for errors
data validation in excel drop down list
data validation in excel tutorial
where is data validation in excel
Просмотров: 87
Видео
Interactive To Do List in Excel | No VBA!
Просмотров 55414 часов назад
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
Просмотров 14914 дней назад
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
Просмотров 74321 день назад
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 Box in Microsoft Excel | No VBA Code!!!
Просмотров 15 тыс.28 дней назад
In this video we will show you how to use the SEARCH() function in combination with FILTER(), ISERROR() and NOT() functions. We will show you step-by-step every detail to make it yourself. You will learn to create and use Interactive Search Box in Microsoft Excel in this tutorial. No VBA Code is required to make this. Keywords: search box in excel how to create a search box in excel create a se...
Quick Interactive Dashboard in Excel | Pivot Chart with Multiple Slicers in Microsoft Excel
Просмотров 567Месяц назад
In this video you will learn to create a quick interactive dashboard with pivot charts 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 mor...
Remove line breaks Automatically while copying text to Microsoft Excel
Просмотров 82Месяц назад
In this video we will teach about removing line breaks while copying a text from word document or pdf document to an Excel file. In the Find What field enter Ctrl Shift J. It will look empty, but you will see a tiny dot. In the Replace With field, enter any value to replace carriage returns. Usually, it is space to avoid 2 words join accidentally. If all you need is deleting the line breaks, le...
How to Create a Month wise and Cumulative Sales Chart in Microsoft Excel with Dotted Projection Line
Просмотров 101Месяц назад
In this video we will teach you to create a cumulative sales chart in Microsoft Excel. You will learn the details of axis options in an Excel chart, month wise column chart and cumulative scatter charts in Excel in detail. There is an introduction to Trendline also in this video. At the end of this video you will be able to create charts more confidently. You will also learn to create a dotted ...
Create Data Entry Form in Excel | Automatically Save Data Through Excel Macro | No VBA Code Required
Просмотров 5 тыс.2 месяца назад
In this video, you will learn about creating a data entry form through Excel Macro. No VBA code is required for this video. You will learn step-by-step how to create a data entry user form from scratch, and add data to database. Features taught include data validation, dropdown list inside cells, use of command buttons, use of Excel macro. Keywords: excel data entry form template free download ...
Create Your Own Customized Tab and Commands in Excel | Advanced Excel Tutorial
Просмотров 4382 месяца назад
In this video you will learn about making your own customized tab in the ribbon inside excel, and also creating your own set of commands. No VBA or code is required for this. A basic example of macro has done all the things. Watch the full video to learn the method step-by-step. This is a well instructed guide video for an advanced level topic of Microsoft Excel. #excelsolutions
Mastering Chart Axis in Excel | Remove gap between grid and value in Month-wise Value Charts
Просмотров 302 месяца назад
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
Просмотров 3193 месяца назад
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
Просмотров 1153 месяца назад
Make a Dynamic To-Do List in Microsoft Excel | Checkboxes
Combine Multiple Excel Files and Automatically Update the Combined File
Просмотров 5293 месяца назад
Combine Multiple Excel Files and Automatically Update the Combined File
Import data directly from any website! Make a map for geographical data
Просмотров 1024 месяца назад
Import data directly from any website! Make a map for geographical data
Excel Basic Operations Revisited | Report Card Project
Просмотров 394 месяца назад
Excel Basic Operations Revisited | Report Card Project
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.
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.
@@myexcel_ideas 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 RUclips 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?
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!
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.
@@myexcel_ideas 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.
@@myexcel_ideas Now I have become a fan of you.
helpful video on excel chart to solve this specific problem.
Thanks for your compliment.
BEST VIDEO ON THIS TOPIC IT SAVED MY LOT OF TIME AND HELPED ME A LOT. THANKS
Glad it helped! Stay with us for more useful videos on data analysis through Excel. You may also advise which topics you'd like to see in this channel.
Well explained
Thanks a lot. Stay tuned.
❤ good explanation
Thanks for your nice 👍 compliment. stay tuned with us.
Very Well explained thanks
Glad it was helpful! Stay tuned with us. Thanks for your compliment.
Excellent, very useful. Please send practice file to follow along.
Sure. Please send me a mail from your id to brainquisitive@gmail.com
Thanks
Welcome.. stay tuned with us for more excellent videos to come.
can i get the practice file🥺
Yes sure, please send a test mail to brainquisitive@gmail.com
Excellent
Thank you so much.
Useful for dashboard report preparation
Thanks for liking. Keep watching.
nice method, it will make big data entry jobs fast.
Yes it will. Thanks for your compliment. Stay tuned with us for more useful videos to come.
Can make a tutorial on how extract data from job portals? Without table
Great
Thank you for the compliment.
Gender could be radio button rather...
Yes that is also possible
Helpful for engineers
😂😂Excel me calculator kyu kholna he bhai
If you're working on a protected sheet you may not be able to calculate in the cells. This will help! :)
Good one, helpful. ❤
Thanks for your compliment