How to make a Kanban Board in Excel

👍 Ready made and ready to use.

How to make a Kanban board in Excel, with movable dynamic Kanban cards you can move across your Kanban board. Great for your Agile team or your next project!

Timestamps:
00:00 Kanban board introduction
01:08 Backlog list, getting started
02:09 Kanban heading and colours
02:41 Kanban Columns
03:14 Setting up the Kanban card sizes
04:41 Adding data to the cards
05:40 Hiding blank titles
07:19 Kanban column borders
08:12 Adding the cards to the Kanban board
09:45 Final Kanban board

#ProjectManagement #Excel #Agile

[PaulMannering-vd]

That was cool.
I also added an Assignee: column to the backlog tab, and as part of the automatic update to the Kanban cards - the Assignee field also puts the name in for whomever is assigned the task.

[arihantprasad]

One of the best tutorial on creating Kanban board using excel.

[hmnc]

You're actually a genius with excel man. Insane how you manage to do this stuff.

[defaultname]

One of the better educational + step by step video tutorials on using Excel for project management. Easy to follow, comprehensive explanations, step by step process, and much appreciation!

[MrWLJ]

Linked Picture! Brilliant!!! The options for dashboards now are infinite! Thank you

[tibibara]

Great Tutorial! Thanks!
Just one reminder, the paste linked picture feature uses the camera tool and unfortunately the shared files on the cloud doesn't handle it, so that means it only works on the desktop version of excel without sharing the content.

[azr]

so nice as an aussie to hear another aussie accent

[tuckerview]

best YouTube I've watched in a long while! Thanks!

[KeyserTheRedBeard]

most excellent video David McLachlan. I broke that thumbs up on your video. Always keep up the amazing work.

[aquaterrafootage]

McLachlan is better than any professor I had in college

[franckyahi]

Super, I didn't know the past as image. Great

[maurocroci]

Very simple and good explained. And works perfect for my needs. Thank you very much. 👍👍👍

[brentgarret]

Very well explained! I mostly use Kanban board template I have on Google sheets though. Thanks for the tutorial!

[MazUKQ]

This is one of the absolute best tutorial videos I've seen and seems to be the answer to my prayers regarding organising my cluttered and disorganised life. Love it man! Learnt a few nifty Excel tricks as well! Nice 👍🏻🙏🏻👍🏻

[lotuspoetisse]

I ABSOLUTELY LOVE YOUR VIDEOS!!!!?❤🎉❤🎉❤🎉❤🎉❤🎉🎉

[Viasatoninternet]

Great video David, many thanks! Works like a charm.

[Bloodfire]

Ok, so I played with the idea you created here some, testing it's application in combination with some mixtures of "IF", "LOOKUP", and "IFERROR" formulas.

There is some huge potential for removing some of the heavy double- and triple-workload when it comes to creating new cards. That can be sped up and automated with a duplicate table that utilizes the formulas with data list drop downs. The cool part is where you COUPD have several hundred pre-loaded cards' data ready to go ahead of time. That part one-ups my own version of the Excel Kanban situation, lol.

The problem with this comes in when you create ten or more of the cards, tho. Whether automating or not, it's still clunky and slows Excel down a LOT. Could certainly be useful in smaller applications tho, especially in pages where you don't want to accidentally edit something but want it to update.

10 to 15 cards seems to be pushing it, although pre-loading 100s of fields was awesome.

However, something very interesting came to light. You can do a linked picture of the Kanban board that already HAS a linked image sitting ON it. The nested, second image will reflect the first card's location: whenever you move it, the nested image will show it has moved. It's a little awkward, tho, as column width will cause the alignment to be off when you place that new picture somewhere on the original.

BUT. Another cool thing: If you resize the original cards' cells, the rest of the cards connected to its rows or columns will be affected in the picture cards themselves. That was cool.

If anyone wants to have more than one sentence in the description of the cards, type the first line, then hit "alt" + "enter". It'll keep you inside the same cell:

"[ ] 1. Text here." (alt + enter)
"[x] 2. More text here."

Honestly, tho, an alternative for the double entry stuff is literally to just insert text boxes, color/shade/border them so they have a blurred shadow under and to the side, and you'll be able to create over a hundred stickynotes (also in a much easier fashion, with less effort on the immediate side). Just make a few colors, group them at top so you can "pull new ones off" (meaning copy/paste the blank one, fill it out, and then move it wherever). Then there is no need at all for linked pictures. You can write inside a text box, shade its background, etc. It looks quite like a stickynote when finished properly around the edges. I created formyself and used that method in college as well as during the writing of my first book, The Violet Curse. It was fun, but sometimes, as I said in a previous comment: nothing beats an actual Kanban board.

[sharifulalam]

amazing... brother. your lessons helped me a lot in my PMP exam! thank you so much

[asifchowdhury]

Awesome! Thank you so much David! Appreciated!!

[PrakashRaman]

Great tips.. Love your style of expressive elucidating