Saturday, March 23, 2013

Excel - Spring into Technology Conference

Site with all the resources:  http://moodle.esasd.net/moodle/course/view.php?id=45
Excel 2011 is for the Mac
Excel 2010 is for the PC

In view, normal is default, page view is neat
Window Freeze pane

All functions start with = (the cells that work) in the parentheses are the cells that you want to work on.  Use the : to anchor, after you put in the =MAX

Double click between bars to auto-click

Highlight columns and drag, all will be the same size

Put mouse on column One, under format, then cell, then alignment, adjust to angle top line.

To highlight two different columns, for a graph,  hold down command or shift key.

To copy or paste, go to edge of chart for commands.

To label graph, right click on "piece of pie"

Format = fluff or fun, be sure to check out

look for Bingo program to make in Excel Jen

For a checkbook, =f2 -d3+d4

Always use Please Excuse My Dear Aunt Sally

No comments: