IAMMANUPRASAD

How to make multiple searchable Dropdown list | Filter list in excel | in excel | Malayalam | No VBA

This video is an extension/updating of the previous video of searchable dropdown list Topics include * How to create a multiple searchable dropdown list * how to remove null spaces in dropdown list * how to assign a name range watch this first part video before for better understanding -- https://youtu.be/-tYvT860TXY Useable information Download the sample excel file here https://drive.google.com/file/d/1YGqt-wm-PVzzlZMsOnUBqI-d7KutrUuK/view?usp=sharing Equations in F3 cell : ==--ISNUMBER(IFERROR(SEARCH(INDIRECT(CELL("address")),E4),"")) IN G3 cell : =IF(F3=1,COUNTIF($F$3:F3,1),"") in H3 cell : =IFERROR(INDEX($E$3:$E$26,MATCH(ROWS($G$3:G3),$G$3:$G$26,0)),"") in Name manager refer to cell : =OFFSET(Sheet1!$H$3,,,COUNTIF(Sheet1!$H:$H,"*?"))

How to Make Table of contents in few clicks | MS Word Tutorial | Malayalam

You can learn making TOC in MS word in few steps in this video Things to learn from this video 1. How to make toc in few clicks 2. How to customise TOC 3. How to apply style in MS word 4. One click navigation in MS word 5. Title making in MS word #happylearning #learnsomethingnew The best way to import pdf data to excel | tip for KTU faculties | Easy report making | Malayalam https://youtu.be/csPl_hzOBqI How to Create a Dependent Drop Down List in Excel | update dropdown list with respect to another https://youtu.be/vFuMmL_ov58 How to make multiple searchable Dropdown list | Filter list in excel | in excel | Malayalam | No VBA https://youtu.be/1c2xk7mHrfk

Design & Engineering - How to answer design & engineering questions - Explanation with Examples

EST 200 DESIGN AND ENGINEERING Module 1 Question (Q1) Show the designing of a wrist watch going through the various stages of the design process. Use hand sketches to illustrate the processes. (Q2)Find the customer requirements for designing a new car showroom. Show how the design objectives were finalized considering the design constraints? Syllabus Design Process:- Introduction to Design and Engineering Design, Defining a Design Process-:Detailing Customer Requirements, Setting Design Objectives, Identifying Constraints, Establishing Functions, Generating Design Alternatives and Choosing a Design.

EST 200: Design & Engineering | Module 2 | Sample question Solution | designing a bag for college students in low budget

Question) 13) Illustrate the design thinking approach for designing a bag for college students within a limited budget. Describe each stage of the process and the iterative procedure involved. Use hand sketches to support your arguments. Topics covered Design thinking Syllabus Design Thinking Approach:-Introduction to Design Thinking, Iterative Design Thinking Process Stages: Empathize, Define, Ideate, Prototype and Test.

Model questions for Scientific computing Lab

1. Write a program in python which can perform, addition, subtraction, multiplication & division of two numbers and display the results

2. Write a python program to find the area of a circle

3. Write a program for solve the given equation in python

2x + 6y - z = 5

3y + 2z = 8

5x - y + 4z = 10

4. Write a program for a function to find out the largest and smallest number from an array in python

5. Write a program for generating and plotting the given function in python

y = 5Cos(t)+sin(10t)

6. Write a program in python for 10 times coin toss and show how many heads and tails are there

7. Generate and plot the signal 7Sin(2πt) and show the histogram of the same

8. Write a program in python to find the square of the max value in an array

9. Realize the equation using python --- any equations---

10. Write a function in python to implement add two numbers

11. Write a program to find the largest number in a list in python

12. Write a python program to print only even numbers from a list

13. Write a program for solve the given equation in python

9x + y - 8z = 5

6x + 8y + 2z = 7

7x - 5y + z = 0

14. Write a program to find the largest number in a list in python

15. Write a program in python for 10 times coin toss and show how many heads and tails are there

16. Write a program to find the largest number in a list in python

17. Generate and plot the signal 7Sin(2πt) and show the histogram of the same

18. Write a python program to find the area of a circle

19. Write a program in python which can perform, arithmetic operation of two numbers and display the results

20. Write a python program to print only even numbers from the list

How to create a Searchable dropdown list in excel | Malayalam | without VBA

This video clearly explains step by step process of making a searchable dropdown list in MS excel Enjoy!!! Useable information Equations in F3 cell : =--ISNUMBER(IFERROR(SEARCH($B$3,E3),"")) IN G3 cell : =IF(F3=1,COUNTIF($F$3:F3,1),"") in H3 cell : =IFERROR(INDEX($E$3:$E$26,MATCH(ROWS($G$3:G3),$G$3:$G$26,0)),"") download the excel sheet here https://drive.google.com/file/d/1yg9-lqwA7sW2ZeStERPNKwEzoHacwbPB/view?usp=sharing Don't forget to subscribe and share Thank you

How to Create a Dependent Drop Down List in Excel | update dropdown list with respect to another

An Excel drop down list is a useful feature when you’re creating data entry forms It shows a list of items as a drop down in a cell, and the user can make a selection from the drop down. This could be useful when you have a list of names, products, or regions that you often need to enter in a set of cells. Sometimes, however, you may want to use more than one drop-down list in Excel such that the items available in a second drop-down list are dependent on the selection made in the first drop-down list. These are called dependent drop-down lists in Excel. #excel #dropdown list

EST 200: Design & Engineering | Module 5 | Sample question Solution

Question (20)Describe how to estimate the cost of a particular design using ANY of the following: i) a website, ii) the layout of a plant, iii) the elevation of a building, iv) an electrical or electronic system or device and v) a car. Show how economics will influence the engineering designs. Use hand sketches to support your arguments.

Topic covered Engineering Economics in Design Module 5 - Syllabus Expediency, Economics and Environment in Design Engineering:-Design for Production, Use, and Sustainability. Engineering Economics in Design. Design Rights. Ethics in Design

സത്യത്തിൽ WhatsApp നമ്മുടെ മെസ്സേജുകൾ വായിക്കുന്നുണ്ടോ?

സത്യത്തിൽ WhatsApp നമ്മുടെ മെസ്സേജുകൾ വായിക്കുന്നുണ്ടോ? WhatsApp എടുക്കുന്ന ഡാറ്റകൾ എന്തോക്കെ? WhatsApp സേഫ് ആണോ? is signal safe? അറിയാൻ വീഡിയോ കാണു Like and subscribe of you like the video

How to search smart in google | Things you don’t know in google search | Easter egg available!!

1. Search specific word/phrase

2. Exclude word/phrase from search

3. Quick calculation 4. Graph plotting (2D/3D) 5. Quick conversion 6. Meaning of a word 7. origin of a word 8. Sunrise/Sunset time 9. Timer/Stopwatch 10. coin flip 11. holyday/Special day search 12. search within a website 13. Flight status 14. Find your phone Easter eggs!!! 15. do a barrel roll 16. google in 1998 17. festivus search Don't forget to give comments and feedbacks Check other videos Easiest way to import pdf file in to excel : https://youtu.be/jET9Y5uvdi8 watch my - 5 tips & Tricks in MS excel course here : https://youtube.com/playlist?list=PLmKq-kgKY8uZCGi-U_bx820HOLmk5NidT if you want to learn python language and you font know programming then watch the course Learn python in Malayalam course : https://youtube.com/playlist?list=PLmKq-kgKY8uZya3cwcX6otT61NPHXbTK0 Photo by Christian Wiediger on Unsplash

The best way to import pdf data to excel | tip for KTU faculties | Easy report making | Malayalam

This video is especially made for KTU faculties who are facing difficulties in result analysis report making.

with some easy steps you can import all the mark list data into an excel file easily Most of the time converting a pdf file to excel wont work as we wish to do so. in this method there is more customised steps ate there watch the video in full don't forget to give your feedback as comment also please like the video watch my - 5 tips & Tricks in MS excel course here : https://youtube.com/playlist?list=PLmKq-kgKY8uZCGi-U_bx820HOLmk5NidT if you want to learn python language and you font know programming then watch the course Learn python in Malayalam course : https://youtube.com/playlist?list=PLmKq-kgKY8uZya3cwcX6otT61NPHXbTK0 music : Tobu-Sound-of-Goodbye-NCS-Release