About Jon Johansson

This author has not yet filled in any details.
So far Jon Johansson has created 21 blog entries.

The Word “Table” in Excel

Microsoft Excel is a spreadsheet program with an interface formed from a set of cells arranged in rows and columns. The columns are labelled with letters along the top of the work area, and the rows are numbered down the left side of the work area. Every cell has a unique address formed by combining [...]

By |2021-09-29T18:10:33-06:00September 29th, 2021|Excel, Tables, Tutorials and How-Tos|0 Comments

What-If Analysis in Excel

Excel's What-If Analysis tools allow us to change the values of inputs to a calculation and explore different possible results. In the following article we will consider a single, simple calculation and discuss how each of the three What-If Analysis tools: Goal Seek, Scenario Manager and Data Tables, can be applied. The commands for What-if [...]

By |2021-09-21T18:10:12-06:00September 21st, 2021|Data Analysis, Excel, What-if-Analysis|0 Comments

Animated GIFs With GNU GIMP

Animated GIFs are a great way to demonstrate a series of changes. Here we are going through the process of creating an animage GIF using the GNU Image Manipulation Program (GIMP). We previously discussed how to create Animated GIFs With Adobe Photoshop CS5. If Adobe Photoshop isn't available, it is of course possible to do [...]

By |2021-05-06T17:11:44-06:00May 6th, 2021|Animated GIF, GIMP, Graphics|0 Comments

Animated GIFs With Adobe Photoshop CS5

The Internet is full of images. These are a great way to capture attention and convey information. Adding motion to images can provide even more information and keep people interested. Video clips are great, but downloads can become tedious with longer videos at higher quality. The animated GIF is a great option if we wish [...]

By |2021-05-05T17:26:38-06:00April 30th, 2021|Animated GIF, Graphics, Photoshop|0 Comments

Excel’s Lookup Functions and Approximate Matching

Excel has 4 functions that allow us to find a value in a column or row, and return a value from a corresponding column or row. The lookup functions can be very useful and are easy to understand when they provide an exact match for a search item. In addition to exact matches, the functions [...]

By |2021-04-20T17:45:07-06:00April 20th, 2021|Approximate match, Excel, Lookup|0 Comments

Ranges in Excel

Functions in Excel can work with multiple cells by providing ranges as input parameters. The Excel documentation will refer to these ranges as either "vector" or "array" ranges. A range is specified by a beginning cell address, a colon, followed by the final cell address. A valid range in Excel looks like: D4:D10, which includes [...]

By |2021-04-14T17:39:44-06:00April 14th, 2021|Excel|0 Comments

A Simple Model of Covid-19 Data With Excel

We currently (as of Jan, 2021) have large amounts of data concerning the Covid-19 pandemic available. We have daily updates through various news outlets and we can download data from different country's public data websites. Aggregated data is available for viewing at Worldometers coronavirus page, and for download at Our World in Data's Covid-19 data [...]

By |2021-02-11T17:12:54-07:00February 8th, 2021|Excel, Exponential trendline, Trendline|0 Comments

“Standard Error” Error Bars in Excel

In previous articles we discussed adding fixed error bars and Standard Deviation error bars to Excel charts. The last option available on the Format Error Bars dialog is the standard error,  short for "standard error of the mean". Using the same data set that we used for the post Standard Deviation Error Bars in Excel, [...]

By |2020-12-14T17:36:39-07:00December 16th, 2020|Error bars, Excel, Tutorials and How-Tos|0 Comments
Go to Top