Another awkward dataset. Should we re-arrange the data or just find a way to calculate what we need? Continue reading

# Posts Tagged → normalize

# Normalize Data using Excel Get & Transform

In my **last post** I used formulas to solve a messy data disaster. In this post/video I’ll show you how to use Excel’s amazing Get & Transform feature (aka Power Query) to re-arrange the data. Continue reading

# Data Disaster: non normalized data

Imagine a weekly task of sending out a simple report. To do this you rely on data from someone else. When the layout of the data changes chaos reigns! *What can we do?* Continue reading

# Video 00167 Sliding Formula Ranges

Data lands in Microsoft Excel in many different structures. Data Analysts like me will often tell you to normalize your data before starting your analysis. This post contains three examples in which normalizing your data might not be necessary when doing a quick analysis. Continue reading

# Video 00122 Normalizing Exported Data

Many of us enjoy puzzles. Sudoku, Crosswords, Chess, etc. I solve a lot of data puzzles using Microsoft Excel. A few months ago, a YouTube viewer had this question for me. Continue reading