간트차트

페이지 정보

profile_image
작성자파이프가이 조회 0회 작성일 2022-05-14 10:09:41 댓글 0

본문

그래, 바로 이 차트였어! | 업무 진행상황이 한눈에 보이는 엑셀 간트차트 만들기 | 엑셀차트 8강

강의에 사용된 PPT 파일 및 예제 전문 보러가기
https://www.oppadu.com/%EC%97%91%EC%85%80-%EA%B0%84%ED%8A%B8%EC%B0%A8%ED%8A%B8-%EB%A7%8C%EB%93%A4%EA%B8%B0-%EA%B8%B0%EC%B4%88/

간트차트 자동와 양식 다운로드
https://www.oppadu.com/product/엑셀-간트차트-고급-자동화-양식/

⭐오빠두엑셀 위캔두 멤버쉽 채널을 오픈하였습니다.
https://www.youtube.com/channel/UCZ6UHYBQFBe14WUgxlgmYfg/join

00:00 영상시작
00:06 간트차트 만들기 기초
05:15 날짜를 아래쪽에 표시하는 방법
05:51 진행상황을 보여주는 간트차트 만들기

❤️ 오빠두엑셀 공식 홈페이지 : https://www.oppadu.com
엑셀 커뮤니티 바로가기 : https://www.oppadu.com/question

#엑셀간트차트 #간트차트만들기 #오빠두엑셀 #엑셀차트강의 #엑셀실무강의 #직장인엑셀 #엑셀기초강의 #실무엑셀 #엑셀강의
오빠두엑셀 l 엑셀 강의 대표채널 : ⭐️20.06.07 라이브 편집본입니다.
00:06 간트차트 만들기 기초
05:15 날짜를 아래쪽에 표시하는 방법
05:51 진행상황을 보여주는 간트차트 만들기
풀꽃 : 알고는 있으나 활용할 생각은 못했던, 이미 있는 기능으로 원하는 작업을 모두 해내는 모습이 가히 경이롭네요ㅠㅜ 역시 어떤 일이든 창의력이 필요한 것 같습니다... 덕분에 많이 배웁니다 감사해요!!
용한돌팔이 : 와..... 다른 엑셀 강좌는 예상을 하는데 오빠두엑셀은
항상 상상을 초월함.. ㄷㄷㄷㄷㄷ
작기tv : 감사합니다... 역대급이네요 설명도깔끔하시고 너무 유용한 정보입니다. !!
v ves : 와! 좋은 강의 너무 감사합니다!
혹시 홈택스 전자세금계산서와 전자계산서 매출매입관리 분석 등에 관련된 엑셀 서식은 다루실 계획 있으실까요?
회계프로그램을 사용하지 않기에 일일히 기록하는게 좀 힘드네요 ㅠ거래처가 많아서 ㅠ

엑셀 이것만! 간트(Gantt)차트, 프로젝트 플래너(Project planner)양식 무료배포! (feat. 조건부서식)

엑셀 이것만! 간트(Gantt)차트, 프로젝트 플래너(Project planner)양식 무료배포! (feat. 조건부서식)
예제 파일은 아래 블로그에서 다운 가능합니다.
https://blog.naver.com/excings/222116655517

모두 행복하세요.

엑셀- [BASIC-EASY-SIMPLE]
엑셀 실무! 이것만 기억하세요!
시중에 나와있는 책과 온라인, 오프라인! 너무 많은 정보가 있는데, 도대체 무엇을 봐야 할까?
이제는 HOW-WHERE시대! 어디에서 정보를 찾아와야 할지 알아야 경쟁력이 있는 시대를 살고 있습니다.
그런 의미에서 잘 찾아 오셨습니다.

저는 13년차 MD! 튜터 ENGINE(엔진)입니다.
실무에서 사용했던 핵심 함수와 기능들만 모았습니다.
그리고 공부는 재미가 있어야겠죠.

FUN하고, BASIC하면서 EASY, 쉽게 배우고, SIMPLE하게 단순하게 배울 수 있도록 강의를 준비하려 합니다!

감사합니다!

#엑셀 #엑셀기초 #직장인엑셀 #BASIC엑셀 #엑셀함수기초 #EXCEL #엑셀기초배우기 #엑셀중첩함수 #엑셀배우기 #엑셀기초배우기 #기초엑셀 #엑셀기초함수 #엑셀이것만 #피벗테이블 #엑셀초보 #중첩함수배우기 #엑셀BASIC #EXCEL기초 #BASICEXCEL #VLOOKUP #XLOOKUP, #데이터입력, #IF함수, #SUMIF, #SUMPRODUCT, #MID, #RIGHT, #LEFT, #LEN, #FIND, #OFFSET, #데이터유효성, #다중데이터유효성검사 #EXCELBASIC #EXCELMULTIPLE #REPLACE #LEN함수 #INDEXMATCH중첩함수 #INDEX #MATCH함수 #VLOOKUP함수한계극복 #INDEXMATCH논리 #SUMIFS함수 #다중조건함수 #엑셀표만들기 #표만들기 #INDEXMATCH중첩함수 #중첩함수 #XLOOKUP와일드카드 #와일드카드 #XLOOKUP정렬 #XLOOKUP마지막값찾기 #이름정의 #이미지불러오기 #INDEXMATCH이미불러오기 #표만들기 #견적서만들기 #간트차트 #프로젝트플래너 #엑셀간트차트 #프로젝트관리 #프로젝트일정
디오수에듀Members : 지금 저에게 딱 필요한 기능을 너무 잘 설명해 주셔서 감사합니다. 다른 엑셀 강의에서 알려주지 않은 한발짝 더 나간 프로젝트 실제 시작과 완료 확인을 할수 있어서 좋았습니다. 한가지 질문 있어 문의드립니다. 프로젝트 기준날짜에 목록이 바뀌도록 해 놓은것이 필터 기능인가요? 아님 다른 함수 기능이 연동되어 있나요? 이부분을 잘 몰라 진도 나가기가 어렵네요.. 좀 알려주실수 있을까요?
Jinsu Shin : 와 감사합니다!
조금 응용해서 회사에서 사용해야겠어요 ㅎㅎ
너무 잘만드신것 같아요
GREEDY FARMERS : 안녕하세요 너무 좋은 강의 감사합니다. 제공해주신 템플릿을 다운받아서 셋팅하고자하는데, 2021년이 되어서 B24열부터 올해 현재 달력으로 바꿧더니, 강의에 나오는 조건부서식 수식이 다 안먹습니다.. 그전에 20년09월일때 연습할때는 잘 됐는데 혹시 제가 놓치는 부분이 있다면 어떤것일까요?
김경숙 : 실무에 유익하게 사용할 내용이네요~ 너무 감사드리고 음... 연속적인 날짜도 있지만 불연속적인 날짜인경우는 어떻게 해야할까요?
회계세무로밥벌어먹기 : 와 깔끔하네여

How to Make a Gantt Chart in Excel

Learn how to Make a Gantt Chart in Excel, including features like a scrolling timeline and the ability to show the progress of each task. Watch as I create the Simple Gantt Chart template from scratch, or download the template: https://www.vertex42.com/ExcelTemplates/simple-gantt-chart.html

Remember to Subscribe and Turn on Notifications (click on the bell)

THIS VIDEO:
0:20 Step 1 - Start with a List of Tasks and Dates
0:44 Step 2 - Set up the Timeline Labels
2:20 Step 3 - Add Initial Formatting to Style the Gantt Chart
4:05 Step 4 - Add the Bars of the Gantt Chart via Conditional Formatting
5:10 Step 5 - Make the Timeline more Dynamic
6:28 Step 6 - Add a Scroll Bar Form Control
7:20 Step 7 - Highlight Today's Date using Conditional Formatting
7:51 Step 8 - Add Columns for 'Assigned To' and Progress (% Complete)
9:07 Step 9 - Show Progress in the Gantt Chart by Shading a Portion of the Bars
11:31 Step 10 - Define Print Settings

OTHER VIDEOS IN THIS SERIES:
Check out the next videos to see how to work with workdays and weekends, how to change the display to weekly or monthly, and how to add dynamic color-coding:
https://www.vertex42.com/ExcelTips/how-to-make-a-gantt-chart-in-excel.html

GANTT CHART TEMPLATE PRO:
A Gantt Chart is an extremely useful tool for project management. You can create a very simple project plan like the one in this tutorial, but if you are a project manager and want more features such as changing the view between daily/weekly/monthly, entering the duration of a task in work days, or color-coding the bars of the chart, download Gantt Chart Template Pro:
https://www.vertex42.com/ExcelTemplates/gantt-chart-template-pro.html

GANTT CHART TEMPLATE
My original free Gantt chart template for Excel (and Google Sheets) can be found here:
https://www.vertex42.com/ExcelTemplates/excel-gantt-chart.html

ANOTHER GREAT TUTORIAL
Check out the following channel for another detailed tutorial showing how to add advanced features to a Gantt Chart in Excel:
https://www.youtube.com/watch?v=OizqFlMtZLQ\u0026t=4903s

FOLLOW VERTEX42 HERE:
Instagram: https://www.instagram.com/vertex42/
Facebook: https://www.facebook.com/vertex42/
Pinterest: https://www.pinterest.com/vertex42/
Twitter: https://twitter.com/vertex42

MUSIC: A Good Mood, by Young Rich Pixies, licensed via ArtList

NOTE: This video is for educational use and for use in making a Gantt chart for your own projects. Reproducing or copying this video in part or in whole for commercial gain (including advertising or making products for sale) is not permitted.
Vertex42 : ~~~~~FAQ~~~~~ It is unlikely I will have time to answer your specific questions about this video. I'll include some answers in this FAQ, but if you are stuck at some point in the video: (1) check formulas, (2) check references or (3) download the templates instead.

1] Q: What version of Excel are you using in this video? A: Microsoft 365 (Excel 2016/2019)

2] Q: How do I display weeks or months instead of days (+100 other ways of asking that)? A: Watch the rest of the videos in this video series or download the files that come with the Pro version of the gantt chart template on my website.
https://www.vertex42.com/ExcelTips/how-to-make-a-gantt-chart-in-excel.html
There are also templates on the construction template page with timelines based on months or weeks:
https://www.vertex42.com/ExcelTemplates/construction-schedule.html

3] Q: What is the "Upper Left Cell in the Range" that is mentioned at 4:46? A: The range I'm talking about was selected at point 4:23 in the video, so the upper-left cell is E7. That means that your relative references within the formula should be created based on E7. That is why you use E$5, $B7 and $C7 when creating the formula. Column E and Row 7 are relative to cell E7 because they do not have the $ in front of them. Think of a conditional formatting rule as being "copied" to the other cells in the "Applies To" range, with relative and absolute references following the same rules for copying as when you create formulas within cells.

4] Q: Are there ways to show repeated/recurring tasks? A: Sure, create additional rows for each occurrence of the recurring task. In Part 2 of the video series, you'll see how to start creating dependencies between tasks (linking the start of one task to the end of another). Although it is possible to show recurring tasks on the same row (by creating a custom formula or CF rule), it becomes extremely complicated to create a dependency to a particular occurrence of a recurring task, unless each occurrence is on its own row with its own start and end date. So, although a lot of people like to show recurring project meetings, unless those meetings affect the timing of other tasks in the project, I would normally recommend leaving them off the gantt chart, or just making a note somewhere that says "Project Meetings: Every Tuesday at 10:00 am".

5] Regarding problems with the progress rule (referring to 11:18 in the video): Make sure that the formula is correct based on the upper-left cell in the Applies To range. Check for correct use of relative vs. absolute references. Make sure you are using the correct Applies To range. If all else fails, download the template.

6] Q: How can I show Planned vs. Actual?
A: See this blog post from a while back: https://www.vertex42.com/blog/help/gantt-chart-help/actual-dates-vs-planned-dates-in-a-gantt-chart.html

7] Q: Can this be done in Google Sheets?
A: Most of it. Watch this ...


8] Q: How do I show delay or float time within the Gantt chart? A: See the answer to question #6. Another approach to show delay or float time as a different color is to create a new column for listing a second End Date. You'll then need to create a new conditional formatting rule that uses THAT end date instead of the original end date, and make sure that the new rule is listed AFTER the original rule in CF Rules Manager. See the following article if you need to learn more about conditional formatting: https://www.vertex42.com/blog/excel-tips/how-to-use-conditional-formatting-in-excel.html

9] Q: How do I add Milestones to the Gantt chart? Method 1: Watch the rest of the videos in the series, especially the one about using different colors for the bars, and then use a specific color for milestones (black is commonly used). Method 2 (really advanced): If you want a black diamond ◆ to show as a milestone, you can use your own formulas and custom number formatting and the black diamond unicode character. I don't have a video demonstrating this, but the latest version of Gantt Chart Template Pro includes an example.

10] Q: I can't get the conditional formatting to work. What am I doing wrong? A: Here is the process for resolving problems with conditional formatting ... (1) Check your Applies To range (2) Check that every reference in your formula is based on or relative to the upper left cell in your Applies To range (3) Check the formula (4) Download the template instead.

11] Q: Can you please slow down? A: The video was intentionally created to fit a LOT of stuff in a short time. It is expected that you'll need to pause very frequently or even rewind as needed if you want to ponder, and especially if you want to follow along in Excel. Note that I never said that this video would show you how to create your own Gantt chart in 13 minutes. It took me FAR longer to create than that, and even if you follow along exactly, it could take a few hours. I didn't originally design the video to be a follow-along tutorial, but rather a quick demo of some advanced techniques for intermediate and advanced Excel users, so a huge congratulations to those people who have commented and said they were able to create their own chart just from the tutorial (rather than downloading the template).
Bruno : I've considered myself above average at Excel for some time. after watching this 1st video of the series, I put myself a lot floors down. What a great class. Thanks.
Altair GEC : Absolutely amazing. So detailed and so well explained. Thanks a ton.
MattDoesGames : I doubt you will see this, but I'm leading a very large project and I will using this and I just have to say. Thank you so much. I wish you all the success. Great narration, great to the point, not in your face. Please never change.
Max G : I can only repeat was others have said: this is the most straight to the point, no BS tutorial I have ever seen on YT. Thank you! Great work.

... 

#간트차트

댓글목록

등록된 댓글이 없습니다.

전체 9,438건 1 페이지
게시물 검색
Copyright © www.wsi.or.kr. All rights reserved.  Contact : help@oxmail.xyz