The Complete Excel Course with AI Integration
Build a task tracker in Excel with a Gantt chart
A good task tracker tells you what is overdue, what is urgent and how many working days are left, without anyone chasing. TaskFlow, the industry-standard tracker you build in The Complete Excel Course with AI Integration, does all three: from a raw task list you make drop-downs, rules that flag urgent work, progress bars, a Gantt chart and counts of working days left and days past due. Designed after talking with people from many different industries, it needs nothing but Excel, and every formula is yours.
Taught by Sagnik Bhattacharya and Virginia Thorn
What you will be able to do
You will be able to:
- Turn a raw list of tasks into a tracker people can scan: a coloured header row, Freeze Panes on the headers or task IDs, and progress shown as percentages.
- Give Status and Priority drop-down lists drawn from a list sheet, so everyone picks the same values and one edit there updates every drop-down.
- Write formula rules with AND and a locked column that mark unfinished high-priority tasks and shade high-priority work that is under half done.
- Show progress as solid data bars and priority as icons, through a helper score that turns High, Medium and Low into 3, 2 and 1.
- Draw a Gantt chart from start dates and planned working days: stacked bars with the start bars hidden, tasks top to bottom and a date axis fitted to the project.
- Work out the working days planned and left with NETWORKDAYS and TODAY, count the days past due on every overdue task, and protect the sheet and the workbook's structure.
Projects
What you will build.
The course has 14 industry-standard projects. These two matter most here.
-
Project 07
TaskFlow
One sheet that shows what is done, what is late and what is urgent.
The tracker this page builds, from a starter workbook of raw task data: owners, dates, status, priority and progress that flag their own problems, then a stress test before anyone relies on it.
-
Project 03
Sales Goal Tracker
Built around sales targets, it is where IF, nested IF, IFS, AND and the date functions are first practised: the logic TaskFlow's highlight rules and countdowns are made of.
Lessons
The lessons that matter, in course order.
The Complete Excel Course with AI Integration has 186 lessons. This page picks out 20 of them, 1 h 44 min of video. Each lesson keeps its number in the course.
Where to start
Lesson 79 TaskFlow project tracker in Excel
Start at Lesson 79 if IF formulas and drop-down lists already feel familiar: the TaskFlow starter workbook is ready and the tracker grows lesson by lesson. New to formulas? Begin at Lesson 10, or at Lesson 1 if Excel itself is new. Once it is built, Lesson 94 has Copilot and ChatGPT apply highlight rules from a prompt.
20 of 186 lessons · 1 h 44 min
01 Microsoft Excel fundamentals: building a foundation from scratch Dollar signs and F4 on a small tax column: why a copied formula drifts, and the mixed references that lock only the column, which every TaskFlow highlight rule depends on.
- 10 Relative vs absolute references in Excel Dollar signs and mixed references 3 min
02 Project: personal budget tracker Conditional formatting at its simplest: a Greater Than rule that colours every large expense, and the menu that also holds the data bars and icon sets TaskFlow uses.
- 15 Conditional formatting in Excel Highlight rules, data bars and icon sets 3 min
04 Essential formulas and functions (IF, SUMIF and more) A comparison that answers TRUE or FALSE, then IF turning it into pass or fail on a class's marks: every highlight rule in TaskFlow is a test of this kind.
- 28 Logical functions in Excel TRUE and FALSE comparisons for beginners 5 min
- 29 The IF function in Excel Pass or fail results with a single condition 3 min
04 Essential formulas and functions (IF, SUMIF and more) Nested IF and IFS for more than two outcomes, down to high, medium and low deal priority, then AND and OR for rules that weigh two conditions, all on sales data.
- 31 Nested IF and IFS in Excel Customer value tiers with nested IF 6 min
- 32 Nested IF and IFS in Excel Sales performance labels with the IFS function 5 min
- 33 AND and OR with IF in Excel Flag high-value deals with multiple conditions 8 min
04 Essential formulas and functions (IF, SUMIF and more) Dates as numbers: days since a sale with TODAY, the month with MONTH, a follow-up date by plain addition and a live stamp with NOW, the arithmetic behind days past due.
- 39 Date and time functions in Excel TODAY, NOW, MONTH and date arithmetic 6 min
05 Text functions and data validation (enhancing data quality) A drop-down list made with data validation, its values kept on a separate sheet and spare rows covered for future entries, practised on a department column.
- 45 Data validation in Excel Create drop-down lists for consistent data entry 4 min
06 Data visualisation: charts and graphs The Format pane in depth on a bar chart: gap width, fills down to No Fill and borders down to No Line, the very settings that turn stacked bars into a Gantt chart.
- 53 Formatting charts in Excel Titles, data labels, colours and chart styles 7 min
08 Advanced Excel functions: lookups, text and arrays TODAY, EOMONTH and NETWORKDAYS on a short list of tasks with start dates and deadlines: the days until each deadline and the working days between two dates.
- 74 TODAY, EOMONTH and NETWORKDAYS in Excel Date calculations for HR data 5 min
09 Project: task automation with data validation and forms TaskFlow from raw list to tested tracker: layout and frozen panes, Status and Priority drop-downs, formula rules that highlight urgent and overdue tasks, the Gantt chart, data bars and icon sets, working days left and days past due with NETWORKDAYS and TODAY, sheet and workbook protection, and a stress test with a new task.
- 79 Start here TaskFlow project tracker in Excel Overview of the task tracker dashboard 4 min
- 80 Designing a task tracker in Excel TaskFlow layout, columns and headers 5 min
- 81 Data validation in Excel Status and priority drop-down lists in TaskFlow 8 min
- 82 Conditional formatting in Excel Highlight overdue and completed tasks 8 min
- 83 Gantt chart in Excel Build a project timeline with conditional formatting 6 min
- 84 Data bars and icon sets in Excel Visual priority and progress in TaskFlow 6 min
- 85 NETWORKDAYS and TODAY in Excel Days remaining and task deadlines in TaskFlow 5 min
- 86 Protect a sheet and lock cells in Excel Secure the TaskFlow tracker workbook 4 min
- 87 Testing an Excel task tracker Stress test TaskFlow with sample data 3 min
Instructors
Who teaches it.
Instructor, Excel with AI
Virginia Thorn
Emmy Award winner. Teaches Excel with AI at Coding Liquids.
Questions
Asked before starting.
Which Excel course teaches you to build your own task tracker?
The Complete Excel Course with AI Integration from Coding Liquids does, and the tracker is TaskFlow: an industry-standard project you build yourself from a starter workbook of raw task data. You finish with Status and Priority drop-downs, rules that flag urgent work, progress bars, priority icons, a Gantt chart, the working days left on every task, the days past due on every overdue one and a protected sheet, with the finished TaskFlow to check each step against. The 20 lessons on this page take you there in 1 hour 44 minutes of video, from locked references to a tested tracker; lifetime access covers the day your tracker needs a new column, and a Certificate of Completion follows when you finish the course.
How do I make a Gantt chart in Excel?
With a stacked bar chart, the way The Complete Excel Course with AI Integration draws TaskFlow's timeline (Lesson 83). Select the task names, the start dates and the planned working days, insert a stacked bar, then give the start-date bars No Fill and No Line so only the durations remain. Tick Categories in Reverse Order so the first task sits on top, set the axis minimum to the earliest start date and pick a major unit that spaces the dates well. The bars read the sheet, so a changed date redraws them, and anyone can see when each task starts, how long it runs and where tasks overlap without reading a single cell.
Can an Excel Gantt chart show dependencies or planned against actual?
TaskFlow in The Complete Excel Course with AI Integration already carries the plan and the slip: a Workdays Planned column from NETWORKDAYS sets each bar, and Days Past Due counts how far each overdue task has run over (Lesson 85). Dependencies are one formula away: make a task's start date its predecessor's due date plus one, and when the earlier task moves, every later start date, working-day count and bar moves with it. That date arithmetic is taught in Lesson 39, and Lesson 87 shows the tracker recalculating as dates change.
Why build a task tracker instead of downloading a free template?
Because your work will change, and only a tracker you built changes with it. A template is fine until you need a new status, an extra column or one more rule; then you are picking through formulas nobody explained to you. In The Complete Excel Course with AI Integration you write every part of TaskFlow yourself: the drop-down lists, the highlight formulas, the NETWORKDAYS and TODAY columns, the chart and the protection. You begin from a starter workbook, the finished TaskFlow is there to check against, and it all runs in Excel alone, on Windows or a Mac. The same build serves a to-do list, a job or assignment tracker or a team's projects: rename the columns and every rule still holds.
How do I highlight overdue or urgent tasks automatically in Excel?
With formula rules, the way TaskFlow does it in The Complete Excel Course with AI Integration (Lesson 82). Select the task rows, choose New Rule and 'Use a formula to determine which cells to format', then write AND with the column locked by a dollar sign: status not Completed and priority High, and every urgent task stands out the moment the sheet opens. A second rule shades high-priority work under 50% done, and TODAY() set against the due date in the same kind of rule lights up every unfinished overdue task. Manage Rules softens the colours so only what matters shows, and the Days Past Due column counts exactly how late each overdue task is (Lesson 85).
How do I add status and priority drop-downs to a to-do list in Excel?
Use data validation, as The Complete Excel Course with AI Integration does in TaskFlow (Lesson 81). Select the column below its header plus spare rows for future tasks, open Data Validation, allow List and point the source at a list kept on its own sheet, with Ignore Blank and In-Cell Dropdown ticked. Typing High, Medium, Low into the box also works, but a list sheet is one place to change for every row. People then choose instead of typing, so 'high', 'HIGH' and 'urgent please' never share a column again.
How do I count the working days left until each deadline in Excel?
Join IF, TODAY and NETWORKDAYS, as TaskFlow does in The Complete Excel Course with AI Integration (Lesson 85). NETWORKDAYS from the start date to the due date gives the working days planned, weekends left out. For the days left, IF asks whether today is already past the due date: if so the answer is zero, if not NETWORKDAYS counts from TODAY() to the due date. TODAY() moves on by itself each day, so the column stays current untouched, and Days Past Due, today minus the due date, appears only on overdue tasks and counts how late each one is.
Can my team share the tracker without breaking its formulas?
Yes, once you protect it the way The Complete Excel Course with AI Integration shows (Lesson 86). Protect Sheet, on the Review tab or the sheet tab, sets what others may do, with an optional password, and Protect Workbook locks the structure so nobody adds, deletes, hides or renames sheets. The lesson opens the Locked setting every cell carries, which takes effect only under protection: untick it on the columns your team updates and they keep their drop-downs while the formulas stay guarded. With the instructor support plan, questions on any of these lessons go to the instructor for two months from the day you switch it on.
Excel with AI
See the whole course.
The Complete Excel Course with AI Integration: 16 hours of video in 186 lessons, built around 14 industry-standard projects, with lifetime access, a Certificate of Completion and a 14-day money-back guarantee.
The same course
For another job, goal, level, topic or comparison.
By job
Finance and accounting
- Accountants and finance teams
- Bookkeepers and accounts assistants
- FP&A and budget analysts
- Auditors and fraud examiners
- Payroll administrators
- Tax accountants and advisers
- Banking professionals
- Cost and management accountants
- Financial controllers
- Credit control and receivables teams
- Accounts payable teams
- Financial planners and advisers
- Credit analysts and loan officers
- Insurance underwriters
- Insurance claims handlers
- Reconciliation analysts
- Treasury analysts
- Medical billing and coding specialists
- Fund accountants
- Billing administrators
- AML and KYC analysts
- Actuarial analysts
- Insurance agents and brokers
- Retirement planners
HR and office administration
Operations and supply chain
- Operations and project managers
- Procurement and purchasing officers
- Logistics coordinators
- Inventory controllers and storekeepers
- Supply chain analysts
- Warehouse managers and supervisors
- PMO analysts
- Import and export coordinators
- Production planners
- Demand planners
- Fleet and transport managers
- Apparel merchandisers
Data and reporting
Sales, marketing and customer service
Business and management
Engineering, construction and manufacturing
- Quantity surveyors and estimators
- Civil and site engineers
- Quality managers and engineers
- Construction project managers
- Health and safety officers
- Document controllers
- Production managers and supervisors
- Mechanical and electrical engineers
- Industrial engineers
- Planning engineers
- Sustainability and ESG analysts
- Maintenance planners
Retail, property and hospitality
Healthcare and life sciences
Education and careers
Public sector, non-profit and legal
By goal
- Instructor support
- Certificates
- How long it takes
- Is Excel worth learning
- A retirement calculator
- A budget tracker
- A KPI dashboard
- A budget vs actual report
- A sales goal tracker
- An employee database
- A chart dashboard
- An employee lookup
- A self-refreshing sales report
- A checking macro
- A Power Automate flow
- A compound interest calculator
- A SIP calculator
- An Excel test for a job
- A step-up SIP calculator
- Practice exercises
- Excel skills for a CV