How to Make a Floorplan in Excel : Microsoft Excel Tips

Подписаться 499 тыс.

Просмотров 1,9 млн

50% 1

Subscribe Now:
ru-vid.com_c...
Watch More:
/ ehowtech
Making a floorplan in Microsoft Excel is a lot easier than you probably think it's going to be. Find out how to make a floorplan in Excel with help from a mechanical engineer with 32 years of experience in this free video clip.
Expert: Edward Russell
Filmmaker: Patrick Russell
Series Description: Microsoft Excel is a powerful database and spreadsheet tool that is an important part of the Microsoft Office productivity suite of software. Get tips on how to best use Microsoft Excel to its full potential with help from a mechanical engineer with 32 years of experience in this free video series.

Наука

Опубликовано:

4 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 398

@maliadavidson7305 5 лет назад

Thank you! I was looking for a simple and clean way of my creating a floor plan. This is way better than my drawing lines and measuring on paper.

@jdhspeedify 6 лет назад

Thanks...forgot all about Excel for simple drafting. Like Dive Like Junk mentioned, there are options for diagonal lines as well; you can also rotate the text how you like and choose where on the square to place it. Another way to open that option window without having to scroll all the way back and forth, is to right click on the highlighted area in windows or open the drop menu in Mac, it will be in the list. That same list also has where you can set the rows height and column width by just entering the number value if you don't want to drag it. Very helpful video thanks again.

@tedrussell3679 3 года назад

Thanks so much for the kind words and for the tip! This is Ted in the video, and I'm always learning.

@kdubs1976 7 лет назад

I was looking for a simple way to make office floorplans for all of our clients, and this was simple and easy! Thanks!

@HansEisenman 6 лет назад

A simple and useful "hack" for doing a quick floor plan. This helped me. I just needed to do some rough comparisons between two offices and whether furniture in one would work well if moved to the other. To do that requires a to-scale method of drawing out the spaces. This worked wonderfully. Thanks for putting it together.

@ThaSaltyDawg 8 лет назад

Very Interesting. I never thought about using Excel for creating floor plans. After watching your video, I created some VBA modules to autocreate and made it easier. I'm still working on the modules to get it just right, If it works as i expect I might come back and post a link to it if anyone is interested.

@fotkamamatv3041 5 лет назад

Please upload ur f plan with VBA....

@sasafie 4 года назад

Yeah... Its already 3 years..

@tedrussell3679 3 года назад

Hi Jimmy. That is really good to hear. It's now 2021. This is Ted in the video.

@charleneduke7855 4 года назад

I am currently enrolled in an online Facility Planning course that requires me to design a healthcare clinic floor plan. I was convinced I was going to fail this class because I had no clue where to begin. I logged onto you tube and searched how to create a facility design using excel and this video emerged. This video gave me the necessary knowledge to execute my assignment and pass the class. Thank you for your post.

@freeholdcottage5508 9 лет назад

Thank you so much. I need to show a floor plan for fire personnel (if necessary) for a residential home and this has just showed me how! Thank you again!

@kalingahhh80 7 лет назад

Thank you very much Ted. Very simple but useful instructions.

@mail06513 5 лет назад

Didn't even think of using the border option in excel for drawing floor plans. Very cool.

@sparkparker 7 лет назад

This was super helpful! Thank you so much for posting! Airbnb requires me to post a floorplan. The online software programs I found were way too complicated. This is perfect.

@muoshoo1 10 лет назад

Yes very helpful...I am doing this for a class...and it was very easy and simple...thank-you!!

@Iron-Bridge 8 лет назад

Thanks! Very useful video as I need to come up with a simple floor plan to assist with an Indoor Air Quality investigation for a building.

@maleekmullings3501 5 лет назад

Thank you for making this man, really helpful looking to build a lil building to start up a business, this video has giving me a better understanding how to use excel for a floor plan

@justiceisstupid 8 лет назад

I love the internet. You're never too old to learn something new. Of course he was using an older version of excel and that's what I hate about Windows every time they do an upgrade you have to learn where everything is all over again. Thanks Ted for the lesson.

@fernandosanjose8691 8 лет назад

My father is very busy to do my floor plan assignment. Thanks Ted now I can do it on my own!

@StaxxxInMyJeans 8 лет назад

Very useful tutorial. Easy and fast design tool for simple projects, that's what I need!

@nancyermert9683 5 лет назад

Thank you! this was easier than I expected, your instructions were easy to follow , I'm not computer savy, but I actually did it! you made my day! Thanks!!

@flakenify 9 лет назад

Your brilliance is in the simplicity. Thank you.

@tedrussell3679 3 года назад

Thanks so much, Jane. That is SO true. I'm Ted in the video.

@missy13april 4 года назад

Thank you. Just managed to put my ideas together using excel before my architect comes to have a look around. Thanks again

@matthewsaint6095 6 лет назад

I had to a floor plan for a retail business, for my Marketing classand I did not know how to do it. So I googled how to create a floor, and this video popped up. I know now how to do it. Thanks!

@judiadams1788 7 лет назад

Thank you Ted. You just saved me $100's of dollars I was dreading having to spend on an office floor plan app. All I need is something simple such as this to start. Thank you for sharing.

@luvtheno 10 лет назад

Thank you Ted! You've been very helpful!

@tedrussell3679 3 года назад

Thank you, Janice! I really enjoyed doing these video, which my son produced.

@weevictor4906 6 лет назад

Thank you so much Ted. I is very useful. simple and to the point without all the confusing computer jargon.

@mikomartinez1 10 лет назад

Great. Thanks for the valued assistance made! More Power!

@jeniferamajuoyi2334 5 лет назад

this is super helpful and who is watching this in 2019?

@azazkadiwala 4 года назад

Jenifer I am

@fodank 4 года назад

I am. Excel is easy to work in an this is a useful, simple tool that avoids all the BS of other online drafting programs. Thanks Ted. Cheers, D.

@VitorEmanuelOliver 4 года назад

2020, you’re living in the past D:

@tedrussell3679 3 года назад

@@VitorEmanuelOliver This is Ted in the video, and it's now 2021. I'm just checking these comments for the first time. So nice to hear people are still watching it.

@tedrussell3679 3 года назад

Hi Jenifer. This is Ted in the video, and it's now 2021, and I"m just checking all the comments for the first time.

@Tboorohn 9 лет назад

Thank you. Fantastic idea. BRILLIANT!

@greenblood5640 4 года назад

It's só simple and yet so helpful and not known by many people, great video

@bonganibrianmpanza106 5 лет назад

Wow it is interesting, thank you for this video. and im one of the young people who are interested in creating floor plans by watching this video im very surprised that you made things more easier to create floor plans by using the famous software it was unexpected to me.Thank you so much

@SammieTheChickenLady 8 лет назад

this helps me a lot thank you

@cherylglackin923 6 лет назад

To beef up your design, you can add diagonal lines, doors, furniture, etc. by inserting shapes.

@amount2nothin244 3 года назад

Thanks for posting this. Perfect for what I needed

@katrinajames6499 4 года назад

Hi Ted, this has been so useful for me !! I come back to your quick instructions each time, thankyou!

@tedrussell3679 3 года назад

Oh wow - thanks so much, Katrina. My son produced a ton of these videos a few years ago, and I did all the Excel ones, but we're both busy with other things now. It's so nice to hear someone has watched more than one of them.

@MrRypoc 2 года назад

Great video, thanks! I think I did see a diagonal line option though, super useful.

@lockhartgmu 7 лет назад

this is great, thank you for taking the time to show me how to do this!

@faizahsallehfs 10 лет назад

THANK YOUUUU! As a student I found this very helpful! :)

@tedrussell3679 3 года назад

Hi Faizah. Glad it was a help! This is Ted in the video.

@bonitaohyea9258 5 лет назад

Thank you! I just learned something fun and very useful!

@DeltaMuse 11 лет назад

Thanks You helped so much! Had to do this for an assignment!

@yurigottesman8781 9 лет назад

Amazing video! Thank you so much for explaining this so well.

@rogerr6534 5 лет назад

1.00 inch is 96 pixels yall

@SixDegreesOfGeek 4 года назад

Huge thanks for this info.

@therealestateslayer 4 года назад

Thank you too.

@yukadiangelo 4 года назад

THANKS

@Skxll007 3 года назад

thnx very helpfull :)

@Homer482976 3 года назад

And 38 pixels is a centimeter for the other 95% of the planet ;-)

@therealestateslayer 4 года назад

Thank you Ted. I need to make an outline of a hotel suite my charity group is using for a green room. The room has all kinds of nooks and crannies, this is soooo helpful.

@tedrussell3679 3 года назад

Oh wow - that is so nice to hear! This is Ted in the video.

@pluzsizebeauty09 5 лет назад

Great video. This was what I was looking for. Thank you.

@alexanderboaza8900 4 года назад

Thank you so so much. Now I have somewhere to start!

@mariaeverson7246 9 лет назад

Most Helpful, Big Thank you..

@ReneeVanDohren 9 лет назад

Thank you so much! You've helped me greatly with an assignment!!

@begood5294 10 лет назад

thanks for your time sharing your knowledge..I.appreciate it much...very helful

@clfung2008 4 года назад

Interesting , very helpful ! Thanks for sharing and looking forward for more of your contribution ! Thanks !

@blange 11 лет назад

PERFECT! Thank you thank you thank you

@tanikapatrick6795 8 лет назад

This was very helpful! Thanks Ted!

@lifetalkz4548 7 лет назад

Good information Ted for a quick floor plan. Thanks.

@divelikejunk8557 9 лет назад

Hey, this is a very helpful tutorial, but you were wrong about the diagonal lines. Excel can make diagonal lines. In the Border options you can see them as clickables on the bottom left and bottom right corner of the options.

@christinatorres4910 10 лет назад

Very grateful for this video helped so much with my project! Much thanks Mr.Ted (:

@cowboieprince3335 8 лет назад

took Mechanical Drafting back in the 60's. Forgotten how to draw....this video was great as a starter video. Thanks for the post it really helped me to get an Idea of where to begin in my Dream Floor Plan.

@lanacahe Год назад

Wow this is so simple and easy to use!! Thank you

@jimmiddleton5093 5 лет назад

Great video, thank you. I was hand drawing a plan for a birdhouse and this will help 👍

@SJCordery 9 лет назад

Excellent! Like most brilliant ideas, it is simple but effective.

@jeaninebenenati6967 7 лет назад

Thanks Ted! You are a big help!

@sheliaferrentino9392 5 лет назад

Thank you Ted. It was very helpful.

@jomarmartinez4351 3 года назад

This is so helpful. Thank you very much, sir!

@PattyRosasWorldofReggae 10 лет назад

VERY HELPFUL THANK YOU VERY MUCH!!!

@yangliu8338 9 лет назад

really great tutorial, thank you!

@sistasaturn 5 лет назад

Thank so much for this video! Very helpful :)

@Koumondji 6 лет назад

Thanks, Ted. I appreciate the information. Very helpful to me...

@lindam2642 8 лет назад

Thanks Ted this was a tremendous help!

@dirkdigler8992 4 года назад

Found this very helpful for the new build

@cobamietvuonseattlewa1490 3 года назад

I would like to make rectangular shape with a partial of a foot like 2 1/2 x 3 3/4. How do you draw that using Excel? Thanks

@alandsouza2421 Год назад

You nailed it man. Wish excel would allow some diagonal lines as you mentioned. Curved lines would also help :)

@marksmith8290 5 лет назад

Ted - Great video and instructions - thanks for taking the time to do this

@tedrussell3679 3 года назад

Thanks, Mark. This is Ted in the video. My son produced a ton of these back in 2012, and I did all the Excel ones. I really enjoyed doing them.

@shaileshpankhania 6 лет назад

Simply Thank you Ted from Malawi

@tedrussell3679 3 года назад

Hi Shailesh! I'm so glad someone so far away found this to be helpful. I wish you the best. - Ted

@agusrahmanudin812 10 лет назад

Really help, thank you Mr. Ted

@christianbool4266 11 лет назад

Thank you! This helped me.

@soniczest1 6 лет назад

Fantastic video and super useful. Thanks Ted.

@TepantorerpothebyMdAbdussalam 5 лет назад

thank you MR. Ted :)

@nnhutube 9 лет назад

Good Technique. Very Useful. Thanks.

@noturdaddyblameyomomma8354 6 лет назад

...another use from one of my all time fave softwares, thanks!!

@mahala77 5 лет назад

thank you Ted, you are a great teacher

@tedrussell3679 3 года назад

Thanks so much, Mahala!

@xhoxhajfeta5166 3 года назад

Thanks Ted, Simple and useful explanation.

@columeshg4194 7 лет назад

Great Ted. Thank you!

@MrSkribanto 8 лет назад

I've learned something new today.

@berylmagwa7860 10 лет назад

Thanks Ted, this was very helpful

@Sandlot1959 6 лет назад

That was very helpful, Thanks!

@hillaryirungu5055 4 года назад

thank you. it works magic.

@carlosquintanilla956 8 лет назад

thank you this was helpful.

@kimberlyjohnson2795 9 лет назад

Wow! Thanks

@TedChastain 6 лет назад

Hi Ted. Ted here. This video was exactly what I needed. Thank you so much!

@tedrussell3679 3 года назад

Hey, Teds are the best. :-) So glad I could help another Ted!

@NelsonRoodfromFlorida 5 лет назад

Thank you Ted. I needed that!!

@tedrussell3679 3 года назад

Glad it helped, Nelson.

@waynemurray2966 10 лет назад

Cheers Ted - very helpfull and easy to use!!

@possingham1 7 лет назад

Thanks Ted, most useful.

@muhammadumairfelix8927 8 лет назад

thank you very much..really helpful

@davidkei2114 4 года назад

Thank you for your guide!

@alittax 11 месяцев назад

Excellent explanation and presentation!

@adannysyuhada429 9 лет назад

Thank You for sharing.. It's really helpful and useful for me... ^_^

@vinodshand 7 лет назад

Thanks a lot. That was very helpful.

@teenawallace1251 7 лет назад

Thank you Ted!

@howardtran5904 4 года назад

Thank you very much for this useful information.

@dannylopez4475 10 лет назад

Thank you ted!!!

@playlist3319 7 лет назад

awesome...i learned from this video two thumbs up

@anglerperakterkumpautersakiti Год назад

Thank you, simple but very usefull and accurate

@sahntlewilliams5800 4 года назад

this was so helpful thank you ted

@darrengodkin 11 лет назад

Great tutorial.. Thanks!

@MichaelRehfeld 10 лет назад

Great Thanks Ted!!