Standardize Currency Pdf Gratuito

welcome to unit two cleaning up raw data in this unit we will look at the raw data again and do some basic formatting and formula exercises to clean up the data so it's ready for us to analyze now we're going to be using some of the Excel skills you learn in class one in terms of formulas and functions to clean up a raw data set that isn't exactly perfect yet for analyzing a lot of times you'll get data from a database or from someone else in your company and it's still has like extra characters or it's not you know filtered correctly and you just have to kind of quickly massage the data a little bit to make sure it's ready for you to analyze because if you're trying to analyze data that's not correctly formatted or contains incorrect values then that's not going to be useful at all right so we're going to do some quick um just kind of tidying up the data before we actually analyze it and this is a very common practice because sometimes when you get data from like a database that comes in a CSV format it's not always going to be perfectly formatted and you'll have to do a lot of formatting before the data is even ready to do any kind of crunching or analyzing or doing pivot tables and stuff like that so the first step is if you look at the raw data set you notice that in the campaign field every single C product has the word uh has the word Acme and ERS signed right Acme ERS sign small wable Acme ERS sign recycled paper basket Acme Amper sign hand thrown ston wear so we want to make sure that the campaign the final data doesn't have the Acme Amper sand and then the product we just want to have the product so for instance in B2 I only want the words small Walnut Bowl I don't want the word I don't want all of Acme and small wall bow together if that makes sense right so if we go back to the lesson plan we want to get rid of the word Acme text in the campaign column right so how do we do this in Excel we're going to use a formula that you'll probably come to use a lot when you're doing this kind of stuff and it's called the mid formula it's similar to left which we talked about in lesson in class one but it's a little more advanced and I'll show you how to do it right now so our goal again is to find is to get get just the product name and not the word Acme the company name so I'm going to be in column M and sell M2 and I'm going to start typing in the mid formula here equals M right and then I I'm going to hit left parenthesis and you'll notice that it takes in three arguments three kind of input variables it has we have to input a text which is the actual Val the actual text cell that we want to pull data from start num which is the point in the the cell that we want to start taking values from and number of characters is how many values or characters you want to take from that once we've indicated a starting point now what I've said it sounds kind of complicated so let's just walk through how I would do this in Excel so the first input again is...