Project years.

Resolved · Low Priority · Version 2016

Tue 17 Nov 2020, 15:17 Delegate Dave said...

Dave has attended:
Excel Intermediate course

Project years.

Hi,

I have a data table that gives me;

1. original Start date.
2. New start date
2. original End date.
4. New end date

I want to produce an auto update report table that shows me.

Name of Project and what year it was originally in and what year it is in now to show changes.

Just a simple table for each year.

Thanks

Fri 27 Nov 2020, 12:33 Trainer Jens said...

RE: Project years.

Hi Dave,

Thank you for the forum question.

I am sorry that you have waited a long time to get an answer.

You can achieve what you want in Pivot Tables if just want them organised in annual tables.

But everything in Excel is a question about how your data are organised.

If it is possible you can send me your file and I can have a look at your data and come up with the best solution.

Please send the file to:

info@stl-training.co.uk

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Mon 30 Nov 2020, 09:02 Delegate Dave said...

RE: Project years.

Hi Jens,

Hope everything is good with you during these............interesting times.

Is there a way of sending you my data table (email address) that I could send it to?

Dave

Mon 30 Nov 2020, 09:04 Trainer Jens said...

RE: Project years.

Hi Dave,

You can send it to:

info@stl-training.co.uk

regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Training courses

	98.8 % recommend us
	More live stats...

Training information:

Excel tip:

Customize the toolbar in Excel 2010

You can create your own toolbar which contains your favourite or most used tools. This will make using Excel much more efficient. To do this, you need to click on View, then select Customize Quick access Toolbars and then select Customize. A list of tools will then appear on the screen of which you can add or remove them as you please.

View all Excel hints and tips