Concerned about the latest vaccine mandate? Visit Pryor's free training resource page to learn more about the latest rulings on the national 100+ vaccine mandate.

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.


Choose a Seminar and Save $10:

Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small> Basics

Microsoft® Excel® Basics

LIVE ONLINE SEMINARS

Jan. 24

Central Time Zone

Jan. 26

Central Time Zone

Jan. 27

Eastern Time Zone

Jan. 31

Central Time Zone

Feb. 2

Central Time Zone

Feb. 3

Eastern Time Zone

Feb. 7

Central Time Zone

Feb. 8

Eastern Time Zone

Feb. 10

Central Time Zone

Feb. 14

Central Time Zone

Feb. 16

Eastern Time Zone

Feb. 16

Central Time Zone

Feb. 22

Central Time Zone

Feb. 24

Pacific Time Zone

Mar. 1

Central Time Zone

Mar. 2

Eastern Time Zone

Mar. 7

Central Time Zone

Mar. 9

Central Time Zone

Mar. 14

Central Time Zone

Mar. 16

Central Time Zone

Mar. 17

Eastern Time Zone

Mar. 22

Central Time Zone

Mar. 24

Central Time Zone

Mar. 28

Eastern Time Zone

Mar. 29

Central Time Zone

Mar. 31

Pacific Time Zone

Apr. 4

Eastern Time Zone

Apr. 5

Central Time Zone

Apr. 7

Central Time Zone

Apr. 11

Central Time Zone

Apr. 12

Pacific Time Zone

Apr. 13

Eastern Time Zone

Apr. 19

Central Time Zone

Apr. 20

Central Time Zone

Apr. 21

Eastern Time Zone

Apr. 25

Eastern Time Zone

Apr. 27

Central Time Zone

Apr. 28

Pacific Time Zone

May. 2

Eastern Time Zone

May. 4

Central Time Zone

May. 5

Pacific Time Zone

May. 9

Eastern Time Zone

May. 10

Central Time Zone

May. 12

Central Time Zone

May. 16

Central Time Zone

May. 17

Pacific Time Zone

May. 18

Central Time Zone

May. 19

Eastern Time Zone

May. 24

Eastern Time Zone

May. 25

Central Time Zone

Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small>: Beyond the Basics

Microsoft® Excel®: Beyond the Basics

LIVE ONLINE SEMINARS

Jan. 25

Central Time Zone

Jan. 27

Central Time Zone

Jan. 28

Eastern Time Zone

Feb. 1

Central Time Zone

Feb. 3

Central Time Zone

Feb. 4

Eastern Time Zone

Feb. 8

Central Time Zone

Feb. 9

Eastern Time Zone

Feb. 11

Central Time Zone

Feb. 15

Central Time Zone

Feb. 17

Eastern Time Zone

Feb. 17

Central Time Zone

Feb. 23

Central Time Zone

Feb. 25

Pacific Time Zone

Mar. 2

Central Time Zone

Mar. 3

Eastern Time Zone

Mar. 8

Central Time Zone

Mar. 10

Central Time Zone

Mar. 15

Central Time Zone

Mar. 17

Central Time Zone

Mar. 18

Eastern Time Zone

Mar. 23

Central Time Zone

Mar. 25

Central Time Zone

Mar. 29

Eastern Time Zone

Mar. 30

Central Time Zone

Apr. 1

Pacific Time Zone

Apr. 5

Eastern Time Zone

Apr. 6

Central Time Zone

Apr. 8

Central Time Zone

Apr. 12

Central Time Zone

Apr. 13

Pacific Time Zone

Apr. 14

Eastern Time Zone

Apr. 20

Central Time Zone

Apr. 21

Central Time Zone

Apr. 22

Eastern Time Zone

Apr. 26

Eastern Time Zone

Apr. 28

Central Time Zone

Apr. 29

Pacific Time Zone

May. 3

Eastern Time Zone

May. 5

Central Time Zone

May. 6

Pacific Time Zone

May. 10

Eastern Time Zone

May. 11

Central Time Zone

May. 13

Central Time Zone

May. 17

Central Time Zone

May. 18

Pacific Time Zone

May. 19

Central Time Zone

May. 20

Eastern Time Zone

May. 25

Eastern Time Zone

May. 26

Central Time Zone

Advanced Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small>-Macros, PivotTables, Charts and More

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

LIVE ONLINE SEMINARS

Jan. 24

Central Time Zone

Jan. 26

Pacific Time Zone

Feb. 2

Eastern Time Zone

Feb. 4

Central Time Zone

Feb. 8

Pacific Time Zone

Feb. 9

Central Time Zone

Feb. 15

Eastern Time Zone

Feb. 18

Central Time Zone

Feb. 24

Central Time Zone

Mar. 3

Central Time Zone

Mar. 8

Eastern Time Zone

Mar. 11

Central Time Zone

Mar. 16

Pacific Time Zone

Mar. 21

Central Time Zone

Mar. 23

Eastern Time Zone

Mar. 31

Central Time Zone

Apr. 4

Central Time Zone

Apr. 6

Eastern Time Zone

Apr. 12

Eastern Time Zone

Apr. 14

Central Time Zone

Apr. 21

Eastern Time Zone

Apr. 22

Central Time Zone

Apr. 26

Central Time Zone

Apr. 27

Pacific Time Zone

May. 4

Central Time Zone

May. 5

Eastern Time Zone

May. 10

Central Time Zone

May. 12

Pacific Time Zone

May. 17

Eastern Time Zone

May. 20

Central Time Zone

May. 23

Central Time Zone

Easily Master Microsoft<small><sup>®</sup></small> Excel<small><sup>®</sup></small> PivotTables<small><sup>®</sup></small>

Easily Master Microsoft® Excel® PivotTables®

LIVE ONLINE SEMINARS

Jan. 27

Central Time Zone

Jan. 27

Central Time Zone

Feb. 1

Central Time Zone

Feb. 1

Central Time Zone

Feb. 10

Eastern Time Zone

Feb. 10

Eastern Time Zone

Feb. 16

Central Time Zone

Feb. 16

Central Time Zone

Feb. 23

Central Time Zone

Feb. 23

Central Time Zone

May. 3

Central Time Zone

May. 3

Central Time Zone

May. 11

Central Time Zone

May. 11

Central Time Zone

May. 19

Central Time Zone

May. 19

Central Time Zone

May. 25

Central Time Zone

May. 25

Central Time Zone

Related Excel® Articles

PRYOR+ 7-DAY FREE TRIAL


Experience 7-days of unlimited learning, then reap the benefits from a year of training at one low price. No credit card. No commitment. Individuals and teams.

Categories