Home>Jon Johansson

About Jon Johansson

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

Dimensions and Measures in Excel Pivot Tables

Excel's pivot table is a tool that allows us to summarize and explore data held in one worksheet or Excel table, and display the results of the summarization in a second table. In this post we consider the basic workflow of creating pivot table reports by dragging fields to the appropriate sections of the PivotTable [...]

By |2022-07-29T17:55:36-06:00April 26th, 2022|Data Analysis, Excel, PivotTables|1 Comment

Importing Too Many Rows Into An Excel Worksheet

For many of us, Microsoft Excel might be either the only tool, or a favourite tool, that we have available for data analysis. Excel can work with large amounts of data, but there are limitations on how much data we can load into a worksheet. In particular, the maximum number of rows in a single [...]

By |2022-07-29T17:56:56-06:00January 6th, 2022|Data Analysis, Excel, Power Query|0 Comments

Excel’s Data Model

Microsoft Excel has a powerful and relatively new tool to add to the arsenal of data analysis tools that we are already accustomed to using, this is the Excel Data Model. Working together with Power Query and Power Pivot, the Data Model enables Excel users to work with much larger data sets than we could [...]

By |2022-07-29T17:57:19-06:00November 17th, 2021|Data Analysis, Data Model, Excel|0 Comments

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 |2022-08-08T18:06:20-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 |2022-08-08T18:07:27-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 |2022-07-29T17:58:04-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 |2022-07-29T17:58:19-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 |2022-08-08T17:56:55-06:00April 20th, 2021|Approximate match, Excel, Lookup|0 Comments
Go to Top