Select Page

## Right Click for a Drop Down List

Did you know you can make a drop down list for selecting an item with just a right click? Yep! I...

## How to Create a Normally Distributed Set of Random Numbers in Excel

What is a Normal Distribution? From a purely mathematical point of view, a Normal distribution...

## How To Select A Random Item With A Given Distribution

Not all data is numeric, so when creating random sets of sample data it can be very useful to know...

## How To Select A Random Item From A List

This formula will return a random selection from a given list with each item in the list having an equal probability of being selected.

## How To Unpivot Data With Power Query

This situation happens a lot. Someone creates a pivot table based on some source data. They copy...

## How To Parameterize Your Power Query

When you create a power query in Excel to import and or transform your data, Excel is creating the...

## How To Create A Hyperlink To The Current Workbook Folder

This formula will create a hyperlink that opens a file explorer window to the folder location where the current workbook is saved.

## Excel Social Communities

These groups can be a great place for beginners to ask questions to the community or have a go at...

## How To Get The Current Workbook Folder Path

This formula will return the folder path where the current workbook is saved.

## How To Query A Query In Power Query

Today I was using power query to import external data in a CSV file and then do some...