Using Microsoft Excel as a Analysis and Report Tool – Post 2

January 8, 2017

Excel as a Reporting Tool – Part 2 – The Basics – Part 1 here

Choosing your Font

Font selection is important. It is important to select a font that looks clear on the screen and when printed out. It is preferable to select a font that is part of the windows native font package so it need not be specially installed by everyone who wants to use your file. The font must be fully populated with the extended character set (more on this later). The font must have minimal scaling problems with Excel’s display when you use different magnification levels.

We have settled on using Calibri and have been using it for the last 5 years and I am very happy with it. The textbook is written in Calibri and it is a clean, san-serif font that looks good in bold and italic.

We have developed a custom font that is part of the XL-Viking package. This font is given away for free without having to make any purchase. We have populated this font with a set of superscript and subscript characters in the native font format that are not usually available.

It is important that attention is paid to the little things. Legibility, transferability and clarity are all key aspects of a technical report.

Page Break Preview and Print Area

Excel was created without consideration for authoring Letter or A4 page size reports in mind. Nevertheless, there are some useful tools built in that help you do this

Excel When First Started:

The figure above is what you see when you start excel, in the lower RH corner are 3 Icons.

Page Layout Icons:

For the report sheets (More on the use of sheets later) we only work in Page Break Preview.

If you click that icon your screen will change and will look like this:

Excel Startup Page Break Preview:

All the cells are ‘greyed-out’. This is because there is no defined Print Area. In order to define a Print Area, select a range of cells and go to the Page layout menu.

Selecting Cells to Define a Print Area:

And click on the Print Area button:

Print Area Button:

And click ‘Set Print Area’. The screen will now look like this

Print Area Defined:

When Excel is used in this way only the area in the while cells is printed. All of the grey area is not printed. When the term ‘Printed’ is used it also applies to the creation of pdf files. When a pdf file is created, the pdf will only show the ‘print area’ of the page.

This is very useful and allows you to display only the results of an analysis on the printed part of the report. We use this concept extensively in many of our standard spreadsheets. The way you arrange and use your analysis within this framework is a key aspect of using Excel and is covered in the next section.

Continued in the next post……..

Have A Comment On This Article? Post It Here.

Comments are moderated and will not be published until approved. Your email address will be kept confidential. Please review our Comment Policy before posting your comment.


2 Comments on "Using Microsoft Excel as a Analysis and Report Tool – Post 2"

Microsoft Excel Spreadsheets

FREE ANALYSIS SPREADSHEETS 3 Over the last 10 years we have developed hundreds of spreadsheet tools to help us with our structural analysis work. We have made these available through the Abbott Aerospace web site and the XL Viking project. We have now brought them into the technical library. They have been updated, improved and the collection has been expanded to cover more analysis methods than ever before.

The XL-Viking Add-In for Excel

XL-Viking 2 We created the XL-Viking Excel add-in to satisfy our own need to make Excel a better engineering tool. XL-Viking shows your Excel Formula in a way that makes sense and brings essential new functionality to Microsoft Excel by providing an additional user interface and easy to use functions.

The Indispensable Tool For Engineers, Mathematicians, Scientists, Accountants and Teaching Professionals!


Technical Papers & Reports

This is our collection of public domain references. All of the material we make available has been placed in the public domain by the authors/owners. If you believe this is not the case and any of the library material is not in the public domain please let us know. If you have any reference material that you would like to see included in the library we would love to hear from you.

Market Analysis and Market Information

Our newest addition to the library is an on-going series of articles on the aircraft and aerospace market. These are part quantitative and part qualitative and introduce a new aspect to the competencies within Abbott Aerospace.