Everything Excel - The Excel Experts


Essential Excel Functions



Simple GIFs to teach you.


The best Excel tutorials online.



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 allows 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



Hit tab when function you want is selected or "blue".



A full rundown on Excel formulas in 15 seconds.



The "fx" bar lets you step into your formula.



Essential Functions






=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.




=AVERAGE() : Add them up, divide it by how many there are.

=MEDIAN() : List all the numbers in order, and take the middle one.




=MIN() : Returns the lowest number in range.

=MAX() : Returns the highest number in range.



=LEN() : Tells you how many characters are in the cell.

=REPT() : Will repeat a cell value a specified amount of times.



=LEFT() : Returns specified amount of characters starting from leftmost.

=RIGHT() : Returns specified amount of characters starting from rightmost.



=CONCATENATE() : Will combine different cells text.
You can add [,"text1"], to add custom text.



...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! My visitors.


Stay tuned to learning 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.