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!
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??
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
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
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.
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!
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
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.
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?