98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Project years.
Project years.
Resolved · Low Priority · Version 2016
Tue 17 Nov 2020, 15:17Delegate 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:33Trainer 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:02Delegate 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:04Trainer 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 information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Customize the toolbar in Excel 2010You 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. |
