Excel+2010

** Using Excel 2010 **
 * Customizing the Ribbon
 * Sparklines
 * Backstage View
 * Management Tools
 * Others: Cloud Computing, Mobile Access

** Files to Use for Training: **
 * Handout for Formulas [[file:Excel-3-Formulas-and-Functions.pdf]]
 * Examples of Commonly Used Formulas
 * Millard Staff Presentation: [[file:esu3officeapps/Beg Excel OCT-2011.ppt|Beg Excel OCT-2011.ppt]]
 * Sample Excel Spreadsheet Use For Examples: [[file:esu3officeapps/Sample Excel File for Millard.xlsx|Sample Excel File for Millard.xlsx]]
 * Excel 2010 Quick Reference Card from Custom Guides: [[file:esu3officeapps/excel-quick-reference-2010.pdf|excel-quick-reference-2010.pdf]]
 * Migrating to Excel 2010 from Microsoft--a Guide: [[file:esu3officeapps/Excel 2010 Migration Guide.PDF|Excel 2010 Migration Guide.PDF]]
 * Sources of Data CSV @http://www.aggdata.com/free-data
 * Awesome Demo Workbook for Teachers [[file:spreadsheets-for-teachers.zip]]

**Customizing the Ribbon** >>
 * **One way to customize**
 * Select the file & open it
 * File menu-->Options-->Customize Ribbon
 * **Another way to customize**
 * Select the file and open it
 * Rt. Click on the Ribbon and select Customize Ribbon from the dropdown menu
 * **When customizing the ribbon,** you can select from All commands, popular commands, etc. from the "Choose commands from" drop down

**Exporting a Custom Tab in the Ribbon:** Once you have created a customized tab, you can export the tab for use on other computers with Office 2010 installed. Here are the steps you will need:
 * **Open Excel** and go to the **"Customize Ribbon"** window (File-->Options-->Customize Ribbon[[image:import_prompt.png align="right"]])
 * At the bottom of the open window on the right side, **click the Import/Export Button** and select **Export all customizations** (see at right). You will not get the export all customizations prompt until you click the import/export button.
 * You will be prompted to **save the file**--save it on the desktop so you can easily find it.
 * Put the file on a USB thumb drive or e-mail it to yourself as an attachment so that you can access the file from the next computer.

**Importing a Custom Tab in the Ribbon:** Once you have created a customized tab on another computer and exported the file (see above), you can import the tab for use on another computer with Office 2010 installed. Here are the steps you will need:
 * **Open Excel** and go to the **"Customize Ribbon"** window (File-->Options-->Customize Ribbon[[image:esu3officeapps/import_prompt.png align="right"]])
 * At the bottom of the open window on the right side, **click the Import/Export Button** and select **Import customization file** (see at right). You will not get the import customization prompt until you click the import/export button.
 * You will be prompted to **locate the file**--navigate to where you have it saved (desktop/thumb drive, etc) to import the file.
 * All custom tabs (and the quick access toolbar) will be imported to the current computer..

**Backstage View:**
 * Similar to **FILE** menu in**Excel 2003**
 * Similar to **Microsoft Button** in **Excel 2007[[image:esu3officeapps/Backstage.png width="176" height="215" align="right"]]**
 * "What you do **TO** a file" rather than "what you do **IN** a file."
 * Tab opens **on top of the file**
 * **Selections** in Backstage View: Save, Save As, Open, Close, Info, Recent, New, Print, Save & Send, etc.
 * **Three Column View** in Backstage
 * Column One--Make a selection
 * Column Two--Options within the selection
 * Column Three--Print Preview with selections and options applied

**Sparklines:**
 * Graphic representation of cells in a spreadsheet[[image:esu3officeapps/sparkline2.png width="528" height="117" align="right" caption="Sparkline is in column J1 & J2"]]
 * Takes up only one cell
 * Unlike charts, it prints along with the spreadsheet within the spreadsheet cell if selected
 * Sparkline Options--columns, lines, win/loss
 * **To add a Sparkline:**
 * **INSERT MENU-->Sparkline**
 * Select the cells to include
 * Select the "type" of Sparkline: columns, lines, win/loss

** Management of Revisions:**
 * ** Office 2010 allows for accessing previous versions of a file **
 * ** Set the Autorecover to the correct number of minutes **
 * Select **FILE** menu
 * Select **Help** form the FILE menu
 * Selection **Options** from the HELP menu
 * Set autorecover to 3-5 minutes
 * ** To open earlier versions: **
 * Select the **FILE** menu
 * Select **INFO** from the file menu
 * Select **Versions** from the INFO menu