From the course: Excel for Project Management
Join today to access over 24,900 courses taught by industry experts.
Creating the Gantt chart - Microsoft Excel Tutorial
From the course: Excel for Project Management
Creating the Gantt chart
- [Instructor] Okay, so let's create our Gantt chart dashboard. So I actually added something extra in here, the status report, and this is going to change our formula just a little bit, so just follow along with me, but we're also going to gain some interactivity. So what I'm going to do is I'm going to type in, starting in cell D10, I'm going to type in a let. So let allows you to create a formula and then give it a variable name within that formula and you get to keep doing that except for the last line of the let is whatever you want this entire formula to return. So if that doesn't quite make sense, just follow along, don't worry, it'll all come together. So I'm going to type in equals let. Then I'm going to do a Alt+Enter on my keyboard. That puts me at the next line, one, two, three, four to indent. And I'm going to type in IsBetween, that's going to be the name of my variable, and in this case it's going to be and. We're going to use the and. We're going to test whether this…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.