Excel Help

A LIST OF ALL EXCEL COMMANDS

HISTOGRAMS: how to make a histogram shown on a spreadsheet

FINANCIAL EQUATIONS

Time Value Functions

FORMATTING

    1. Inserting columns & rows: written instructions or video
    2. Deleting blank rows & columns: video
    3. Find and Replace: video & written instructions
    4. Fit to one page: video & written instructions
    5. Merge Cells: video & written instructions
    6. Wrap text: video & written instructions
    7. Center vertically & horizontally:  written instructions
    8. Cell Styles:video & written instructions
    9. themes: video & written instructions
    10. Freeze Panes: video & written instructions
    11. If statements: video & written instructions
    12. Filter: video & written instructions
    13. Sparklines: video & written instructions
    14. PMT (loans): video & written instructions

COMMON EQUATIONS:

  1. If statements: video & written instructions
  2. PMT (loans): video & written instructions

PROBABILITY:

Finding permutations an combinations on excel

How to find probability for dice rolls

Finding the probability of tossing a coin on excel

HYPOTHESIS TESTING

list of commands

step by step instructions for hypothesis test on excel

SAMPLES AND SURVEYS

RunningSimulation on excel

CORRELATION & LINEAR REGRESSION

correlation coefficient (r) =correl(array1,array2)

z score: =standardize(x,mean,standard deviation): Standardizing scores (finding the z-value)

NORMAL DISTRIBUTION

Excel Commands:

z-score: =standardize(x,mean,standard deviation)

z-table: =normsdist(x)

z-score from probability: =normsinv(x)

Videos and Readings:

Video: How to make a normal curve on excel  (STOP AT 2:39)

Video: How to find z-value on excel (STOP at 2:04)

FORMATTING

unhide on excel: see video or quickly look at webpage

conditional formatting: see video or quickly look at webpage

GENERAL

How to make a Histogram

How to Make a Box Plot (this is not easy)

10 Tips for Excel 2010

Quick Tips and Tricks: demos on graphing included and more…

Conditional Formatting

Sorting Data in Excel

Modifying Columns, Rows and Cells (includes merging cells)

Learn for Free Excel Help Search Site

Advertisements

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