Our blog

In this part of our data cleaning series, well help you find and remove duplicate entries in Excel. Repeats are a very common data entry mistake or error from a data pull. Duplicates in your data can create a variety of unfortunate consequences in administrative duties and analysis. Worst of all, they lead to a real misrepresentation of your results. This is Part 6 in our Data Cleaning in Excel 101 series.

Ever try to do a calculation with numbers in Excel and get an error or the numbers don’t seem to be adding up? Ever fight with ZIP code formatting? Below you can find some methods of dealing with numbers that just aren’t acting like numbers. Well also review some instances in which youll actually want Excel to store numbers as text, and how to convert them. This is Part 5 in our Data Cleaning in Excel 101 series.

Having the right data in the right columns to meet specific requirements for your analysis plays a major role in the data cleaning process. In Parts 2, 3, and 4 of our Data Cleaning in Excel series, well show you how to solve common issues by utilizing both standard and Excels powerful Flash Fill shortcut. Part 2 focuses on splitting data from one cell to multiple cells. Part 3 covers the opposite: combining data from multiple columns into one column.

Having the right data in the right columns to meet specific requirements for your analysis plays a major role in the data cleaning process. In Parts 2, 3, and 4 of our Data Cleaning in Excel series, well show you how to solve common issues by utilizing both standard and Excels powerful Flash Fill shortcut. Part 2 focuses on splitting data from one cell to multiple cells. Here, in Part 3, well cover the opposite: combining data from multiple columns into one column.

We need a new data system. The stuff of dreams and nightmares. Whether you arent storing the right data in your system, or you cant get what you want out of it, you either have considered a new data system, or you were in the process of implementing one. So you got everyone on board, figured out what you needed out of a data system, did an inventory of your current systems, lined up the funding, and then coronavirus.

Having the right data in the right columns to meet specific requirements for your analysis plays a major role in the data cleaning process. Over the next 3 parts in our Data Cleaning in Excel series, well show you how to solve common issues by utilizing both standard and Excels powerful Flash Fill shortcut. Part 2 focuses on splitting data from one cell to multiple cells. Part 3 covers the opposite: combining data from multiple columns into one column.

At Inciter, we use many tools to clean data. Google Sheets and Excel are widely available and powerful tools for basic data cleaning of small to medium data sets. In this series, we will describe different methods for cleaning data that have common problems such as blank rows, duplicates, multiple values in one column, data split into too many columns, leading zeroes, numbers that dont act like numbers, basic data recoding, and comparing two versions of a spreadsheet.

At the risk of adding more peer pressure to be productive right now, I wanted to propose to those of you responsible for the data maturity of your organization (this includes CTOs, CIOs, database managers, data analysts, and other data nerds) that there ARE things you can do right now, in the middle of all this, that will make your organization stronger when its all over. You might be feeling like you cant possibly move forward with anything data-related, because of the uncertainty ahead.

Ive always been fascinated with neuroscience and how our brains work. Mine, especially. So last year, because I apparently cant stop going back to school, I got a certificate in brain-based coaching from the Neuroleadership Institute. What I learned there about how our brains work got me thinking about how they are responding to the current situation with COVID-19. I thought it might be helpful to share some reasons why you may be feeling the way you are (aside from the obvious) and present just a few things you could do to help your brain calm down, and to help you and everyone around you feel a bit better while getting through this pandemic.