Excel+for+Classified+Staff

This class will help classified staff learn to use Excel for many purposes. This is a basic Excel class. The expectation is that participants have little experience with the program. Excel simplifies the way you collect and analyze information and lets you be more productive while doing it. Simply enter any piece of data into an Excel worksheet and choose from a variety of features to help you arrange information, evaluate data trends, and convert the results into easy to read charts, graphs, and tables.
 * Excel Introduction **


 * Basic Excel - **Will include basic OPAC expectations for data and text manipulation:
 * EDIT, SORT, RELOCATE, REWORK, FORMAT

Participants will do the following with Excel: 
 * **Use basic terminology associated with Excel **
 * Cell
 * Rows and Columns
 * Ribbon
 * Sheets
 * Gridlines
 * **Format a Spreadsheet**
 * Sizing
 * Font
 * Cell Color Coding
 * Justification
 * Merging
 * Gridline Styles
 * Text Orientation
 * Wrapping Text
 * **Print Settings**
 * Headers and Footers
 * Titles
 * Grid Lines
 * **Sorting Information **
 * Rename and Arrange sheets
 * Sorting and Filtering Data
 * Fill Series
 * Separating Text to Columns
 * Separating Text into Columns
 * 1) If you have text all in one column that you would like in two different columns, such as, first name and last name in one single column.
 * 2) Click on the Data tab in the Ribbon.
 * 3) Under the heading of Tools, click on Text to Columns.
 * 4) <span style="font-family: Arial,Helvetica,sans-serif;">Make sure Delimited is selected, click Next.
 * 5) <span style="font-family: Arial,Helvetica,sans-serif;">Selected the way that the data is separated, such as, tab, space, comma, etc. Click Next.
 * 6) <span style="font-family: Arial,Helvetica,sans-serif;">Select Column data format: general, text, date for each column. Click Finish.Copying Data Easily
 * 7) <span style="font-family: Arial,Helvetica,sans-serif;">Sequential Filling Data
 * <span style="font-family: Arial,Helvetica,sans-serif;">Inserting a Chart
 * 1) Select columns that you want to graph (make sure that you include the titles).
 * 2) Click Insert.
 * 3) Select the type of graph (chart) that you would like to create (bar, pie, linear, etc.).
 * 4) You can change the titles, colors and preferences by double clicking
 * 5) Click on the graph of the items you would like to change. You can insert the chart on a different sheet by going to Chart on the top menu and selecting move chart.
 * <span style="font-family: Arial,Helvetica,sans-serif;">Conditional Formatting - This feature allows you to quickly see differences in a set of data by color coding the data for you. You set the conditions and color/style that you want and it does the rest. Quick Start Guide to Conditional Formatting
 * <span style="font-family: Arial,Helvetica,sans-serif;">Data for Conditional Formatting Example:

Templates


 * NEW! UPDATE FOR CAFETERIA MANAGERS**

=<span style="font-family: Georgia,serif;">Video Help Library = @http://video.about.com/spreadsheets/Headers-and-Footers-in-Excel.htm (video) || <span style="font-family: Georgia,serif;">Want to learn more about Excel 2010? Simply visit, <span style="font-family: Georgia,serif; line-height: 1.5;"> @http://www.gcflearnfree.org/excel2010
 * <span style="font-family: Georgia,serif;">Finding Commands in the Ribbon || <span style="font-family: Georgia,serif;">@http://office.microsoft.com/en-us/excel-help/video-introduction-to-the-ribbon-in-excel-2010-VA101825135.aspx ||
 * <span style="font-family: Georgia,serif;">Formatting Your Spreadsheet || <span style="font-family: Georgia,serif;">@http://www.gcflearnfree.org/excel2010/4.2 ||
 * <span style="font-family: Georgia,serif;">Inserting Columns and Rows || <span style="font-family: Georgia,serif;">@http://www.gcflearnfree.org/excel2010/3.2 ||
 * <span style="font-family: Georgia,serif;">Inserting Headers and Footers || @http://www.dummies.com/how-to/content/adding-a-standard-header-or-footer-in-excel-2010.html
 * <span style="font-family: Georgia,serif;">Renaming Sheets || @http://office.microsoft.com/en-us/excel-help/rename-a-sheet-HP005202108.aspx ||
 * <span style="font-family: Georgia,serif;">Printing Your Worksheet || <span style="font-family: Georgia,serif;">@http://www.gcflearnfree.org/excel2010/8.2 ||
 * <span style="font-family: Georgia,serif;">Sorting Data || <span style="font-family: Georgia,serif;">@http://www.gcflearnfree.org/excel2010/11.2 ||
 * <span style="font-family: Georgia,serif;">Creating graphs, charts, and tables || <span style="font-family: Georgia,serif;">@http://www.gcflearnfree.org/excel2010/17.2 ||
 * Overall Microsoft Office Help || http://empowerstudents.wikispaces.com/Microsoft+Office+Suite+2007+and+2010+for+PCs ||


 * Intermediate Excel **


 * PRACTICE BASIC OPAC EXPECTATIONS FOR DATA AND TEXT MANIPULATION

Sample Data Workbook-

By using a PivotTable report, you can summarize, analyze, explore, and present a summary of your worksheet data. 1. Open the data you wish to create the PivotTable. Making sure that it is formatted correctly for PivotTables. 2. On the Insert Tab, click PivotTable. Excel will automatically determine the range for the PivotTable report. 3. You can choose to place the PivotTable in a New Worksheet or on an Existing Worksheet. 4. Next you will add Fields to your PivotTable report by selecting the fields and layout options. There are four sections you may add fields: Report Filter, Column Labels, Row Labels, and Values. By default, test fields are added to the Row Labels area, numeric fields are added to Values area, and date and time data is added to the Column Labels area. You may change the Row and Column Labels area interchangeably to suit your needs. The Values area will sum data by default. By using the drop down arrow beside the data name you can change that calculation from sum to count, average, max, min, and many other calculations. Example for Creating a PivotTable -
 * Creating Pivot Tables (Note: Insert Header, Move/Create/Rename Worksheets)**

1. To create formulas using more than one operation be sure to use order of operations correctly (Parenthesis, Exponents, Mulitplication, Division, Addition, Subtraction). Parenthesis are needed to separate values that need to be calulated first. Example of Complex Formulas -
 * Creating Complex Formulas (Note: Create Chart)**

1. Select the Row or Column you want to show/hide. To select a whole row click the number in front of the row. To select a whole column click the letter above the column. 2. Then on the Home tab, click Format, then select Hide/Unhide under Visibility.
 * Show or Hide Columns or Rows**
 * Use Complex Formula Example to show this.

There are two types of cell references: **relative** and **absolute**. Relative references change when a cell is copied into another cell this is the default for Excel. Absolute references no not change when copied into another cell. 1. Using a $ in front of a column or row reference makes that part of the cell remain unchanged. Example of Relative and Absolute Cell References:
 * Relative and Absolute Cell References (Note: show sorting here also)**

If you are creating a long list and would like your heading to remain visible throughout the document when viewing: 1. Click on the View tab and Select Freeze Panes. 2. Select what you would like to freeze, top row, first column, or pane
 * Freeze Panes**
 * Use Relative and Absolute Cell References to show this.

1. Select Review and then select New Comment. 2. In the box the pops up, type your comment. 3. When finished, click off of the comment box and a small red triangle will appear in the cell where the comment was made.
 * Inserting Comments**
 * Use Relative and Absolute Cell References to show this.

If you would like to create drop down menus in an excel document, this document will show you how.
 * How to Create a Drop Down Menu** -

Data for Conditional Formatting Example:
 * Conditional Formatting** - <span style="font-family: Arial,Helvetica,sans-serif;">This feature allows you to quickly see differences in a set of data by color coding the data for you. You set the conditions and color/style that you want and it does the rest. Quick Start Guide to Conditional Formatting


 * How to Link Across Workbooks/Sheets** - If you would like to link one worksheet to another or a part of a worksheet to another, here are the instructions.


 * Creating Pivot Tables || @http://fiveminutelessons.com/learn-microsoft-excel/how-create-pivot-table-excel ||
 * Creating Complex Formulas || @http://www.gcflearnfree.org/excel2010/9 ||
 * Working with Basic Functions || @http://www.gcflearnfree.org/excel2010/10 ||
 * Outlining Data || @http://www.gcflearnfree.org/excel2010/12.2 ||
 * Show or Hide Columns or Rows || @http://office.microsoft.com/en-us/excel-help/show-or-hide-columns-and-rows-HP010342574.aspx ||
 * Relative and Absolute Cell References || @http://www.gcflearnfree.org/excel2013/15 ||
 * Freeze Panes || @http://spreadsheets.about.com/od/excel101/ss/freeze_pane.htm ||
 * Inserting Comments || @http://www.dummies.com/how-to/content/using-excel-2010s-cell-comment-feature.html ||
 * Creating a Drop Down || @http://spreadsheets.about.com/od/datamanagementinexcel/ss/2011-09-05-excel-2010-data-validation-pt-1.htm ||
 * Conditional Formatting || @http://www.gcflearnfree.org/excel2010/19 ||

<span style="display: block; height: 1px; left: 0px; overflow: hidden; position: absolute; top: 1944px; width: 1px;"> Data for Conditional Formatting Example: <span style="display: block; height: 1px; left: 0px; overflow: hidden; position: absolute; top: 1969.5px; width: 1px;"> <span style="display: block; height: 1px; left: 0px; overflow: hidden; position: absolute; top: 2041px; width: 1px;"> <span style="font-family: Georgia,serif;">1. If you have text all in one column that you would like in two different columns, such as, first name and last name in one single column. 2. Click on the Data tab in the Ribbon. 3. Under the heading of Tools, click on Text to Columns. 4. Make sure Delimited is selected, click Next. 5. Selected the way that the data is separated, such as, tab, space, comma, etc. Click Next. 6. Select Column data format: general, text, date for each column. Click Finish. <span style="display: block; height: 1px; left: 0px; overflow: hidden; position: absolute; top: 1864px; width: 1px;">http://empowerstudents.wikispaces.com/Microsoft+Office+Suite+2007+and+2010+for+PCs
 * Conditional Formatting** - <span style="font-family: Arial,Helvetica,sans-serif;">This feature allows you to quickly see differences in a set of data by color coding the data for you. You set the conditions and color/style that you want and it does the rest. Quick Start Guide to Conditional Formatting
 * **Conditional Formatting** - <span style="font-family: Arial,Helvetica,sans-serif; line-height: 1.5;">This feature allows you to quickly see differences in a set of data by color coding the data for you. You set the conditions and color/style that you want and it does the rest. Quick Start Guide to Conditional Formatting
 * Data for Conditional Formatting Example:
 * <span style="font-family: Georgia,serif;">Separating Text into Columns **