The Printable Excel Cheat Sheet

This simple to use Infograph cheat sheet for Excel is incredibly useful and portable!

Use it for math, for accounting, or to run a home business.

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.

** If it doesn’t show up perfectly in your browser, click on the image and make it larger.  Then print it out from the browser.**

 

3rd_times_a_charm_Excel

[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

Advertisements

3 Responses to The Printable Excel Cheat Sheet

  1. jamesjflick says:

    Reblogged this on jamesjflick and commented:
    As a super user of Excel, this is a pretty cool cheat sheet to have

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: