Changing parts of data within an Excel cell, AKA String Manipulation, consists of a few simple functions. Once we understand the basics, we can look at how to combine them to do perform complex maneuvers. When I use the term string, I am referring to a series of alphabetic, numeric, and other characters (e.g. comma, …
Tag: Excel
Importing Data into PowerPivot Part 1
Jumpstart your PowerPivot knowledge with this post. This Excel add-on can do some serious heavy lifting when it comes to crunching data. Here is an easy way to practice using PowerPivot with a free large dataset. Microsoft PowerPivot extends the capabilities within Excel to BI Analytics. The process is to pull data in from a …
Not a Data Scientist 