Key Excel Shortcuts

Why is excel important? From engineering to marketing, architecture to law; I can guarantee that at some point your company will ask you to use excel so here are some quick tips!

  • VLOOKUP 

You can use VLOOKUP when you need to find things in a table or range by row. This can be done by:

=VLOOKUP(lookup value, the range containing the lookup value, the column number in the range containing the return value, optionally specify TRUE for the approximate match or FALSE for an exact match)

  • COUNTIF

Use COUNTIF is one of the statistical functions to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list. This can be done by:

=COUNTIF(Where do you want to look?, What do you want to look for?)

  • Concatenate

Use CONCATENATE, one of the text functions, to join two or more text strings into one string. This can be done by:

=CONCATENATE (first text, second text,... text)

This can also change text into number format.

For example, if cell A1 contains the number 23.5, you can use the following formula to format the number as a dollar amount:

=TEXT(A1,"£0.00")

Result: £23.50

Could these help in your work?

Latest Blogs