fbpx
May 2020 - Inciter
0
archive,date,ajax_fade,page_not_loaded,,select-child-theme-ver-1.0.8,select-theme-ver-1.7.1, vertical_menu_background_opacity,smooth_scroll,wpb-js-composer js-comp-ver-6.3.0,vc_responsive

Data Cleaning in Excel 101, Part 6: How to Remove Duplicates

In this part of our data cleaning series, we’ll 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. Part 1 showed methods of removing blank rows from your data. 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. In Part 4, we discussed some incredibly useful and time-saving tricks with Excel’s “Flash Fill” function. Part 5 covers solutions for when your...

Read More

Data Cleaning in Excel 101, Part 5: Numbers That Don’t Act Like Numbers and Leading Zeros

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. We’ll also review some instances in which you’ll 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. Part 1 showed methods of removing blank rows from your data. 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. In Part 4, we discussed some incredibly useful and time-saving tricks with Excel’s “Flash Fill” function.Numbers that...

Read More

Data Cleaning in Excel 101, Part 4: More Uses for Flash Fill

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, we’ll show you how to solve common issues by utilizing both standard and Excel’s 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. Here, in Part 4, we’ll showcase some incredibly useful and time-saving tricks with the mystical powers of Excel’s “Flash Fill” function.Flash Fill is the mind-reading short-cut us data folks have been waiting for. It works by analyzing your data entries, detecting a pattern, and then filling in the rest for you.Here,...

Read More

Data Cleaning in Excel 101, Part 3: How to Combine Columns in Excel

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, we’ll show you how to solve common issues by utilizing both standard and Excel’s powerful “Flash Fill” shortcut.Part 2 focuses on splitting data from one cell to multiple cells. Here, in Part 3, we’ll cover the opposite: combining data from multiple columns into one column. Coming up in Part 4, we’ll showcase some incredibly useful and time-saving tricks with the mystical powers of Excel’s “Flash Fill” function.Combining Data from Multiple ColumnsIn our last blog post, we went over how to break apart data that has been exported into just one cell. What about...

Read More