Computer Applications 170:  Learning Excel      

Here is a PowerPoint you will find to be a useful introduction....  Excel   Introduction

Course What you'll learn Up to speed with Excel 2007 The layout of the new design, how to accomplish everyday tasks in Excel 2007, and a bit about the new XML file formats Get to know Excel 2007: Create your first workbook How to create a workbook, enter and edit text and numbers, and add rows or columns Get to know Excel 2007: Enter formulas How to enter simple formulas into worksheets, and how to make formulas update their results automatically

A picture is worth a thousand numbers Once you know how to make charts with Excel, you can get your point across fast and clear. With a chart you can summarize data, dramatize a comparison, or show a trend at a glance. Course What you'll learn Charts I: How to create a chart in Excel 2007 How to create a chart using the new Excel 2007 commands and make changes to a chart after you create it Make the data dance: PivotTable reports You keep hearing about them. Isn't it about time you try for yourself? In a few quick minutes, learn how to create a PivotTable report, and see what it can do for you. Then take PivotTable series and find out what the pros know. Course What you'll learn PivotTable I: Get started with PivotTable reports in Excel 2007 How PivotTable reports organize, summarize, and analyze your data to reveal its meanings. How to create a PivotTable report yourself — fast! PivotTable II: Filter PivotTable report data in Excel 2007 How to filter to hide and display selected data in PivotTable reports PivotTable III: Calculate data in PivotTable reports in Excel 2007 Power tools: how to summarize data by using summary functions other than SUM, such as COUNT and MAX. How to show data as a percentage of the total by using a custom calculation. How to create your own formulas in PivotTable reports. And that's not all – the whole schmeer Online training isn't just for Excel 2007. It's also available for the entire 2007 Microsoft Office system. Because the more you know, the better you do.

Course Description

Intended Outcomes for the course

• Develop accurate, readable worksheets for a variety of business applications.
• Use critical thinking skills to design and create worksheets.
• Use the specialized vocabulary associated with spreadsheets.

Course Activities and Design

Outcome Assessment Strategies

• performance tests
• may include objective tests, scored assignments, or projects
• may include the use of skill assessment software

Course Content (Themes, Concepts, Issues and Skills)

• Communicate effectively using appropriate spreadsheet vocabulary.
• Use critical thinking and problem solving skills in designing the spreadsheets for various business problems.
• Proofread for accuracy in the entry of data and creation of formulas.
• Assess the document for accuracy, readability, and appearance.
• Develop efficiency with specific sets of skills through repetitive reinforcement.

• Students will develop proficiency through reinforcement and assessment on the following skills:
• Building basic worksheets by entering text, numbers, and formulas.
• Generating pie and column charts by using the chart wizard.
• Developing skills in formatting, saving, and printing accurate, readable worksheets.
• Creating formulas using absolute and relative references, if and average functions, AutoSum, and grand total. Developing skills in managing multiple-sheet worksheets.
• Developing decision-making skills by using what-if analysis on spreadsheets.
• Creating lists and using sort and filter features.
• Creating a spreadsheet from data with no specific instructions.

• Using help features.
• Creating templates.
• Using 3-D referencing.
• Generating Web pages from spreadsheet documents.
• Using additional functions such as PMT, maximum, and minimum.
• Using linking and embedding concepts.
• Students may be exposed to additional spreadsheet skills/concepts as time allows.