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](https://i0.wp.com/neutrondev.com/wp-content/uploads/2016/10/tab-function-select-neutron-dev.png?resize=300%2C179&ssl=1)
![rundown excel formula rundown](https://i0.wp.com/neutrondev.com/wp-content/uploads/2016/10/rundown-excel-formulas-neutron-dev.gif?resize=960%2C540&ssl=1)
![excel fx bar neutron dev](https://i0.wp.com/neutrondev.com/wp-content/uploads/2016/10/excel-fx-bar-neutron-dev.png?resize=187%2C76&ssl=1)
Essential Functions
![excel sum and count functions neutron dev](https://i0.wp.com/neutrondev.com/wp-content/uploads/2016/10/excel-sum-and-count-functions.gif?resize=593%2C334&ssl=1)
=COUNT(): Returns how many items are in a selection. Helpful for getting a feel for data.
![excel average median functions](https://i0.wp.com/neutrondev.com/wp-content/uploads/2016/10/excel-average-median-functions-1.gif?resize=593%2C334&ssl=1)
=MEDIAN(): List all the numbers in order, and take the middle one.
![excel min max functions neutron dev](https://i0.wp.com/neutrondev.com/wp-content/uploads/2016/10/excel-min-max-functions-neutron-dev.gif?resize=593%2C334&ssl=1)
=MAX() : Returns the highest number in range.
![excel len rept functions neutron dev](https://i0.wp.com/neutrondev.com/wp-content/uploads/2016/10/excel-len-rept-functions-neutron-dev.gif?resize=593%2C334&ssl=1)
=REPT() : Will repeat a cell value a specified amount of times.
![excel left right functions](https://i0.wp.com/neutrondev.com/wp-content/uploads/2016/10/excel-left-right-functions-1.gif?resize=593%2C334&ssl=1)
=RIGHT() : Returns specified amount of characters starting from rightmost.
![excel concatenate function neutron dev](https://i0.wp.com/neutrondev.com/wp-content/uploads/2016/10/excel-concatenate-function.gif?resize=593%2C334&ssl=1)
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.