Analysis | Depict Data Studio

How to Use Vlookup in Microsoft Excel: Two Step-by-Step Examples for Beginners

Mar 30th, 2021 / Data Analysis

Vlookup is my all-time favorite function in Excel! (Well, the entire lookup family—vlookup, hlookup, index-match, and xlookup.) In this blog post, I’ll walk you through what what vlookup is used for, why it’s tricky and how to fill in the four pieces of the formula. In this blog post, you’ll learn what vlookup is used for; why vlookup can be tricky; how to fill in the four pieces of the formula.

Four Stats Formulas that Every Spreadsheet User Should Know About

Dec 10th, 2019 / Data Analysis

Summarizing datasets for use in your data visualizations doesn’t have to be time consuming and frustrating. This article will outline four statistical formulas that every spreadsheet user should know.

Dataviz Challenge #3: Alternate Solution by Paul Denninger

Jun 19th, 2013 / Data Visualization in Excel

In a previous blog post I shared a dataviz how-to guide on how to create side by side bar charts. Paul Denninger has a great alternative solution to share!