MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 28 lectures (1h 27m) | Size: 610.8 MB
Learn how to build a project tracking "Gantt" Chart!
- 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
- Milestones
- Tasks
- Assignees
- Dependents
- Pattern style
- Border
- Data Validation
- Transparent chart
- Overlapped chart
- Form
- Calendar Date Picker
Learning Objectives
● 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
Office workers, Professionals, and Managers
DOWNLOAD
uploadgig
rapidgator
nitroflare
Feel free to post your Excel Magic 9: Building a Project Tracking "Gantt" Chart Free Download, torrent, subtitles, free download, quality, NFO, Dangerous Excel Magic 9: Building a Project Tracking "Gantt" Chart Torrent Download, free premium downloads movie, game, mp3 download, crack, serial, keygen.