Trends

Resolved · Low Priority · Version 2010

Wed 15 Jul 2015, 16:23 Delegate Stuart said...

Stuart has attended:
Excel Introduction course

Trends

I would like to understand how to read trends

Wed 15 Jul 2015, 16:46 Trainer Richard said...

RE: trends

Hi Stuart,

Thank you for using the forum to ask a question.

Are you looking to find the Trends in your data, or are you trying to understand the Trendline feature in Excel?

You can spot Trends by comparing and charting data, this can be achieved by using a Pivotchart.This feature is available on our Advanced course

https://www.stl-training.co.uk/excel-2010-advanced.php

I would recommend booking on to our Intermediate course first so that you have the skills and knowledge to prepare the data ready for the analysis tools on the Advanced course

https://www.stl-training.co.uk/excel-2010-intermediate.php

Kind regards

Richard Bailey
Microsoft Certified Trainer

Best 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

Wed 22 Jul 2015: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Entering text in Multiple Worksheets

If you have a number of worksheets in a workbook that require the same information (data or tables) on each worksheet, this can be done as follows:

Hold down the Ctrl key and click one or more of the additional worksheet tabs (i.e. Sheet2, Sheet3, etc).

In your mainsheet (Sheet1) enter the required data or design a table.

When done 'Click' on the other sheet tabs and you will see that the information entered in Sheet1 is on all the other selected worksheets.

NB Do not forget to deselect the worksheets - otherwise you may add data to the main worksheet and all the selected worksheets will also have that data!

View all Excel hints and tips