Month: May 2017

How To Transform Data by Example

Microsoft Excel has just released a cool new add-in called Transform Data by Example to help make cleaning and transforming data easier. This add-in will allow you to quickly standardize time and dates, names, postal addresses, email addresses and much more! All you need to do is provide a few examples and Excel will find the transformation function for you. It does this by searching its large index of sophisticated transformation functions from services such as GitHub, Stack Overflow, .NET and Bing Maps to find the best match.   How to Install the Add-In?   The add-in is only available for Excel 2016,...

Read More

How To Create A Pivot Table

In this tutorial, we’ll take you through the steps to create a new Pivot Table. It’s generally a good idea to turn┬áthe data for your pivot table into a Table first. This will make it easier to add data at a later time and update your pivot table in addition to the many other benefits of tables. You can read more about the benefits of Excel Tables here.   Get The Starting Workbook     Turn your data into an Excel Table. Select any cell in your data range. Go to the Insert tab. Under the Tables section select...

Read More

How To Export Your Data Into Separate Workbooks Based On The Values In A Column

Something that comes up time and time again in any kind of work is separating data out into separate workbooks based on the values of a field in the data.   Download Example File Let’s say you have sales data for your company and you need to send each of the sales representatives in the company a copy of their sales. You might not want to share the entire set of data with each rep but just their own sales due to privacy concerns around their commission based compensation. To do this, we will need to take our original set...

Read More

Follow Us


Free Book

Microsoft MVP



Pin It on Pinterest