Array Tables

Resolved · Low Priority · Version 2003

Tue 27 Jan 2009, 15:24 Delegate Paul said...

Paul has attended:
Excel Advanced course

Array Tables

General one for you all but does anyone have any tips when creating array tables?

Wed 4 Feb 2009, 11:24 Trainer Rajeev said...

RE: Array Tables

Dear Paul

Thank you for attending Excel Advanced course!! I hope you enjoyed the course and benefited from it.

I beleive that yo'll find the below link very helpful to work with Arrays!! There are lots of examples and videos to help you!!

http://www.ozgrid.com/Excel/arrays.htm

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007

Wed 11 Feb 2009: Automatically marked as resolved.

Excel tip:

Filtering Data in an Excel 2010 Worksheet

When you have an Excel Worksheet with masses of data, it's not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter.

You will now see arrows in the top row of all the columns. If you click on an arrow, it will give you some filtering options so you can sort your data into ''Smallest to Largest'' or ''Oldest to Newest'' and so on..

To turn off the filtering, go back to the Home tab and click the Filter button again.

View all Excel hints and tips

Array Tables

Array Tables

RE: Array Tables

Excel articles

Excel tip:

Filtering Data in an Excel 2010 Worksheet