Skip to content

Essential Excel Functions and How To use Them

Essential Excel Functions and How to Use Them

Why is Excel Better Than Using Pen and Paper?

If you are adding a list of numbers, you do each calculation at once. What if I said you can tell the piece of paper how to add once, and repeat it the whole way down?

Excel let’s us work with big (or small) sets of numbers and allows for manipulation to be EASY, CLEAN, and REPEATABLE. This repeatable word is extremely important, it is the root of automation.

If you want to be part of the future – these are concepts you should be familiar with. Excel is a great tool to get started with that!

Quick Pre-Lesson How to Type a Formula

tab function select neutron dev
Hit tab when the function you want is selected or “blue”.

rundown excel formula rundown
A full rundown on Excel formulas in 15 seconds.

excel fx bar neutron dev
The “fx” bar lets you step into your formula.

Essential Functions

excel sum and count functions neutron dev
=SUM(): If you want to add any amount of numbers. Hold CTRL to select multiple ranges.
=COUNT(): Returns how many items are in a selection. Helpful for getting a feel for data.

excel average median functions
=AVERAGE(): Add them up, divide it by how many there were.
=MEDIAN(): List all the numbers in order, and take the middle one.

excel min max functions neutron dev
=MIN() : Returns the lowest number in range.
=MAX() : Returns the highest number in range.

excel len rept functions neutron dev
=LEN() : Tells you how many characters are in the cell.
=REPT() : Will repeat a cell value a specified amount of times.

excel left right functions
=LEFT() : Returns specified amount of characters starting from leftmost.
=RIGHT() : Returns specified amount of characters starting from rightmost.

excel concatenate function neutron dev
=CONCATENATE() : Will combine cells text.
You can add [,”insert text”,] to add more text in between.

Closing Thoughts

Now that we are getting more comfortable with Excel, I figure next time I can show you some real-life analysis.

I have been collecting some good data from my Google Analytics on the traffic of my website, so technically it will be my first post about you!

Stay tuned to learn about converting Google Analytics data into actionable signals through the power of Excel!

I aim to have the freshest Excel content for you.

If you ever have any suggestions please do not hesitate to contact me.

[This article has been originally posted on Everything Excel]

Let me know what you think about this article in the comments section below.

If you find this article helpful, please share it with others and subscribe to the blog to support me, and receive a bi-monthly-ish e-mail notification on my latest articles.