New to Excel with the question. How to amend a column of information.

[BrianBricky]

I am in the process of studying the effects of unemployement and one study I am creating is multi job applications from the more mature person. The study carrys the job title, the location of the job and the date thhe application was made all these factors are picked out of a box so do not run in order. With a list of dates on a word document its simple to arrange them logically but how does one do that with an Excel spredsheet column. Having said that is it possible to impose the excel spread sheet result onto a word table?

[TMS]

Insert a Structured Table. You can then sort and/or filter on any column.

[BrianBricky]

I am 200 entries into the Spreadsheet. Is that to late to insert a Structured Table? If not, how does one insert a structured table?

[TMS]

No. Just select a cell (any cell) within your data and, on the Insert tab, choose Table.

See: https://www.contextures.com/xlExcelTable01.html

[PrimePorkchop]

If you really want to take your data analysis to the next level (sounds like you're working with a good sized pool of data) then you might be interested in learning about pivot tables.

If the conversion from range to table doesn't do everything you're wanting, let me know and I'll see what I can do to help further

[Chris802]

I've always found pivot tables confusing, is there a simple "explain like I'm five" overview somewhere?

[TMS]

Google: excel pivot tables explained


Strictly ...

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread