The 10 best Excel formulas for beginners
If you're new to Excel, figuring out where to start can be a bit overwhelming. There are so many functions and formulas available that learning them all sometimes seems like an impossible task.
To that end, we've compiled a list of the 10 best Excel formulas for a beginner to learn. Our goal here is to provide a succinct list of places for beginners to start to quickly and easily learn this incredibly powerful program.
Without further ado — the top 10 Excel formulas for beginners to learn. Click the name of each function for an in-depth tutorial on how to use it.
SUM. Excel's most simple formula, SUMallows you to add up the values of numbers in a row or column. This function is extremely useful for calculating totals across data tables. AVERAGE. A great place to start after you've learned about SUM, AVERAGEtakes the average of numbers in a row or column. It's great for simple average calculations, and can also be used to calculate rolling averages to smooth out data IF. This versatile function is the foundation of logical formulas, which execute different commands depending on whether given conditions are met. For example, you could use IFto output one message, like "congratulations!", if sales representatives have met a particular sales quota for the quarter; and an entirely different message, like "better luck next time!", if they have not. Learning IFis key to unlocking some of Excel's most advanced functionality. SUMIF. SUMIFextends the logical formulations within IFeven further, allowing you to take the sum of items in a range of values contingent upon a given external criteria. For example, if you have a list of sales by date and customer, you could use SUMIFto sum the revenue from sales to a particular customer while ignoring the rest. COUNTIF. Like SUMIF, COUNTIFextends logical formulations. It allows you to count the number of items in a range of values contingent upon a given criteria. For example, you could count the number of sales made to a particular customer in a given month based on a list of all sales. CONCATENATE. Excel's most basic string function, CONCATENATEallows you to combine two strings of text together. You can use it for a number of different purposes that require combining strings. For example, you could use it to combine a user's first name and last name with a given domain name to create a complete e-mail address. RIGHTand LEFT. These functions are used to chop up strings of text and extract only the important parts that you care about. RIGHT, for example, can extract the state abbreviation from a City, State combination for easy parsing and handling by other functions. SEARCH. Another string function, SEARCHhelps you find a given string of text within another, bigger string. Use it to check to see whether a block of text contains a given search criteria. For example, try use it to search for a particular last name within a cell that contains a person's full name. VLOOKUP. One of Excel's most-used functions — particularlly for Excel experts — VLOOKUPhelps you extract a value from a foreign table based on a given lookup criteria. As an example, you could use it to dynamically pull out a user's e-mail address from a table of contact information based on their name or phone number. INDEX MATCH. VLOOKUPhas a bigger, better, even-more-useful brother: INDEX MATCHthis handy formula contains much of the same functionality as VLOOKUP, but it a bit easier to use and more versatile in tricky situations.
Save three hours of work a day with these 5 simple Excel hacks
Work smarter, not harder. Sign up for our 5-day mini-course to receive must-learn lessons on how to automate your work using Excel.
- Why the TRUE and FALSE functions are so important...
- Why to rethink the way you do VLOOKUPs...
- Plus, we'll reveal why you shouldn't use PivotTables and what to use instead...