How to Create a Project-Task List in Microsoft Excel

preview_player
Показать описание
In this video, I walk you through how to build a simple but powerful project-task list in Microsoft Excel!

You begin all the way from a blank workbook, and by the time you've finished, you will have an awesome and amazing tool to work with!

LINK TO TEMPLATE
If you don't want to build it, you can purchase this template instead!

RESOURCES

LEARN EXCEL OR GOOGLE SHEETS
- Google Sheets Masterclass: Coming soon...

MUSIC TRACK
Track: Ikson - Stardust [Official]
Music provided by Ikson™

TIMESTAMPS
00:00 - Intro
00:16 - Demonstration
03:01 - Build the Template
21:57 - Conclusion
23:10 - Outro
  1. Spreadsheet Life
Рекомендации по теме
Build a Project 0:10:42

Build a Project Task Manager in Notion (THE EASY WAY)

How to Create 0:23:29

How to Create a Project-Task List in Microsoft Excel

MS Project Task 0:01:47

MS Project Task Dependency

Build a Notion 0:11:19

Build a Notion Task Management System from Scratch (for 2024)

Notion Masterclass: Build 0:58:29

Notion Masterclass: Build a Task Manager from Scratch

CREATE a Project 0:16:56

CREATE a Project & Task Manager with progress bars | Free Notion Template + EASY Tutorial

How To Build 0:19:25

How To Build A Simple Project & Task Manager In Notion

Create a task 0:01:20

Create a task

Power Apps Grid 0:11:34

Power Apps Grid Control: SMART Grid for Model-driven Apps

The Ultimate Notion 0:28:59

The Ultimate Notion Task Manager Build | Start Getting Things Done in Notion

Creating project and 0:13:56

Creating project and task templates with QuickBase Pipelines

Notion: Build a 0:00:43

Notion: Build a Task Database in SECONDS 🕓

This video explains 0:04:34

This video explains how to create a recurring task in Microsoft Project

Task Management Tracker 0:16:35

Task Management Tracker in Google Sheets | Step by Step tutorial

Tips for Creating 0:03:56

Tips for Creating Task Lists

Creation and Assigning 0:05:55

Creation and Assigning of Task Calendar

Excel Task Management 0:00:16

Excel Task Management Template

STEP by STEP 0:49:20

STEP by STEP Task, Project or Activity Simple EXCEL Dashboard | Agile | Management

Motion Project & 0:03:41

Motion Project & Task Auto-scheduling Tutorial

Task Management in 0:21:53

Task Management in Coda: Step-By-Step (Free Template)

Re-thinking task management 0:09:47

Re-thinking task management systems for my ADHD brain!

How To Use 0:35:54

How To Use Notion As A Task Manager: Sub-tasks & Dependencies Tutorial!

How to Create 0:06:21

How to Create 'Task Templates' in Asana

Stephen explains how 0:01:01

Stephen explains how to create a template task using an example from one of our workspace projects!

Комментарии
Автор

I went through and made the spreadsheet in the tutorial and it worked out great! I was able to customize it with my own colors too, which was a lot of fun! I learned some new stuff with the conditional formatting (I didn't know that you could add check marks like that! I added stars to mine!). I hope that this is something we see more of because it's a lot of fun to build these and I feel like I'm learning a lot! I guess I should go check out your course then!

meaganlong
Автор

Haiii
Thank you for sharing this knowledge. Keep up the enthusiasm for creating useful content, God bless you

agasta
Автор

wow, I just discovered your channel today and I wonder why are you not getting more views, your work is awesome!

labelus
Автор

Thank you for sharing, I have one question- How do I assign multiple tasks under each project?

MrSondhisaurav
Автор

I am following your tutorial but the first Countif formula which I hsve copied aexactly as in the tutorial gives an error message - any suggestions on what might be the issue?

FatimaHusain-lvqp
Автор

It's a wonderful spreadsheet but the task-count formula sadly doesn't work for me :( I keep getting an error when I hit enter. I tried it multiple times too.
Edit : Excel uses a different list separator depending on your region. I'm not located in an English speaking country, so my list separator is ";", instead of ", ". So replacing ", " with ";" when typing the formulas solved the problem! And then all of the formulas worked flawlessly.

CelestialCookies