Professor Excel
histogram, histograms, excel, chart

Histograms in Excel: 3 Ways to Create a Histogram Chart (+Download)

A histogram chart is a great way to present your data. It groups your data into bins or classes and shows the number of items per bin. For example: Your data has “Big Mac” prices in different countries. A histogram shows how many countries have a Big Mac price between 1 and 2 USD, 2 and 3 USD and so on. 

This article introduces three methods in Excel how to create a histogram. Please also feel free to download all examples in an Excel file.

[…]

pivot, pivotable, excel

Pivotable: How to Prepare Data for Creating Pivot Tables in Excel

Pivot Tables are one of the most helpful features in Excel. With Pivot Tables, you can easily evaluate data. Per drag-and-drop you arrange analysis layouts. Within seconds, you’ll see your results – without using any formulas. Usually the first obstacle comes up, when you try to create a Pivot Table. There are some rules to regard in order to create Pivot Tables and your data needs a certain structure. In this article we explore how to make your data ‘pivotable’.

[…]

See and Change the Data Source of a Pivot Table in Excel

You receive an Excel workbook with a Pivot Table and don’t know what data it is referring to? Or you have added a column or row to your data and want to adapt the Pivot Table?

power, pivot, powerpivot, excel, addin

PowerPivot: No More Trouble Working with Big Data in Excel

You got a large amount of data which you want to evaluate in a Pivot Table. In such case, Excel crashes often or gets very slow. You might want to consider using PowerPivot, a free Excel Add-In provided by Microsoft. You can download it from the Microsoft webpage. Once successful installed, you’ll see a new ribbon called “PowerPivot”.

How to Avoid Changing the Column Width With Each Pivot Table Update

In a previous Excel Tip we have learned how to create a simple Excel Pivot Table. Now we will go on from there and learn how to eliminate one of the major pains of Pivot Tables: It changes the size of the columns after each update of the values.

Pivot Tables – How to Create a Pivot Table in Excel

You have some data and want to gain a quick overview? Or conduct some easy evaluation? Maybe later on analyze the data in more detail? For all these purposes, a Pivot Table can be a good choice.