Open the project in Microsoft Project that you want to link with Excel. If your project isn't displaying the correct view, click the "View" tab and select the one you need.

One of Excel's most underrated features for project management is conditional formatting. This simple tool allows you to visually represent project data, keep tasks on track, and see which ones ...

Click "File" in the Project ribbon and select "Save As." Click the "Save as type" drop-down box and select "Excel Workbook." Click "Save" to open the Project Export wizard.

Once your Excel dashboard is ready, you can tweak it further with the built-in theming engine. You can head to the Page ...