Microsoft Project is an effective management service for budgeting, tracking and analyzing project tasks. It stores data in tables whose contents you can easily migrate into Excel workbooks.

Choose the Excel file with the data to be imported into Project and click "Open." Follow the instructions in the Import Wizard to map your Excel data to the correct Project fields.

Tutorial 2: Import Sage balances into Excel with MS Query Sage offers numerous Trial Balance and P&L reports - but only allows you to print a TB or P&L for a single period. This tutorial uses Query to ...