Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel training seminar - Estates Computer Management

excel training seminar - Estates Computer Management

ResolvedVersion Standard

Wed 30 May 2007, 14:16 Delegate Sara said...

Sara has attended:
Excel Introduction course

Estates Computer Management

We use ECS package for our property management at work and I would like to know if we can tie up Excel with this package. For example, we have tenancy schedules,
budgets etc currently on Excel and it would be ideal for this to be linked in somehow.

Fri 1 Jun 2007, 09:54 Trainer Richard said...

RE: Estates Computer Management

Hi Sara

As we have no experience with ECS, we are not able to tell you if it integrates with Excel. The best place to find out about that is to speak to the providers of that software.

Having said that, if there is an EXPORT or SAVE AS fuction included in your software, you might be able to do it that way. Depending on the data you want to use, look at using CSV files or TXT files, if you have that option.

Regards

Richard

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Use the SUBTOTAL function in Excel

You can create subtotals in your spreadsheet using the SUBTOTAL function, which looks like this:

=SUBTOTAL(9,cell:cell)

9 represents the function being used (SUM), followed by the range of cells the function is operating on.

The neat thing about using the Subtotal function is that if you have used it several times in the same column or row, clicking on the AutoSum button at the end of the column or row will make Excel add only the results of cells containing the Subtotal function in that column or row.

View all Excel hints and tips

excel training seminar - Estates Computer Management

Estates Computer Management

RE: Estates Computer Management

Excel articles

Excel tip:

Use the SUBTOTAL function in Excel