Tips for Analyzing Categorical Data in Excel

It is often necessary to analyze different data types in Excel, including analyzing categorical data in Excel. Having opened up some blog posts to questions from you, the reader and Excel learner, Jeff sent me on this question: ” I am new to Excel and using it to start my learning journey in basic data […]

Vlookups with text in excel

How to carry out a VLOOKUP within Text in Excel

In a previous article we covered The Basics of VLOOKUP.¬† VLOOKUP is a very versatile function that can be combined with other functions.¬† When you learn to combine VLOOKUP with with other functions it makes it super powerful. In this article we will look at combining VLOOKUP with TEXT functions. Lets quickly refresh some basics […]

How to Parse Custom JSON Data using Excel

How to Parse Custom JSON Data using Excel

To Parse Custom JSON data is to split out its name/value pairs into a more readable useable format. Excel is a powerful tool that allows you to connect to JSON data and read it.  However sometimes this data might require a little manipulation to be fully understood and analysed in Excel.  In this article you […]