Choosing between MS Word Table and MS Excel

[jpreman]

Thanks for reading this post.

Can any one guide me, when I should go for a Table in MS Word and when I
should opt for MS Excel. (The pros and cons of each).

Regards

 

[JoAnn Paules [MVP]]

A lot depends on what you are going to do with the data. So...........what
will you be doing with the data?

 

[jpreman]

Hi JoAnn, Thanks for your response.

I am seeking an answer for teaching purposes. ie. to tell students when they
should opt for table and when they should go for Excel.

Regards

A lot depends on what you are going to do with the data. So...........what
will you be doing with the data?

--

JoAnn Paules
MVP Microsoft [Publisher]

Thanks for reading this post.

Can any one guide me, when I should go for a Table in MS Word and when I
should opt for MS Excel. (The pros and cons of each).

Regards

 

[JoAnn Paules [MVP]]

If all I need is a table that won't be changed often, or need repeated
sorting, or is just a basic way to present a fixed table of data, then I'll
use Word.

If I have data that gets changed often, needs to be sorted one way for one
reason and another way for a different reason, if the data will be used for
mail merge, has calculations, etc, then I'll use Excel.

There was a time when I always used Word for tables, now it seems that I'm
more comfortable putting just about all of my data in Excel. It seems like
lately the only reason I'll use a table in Word is if I'm making a form.

--

JoAnn Paules
MVP Microsoft [Publisher]

Hi JoAnn, Thanks for your response.

I am seeking an answer for teaching purposes. ie. to tell students when
they
should opt for table and when they should go for Excel.

Regards

A lot depends on what you are going to do with the data.
So...........what
will you be doing with the data?

--

JoAnn Paules
MVP Microsoft [Publisher]

Thanks for reading this post.

Can any one guide me, when I should go for a Table in MS Word and when
I
should opt for MS Excel. (The pros and cons of each).

Regards

 

[JoAnn Paules [MVP]]

Oh - one other very good reason to use a Word table instead of Excel: If you
are sending the data to another person and you aren't positive that they
have Excel, use Word. All but two of the people I correspond with regularly
use Word (the other two use Word Perfect). Only about a third to a half of
them use Excel.

--

JoAnn Paules
MVP Microsoft [Publisher]

Hi JoAnn, Thanks for your response.

I am seeking an answer for teaching purposes. ie. to tell students when
they
should opt for table and when they should go for Excel.

Regards

A lot depends on what you are going to do with the data.
So...........what
will you be doing with the data?

--

JoAnn Paules
MVP Microsoft [Publisher]

Thanks for reading this post.

Can any one guide me, when I should go for a Table in MS Word and when
I
should opt for MS Excel. (The pros and cons of each).

Regards

 

[jpreman]

Thank you JoAnn for your post.

That's a handful of new knowledge. Thanks to you.

Regards

Oh - one other very good reason to use a Word table instead of Excel: If you
are sending the data to another person and you aren't positive that they
have Excel, use Word. All but two of the people I correspond with regularly
use Word (the other two use Word Perfect). Only about a third to a half of
them use Excel.

--

JoAnn Paules
MVP Microsoft [Publisher]

Hi JoAnn, Thanks for your response.

I am seeking an answer for teaching purposes. ie. to tell students when
they
should opt for table and when they should go for Excel.

Regards

A lot depends on what you are going to do with the data.
So...........what
will you be doing with the data?

--

JoAnn Paules
MVP Microsoft [Publisher]



Thanks for reading this post.

Can any one guide me, when I should go for a Table in MS Word and when
I
should opt for MS Excel. (The pros and cons of each).

Regards

 

[JoAnn Paules [MVP]]

I'm glad I could help you. And just to add a wee bit more to that, there is
an Excel Viewer available for free but it's not nice to send someone a file
that requires them to download a viewer to see. If I have an Excel file that
I want others to see and not edit, I send it as a .pdf file.

--

JoAnn Paules
MVP Microsoft [Publisher]

Thank you JoAnn for your post.

That's a handful of new knowledge. Thanks to you.

Regards

Oh - one other very good reason to use a Word table instead of Excel: If
you
are sending the data to another person and you aren't positive that they
have Excel, use Word. All but two of the people I correspond with
regularly
use Word (the other two use Word Perfect). Only about a third to a half
of
them use Excel.

--

JoAnn Paules
MVP Microsoft [Publisher]

Hi JoAnn, Thanks for your response.

I am seeking an answer for teaching purposes. ie. to tell students when
they
should opt for table and when they should go for Excel.

Regards

:

A lot depends on what you are going to do with the data.
So...........what
will you be doing with the data?

--

JoAnn Paules
MVP Microsoft [Publisher]



Thanks for reading this post.

Can any one guide me, when I should go for a Table in MS Word and
when
I
should opt for MS Excel. (The pros and cons of each).

Regards