Nonfiction Media - Excel - Revision history

Greenea: /* Modifying the Worksheet */

2013-04-08T19:53:18Z

‎Modifying the Worksheet

Greenea: /* Other tools for creating spreadsheets */

2013-04-08T15:31:29Z

‎Other tools for creating spreadsheets

Greenea at 15:30, 8 April 2013

2013-04-08T15:30:07Z

Greenea: /* Printing */

2011-02-23T17:22:44Z

‎Printing

Greenea at 23:45, 22 February 2011

2011-02-22T23:45:07Z

Greenea: /* Formulas */

2011-02-22T23:37:32Z

‎Formulas

Greenea at 18:08, 22 February 2011

2011-02-22T18:08:33Z

Greenea at 17:02, 22 February 2011

2011-02-22T17:02:42Z

Greenea: Created page with '== Excel Workshop == ===The Environment=== * Menu, toolbar * Workbook/worksheet ** Creating, moving renaming worksheets * Rows | columns | cells ===Modifying the Worksheet=== …'

2011-02-03T18:43:44Z

Created page with '== Excel Workshop == ===The Environment=== * Menu, toolbar * Workbook/worksheet ** Creating, moving renaming worksheets * Rows | columns | cells ===Modifying the Worksheet=== …'

New page

== Excel Workshop ==

===The Environment===

* Menu, toolbar
* Workbook/worksheet
** Creating, moving renaming worksheets
* Rows | columns | cells

===Modifying the Worksheet===

* Inserting a row/column
* Resizing rows/columns
* Menu > Tools > Customize > Customize Toolbars/menus
* Column Headers, page headers
* Split View

===Cell Formatting===

* Text
* Numbers, (decimals, scientific notation)
* Formulas (the formula bar) View > Formula bar
* Borders and shading

===Adding, Selecting and Moving data===

* Creating a series
* Different cursors for different operations
* Keyboard Shortcuts (control-shift-arrow, control home, control end)

===Sorting data===

* What to Sort and Not to Sort
* Rows vs. Columns
* Ascending/descending

===Formulas===

* Functions: Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure.
* Arguments: Values that a function uses to perform operations or calculations Common arguments Include numeric values, text, cell references, etc.
* Operators: +-/*
* Cell Referencing: Absolute vs. Relative

===Printing===

* Page Break view
* File > Page Setup
** Repeat headers across multiple pages
** Gridlines

[[category:2010-2011]]

@@ Line 47: / Line 47: @@
 ===Other tools for creating spreadsheets===
 *[http://docs.google.com/ Google Docs]
 *[http://www.openoffice.org/ OpenOffice]
 [[category:2010-2011]]
 [[category:2012-2013]]

← Older revision		Revision as of 15:30, 8 April 2013
Line 50:		Line 50:

	[[category:2010-2011]]		[[category:2010-2011]]
		+	[[category:2012-2013]]

@@ Line 40: / Line 40: @@
 ===Printing===
-* Page Break view
+* '''Views''': Normal and Page Layout
-* File > Page Setup
+* '''File > Page Setup'''
-** Repeat headers across multiple pages
+** '''> Sheet''' to repeat headers across multiple pages
-** Gridlines
+** add Gridlines
 ===Other tools for creating spreadsheets===

@@ Line 16: / Line 16: @@
 * The more you work with Excel you may want to customize the toolbar for those commands you use frequently: '''View > Customize Toolbars/menus'''
 * Column Headers, page headers
-* Split View
+* Split View - '''Window > Split'''
 ===Cell Formatting===

@@ Line 28: / Line 28: @@
 * Creating a series
-* Different cursors for different operations
+* Different cursors for different operations: hand, plus sign, double-headed arrow
-* Keyboard Shortcuts (control-shift-arrow, control home, control end)
+* Keyboard Shortcuts (control home, control end)
 ===Formulas===
+*AutoSum -  a quick and easy way to add cells
 * Functions: Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure.
 * Arguments: Values that a function uses to perform operations or calculations Common arguments Include numeric values, text, cell references, etc.

@@ Line 3: / Line 3: @@
 ===The Environment===
-* Menu, toolbar
+* Menu, toolbar, formatting palette
 * Workbook/worksheet
 ** Creating, moving renaming worksheets
-* Rows | columns | cells
+* Selecting Rows | columns | cells
 ===Modifying the Worksheet===
-* Inserting a row/column
+* Inserting a row/column: '''Insert > Row ...'''
-* Resizing rows/columns
+* Resizing rows/columns:
-* Menu > Tools > Customize > Customize Toolbars/menus
+**mouse over column/row header and drag border to resize
 * Column Headers, page headers
 * Split View