FREE 1-HOUR EVENT, October 20 at noon CST. Diversity & Inclusion: Top Lawsuits Reveal How to Protect Employees and Avoid Liability. REGISTER NOW

When to Use Microsoft® Excel® for Text Products

When to Use Microsoft® Excel® for Text Products thumbnail

Microsoft® does a good job of creating different software for different core business functions, however, there can be some overlap between tools.  For example, we often select Microsoft® Word for text-heavy documents with tables, but there are times when Excel® may be your best starting point.

Here are examples of when it may be best to create a text-based document in Excel®:

  • When you need to sort or filter information. For example, you may want to sort by last name or by State down the road, or by a specific criterion, like interest area or special qualification.  While these data may be text based, using Excel® will help you slice and dice the data differently down the road.
  • The entire document is table based. If your document is only going to have one table in it, you may want to consider Excel® rather than Word. This is particularly the case when the text blocks aren’t longer than 1 to 2 sentences each. This leaves you options for the future – and, if you change your mind, you can always copy and paste the Excel® cells into Word and format there.
  • When you may need to add, count or group items. If columns of numbers are an important part of your table, and if there is any possibility that you are going to want to add those columns up, or count rows that meet a specific criterion (like the number of rows in a State, or the number of rows that fall into a certain category), then Excel® can provide you with more options than hand-counting in Word.

 Before starting your document, think about your goal, and what tool will serve that goal best. Microsoft® generally handles inter-tool compatibility well – in other words, it is easy to paste an Excel® table or chart into Word later on.  PowerPoint® and Publisher® are also popular destination tools for Excel® outputs.  Just copy from Excel® and “Paste Special” in the destination tool to pick the best option for your needs.

Local Seminars Related to this Topic:

Microsoft® Excel® Basics

LIVE ONLINE SEMINARS

Sep. 27

Eastern Time Zone

Sep. 29

Pacific Time Zone

Sep. 30

Central Time Zone

Oct. 4

Eastern Time Zone

Oct. 5

Central Time Zone

Oct. 7

Central Time Zone

Oct. 12

Central Time Zone

Oct. 13

Central Time Zone

Oct. 14

Pacific Time Zone

Oct. 18

Eastern Time Zone

Oct. 19

Central Time Zone

Oct. 21

Central Time Zone

Oct. 25

Pacific Time Zone

Oct. 27

Central Time Zone

Nov. 1

Central Time Zone

Nov. 2

Central Time Zone

Nov. 3

Eastern Time Zone

Nov. 4

Central Time Zone

Nov. 8

Central Time Zone

Nov. 9

Eastern Time Zone

Nov. 15

Pacific Time Zone

Nov. 17

Central Time Zone

Nov. 18

Central Time Zone

Nov. 29

Central Time Zone

Dec. 1

Central Time Zone

Dec. 2

Eastern Time Zone

Dec. 6

Central Time Zone

Dec. 7

Central Time Zone

Dec. 8

Eastern Time Zone

Dec. 9

Pacific Time Zone

Dec. 13

Central Time Zone

Dec. 14

Pacific Time Zone

Dec. 15

Eastern Time Zone

Dec. 16

Central Time Zone

Jan. 5

Central Time Zone

Jan. 10

Central Time Zone

Jan. 11

Pacific Time Zone

Jan. 13

Eastern Time Zone

Jan. 18

Eastern Time Zone

Jan. 19

Pacific Time Zone

Jan. 20

Central Time Zone

Jan. 24

Central Time Zone

Jan. 26

Central Time Zone

Jan. 27

Eastern Time Zone

Microsoft® Excel®: Beyond the Basics

LIVE ONLINE SEMINARS

Sep. 28

Eastern Time Zone

Sep. 30

Pacific Time Zone

Oct. 1

Central Time Zone

Oct. 5

Eastern Time Zone

Oct. 6

Central Time Zone

Oct. 8

Central Time Zone

Oct. 13

Central Time Zone

Oct. 14

Central Time Zone

Oct. 15

Pacific Time Zone

Oct. 19

Eastern Time Zone

Oct. 20

Central Time Zone

Oct. 22

Central Time Zone

Oct. 26

Pacific Time Zone

Oct. 28

Central Time Zone

Nov. 2

Central Time Zone

Nov. 3

Central Time Zone

Nov. 4

Eastern Time Zone

Nov. 5

Central Time Zone

Nov. 9

Central Time Zone

Nov. 10

Eastern Time Zone

Nov. 16

Pacific Time Zone

Nov. 18

Central Time Zone

Nov. 19

Central Time Zone

Nov. 30

Central Time Zone

Dec. 2

Central Time Zone

Dec. 3

Eastern Time Zone

Dec. 7

Central Time Zone

Dec. 8

Central Time Zone

Dec. 9

Eastern Time Zone

Dec. 10

Pacific Time Zone

Dec. 14

Central Time Zone

Dec. 15

Pacific Time Zone

Dec. 16

Eastern Time Zone

Dec. 17

Central Time Zone

Jan. 6

Central Time Zone

Jan. 11

Central Time Zone

Jan. 12

Pacific Time Zone

Jan. 14

Eastern Time Zone

Jan. 19

Eastern Time Zone

Jan. 20

Pacific Time Zone

Jan. 21

Central Time Zone

Jan. 25

Central Time Zone

Jan. 27

Central Time Zone

Jan. 28

Eastern Time Zone

Advanced Microsoft® Excel®-Macros, PivotTables, Charts and More

LIVE ONLINE SEMINARS

Oct. 1

Central Time Zone

Oct. 5

Pacific Time Zone

Oct. 6

Central Time Zone

Oct. 12

Central Time Zone

Oct. 21

Central Time Zone

Oct. 25

Eastern Time Zone

Oct. 29

Central Time Zone

Nov. 2

Eastern Time Zone

Nov. 8

Central Time Zone

Nov. 17

Central Time Zone

Nov. 19

Pacific Time Zone

Nov. 29

Central Time Zone

Dec. 3

Central Time Zone

Dec. 8

Central Time Zone

Dec. 9

Central Time Zone

Dec. 14

Eastern Time Zone

Dec. 15

Central Time Zone

Jan. 7

Central Time Zone

Jan. 12

Eastern Time Zone

Jan. 13

Central Time Zone

Jan. 18

Central Time Zone

Jan. 24

Central Time Zone

Jan. 26

Pacific Time Zone

Easily Master Microsoft® Excel® PivotTables®

LIVE ONLINE SEMINARS

Sep. 28

Central Time Zone

Sep. 28

Central Time Zone

Oct. 14

Central Time Zone

Oct. 14

Central Time Zone

Oct. 19

Pacific Time Zone

Oct. 19

Pacific Time Zone

Oct. 27

Central Time Zone

Oct. 27

Central Time Zone

Jan. 5

Central Time Zone

Jan. 5

Central Time Zone

Jan. 11

Central Time Zone

Jan. 11

Central Time Zone

Jan. 19

Central Time Zone

Jan. 19

Central Time Zone

Jan. 27

Central Time Zone

Jan. 27

Central Time Zone

How To Create Powerful Excel® Dashboards

LIVE ONLINE SEMINARS

Nov. 3

Central Time Zone

Nov. 3

Central Time Zone

Nov. 9

Central Time Zone

Nov. 9

Central Time Zone

Nov. 18

Central Time Zone

Nov. 18

Central Time Zone

Nov. 30

Central Time Zone

Nov. 30

Central Time Zone

Dec. 1

Pacific Time Zone

Dec. 1

Pacific Time Zone

Dec. 9

Central Time Zone

Dec. 9

Central Time Zone

Dec. 15

Central Time Zone

Dec. 15

Central Time Zone

Related Excel® Articles

Categories

Monthly Archives

Leave a Reply

Your email address will not be published. Required fields are marked *