Excel Magic 9: Building a Project Tracking “Gantt” Chart
What you'll learn
- - to build a "Gantt" Chart
- - to make yourself the go-to-person in their office, or
- - to be well positioned for your next promotion!
- Basic Excel
- Example: be able to open one Excel file, etc.
The course is presented in four parts.
First, the course introduces the popular project tracking system in project management – the Gantt Chart, and where we can quickly get a sample of Gantt Chart in Excel.
Next, the course will refresh some basic but crucial Excel skills that will help us build a Gantt Chart in Excel. They include:
- ROUNDDOWN() formula
- Conditional Formatting: both single-element and multi-element conditional formatting
- Dropdown list
Third, we will learn how to build a Gantt Chart from scratch in three parts:
- Building a basic Gantt Chart
- Building an advanced Gantt Chart, and
- Building a “pure” Gantt Chart
Last, we introduce 2 cool Excel apps that will facilitate the data entry of Gantt Chart. They are:
- Form in Excel 365, and
- Calendar Date Picker
Course Search Keywords
- Project tracking
- Gantt Chart
- Pattern style
- Data Validation
- Transparent chart
- Overlapped chart
- Calendar Date Picker
● Understand the components of a Gantt Chart
● Recognize the basics for setting up both single-element and multi-element conditional formatting
● Discover how to build an advanced Gantt Chart with Overlapped Conditional Formatting
● Explore how to build a “pure” Gantt Chart with Overlapped Bar Chart
● Discover 2 cool apps in Excel that can facilitate data entry into the Gantt Chart
Who this course is for:
- Office workers, Professionals, and Managers
Lenny Wu was a Lecturer at Tsinghua University in Beijing, China. He also sat as an Examiner for the International English Language Testing System (or IELTS) in the 1990s. On top of these, he is an exam trainer for various high profile exams, such as GRE (or Graduate Record Examination), GMAT (or Graduate Management Admission Test), TOEFL (or Test of English as a Foreign Language), and math contests such as Euler, Gauss and Pascal. He has published books on test taking strategies.
Lenny received his MBA, Finance from The George Washington University in Washington, DC, USA, and currently is a Senior Financial Analyst with an international engineering company in Vancouver, BC, Canada.
Lenny's motto at work is "Don’t work hard, work smart". Lenny has passion in teaching how to build your own "robot" into everyday office work. He has over over 22 years working with Microsoft Excel, and he is a modeling expert in Power Query, Power Pivot, and Power BI.
Lenny is a big proponent of OCR (One-click Reporting), and SSR (Self-service Reporting).