Home / Software / How to Make a Floorplan in Excel : Microsoft Excel Tips

How to Make a Floorplan in Excel : Microsoft Excel Tips



Subscribe Now:
http://www.youtube.com/subscription_center?add_user=Ehowtech

Watch More:
http://www.youtube.com/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.

Check Also

வீட்டு வரைபடம் வரைய எந்த software பயன்படுத்துறாங்க | வீட்டு மனையின் உயரம் | நீரின்றி அமையாது உலகு

zwcad #india #housedesign Be a part of #Aishwaryambuilder If you are #architects, #Civilengineers or #contractors ...

25 comments

  1. 1.00 inch is 96 pixels yall

  2. SophizzleDalizzle

    This is pretty cool. Thank you!

  3. thank you Ted, you are a great teacher

  4. Virgelito Jr Soon

    How did u change pixels to inches?

  5. Shelia Ferrentino

    Thank you Ted. It was very helpful.

  6. Cor van der Laan

    P

  7. Thank so much for this video! Very helpful 🙂

  8. Thank you!

  9. This video are too many explanation and many step, its too boring not simple as like that aplication floor plan creator (fpc) by developer. I need you help us to try a make easy that fpc can take by screenshot or video from android or convert by another aplication just simple and we can explore by anything.

  10. Well done!

  11. Very clever, but probably too clever. You'd be a lot better off learning how to use SketchUp or some 2d drafting program that can produce the output you want.

    It depends on why you want to draw a plan in the first place, but you probably want to do more than just document where (to within one foot) the walls are/will be. SketchUp will allow you to create a 3d model, complete with doors, windows, furniture and roof so you can visualize what it actually looks like. https://duckduckgo.com/?q=SketchUp&iax=images&ia=images

    My experience has been that it can be extremely frustrating to use an inadequate drafting program. You want to choose the most complete program that you still find intuitive to use. SketchUp is about as intuitive as it can be. Preferably it should have a catalog feature where components such as chairs and tables, toilets and vanities can be stored so you're not constantly reinventing the wheel. SketchUp is a general purpose 3D program. If you look around the internet you may find a program that will work even better for your needs.

  12. I use the same process to map cemeteries. However, where Ted made 72 squares for a cell, which I think represents a foot, I reduce mine. I make a cell 15 square for a cell. That equals 6 inches for me. If I were to draw something as small as a house, I would probably make a cell 10 points square and have that represent a half inch. I could be much more precise with my drawing. Don’t forget you can use notes and hyperlinks as well, to show additional information. I don’t know what version of excel he is using, but you can now make 45 degree borders now. The biggest thing to remember here is, you are creating graph paper, be creative with this for anything you would use graph paper for.

  13. wtf

  14. How do I it make excel into meter

  15. Hi Ted. Old school calls Mac Macintosh huhu.

  16. Antoni Sos Grosso

    I'm amazed learning this technique leaked in this reality from a dimension where autocad doesn't exist

  17. I like OCAD (organic CAD) = pencil + paper. Maybe a ruler.

  18. thanks so much

  19. good shit

  20. Oh hang on, why if it's 20×10 did you make 12 columns, and what on earth is 8xr? you didn't explain this. Why can you just say if it's 20 feet long have 20 rows and if it's 10 feet wide have 10 columns?

  21. This is just what I was looking for

  22. Come on 😀

  23. Does anyone know how to get a true scale in excel for a site plan?
    It seem that the bigger the site plan is the more the scale gets off. I think excel is not accounting for the grid lines and it throws the cells off. Is there an option in excel to take that into account?

  24. How do you switch from pixels to inches? Think like an idiot if you're going to make an instructional video. It's like, "Step 1: create a nuclear explosion". Duh

  25. Thank you Ted. I needed that!!