The Printable Excel Cheat Sheet {infographic}

3rd_times_a_charm_Excel

Share This On Your Site

The printable Excel cheat sheet

Excel can be used to prepare data, do math, and even run small businesses. With a few simple tools, you too can work wonders.

[comment# I imagine this as a printable cheat sheet. So perhaps fonts/style is very important, but I imagine other graphic/presentation to be pretty minimal so as not to distract from the sheet being a reference. Think something that someone would want to attach to the wall of their cubicle.Perhaps something that nicely frames the text?]

The Basics
[comment: I imagine these three sections being consolidated (perhaps side by side) with the majority of the graphic being commonly used formulas in a section below.]

1.)
A function = a predefined formula

Ex.
Sum = add cells
Average = find the mean of cell
Count = count a number of cells
INT = round off decimals leaving integers
Round = rounds to a specified number of digits or decimals

And hundreds more.

So you’ve chosen a function, now how do you use it?

2.)
Syntax = the way in which you must format a function for it to work

First an equal sign (=)
Then, the function name (SUM)
Then, the argument (B3:B12)

[comment# small image of =sum(B3:B12) on a spreadsheet with B column visible might be appropriate]

3.)
The argument = the information you want the function to calculate
+ = Add
- = Subtract
* = multiply
/ = divide
^ = exponent
( )’s = organization for order of operations
B3,E4,… commas seperate elements
B3:B45 colons denate ranges of cells
$ = makes references absolute

[#small box]
Order of operations
Excel treats multiplication and division of equal importance, as well as addition and subtraction
() Parentheses
^ Exponents
* or / from left to right
+ or - from left to right

4.)
References
[comment# This section takes up more space than 1-3. I imagined one through three side by side, and four spanning across the graphic below the first three.]

When pasting formulas somewhere else,
1.)=A1 = relative reference
2.)=$A1 = Column is absolute, row is relative
3.)=A$1 = Row is absolute, column is relative
4.)=$A$1 = Everything is absolute

Relative references adjust to their new surroundings.
[Format: Cell name:Contents]
-B2:4
-B3:5
-C3:=B2+6

Paste C3 to C4…And
-C4:11
[comment#use an arrow to point out the relationship pointed out in following line]
The relative reference in C3 tells excel that you want to reference the cell to the left and up one.

You can drag formulas down to fill up entire rows or columns

-A1:5-B1:=sum(A1:A5)
-A2:5-/
-A3:5-/
-A4:5-/
-A5:5-/
-A5:0-/

Excel-thumb