Microsoft Excel Workshop Outline

1. Overview of spreadsheets software

2. MS Excel Interface (Related Link)

   • Title Bar

   • Menu Bar

   • Tool Bars

3. Basic Spreadsheets Terminologies/Elements (Related Link)

   • Workbooks

   • Worksheets

   • Rows

   • Columns

   • Cells

   • Range (array, matrix)

   • Name

4. Settings

5. Entering and editing text, data, formulas (Related Link)

6. Formatting worksheets, workbooks, cells (Related Link)

7. Functions (Related Link)

   • Worksheet functions

   • Math and financial functions

8. Data Analysis

   • Statistical analysis (Related Link)

   • Optimization analysis (Solver)

   • Goal seeking (Related Link)

9. Database manipulation (pivot tables)

10. Creating charts and graphics (Related Link1, Related Link2)

11. Macros (Related Link)

Selected Tutorials:

Baycon Group Excel Turorial (http://www.baycongroup.com)

Excel Tutorial from Florida Gulf Coast University

Excel Tutorial (http://www.bellevue.edu)

Excel Tutorial (http://www.usd.edu)

Solver Tutorial (http://www.solver.com/tutorial.htm)

E

Exercise to be submitted (Click here to download)

Exercise 2 (Click here to download)

Click here to download exam