rainintheforest21:annasellheim: dianasson:broken-horn-of-equius:bryannagraham:quiteliterallyho
rainintheforest21:annasellheim: dianasson: broken-horn-of-equius: bryannagraham: quiteliterallyhotsauce: Invest in yourself and you increase your income Filtering is definitely a must! Here are some links to it, but also research excel, sharepoint, and PowerPoint on youtube!!! How to Filter in Excel How To Filter In Excel: Advanced Filters And Autofilter Explained Video: Filter data in a range or table Citizen: *goes to college, accumulates at least tens of thousands of dollars in debt, almost burns out* HR interviewer: You’ve got the education, but we’re not sure you have the knowledge and experience necessary for this line of work. Citizen: I also…. Know how, to…. use Excel(?) Interviewer: *trying to hide massive work-boner while noticeably sweating* Go on…. Lmaoooooo true. Reblogging for those looking to add marketable skills to their applications This is being reblogged on my main. Learning Excel, even at my basic level (I don’t know how to do most of the above), has made me far more employable as well. I’m probably the biggest Luddite on this site too. If I can learn it you can too. May I suggest replacing VLOOKUP with XLOOKUP?Xlookup is at the same time a more advance and more simple version of Vlookup.Xlookup syntax looks like this (for all the friends out there who doesn’t know: block brackets [XXX] in a formula means the syntax is optional, it does not need to be completed for a formula to work):=Xlookup(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])Vs Vlookup syntax=Vlookup(lookup_value, table_array, col_index_num, [range_lookup])At first glance, Xlookup looks very complicated. But ever since I’ve started using Xlookup, I’ve never gone back to Vlookup.Here are some of my favourite things about Xlookup:Order of the columns doesn’t matterSay you want the information from column B, but the lookup array is in column G. Anyone familiar with Vlookup knows that the column containing the lookup value (in this case G) needs to be before the column with the return value (column B). And while it is easy to sort the columns into the correct order, it can be time consuming. (In this example we can just copy column G and paste it in front of column B) With Xlookup, the columns remain where they are. Using Xlookup, you select your lookup value (syntax lookup_value) , then you select ONLY your lookup array (ONLY column G) (syntax lookup_array), and then you select your return array (column B) (syntax return_array). Close your formula, and voila! You’re done! No need to count columns for the col_index_num! It combines a VLOOKUP with an IFERRORSay your Vlookup returns a #N/A. Bothersome, because you need only number values, and these cells are messing with your data. Urgh, now you have to combine your Vlookup with an IfError for the errors to return a number value.Xlookup’s 4th syntax [if_not_found] already includes an IfError option. You just specify what value you want the formula to return in case the formula results in an error, and the formula will replace the error with that value.You can specify which way you want the formula to searchUsing Xlookup, you can specify using [search_mode] if you want the formula to search from top to bottom (1) or from bottom to top (-1). Most of the time this step is not necessary but it is handy if you know your list is “upside down”. You can combine more than one XlookupLike nested IFs you can nest Xlookup. Using the [if_not_found] syntax of the original Xlookup, you can create a new Xlookup with new conditions. Excel will help you close all those pesky brackets if you forget.Xlookup works for both columns and rowsXlookup doesn’t just replace Vlookup! It can replace Hlookup as well. The syntax stay exactly the same, you just use rows instead of columns. It is a bit difficult to explain formulas without showing Excel, so I suggest you Google the formulas. There are thousands of people out there making videos on how to use formulas (I like Leila Gharani)Here are some other formulas/Excel functions that are worth learning:Charts!!! Especially if you’re in a management positionClean/Trim (I prefer Trim). Both formulas removes unwanted or nonprintable characters, such as unnecessary spaces and apostrophes.And/Or. If you’re comfortable with the IF formula, the And and Or formulas extend your logical_test conditionsRound. Using round, you can specify how many decimals you want in your number. Or you can round to the nearest 10/100/1000/etc.Roundup/rounddown. Same as round, except you either round up to the nearest 10/100/1000 or you round down to the nearest 10/100/1000Replace CONCATENATE with CONCAT. Both formulas function exactly the same, you just have less characters to rememberDate formulas. I don’t use them as much in work, but they are very nifty for people that need certain info based on dates. (Awesome ones include Day/Month/Year, Edate and EOMonth)Transpose. The formula functions exactly like the Paste Transpose option, except in formula mode.Basic font formatting. (How to change fonts/fontsizes, how to merge cells, how to change the formatting of a number/date)Hope this helps! -- source link
#reference