Preparing Final Products using Microsoft® Excel®

Preparing Final Products using Microsoft® Excel® thumbnail

Many of today’s desktop applications are designed to show the final formatting on the screen as you work on the product.  For example, in Microsoft® Word, as long as you view the document in “Print Layout” as you are typing, you will generally see on the screen what you can expect when you print.  For example, it is pretty clear where the page breaks are, where the margins are and how the text is formatted.

Microsoft® Excel® is different. It is designed with function in mind, such as heavy calculations and visual representations. Because the goal is to focus on the specific task at hand, rather than the final visual product, it is important to add a step to your work when those calculations and visualizations are complete. You need to spend a little time getting your document ready to preview and print.  If you don’t, recipients may go to print the document and find that graphics span multiple pages, or that one stray column prints on 12 separate pages!

Here are three vital formatting tips to get your document ready in Excel®. These functions are available in the “Print Layout” menu.

  • Page Breaks – Make sure the page breaks make sense for your content. You may need to set your first row and/or column to repeat on each page, so the reader can make sense of the content on each page.  You may also need to move or resize graphics to fit on a page.
  • Headers and Footers – Regardless of software used, every ready-to-publish (or “ready to send to your boss”) document should have a title. Other common headers include the organization name, whether the document is internal or confidential, and/or a date produced.  Footers should include the page number; the file name can be helpful too.
  • Margins – Different printers can accommodate different margins, and it is important to make sure that the main content of the document doesn’t overlap your headers and footers. Check your margins.

Details matter!  Even if you think someone will just use your work in Excel®, check the formatting to be sure you are providing an attractive final product to the recipients – you never know when someone will want to print or create a PDF.  Your attention to the final details will be noticed and appreciated!

Local Seminars Related to this Topic:

Microsoft® Excel® Basics

LIVE ONLINE SEMINARS

Sep. 20

Pacific Time Zone

Sep. 21

Central Time Zone

Sep. 22

Eastern Time Zone

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

Microsoft® Excel®: Beyond the Basics

LIVE ONLINE SEMINARS

Sep. 21

Pacific Time Zone

Sep. 22

Central Time Zone

Sep. 23

Eastern Time Zone

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

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

LIVE ONLINE SEMINARS

Sep. 20

Central Time Zone

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

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

Easily Master Microsoft® Excel® PivotTables®

LIVE ONLINE SEMINARS

Sep. 23

Central Time Zone

Sep. 23

Central Time Zone

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

Related Excel® Articles

Categories

Monthly Archives

Leave a Reply

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