![]() Subtraction: Type “=” in a blank cell where you want the difference to appear, click the cell you want to subtract from, type “-”, click the cell you want to subtract, and then hit enter.Addition: Type “=SUM” in a blank cell where you want the total to appear, click the cells you want to add together, and then hit “Enter.”.Here are the basic formulas you’ll want to know: Trust me, if I can figure this out, so you can you. Think that sounds like it’s way beyond your Excel knowledge? Think again. Stop reaching for that calculator-Excel can handle all sorts of math functions for you! All you need to do is enter a few simple formulas. The bottom line is, utilize enough information so that you’re removing rows that are true identical copies of each other-and don’t just share one similar value! For example, if I had just selected to remove duplicates in only Column A above (meaning Excel would’ve looked for duplicates of “Oprah”), I would’ve deleted one Oprah that indeed had the same address, but one that had a different last name and address altogether (a different Oprah entirely!) IMPORTANT NOTE: Be careful that you choose enough qualifiers to weed out the true duplicates. Select what columns you want Excel to find duplicates in.Rather than getting bleary-eyed and frustrated by scrolling through that entire spreadsheet and looking for them yourself, Excel can do all of that legwork for you and remove duplicates with the click of a button. ![]() It’s inevitable: When you’re working with a large dataset, there are bound to be a few duplicates that sneak their way in. Had I just selected the first column, Excel would’ve sorted only that one column alphabetically, making the addresses a mismatched mess. That way, your rows will stay intact-meaning, in this case, the correct address will stay with the appropriate person. IMPORTANT NOTE: It’s important that you select the entire data set you want to sort, and not just one column. Then, your data will be sorted accordingly-in this case, alphabetical order by city. Select how you want to sort your data (in the example below, I sorted by city!).Highlight the entire data set you want to sort (not just one column!) by either dragging your cursor across all of the cells or clicking the triangle in the upper left of your spreadsheet to select the entire thing.Or, maybe you want to group them together by city.Įxcel makes it easy to comb through your entire data set and sort everything into a clean and easy to read spreadsheet. Perhaps you want them listed in alphabetical order by last name. ![]() Now, let’s say that you want to sort those people accordingly. Typically, spreadsheets are useful for storing and sorting a whole bunch of information-think a contact list for 800 people that you want to invite to your company’s luncheon, for example. Get your certificate today! Start free course Learn Excel essentials fast with this FREE course. Here are six things you should absolutely know how to do in Excel (and, trust me, you’ll be glad you do!). In fact, there are plenty of helpful tricks and tools you can utilize-whether you’re a total newbie or an established expert. But, fortunately, Excel isn’t nearly as complicated as you’re likely making it out to be. It’s that last part that trips people up. I’ve been able to put my hatred aside and recognize that learning Excel can actually be an incredibly powerful tool for combing through information and finding exactly what you need-provided you know how to use it correctly. Since then? Well, he’s made some progress. ![]() And, he’s made it his personal mission to convert me to his tribe of Excel-lovers (honestly, I’m surprised it wasn’t in his wedding vows). Then, my life experienced a major plot twist: I married a total Excel whiz-someone who literally spends his entire workday creating complicated macros and some of the most impressive spreadsheets I’ve ever seen. But, after 20 odd minutes of trying to get one stupid decimal point to appear properly in its cell, I’d throw my hands up once again and claim Excel just wasn’t for me. I’d open a new Excel workbook with the best of intentions. They’d rather lock themselves in a phone booth full of mosquitos than have to go cross-eyed looking at all of those columns and rows.Īdmittedly, I used to fall into that latter group. And, then you have the people who absolutely detest it. You have people who absolutely love it and will sing the praises of spreadsheets all day. When it comes to Excel, there isn’t much middle ground.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |