Excel Beginning Objectives

Upon the completion of the Beginning Excel class participants will be able to:

·    Demonstrate how to open a workbook and know difference between workbook and worksheet.

·    Identify the parts of a worksheet window.

·    Open a given workbook and be able to change views.

·    Create a blank workbook then name and save it to a specific location.

·    Recall algebraic rules that govern order of operation.

·    Format cells using text, number, percentages and currency.

·    Rotate text in a cell.

·    Enter and edit data, modify column and rows with respect to height and width, and sort data.

·    Add a worksheet to a given workbook and modify the color, name and location of its tab.

·    Use simple formulas and functions (such as min, max, count, sum, and average),

·    Use a spreadsheet to compute "loan payments" by using financial functions.

·    Understand and use absolute and relative cell references in formulas.

·    Copy values and formulas down and over in a worksheet.

·    Use the AutoSum tool on rows and columns in a worksheet.

·    Enter data into a cell and use the "merge and center" tool to combine a number of cells into one cell.

·    Set print areas, change print options and print documents.

·    Use the "Date" and "Now" functions in a worksheet.

·    Calculate the difference between two given dates in a worksheet.

·    Use various means for sorting data in a worksheet.

·    View and print the formulas version of a worksheet.

 

Excel Intermediate Objectives

Upon the completion of the Intermediate Excel class participants will be able to:

·    Demonstrate how to add a header and footer, change margins and insert a page break.

·    Add comments to a cell on a given worksheet.

·    Create a variety of charts from data in a given worksheet.

·    Use the Format Painter button to copy the formatting from one group of cells to another.

·    Enter data and then use border thickness and color to highlight and enhance.

·    Use conditional formatting for a specific set of data in a given worksheet to highlight specific data.

·    Name Cells in a given worksheet and use those names in a formula.

·    Use the COUNTIF, IF and VLOOKUP functions in a given worksheet.

·    Explore advanced format painting, styles, and additional formulas and functions.

·    Assign a name to a cell and refer to the cell in a formula by using the assigned name.

·    Demonstrate how to create and use a template.

·    Given a worksheet be able to display subtotals.

·    Add a hyperlink to a worksheet element.

·    Show how to use the find and replace command in a given worksheet.

·    Protect and unprotect cells in a worksheet.

·    Split worksheet windows.

·    Freeze rows and columns in a given worksheet.

 

Excel Advanced Objectives

Upon the completion of the Advanced Excel class participants will be able to:

·    Create a List from a set of data entered in a spreadsheet.

·    Add records to a List.

·    Do a simple sort of a List.

·    Add computational fields to a List.

·    Sort a List by one or multiple fields.

·    Compose and use a query for a List.

·    Use the Totals button to open and close the Totals row and use various options in the Total row.

·    Use the Criteria create a query from a list and print results.

·    Apply database functions, the SUMIF function and the COUNTIF function to generate information from a list

·    Create a Pivot Table from a given set of data on a worksheet.

·    Create a Pivot Chart from a given set of data on a worksheet.

·    Create an amortization schedule on a blank spreadsheet.

·    Use the Excel Speaks function to listen as you enter and review data on worksheet.

·    Use the Concatenate function in a worksheet.

·   Create a document in Excel.