STEP by STEP Easy to do Task Board/Kanban in EXCEL | No VBA or complex Formula | Simple Design
This video shows you how to create a Kanban / Task board in Excel.
In this video, I'll guide you through the process of building a Kanban board from scratch. Whether you're new to Kanban or looking to improve your workflow management, this tutorial is designed to help you get started.
Kanban is a powerful visual tool used for ๐ผ๐ฟ๐ด๐ฎ๐ป๐ถ๐๐ถ๐ป๐ด ๐๐ฎ๐๐ธ๐, ๐ฝ๐ฟ๐ผ๐ท๐ฒ๐ฐ๐๐, ๐ฎ๐ป๐ฑ ๐ฝ๐ฟ๐ผ๐ฐ๐ฒ๐๐๐ฒ๐. With its simple yet effective approach, you can increase productivity, streamline your work, and achieve better results.
Thanks for watching this video on Excel for Project Management
โ
๐๐๐ข๐ฅ๐ก๐๐ฉ๐
If you did not complete the tutorial and would like to use the template please visit:
www.etsy.com/au/listing/16818...
โ
๐๐๐ค๐ฅ
My new Etsy Shop
yourlifeyourproject.etsy.com
โ
๐๐ฃ๐ก๐๐ฃ๐ ๐พ๐ค๐ช๐ง๐จ๐๐จ
๐ Use the coupon code KZread03 to get the best price
www.udemy.com/user/ben-m-21/
Some of my other Excel videos:
๐๐๐ป ๐ง๐ถ๐บ๐ฒ๐น๐ถ๐ป๐ฒ๐ ๐ถ๐ป ๐๐
๐ฐ๐ฒ๐น
โข Fun EXCEL Timelines | ...
๐ง๐ฟ๐ฒ๐ป๐ฑ๐ ๐ฃ๐ฟ๐ผ๐ท๐ฒ๐ฐ๐ ๐ง๐ฎ๐๐ธ ๐น๐ถ๐๐ ๐ถ๐ป ๐๐
๐ฐ๐ฒ๐น
โข 2024 Modern EXCEL Dash...
๐๐ฒ๐ฎ๐๐๐ถ๐ณ๐๐น ๐ฎ๐ป๐ฑ ๐ฆ๐ถ๐บ๐ฝ๐น๐ฒ ๐ง๐ฎ๐๐ธ ๐น๐ถ๐๐ ๐ถ๐ป ๐๐
๐ฐ๐ฒ๐น
โข EASY Task tracking Exc...
๐ฃ๐ผ๐๐ฒ๐ฟ๐ณ๐๐น ๐ง๐ฎ๐๐ธ ๐น๐ถ๐๐ ๐ถ๐ป ๐๐
๐ฐ๐ฒ๐น
โข STEP by STEP Task, Pro...
๐ฅ๐ถ๐๐ธ ๐ฅ๐ฒ๐ด๐ถ๐๐๐ฒ๐ฟ ๐ถ๐ป ๐๐
๐ฐ๐ฒ๐น
โข STEP by STEP Excel Sma...
๐ฃ๐ผ๐๐ฒ๐ฟ๐ณ๐๐น ๐๐ฎ๐ป๐๐ ๐๐ต๐ฎ๐ฟ๐ ๐ ๐ฆ ๐ฃ๐ฟ๐ผ๐ท๐ฒ๐ฐ๐ ๐น๐ถ๐ธ๐ฒ ๐ถ๐ป ๐๐
๐ฐ๐ฒ๐น
โข STEP by STEP EXCEL to ...
Courses/Channel topics;
Excel Dashboard Task list and Status
Learning Excel
Excel Tips and tricks
Excel tutorials
Learning Project Management
Excel timeline
Timeline chart
Gantt chart
Excel tutorial
Data visualization
Project management
Excel charting
Timeline template
Excel tips
Data analysis
Excel demonstration
Excel how-to
Chart design
Excel spreadsheet
Time management
Excel graphs
Timeline creation
Excel data visualization
Chart formatting
Excel charts and graphs
Other topics with free tutorials:
Agile
Waterfall
#ExcelProjectManagement
#KanbanBoard
#KanbanWorkflow
#TaskManagement
#ProductivityTools
#ProjectTracking
#AgileManagement
#ExcelTips
#TaskVisualization
#ProjectPlanning
#KanbanSystem
#WorkflowOptimization
#ProjectTrackingTools
#ExcelTemplates
#KanbanProcess
#TaskOrganization
#ProjectManagementTools
#KanbanCards
#ExcelHacks
#KanbanPrinciples
#TaskAutomation
#ProjectManagementSkills
#ExcelSpreadsheets
#LeanKanban
#TaskPrioritization
#ProjectManagementMethods
#ExcelWorkbooks
#VisualProjectManagement
#KanbanFlow
#TaskScheduling
ะัะบััะปะตั: 33
Awesome! Thanks for sharing. Hope to see more of these creative Excel tools that can be adapted to suit other environments. take care.
@ProjectManagementMastery
5 ะฐะน ะฑาฑััะฝ
More to come!
Great template, thank you!
Great work.... thanks for share
I was searching for something like that, with no VBA or Macro and will adapt as a Sales Pipeline!! Thxxx man!!!
@ProjectManagementMastery
8 ะฐะน ะฑาฑััะฝ
Thanks for the feedback!
great!
So great! Thanks you for share!
@ProjectManagementMastery
8 ะฐะน ะฑาฑััะฝ
Thanks!
Thank you for making it simple to create.
@ProjectManagementMastery
7 ะฐะน ะฑาฑััะฝ
You're welcome ๐
Looking for something like this for our R&D team, thanks for sharing!
@ProjectManagementMastery
3 ะฐะน ะฑาฑััะฝ
Any time!
Great tutorial. I would love if you could show how to achieve this without the filter function in an older version of excel.
@ProjectManagementMastery
6 ะฐะน ะฑาฑััะฝ
@koreankuma Thank you for the feedback. Without a FILTER function I would number each "Status" in my task list (i.e. Done 1, Done 2...) and I would use a VLOOKUP in my boards to retrieve those (one for each cell). If this is unclear feel free to get in touch via the email from the template I can provide more details...
Super useful thanks!
@ProjectManagementMastery
6 ะฐะน ะฑาฑััะฝ
Glad to hear that!
Amazing! Thank you so much! I wanted to use Jira for personal task tracking, but this became way too cumbersome.
@ProjectManagementMastery
5 ะฐะน ะฑาฑััะฝ
@neeleshgupta3491 Thank you!
nice
This is very very helpful
@ProjectManagementMastery
5 ะฐะน ะฑาฑััะฝ
Thanks for the feedback :-)
A person is determined by his deeds and actions
@ProjectManagementMastery
6 ะฐะน ะฑาฑััะฝ
Well played! You should have the template by now...
The look of the colored tab is great, but the true power of a task list would be the ability to drag and drop the task from stage to stage and this appears to instead need users to both enter new tasks and change the status on the 'Step 1' white tab instead of where you'd want to stay viewing.
@ProjectManagementMastery
2 ะฐะน ะฑาฑััะฝ
Excel allows you to do things you would normally need to have a software to develop. Of course it is not perfect, specially when you do not want to have macros or VBA, but the things you can do "for free" are amazing, I find new uses everyday.
I'm loving this!!! Is it possible to group the colours together?
@ProjectManagementMastery
3 ะฐะน ะฑาฑััะฝ
@Sh3ll834 Thanks! If you are talking about the boards color yes you can as they are hardcoded. To group the other colors you just need to change them in the Cond formatting.
This looks good! But the template link is not working :(
@ProjectManagementMastery
6 ะฐะน ะฑาฑััะฝ
@SuperWoWen It's working, still getting plenty of requests!
This looks great! Please share the template
@ProjectManagementMastery
9 ะฐะน ะฑาฑััะฝ
Thank you! The template is now only available through the link in the Description
@codecounselling
9 ะฐะน ะฑาฑััะฝ
โ@@ProjectManagementMastery, Thanks Ben! This will be useful. Nicely structured videos... Liked and Subscribed. ๐