Omg finally someone that does not make excel more complicated than has to be, this was fantastic.
@PradeepKumar-zb9lt
3 жыл бұрын
Hi There, You Sweet and Crispy voice and excellent skill......lots of thanks.
@knowandgrow6254
5 жыл бұрын
The tutorial is great. I loved the way you put instructions patiently and to the work. By the by, your voice is clear and lovely.
@Diana-Trans2Scribe
7 жыл бұрын
This is probably one of the best excel tutorials, thanks a million. for the first time it sank in!!! Please make more!
@ourkodidog
8 жыл бұрын
OMG THANKYOU I watched no less than 10 other boring videos that were not clear and I was getting no where fast. Your video was easy to follow and solved my 2 hours of frustration. My first worksheet with dropdown choice is DONE. THANK YOU!
@leobenjaminlopez9255
7 жыл бұрын
Hi Sally, You have such a BEAUTIFUL voice :) thanks for the tutorials and for the enjoyment of hearing you while you explain how to create certain forms in Excel.
@wmfield152
6 жыл бұрын
Yes you do have a pleasant voice. This is good and clear basic info. Thanks!
@josephl431
4 жыл бұрын
Thank you, this was very helpful, concise, to the point, and filled with useful information, Thank You
@educatorestrada29
7 жыл бұрын
Hello from San Juan, Puerto Rico: This video has changed my deception: I'll explain. I was about to give up. I have a problem with no solution, i have been trying for days to looking everywhere for hope. I finally found it here with you. I am a newbee in programming, i don't have the skills in developing logic behind the ideas people want you to solve for them. I mean not just yet, in programming its different. My problem is this: I have to plan a database that entails creating a user end form with buttons for someone who does not know programming, or just creating a query if she would just use "Access 2010". The form must have validation input to prevent someone from the outside source entering some other data, ej. where gender is m or f, they'll put 0. The outside source must submit data in an excell sheet, "this then is imported in the user's excel sheet, they must filter out the duplicates and where data is missing, must be returned back to them, and demand to complete where left empty. The outside source returns the excell sheet again, with the missing data and duplicate records of before. WOW! There is so much redundant (repetition) work for the user, that it's too tedious. They asked me to come in as an "intern" to help them create a form with buttons to speed up the process for the user. But they mentioned using "SQL", and i don't know what to do, regarding the database using 'SQL', because this i believe would entail creating a platform for client/server services. When i spoke to the IT team in the company, they said it is not a good idea, because the server, their mainframe, must be protected from hackers entering inside their database. First of all they don't have "Visual Basics", that works with "SQL", when creating that platform. Sally this database holds 9,400 pieces of data, and a client/server service would be excellent, but i believe i could solve this issue creating a form right in excel, the way you helped teach me. The user uses excel 2010, i think its a good idea, but their's one doubt. The user uses a pivot table, something they said they want to eliminate. In the end a final report must be produced (a clean copy) without duplicates and errors, this is where the filtered report comes in using validation. Sally what's your opinion. Please Worried, i'll be forgotten
@hydrofal78
7 жыл бұрын
A form as it works in databases receives input and sends it back to a table or more where afterwards one can get more data and results . Here you just reproduce the fields in rows and there is no way one can add more than one records . A form creates a record and saves it in a list of other records. If you want to build a form in Excel there is no doubt you should use VBA buttons and combo boxes as well as text fields. That makes it extremely difficult for me because i have no clue how to complile a VBA code. Access is my primary tool where forms are built easily and the records can be stored fast and in big quantiities. Excel is nice and I would love to manage and create a form like Access creates them. The easy way is to use the Form button from the ribbon if you add it from the More Commands but even then one should have a table fixed with headers and records so as this automatic form can detect everything and pop up a simple form for adding data.
@vanessapegg5810
7 жыл бұрын
Thank you Sally, great video to set up drop-down lists will make life easier. -Vanessa
@jehovahcarrentals365
6 жыл бұрын
Simple and to the point.....will use this for sure
@Atomicgardeners
6 жыл бұрын
Thank you, learned something new, I thought you were going to do a V or H look up but this was much easier to follow. Thank you
@oliveo7336
7 жыл бұрын
Super Sally!You’re my Excel life saver👍
@The80sBoy
7 жыл бұрын
What a very interesting, compact video. The way you explain the processes involved is very understandable and not patronising. You have a lovely, listenable voice which definitely helps! Also you have a new subscribee!!
@manishakhandelwal3084
5 жыл бұрын
Thank you
@catherinehough1265
4 жыл бұрын
Thanks fo this Sally
@natasjavanvugt56
6 жыл бұрын
Thanx, it was nice to learn something new!!
@prasadintergulf
6 жыл бұрын
hi Madam, Thank you very much to share the valuable knowledge, and hereby look forward to more training like this in future too. Kind regards.
@beckylibbert6376
6 жыл бұрын
Sally, this is great. It helps a lot. Do you by chance have it written down or in a PDF? I like to keep a notebook of written material on hand. (I know but sometimes just watching the tutorial is not enough for me. I am over 60 and from the old school)
@EdsonNascimentoEN
5 жыл бұрын
Lovely - thanks for sharing with so nice voice...
@richardcourt6494
5 жыл бұрын
Have you a video on how to incorporate this with prices, discount etc....?
@trishthomas171
6 жыл бұрын
Great presentation
@roelofco
6 жыл бұрын
Loved the video. Is there any way to put the shirt size or color information in a separate excel document and then link it to the order form? Even if the info is hidden, in my case it would be confidential and would not risk buyers viewing the information.
@imichael188
6 жыл бұрын
Great video. Thanks. But what happens if you wish to input a one-off size, or require a larger quantity? Can you add a free text option?
@starzippers8932
7 жыл бұрын
Hey Sally, u have really good tutorials and attitude, I wanted to know where can i find info about how to work with the IF function on the form. for example how do I make it so when a customer chooses a value from the dropbox so certain dropbox appear and when he chooses another value than other dropbox appears?
@activateelectrical1720
6 жыл бұрын
Really great video Sally. Im attempting to utilise your lesson to design a purchase order form, to help me calculate the cost of materials required for each electrical job. I have just over 600 material items to choose, depending on whats required, eg cable too differing light fittings. (sorry to ramble). what I would also like to do is to be able to type / search into each dropdown box so as to speed up selecting the required material description. Can you help? Kind Regards James
@NoahCowper
7 жыл бұрын
You can print it but the drop down selection box won't work haha. How would you export this to a form. And how would you have it update a data base?
@g4gypsy
3 жыл бұрын
Thank you for a great tutorial, Sally! Is there a was to start typing in a long drop down list field rather than scroll up and down? Do you have a tutorial?
@SimpleSoftwareTutorials
3 жыл бұрын
Great question & one that gets asked frequently! Right now, there isn't a simple way to do it, but I believe it's possible using Visual Basic (VBA), which I'm still learning about. That's why it's really important to have those dropdowns in a logical order so it's easy for users to scroll through and find what they're looking for. But I agree, it would be fantastic for users to be able to just start typing. Unfortunately, I don't know how to make that happen (yet).
@psarch18
7 жыл бұрын
Very Helpful! Do you know if there is anyway that excel would allow you to create a form like this from a list of data? Say you already have a data spreadsheet with contact information from 20 individuals (like the data you provided in the video for rows 1-7). I want to easily pre-populate this info into my order for the customers and then send it out to them. How could I link this data? Would I need to do it separately for all 20 customers? A quick answer or another tutorial video on this would be great!
@chickoo7474
5 жыл бұрын
thats my question too
@sharonchen5649
7 жыл бұрын
Having drop downs means a lot of clicking. Can you put a form on this with multiple choice radio buttons for size for instance? I find repeated data entry using drop downs as cludgy - particularly on mobile devices.
@blueescape9735
5 жыл бұрын
It is a great tutorial. Can you please show how to do the same with Invoice creation
@jayrosenberg7552
7 жыл бұрын
Sally, VG, smart present. Can I assume that the dropdown cell can be referenced anywhere? Also, how do you link to a VBA public subroutine to process the data, say once you hit a "button" or a "CRL" key to a macro? ?
@carp04us
8 жыл бұрын
Sally thank you, I've always wanted to learn this format. Can you import these fields into Microsoft Word?
@TEDDY78ify
5 жыл бұрын
Great video! Easy and clear to follow! - Question, How do you save the file as a fillable form, in order for the client to fill it out via computer &/or mobile device? Thx
@SimpleSoftwareTutorials
5 жыл бұрын
Thank you! What I did to make it client-friendly was I hid all the data worksheets and cells that weren't relevant to the order form and I password protected cells to keep them from editing the cells. Here's a video showing how to do that: kzitem.info/news/bejne/r5x3qGWlo56Edqg You'll want to make sure the customer can select or input their order into it, but you don't want them adding their own info or changing things. Once you've done that, I'd do a few test runs through it to ensure it's working as expected with no errors, then send it off!
@TEDDY78ify
5 жыл бұрын
Thank so much & for the link on how to.
@willierollerskating8642
5 жыл бұрын
Hi Sally! Thank you so much for your Video! It was so HELPFULLLL : ) I subscribed to you as well! I will refer my friends to your trainings! Take care! : )
@SahilKhan-nb9bm
7 жыл бұрын
thanks sally
@logenrajah448
5 жыл бұрын
Its really useful and i love your voice... ")
@janetkeru4627
7 жыл бұрын
This was very helpful..Thanks!!!
@jakytube1
4 жыл бұрын
Thanks, I thought about the Vlookup too, but no. still, have a question I need a drop-down list that pulls more that one column, for example project # pull project name, contact, and phone on the same table, kind that cross-reference, between employees, and projects. Thansk
@glenncampbell5077
6 жыл бұрын
Awesome video! But how do you select multiple sizes and how can I add prices to this sheet?
@worgasm
5 жыл бұрын
Great video and well presented. I would like to ask if there is a way to add multiple cells (multiple columns) with one selection from a dropdown selection? Example: I have a header with last name, first name, date of birth, passport number, etc. I would like to select the person by name and the rest of the info fill in across columns A-H, in proper order and format under the correct header. Or I would like to select someone by name from a dropdown list and have have all their data auto fill on a table that you would use in MS Word. Thank you in advanced.
@SimpleSoftwareTutorials
5 жыл бұрын
Yes, you can absolutely do this and not too difficult either. If you already have the data you would need to fill those fields, you could use a VLOOKUP formula to pull the correct data into the correct field. I'd have a sheet with all the data on it, then in each field, write a VLOOKUP formula to pull the correct data. It'll be a little bit tedious setting up, but well worth it once you're done. For example, if I had all my customer info on a sheet called customer data, I could write a formula like: =VLOOKUP(A10,'Customer Data'!A:J,3,FALSE). -My lookup value would be the dropdown list that I select the customer name from. -My table array would be the columns on my customer data sheet that contain the data I'm looking for. You need to be sure to include the column with the customer name (in the leftmost column) as well as the column that contains the specific data you're looking for as it'll first search for a match in the name column then it'll search the column you specify. -Col Index Num is where you specify which column contains the information you're looking for. In this example, I'm looking in the third column (since I start with column A, the third column would be C). -Range lookup would be false, since I want an exact match. Otherwise, it'll find the closest match, which may not be correct. Then you'd need to update the formula for each column across, but that's pretty easy to do - you can just copy that original formula and edit the col index num to match your column header. So if you start with the name in column A and your address is in column D, the col index num would be 4, since D is the 4th column. Next, if you have the city in column E, the col index num would be 5, and so on. Once you've created the formulas for all of the columns, then you can copy and paste them down the rows and they will automatically update. I hope this was helpful! This site is a great way to get Excel help as well: techcommunity.microsoft.com/t5/Excel/ct-p/Excel_Cat
@worgasm
5 жыл бұрын
@@SimpleSoftwareTutorials Sally, I could kiss you right now! You have just made it to the top of my Christmas gift list (way better than the Christmas card and fruitcake lists) I have been watching countless videos and tried to follow along creating my own for 2 weeks now. I LOVE YOU!!!
@emf_eurohaus
7 жыл бұрын
Thanks for the tutorial. When I do the validation, with the list, then the source box with the way you showed in the video but forgot the = sign, when I add that = in front of the word it showed "the list source must be a delimited or reference to a single row or column" How to fix that?
@DougMeeks-oe8zn
Жыл бұрын
Now I need to have the data in another sheet to summarize?
@thomasdesanti1664
7 жыл бұрын
Great Video Sally, I am excited about experimenting with the drop down feature. Maybe you can advise me further. I would like to create a packing list for my business so I would need a drop box that contains all my customers info so. Don't have to insert name, address,etc.
@msdamd829
7 жыл бұрын
also check out about "=indirect()" in excel. this returns the 2nd level and 3d level drop down list.
@Moses4694
7 жыл бұрын
Where is the actual form it seems as though you are creating a normal spreadsheet with dropdown lists
@ynmarshmallowslilttlesiste6753
5 жыл бұрын
Thank you!
@johnm.evangelis693
7 жыл бұрын
Very good excel video Sally U. Thank you!!!
@katesnapp
8 жыл бұрын
What about price per each - and how to compute that in the form? Thank you.
@Aztshirts
7 жыл бұрын
Great video
@johnm.evangelis693
7 жыл бұрын
Hi Sally, is their a way you can scan a document and be able to edit or write info in the boxes save it and print them as you need them. (weekly)
@johnm.evangelis693
7 жыл бұрын
Thank you, I will try that!!!
@patbcsllc
6 жыл бұрын
how would i take that info and repeat it on the page multiple times?
@bradmartin6625
6 жыл бұрын
I have a question. I followed ALL your steps but when I started to change my colors, the drop down button shows nothing. Can you please help?
@MuhammadAdnan-gx6rd
7 жыл бұрын
Thanks a million tonnes :D
@MuhammadAdnan-gx6rd
7 жыл бұрын
***** would you make a video on accounting (financial statement ) (general ledger)
@MuhammadAdnan-gx6rd
7 жыл бұрын
***** thkewwwww. ...thnx
@MuhammadAdnan-gx6rd
7 жыл бұрын
***** please argent....
@joeazzala9765
7 жыл бұрын
if i want to save the details in another sheet how i can do that? thnx for the video
@magdieladames7233
7 жыл бұрын
you would need to write a macro that would log the data to another sheet.
@stellafridley3249
7 жыл бұрын
can you provide instructions for 2010? I'm completely lost
@fatdaddyflyboy5377
7 жыл бұрын
Where is your video on index and match??
@hazemmohamed02
6 жыл бұрын
if this data form about reservation for an event how i got finally a sheet with full data about all applicants ??? i hope you help me plz
@hazemmohamed02
6 жыл бұрын
Sally Ulianich in middle east not everyone can access into internet , the easy way is making a phone call to reserve Anyway i really appreciate your reply Many thanks
@robertfriesen8925
6 жыл бұрын
How do you shrink all the lines into a drop down. (No order forms or formulas) Thanks,
@robertfriesen8925
6 жыл бұрын
Great, thanks this is very close to what i was looking for. Nice and simple.
@leilowwww
5 жыл бұрын
Hi I cant hide? It only hides my window?
@thejobnet1058
2 жыл бұрын
Thanks. You did not show how to save this
@javidparsa2199
2 жыл бұрын
The video was useless, a simple exercise for writing inside the cell and formatting the cells, which unfortunately was not mastered. It was just a waste of time!
Пікірлер: 78