STEP by STEP Easy to do Task Board/Kanban in EXCEL | No VBA or complex Formula | Simple Design
ฝัง
- เผยแพร่เมื่อ 30 ก.ย. 2023
- 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 TH-cam03 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
Project Management
Management
MS Project
Time Management
Scheduling
Budget
Issue Management
Issue Log
Project Management fundamentals
Project Management essentials
Project Management 101
For all my course coupon codes please visit
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
course
project manager
project coordinator
project
course
tutorial
learning
PMI
PM
PMBOK
Prince2
PMP
Training
Project Management
free training
Steering
Steering committee
Management training
Risk Management
Risk Register
Stress Management
Stakeholder Matrix
Stakeholder Management
#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
Great work.... thanks for share
Great template, thank you!
Awesome! Thanks for sharing. Hope to see more of these creative Excel tools that can be adapted to suit other environments. take care.
More to come!
great!
So great! Thanks you for share!
Thanks!
Thank you for making it simple to create.
You're welcome 😊
I was searching for something like that, with no VBA or Macro and will adapt as a Sales Pipeline!! Thxxx man!!!
Thanks for the feedback!
Super useful thanks!
Glad to hear that!
Looking for something like this for our R&D team, thanks for sharing!
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.
@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...
This is very very helpful
Thanks for the feedback :-)
Amazing! Thank you so much! I wanted to use Jira for personal task tracking, but this became way too cumbersome.
@neeleshgupta3491 Thank you!
nice
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.
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.
A person is determined by his deeds and actions
Well played! You should have the template by now...
I'm loving this!!! Is it possible to group the colours together?
@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 :(
@SuperWoWen It's working, still getting plenty of requests!
This looks great! Please share the template
Thank you! The template is now only available through the link in the Description
@@ProjectManagementMastery, Thanks Ben! This will be useful.
Nicely structured videos... Liked and Subscribed.
👍