How to Make a Flow Chart in Excel - Tutorial
Вставка
- Опубліковано 1 лип 2018
- Excel tutorial on how to make a Flow Chart in Excel. We'll review how to create a flowchart using Shapes. We'll add arrows to connect each step in the process and format each step so that the flow chart is easier to follow. We'll also add a hyperlink to a process step.
It's important to know that you can make a flow chart in other programs, like Word and PowerPoint. The benefit of using Excel is that you're not as limited by reaching the end of the page or end of the slide.
And make sure to get your FREE pdf list of top Excel keyboard shortcuts: yacostasolutions.com/newsletter/
*FYI:
This tutorial was created using the desktop version of Excel in Microsoft 365. You can upgrade to this version here: yacostasolutions.com/MS365
The screen recording + editing was done using Techsmith Camtasia. You can check it out here: yacostasolutions.com/camtasia
Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends - it really helps us out 😊
To catch our Excel tutorials as they come out, subscribe to this channel by clicking: yacostasolutions.com/youtube
Thanks!
*DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support!
#YAcostaTutorials
Thank you so much for the tutorial! It's clear and has enough detail to let me make a complicated chart.
Thank you, Kitty T. That’s kind of you to say. I’m happy this was helpful to you 🙂
Very helpful, concise and well taught. Thank you!!
Thank you, Cynthia. I really appreciate the compliment 🙂
I used it years ago and this was great incorporating the basics and what new Excel has to offer. Thanks
That’s great that this has helped you for so long! Thanks so much 🙂
Thanks you :-) short as it should be and yet it contains all the essential we need 👍
Thank you so much 🙂 Glad you liked this!
This is perfect. I think I can do this. Thank you!
Great video! Thanks for the helpful hints.
Happy you enjoyed it and thank you for the kind words 😊
Thank you for this clear and helpful tutorial.
Thanks, John. Happy it helped you 🙂
Simply brilliant. Great tutorial. So helpfull.
Thank you so much for the high praise, TheShatteredSword 😊 Happy this was helpful for you!
Thank you so so much your video gave me all of the solutions that I wanted within only 7:56 mins. Bravo!
Awesome! I’m happy this was able to help you 🙂
Very clear presentation. Thanks!
Thanks, profarrington! Happy you enjoyed it 🙂
Thank you so much. It was an awesome tutorial.
Thanks, Gaurav! I’m glad you liked this 🙂
This was brilliant! Thanks a lot
Thanks so much, chino 8666 😊 I'm happy this was helpful for you!
Thank u .. u have been so helpful
Thank you, Ibra Al sahil. I really appreciate your comment. Happy you enjoyed it :)
thank you for this, very helpful! This will save me a lot of time building new flow charts now I no longer have access to Visio.
That's awesome! Visio does have some tricks that Excel doesn't, but there's so much you can do with Excel. I'm happy this was able to help you!
Give me some more videos
Thank you so much. This was very helpful. Following!!!!
Thanks so much, Janice! I'm so happy this helped you🙂 Welcome to the club!
Thanks for your help. It was easy to follow.
Glad it helped, Braidys! 🙂 Thanks
I think my presentation content will be beautiful because of you. thanks.
I hope it went beautifully, Adan! Thanks so much 🙂
Thanku sister.. Very helpful
You're very welcome and thank you for watching! Glad you found it helpful 🙂
Great tutorial. Thank you!
You're very welcome! Glad you enjoyed it 🙂
Clearly explained..thanks
So nice of you 🙂 Thank you!
Really very very helpful and thank you so much.
Thanks so much, Sudheer! I’m so happy this helped you 🙂
Extremely helpful. I did not want to pay money for a flow chart program! Thank you!
I’m happy this was helpful for you 🙂 To be fair, the flow chart programs are more robust, but you can still do a lot with just a spreadsheet. I hate spending money if I don’t have to too. Thanks!
Great video. I'll be honest, the thumbnail put me off clicking on this video ( I think it was the grey colour used ) but it's one of the better demo's I've seen. Many thanks.
Hi, Ian and thank you. I really appreciate your feedback. And, yes, the thumbnails are something I've been experimenting with - between you and me, I don't much like them either... 😉
verry helpfull thank you so much.
Thanks so much! I’m happy this helped you 🙂
Thanks for teaching me this program
I'm happy you found this helpful, Anthony! Thanks so much for commenting 🙂
Informative and easy for understanding.
Thanks so much! I’m glad you liked this 🙂
Excellent essential knowledge video. Thank you
Thanks so much! I'm glad you liked this 🙂
This was awesome!
Thanks so much, Jazimine! I’m happy this was helpful for you 🙂
great tutorial thank you so much
Thank you so much! I’m glad this helped you 🙂
✅Good overview with some great little tips too 👍
Thank you 🙂 I'm happy you liked this so much!
Really useful, thank you ;)
Thanks so much! Glad this helped you 🙂
Thank you for information and tutorial video is to useful.
Thanks, Isidro! I’m really happy this helped you 🙂
Well said. Thanks
Thank you, Sudhansu. I'm happy you liked this 🙂
Thanks. This was helpful
That’s great, Steven! I’m so happy this helped you 🙂
You made my life easier. ❤
Happy to help 🙂 Thanks so much!
I loved it
Thanks so much, Fadi! I'm happy this helped you 🙂
Great Video!
Thanks so much, Megan! I’m happy you liked this 🙂
Thanks a lot😊
Thank you! I’m so happy you liked this 🙂
Thanks so much
Thank you! I’m glad you liked this 🙂
Wow thanks
Thank you! I'm so happy you liked this 🙂
Simple and helpful . Just the way I like
Thank you, Devarshi. Thank you for the compliment 🙂 I'm happy you found it helpful
Much love
Much love back at you ❤️ Thanks so much 🙂🙂
Hi ... this was really helpful ... Thank you so much ... God bless
Thank you, Laurendo Joseph. This is kind of you. I'm glad you found it helpful 🙂
nice
Thank you so much; am making a flow diagram for work with key binary decisions to be made so this is excellent. Nice and simple and yet so informative. You have a gift. So nice to learn in bite-sized chunks.
Thanks so much, Jacqueline! I'm so happy this helped you 🙂
Hi. Thank you for this help. But can I know if the connector automatically connects only in excel or is there a way to enable that in word too? Because I tried it in word and it doesn’t automatically connect. I would like to draw my flowchart in word so that I can adjust my pages
Hi, Hafiz. This was tricky! If you're using Word, you need to first create a New Drawing Canvas, then insert your shapes inside the Drawing Canvas. You'll find this at the very bottom of the Insert Shapes drop-down. FYI, I tried this with existing shapes and couldn't get it to work. I found I had to insert new shapes AFTER adding the Drawing Canvas.
I found this tutorial from Make Use Of that I think you'll find helpful. Note, that they begin by creating a flowchart using SmartArt, then follow that with the Drawing Canvas option. Here is the link: ua-cam.com/video/iiS7aAFI2Cs/v-deo.html
As a side note, if you're using Excel 2007 or newer, you can use the Page Layout workbook view to more easily see where your page begins and ends.
I hope this helps with what you're looking for. And thanks!
Great
Thank you! I'm happy you liked this 🙂
Excellent. Just saved me a bunch of money
Hi, William. Glad you found the tutorial helpful. The bill is in the mail (j/k) 😉
Thank u for usefull tutorial
How can I delet a shape or arow ?
Hi, Khaled. You can select it and press Delete. You can do so either from the writing pane or directly in the flow chart. Thanks and hope this helps.
Thank you so much! Do you perhaps know how you can transfer this flowchart to a new Word document? Because I have a school assignement where I HAVE to make a flowchart in Excel and then add it to a word document, but my professor needs to know I made it in Excel and not in Word. Any help? I hope I was clear 😅
I believe you can insert an excel worksheet within word.
Great! Thank you very much for your technique. I would like to use it as a documentation standard for our organizational processes so all can be done without leaving Excel :) It would be very useful if you could let me translate its captions to Spanish, because not all my colleagues understand English. So I could show it to them to learn.
Hi, Daniel. This is such a big compliment, thank you! I've turned on Community Contributions for this tutorial. And please let me know if you have any questions or need additional help with anything else for your project.
Hi bro, how to show documentation process..in this chart
learning
how we make flow chart in images ? not words
please make more videos like this, thanksss
Thanks, Jeremy! Taking a short break while we focus on some website updates, but new videos will be coming back soon 🙂
Useful .. Thank you
Thank you 🙂 Happy it was helpful for you
Thank you
Thanks, Reena! 🙂
Thank you for the video, really amazing, the only thing that I'm facing now is how to export it to a PDF or Image format, since the whole chart is larger than an A4 size. I have tried to save it to PDF format but only half of my chart being save.
Hi, Lucas. When you save it as a PDF from Excel, it will be saved as it would display on your Print Preview.
So, in Excel, format your print area as you prefer (including any page breaks to a second page, if necessary) then save as PDF. You'll find options to format your print area in the Page Layout tab.
The margins can sometimes be a bit sensitive when saving to PDF. I usually advice people to use 1" margins, but you can try smaller, just double check your PDF for anything that may have been cut off.
@@YAcostaSolutions wow.. Appreciate it. Thanks for the reply. I will try it out soon. So far what I'm doing is to select all my chart and then save it into image (right click option when selecting all charts) Thanks a lot.. Looking forward with your videos. =)
Thanks
Thanks, Pete. I’m happy this helped you 🙂
Why we are doing that in excel instead of PowerPoint? Any thoughts?
Hi, Anas. Hi, Anas. Like with org charts, Excel can be a good option for Flowcharts if you need the extra room as you don't have limitations like reaching the edge of a slide. Some people also like including them in the same workbook as other sheets they may have.
Like this tutorial? Make sure to grab your FREE pdf list of top Excel keyboard shortcuts: yacostasolutions.com/newsletter/
Hi I am interested to learn how i get Microsoft excel without pay
Hi, Ahmer, both the Excel mobile app and Excel online are free to use. You'll need to create an account to use them, which you can do for free. Just be aware that these versions of Excel have some limitations as far as how robust they are. Once you download the app, you’ll have an option to create an account. Thanks and hope this helps!
Yes and no are not linked. I prefer making yes, an 8 point green line and no, an 8 point red line. I make them wider so the colour is more pronounced.
video
Why do you need to have the competency in creating process flow chart?
Some people need to make Flow Charts. Just depends what you need to use Excel for.
Thank you 😊 I really appreciate it.
I know how to make a flow chart now
I'm happy this helped you, Fadi 🙂 Thanks!
Cant understand sis dude