Welcome! Enter below articles or choose one from the menu above

How to Use Visual Basic Editor in Excel

On this page I present the Visual Basic Editor - an environment where you can edit recorded macros and write new macros and programs in Visual Basic for Applications. This is practically relevant workshop in which you write code programs.

How to Test Hypothesis in Excel

In this Excel tutorial you will learn how to test hypothesis in Excel application based on given data arrays. This is a testing that make it possible to test if two range are equal to one another.

Show Yes/No As the Values in a Pivot Table

Showing the yes/no value in the Pivot Table has multiple steps to it. See how to do that in Excel.

How to calculate League of Legends meta changes in Excel

To calculate the changes in the League of Legends meta, you'll need data on the champions and their popularity over time.

How to Make Gauss Normal Distribution Chart

In this lesson, you will learn what a gauss chart is and how to insert it. The chart is also known as a normal distribution chart or a bell curve.

How to use Power Query in Excel

In this article we will learn to install a very useful feature of Excel which is known as Power Query. Getting started with Power Query has multiple steps. But, for the sake of eliminating confusion, let's say we'd have nothing. Therefore, we'd need to begin from the beginning.

You will have to choose the version as per your Excel installation (32 bit or 64 bit). Wait for it to download, and then install it.

Open Microsoft Excel, and click File.

Click Options.

Click on Add-ins (1), Browse manager to COM Add-ins (2), and then press Go (3).

Check the Microsoft Power Query for Excel (1), and then press Ok (2).

Get data

Now, click on Power Query (1), then choose any options in the Get External Data (2).

Note: This tutorial article uses online search that is also in the Get External Data.

Write something relevant to search (1), and click on search (2).

Note: You could now click on the result, and choose the kind of data you would like to display. This is just one example of how to use the Power Query, as there are a lot of other ways to use it.

How to consolidate tables with Power Query?

Let's see how to consolidate tables with Power Query. This is wonderful way to boost your efficiency and save bunch of time.

I have a worksheet. There are a few tables in there and I'd like to combine them into one table. Power Query will help me with that.

To join tables click Power Query in the ribbon menu. Choose From File - From Excel.

Choose the file in your local drive.

Power Query Navigator window pops out.

Select the whole file and click Edit.

I can see every objects in the whole workbook. I'd like to load only tables. So I need to click Kind and filter only tables.

Next I'd like to remove obsolete columns. I don't need so many of them.

To merge tables I need to press a small icon next to Data header.

I unchecked Use original column name as prefix option. Just because I don't like it.

This is how preview of my consolidated tables looks like.

Here is the time for final formatting.

First thing is to change the name. I did it on the right side of the screen.

Next important thing is to set proper columns data formatting. Click the small icon in the top headers and set right data type for each column.

When you are happy from your merged tables, and I am happy, click Close & Load To in the left top side of the screen.

I'd like to have Table in the New worksheet. Click Load to get merged tables in the new sheet.

And here is how my joined tables by Power Query look like.

I saved a bunch of time because now I have joined tables which don't require any more formatting.

```Further reading:
Anova test
How to create KPI dashboard?
Interactive Charts```