What is XLGantt(Excel Gantt)? XLGantt is a program designed to enable project scheduling in Microsoft Excel. It is composed of the following features. You don’t need to install this program because it is an Excel macro file. Main Sheet The schedule sheet is the main […]
Excel WBS and Gantt Chart - XLGantt(ver 5.0.0) June 5, 2022 Release Read More »
XLMultimail(Excel MultiMail) version 2.6.0 has been released. When you need to send emails with different content for each recipient, such as notifying individual overdue amounts or sending attached files with recorded grades, you can use Excel MultiMail to send emails all at once. After the
Send multiple emails from Excel(XLMultimail Ver 2.6) Read More »
In this chapter, you will learn how to set the appearance and color of the XLGantt (Excel Gantt) "Schedule" sheet. 1. Schedule sheet The “Schedule” sheet in XLGantt looks like the following illustration. You can set the display style and color in the options.
Excel Gantt Chart - How to #15 – Setting WBS Area and Color Theme Read More »
Let's take a look at how to calculate the workload when scheduling a project. As shown below, if the start date of the “Design database” task is July 22 and the finish date is July 31, the working days(excluding nonworking days) are 8. ※
Excel Gantt Chart - How to #14 – Workload calculation Read More »
You can use this feature when you want to see the schedule management data of the IT system running on the server on your PC. After exporting the schedule management data to the ServerData sheet of the XLGantt file in the Server, download and open
Excel Gantt Chart - How to #13 – Importing Server Data Read More »
You can include the formulas and functions of Excel in XLGantt. 1. Display project information using functions provided by XLGantt You can add rows above the title and use the functions provided by XLGantt to display the project start date, etc. at the range you
Excel Gantt Chart - How to #12 – Integration with Excel Features Read More »
XLGantt(Excel Gantt) provides the features to set nonworking days and to set the first day of the week. On the XLGantt tab in the ribbon, click the "Options" button and then Choose the "Calendar" tab to set options. 1. Set nonworking days If you
Excel Gantt Chart - How to #11 – Calendar Read More »
XLGantt(Excel Gantt) provides a feature to import a schedule file which is created in Microsoft Excel or XLGantt. To import the schedule, click the "Import" button on the ribbon menu as shown below. 1. Import files created in XLGantt. You can import schedules created
Excel Gantt Chart - How to #10 – Importing Schedules Read More »
Currently, we support only English and Korean as user interface(UI) languages at XLGantt. Since the program code and the resource file for multiple languages are separated, it is possible to add multiple languages without modifying the program. 1. Choose a language Depending on the language
Excel Gantt Chart - How to #9 - Multilingual Support Read More »
XLGantt(Excel Gantt) provides a feature to add a task entered in a Schedule sheet as a task or an appointment to Microsoft Outlook (Microsoft Outlook must be installed on your PC). 1. Add tasks to Microsoft Outlook Task As shown in the illustration below, let's
Excel Gantt Chart - How to #8 - Adding Tasks to Microsoft Outlook Calendar Read More »
