Excel

=Excel=

Fantastic Support Site for Excel 2010 with video clips and How-Tos that can be printed! @http://www.gcflearnfree.org/excel2010

Basics:

 * Overview and layout (workbook, worksheets and functionality)
 * Ribbon Bar and Toolbar customization
 * Basic navigation – moving around and through a workbook quickly
 * Inserting and editing data
 * Formatting techniques – borders, frames, colors
 * Freezing and Hiding cells/rows/columns
 * Sort Data
 * Introduction to basic formulas and functions – (autosum and basic addition, subtraction, multiplication and division using cell referencing)

Formatting Basics

 * Use this sample file: [[file:excelformatsample.xlsx]]
 * 1) Select a cell and change the font, size or color of the text. If you are using the example, you change the title in cell A1 to the Verdana font, size 16 with a font color of green.
 * 2) Select a portion of the content in one cell and make only that portion bold. For example, if the words "Weight (pounds)" are in a cell, make only the word "Weight" bold.
 * 3) Add a border to a group of cells. If you are using the example, add a border to the descriptions in row 3.
 * 4) Change the fill color of a group of cells. If you are using the example, add a fill color to row 3.
 * 5) Try changing the vertical and horizontal text alignment for some cells.
 * 6) Try changing the formatting of a number. If you are using the example, change the date format in column A.

Basic Formulas & Functions

 * Use this sample file: [[file:excelbasicformsample.xlsx]]
 * 1) Open an existing Excel workbook. If you want, you can use this [|example].
 * 2) Write a simple division formula. If you are using the example, write the formula in cell B18 to calculate the painting cost per square foot.
 * 3) Write a simple addition formula using cell references. If you are using the example, write the formula in cell F5 to calculate the "Total Budget."
 * 4) Write a simple subtraction formula using the point and click method. If you are using the example, subtract the "Expand Bathroom" cost (C6) from the "Total" cost (C11). Calculate your answer in C12.
 * 5) Edit a formula using the formula bar.

Sorting Data
media type="custom" key="21574062"

Freezing Panes
media type="custom" key="21574124"



BOCES Excel File

Working with Tables in Excel
Check out this page for information on using tables in Excel.

Creating Formulas in Excel
Please visit this page for more information on using formulas in Excel.

VLOOKUP in Excel
VLOOKUP is a function in Excel... a predefined formula. Get more information here.

Backstage View Working with formulas: Video