Sending Emails from Excel with Microsoft Outlook(11/22/2020 Ver 1.5 Released)

You can send mails with different contents to each recipient at once from Microsoft Outlook using this VBA program. For example, you can send mail at once if you want to notify the amount of overdue for each individual or to send an attachment with a record for each individual.   Send mail in the …

Sending Emails from Excel with Microsoft Outlook(11/22/2020 Ver 1.5 Released) Read More »

Excel WBS and Gantt Chart – XLGantt How to #15 – Setting WBS Area and Color Theme

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.   2. Setting the appearance of the WBS area you can …

Excel WBS and Gantt Chart – XLGantt How to #15 – Setting WBS Area and Color Theme Read More »

Excel WBS and Gantt Chart – XLGantt How to #14 – Workload calculation

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. ※ Refer to the following link for setting nonworking days and calculating …

Excel WBS and Gantt Chart – XLGantt How to #14 – Workload calculation Read More »

Excel WBS and Gantt Chart – XLGantt How to #13 – Importing Server Data

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 the XLGantt(Excel Gantt)file, and this data comes into the Schedule …

Excel WBS and Gantt Chart – XLGantt How to #13 – Importing Server Data Read More »

Excel WBS and Gantt Chart – XLGantt How to #12 – Integration with Excel Features

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 want.   Functions provided by XLGantt xlgantt.ProjectName(): Get project name …

Excel WBS and Gantt Chart – XLGantt How to #12 – Integration with Excel Features Read More »

Excel WBS and Gantt Chart – XLGantt How to #11 – Calendar

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 set nonworking days, XLGantt excludes them from calculations of working …

Excel WBS and Gantt Chart – XLGantt How to #11 – Calendar Read More »

Excel WBS and Gantt Chart – XLGantt How to #10 – Importing Schedules from Another File

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 in XLGantt. 1) Choose a file type to import If you …

Excel WBS and Gantt Chart – XLGantt How to #10 – Importing Schedules from Another File Read More »

Excel WBS and Gantt Chart – XLGantt How to #9 – Multilingual Support

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 setting of the computer O/S, the language is automatically chosen …

Excel WBS and Gantt Chart – XLGantt How to #9 – Multilingual Support Read More »

Excel WBS and Gantt Chart – XLGantt How to #8 – Adding Tasks to Microsoft Outlook Calendar

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 add “Define scope” and “Confirm scope” tasks to Outlook.   …

Excel WBS and Gantt Chart – XLGantt How to #8 – Adding Tasks to Microsoft Outlook Calendar Read More »

Excel WBS and Gantt Chart – XLGantt How to #7 – Deliverables

Excel Gantt provides the feature to set the save path (folder location) of the deliverables and open the deliverables from the Schedule sheet. 1. Setting the deliverables saving path On the XLGantt tab in the ribbon, click the “Options” button. Choose one of the following paths to save the deliverables and enter the path (click …

Excel WBS and Gantt Chart – XLGantt How to #7 – Deliverables Read More »