Microsoft_Excel_2013_logo.svg

3 Excel Formulas You Must Know For Your Next Interview

As you prepare for your next job interview or promotion, there are three Excel formulas that you must know if you want to impress your interviewer. These three Excel formulas are simple to learn, easy to implement into almost any project, and sure to impress your prospective boss. In addition, these formulas are great time-savers and will make your job easier, wherever you end up!

1. VLOOKUP

This is one of the most crucial Excel formulas to learn, yet it is also one that a lot of people have trouble mastering. So, if you can master this formula, it’s a good way to showcase your Excel skills. Once you know how to use it, you’ll also find that VLOOKUP has a broad range of uses and numerous applications. Knowing how to use the VLOOKUP formula is a foundational Excel skill that will open many doors for you.

2. SUMIF/COUNTIF

Technically, SUMIF and COUNTIF are two different Excel formulas, but their structure and function is similar. Rather than doing a simple add or count, these two functions allow you to apply conditions to your formula. So, if you have a column of data, and you only want to add or count lines that meet a particular set of criteria, you can use these two functions to accomplish that. Aside from Excel formulas job interviewshowing your future boss that you know how to use Excel, demonstrating an understanding of these two Excel formulas shows that you know how to use Excel efficiently. These two formulas allow you to integrate a conditional (if) statement and an addition command into one formula, turning what would normally be a two-step process into a one-step process. This saves you time and allows you to work more efficiently. If you know how to use these Excel formulas (and others like) them, you will demonstrate that you are a smart Excel user.

3. IF/AND/OR

Again, this is not technically “one” Excel formula, but the use and function of these three formulas is very similar. IF, AND, and OR form the basis of conditional statements in Excel. These three formulas allow you to evaluate data and other formulas against a set of given criteria. They allow you segregate your data and to pull out and evaluate only that data which you really need. If you know how to use these three Excel formulas, you can build extensive logic trees and other complicated formula strings. If you can demonstrate to a future boss that you can use these three formulas proficiently and creatively, you will be sure to impress.

Learn More Than Just How to Use  Excel Formulas

Get even more free tips and tricks when you signup for our free email newsletter. You’ll receive free Excel tips and tricks directly in your inbox and also receive exclusive discounts to our upcoming training classes.

Microsoft_Excel_2013_logo.svg

4 Advanced Excel Formulas Everyone Should Know

Whether you are applying for a new job or looking to get ahead in your current one, there are four key advanced Excel formulas that you should know in order to be successful. The following four formulas are extremely flexible and extremely powerful. Used by themselves or with others, these four advanced Excel formulas will enable you to amplify your data analysis.

1. VLOOKUP Formula

The VLOOKUP formula is one of Excel’s most useful functions. Consequently, knowing how to design and use VLOOKUPs is an Excel skill frequently requested by hiring managers. If you are confronted with a large set of data, a VLOOKUP allows you to pull select values out of the data set by defining a look-up value (such as a name or other unique key). The look-up value tells Excel which row in your data set to pull data from. Once you’ve specified the row you need via your look-up value, you simply need to tell Excel which column to pull data from. The VLOOKUP formula will pull the data at the intersection of the row and column you have specified. So, if your data set is very large, the VLOOKUP formula makes it very easy to quickly find the specific data you need. This makes the VLOOKUP one of the most important advanced Excel formulas you can learn.4 key advanced excel formulas

2. IF Formula

The IF formula allows you to insert logic into your data analysis. It functions as a simple “If…, then…” statement does in regular speech. Using the IF formula, you can create a logical test (such as A1>0), have Excel evaluate your statement/test, and then create two outcomes (based on whether the statement/test you have created evaluates as true or false). The real power in this particular advanced Excel formula lies in nesting the functions, which enables you to create logic trees. You can create an initial IF formula and then build additional IF formulas to serve as the outcomes of the initial formula. So, if A1>0 evaluates as true, you can tell Excel to evaluate the IF formula A2>10, and so on. Using the IF formula, it is very easy to design very complicated decision-making sequences.

3. CONCATENATE Formula

The CONCATENATE formula is a text formula, and its use is tied to the most important advanced Excel formula (the VLOOKUP). CONCATENATE enables you to combine two or more strings of text (or numbers) together. For example, if cell A1 contains “First” and cell A2 contains “Last”, then you can use CONCATENATE to create the value “FirstLast” in cell A3. This is especially helpful if you need to create unique look-up values (or keys) for a VLOOKUP formula. And if you have trouble remembering how to spell “Concatenate”, you can simply use the “& “symbol between your cell references (i.e. use A1&A2 rather than CONCATENATE(A1,A2)).

4. AND/OR Formulas

AND and OR formulas are two very similar types of logical formulas (much like the IF formula). The reason they are included on our list of advanced Excel formulas is because when they are used in conjunction with the IF formula, the flexibility of the IF formula increases exponentially. AND works just like you would expect it to. If everything inside of the formula evaluates as true, then the entire formula evaluates as true. If even one function inside the formula evaluates as false, the entire formula evaluates as false. OR works very similarly, except as long as at least one function inside the formula evaluates as true, the formula will evaluate as true. Only if every function inside OR evaluates as false will the entire formula evaluate as false. So, if you nest an AND or OR formula inside an IF formula, you can create extremely powerful advanced Excel formulas.

Learn Even More Advanced Excel Formulas

While these four formulas are some of the most important formulas to learn, there are many other advanced Excel formulas that will enable you to unlock the full potential of Microsoft Excel. Signup for one of our classes or upcoming webinars to learn about even more formulas and how you can use them in your everyday work.

You can also join our mailing list to receive free Excel tips and exclusive discounts on our training classes right in your inbox!