Chapter 5 Spreadsheets
home glossary index



Spreadsheets: Making Numbers Talk

Author Supplement to Chapter 8

Applications and Comptencies


Websites That Expand on Chapter 8's Knowledge




For those of you who have Excel 2016 or 365 there are some new charts which are very interesting. It takes a little while to understand each one, but it is well worth your while if you are working with figures. We are all familiar with the pie, line, and bar graphs, but there is some data for which they only tell part of the story. I think that you will find that these take data from information to knowledge. They are more of a forest view versus the trees. Have fun with them.

Charting with Excel. Great help in understanding which column will be the X axis and which will be the y axis.

Using charts to present data.

Using data and statistics. Although this is the title, this site is best used as a great description of line, pie, and bar graphs with description of what they are best used for. (See also Excel charts for statistics can be dangerous)

See the Tutorials for more help.

Go to the top of the page


Hall, Owen P. (2003). Using Dashboard Based Business Intelligence Systems. A good source of information.

A Look At Dashboard Reporting Time Frames (2011). Enterprise Dashboard Digest/

The Dashboard Spy’s collection of digital dashboards. A plethora of links to examples etc. of dashboards. See the 2008 example of an Excel Dashboard and you will find a linke to a tutorial ($47) on using Excel to create not just dashboards, but other things for business intelligence. Did not see the tutorials myself. You are told before you download that if you are an Excel beginner forget it!

Designing Spreadsheets


Designing and Developing Good Spreadsheet Models (2005). This document, class notes, are still very valuable. Spreadsheet principles remain the same. It is organized under two categories, Characteristics of Good Models and Designing and Building Good Models.

Read, Nick & Batson, Jonathan (1999). Spreadsheet Modelling Best Practice. Sponsored by IBM, the age of this and the fact that it is still available indicates that the principles outlines in this lengthy (102 pages) document are solid and still applicable.

Making it look good

Excel Design Tips - Make Your Excel Spreadsheets Look Good



Order of math functions in formulas (holds true for any computer formula). From the math forum at Drexel University. (Incidentally PEMDAS was coined by one of your authors, LQT)

Go to the top of the page


Pivot Tables

Excel Pivot Table Fundamentals

Explains uses for pivot tables


Printing a Spreadsheet

How to avoid spreadsheet printing errors. (Note in 2007 & 2010, access printing on the Page Layout tab and then Page Setup Group, Print Area). There is some very helpful information here including how to see what the page view is. Don't forget that you can always change your page orientation to landscape (See changing page orientation).


Spreadsheet or Databases

Database vs. Spreadsheet. A thorough discussion of this topic with and excellent summary of its points at the end.

Patten, B. (1998). Database vs. spreadsheet is no contest.

Spreadsheet vs. Database. A good overview of when one needs each.

See also the file from your authors.

Go to the top of the page

Excel Tutorials


A free, seven lesson tutorial on Excel. Covers topics of quick navigation, formatting, functions, advanced functions, conditional formatting, managing big data,and visualizing data. One needs to provide an email address so the lessons can be sent one by one.

Note that the 2007 and 2010 versions are so similar that you can easily use a tutorial for either one.

Tutorials for all of Office 2010 Programs

This tutorial is excellent, covers the basics, plus formatting cells, formulas, functions, and graphs. Recommended. Although for Excel 2000, this site will work for XP (2002) as well.
2007 & 2010 version is at

Excel 2000 help. This tutorial is excellent, covers the basics, plus formatting cells, formulas, functions, and graphs. Recommended. Although for Excel 2000, will work for XP (2002) as well.

Excel 2003 from Rutgers State University of New Jersey

Excel 2007 tutorials designed to make you think by giving you a task to perform and pointing you to the article(s) in the Excel Help System.



Excel 2007 for all charts in Microsoft Office.

Pivot Charts and Tables

Videos about creating pivot tables and charts

Create a pivot table

Go to the top of the page


Websites from the Text in Chapter 8

About mathematics



Health Resources and Services Administration (HRSA)

Excel Tutorials

Power Pivot


Applications and Competencies Spreadsheets

Spreadsheet for number 2 Calculate Gestational Age

Spreadsheet for number 3 Calculate BMI

Spreadsheet for number 5 Calculate age on admission


Go to the top of the page


Websites from the Reference List in Chapter 8

Camoes, J. (2007). How to create a dashboard in Excel. Retrieved April 16, 2010, from

Centers for Disease Control and Prevention. (2009, July 26). About BMI for adults. Retrieved April 9, 2010, from

Decision Models. (n.d.). Excel memory limits. Retrieved April 12, 2010, from

European Spreadsheet Risks Interest Group. (2010). EuSpRIG original horror stories. Retrieved April 12, 2010, from

Few, S. (2004a). Common mistakes in data presentation. Intelligent Enterprise, 7(12), 34. Retrieved from jhtml;jsessionid=QAKJKMB4JHXVFQE1GHPCKH4ATMY32JVN?articleID=26100530

French, T. (2010, April 9). Excel 2007 pivot table tutorial. Retrieved April 16, 2010, from

Google. (2010). Size limits: Getting to know

Google Docs – Google Docs help. Retrieved April 9, 2010, from Wiki Contributors. (2008, November 26). What’s the maximum number of rows and cells for a spreadsheet file. Retrieved April 9, 2010, from

Panko, R. (2008, May). What we know about spreadsheet errors. Retrieved April 12, 2010, from

Russell, D. (2010). Order of operations. Retrieved April 9, 2010, from

Tufte, E. (2004, May 27). Sparklines: Theory and practice. Retrieved April 22, 2010,

Go to the top of the page

Created November 19, 2011

home glossary index Home Glossary Contents of this page