|
|||||||||||||||||||||||||||||||||||||||||||
Spreadsheets
| Microsoft Excel 2003: Enhancing Appearance & Usability | |
|
Intended Audience:
|
Faculty, staff, graduate students |
|
Prerequisite Skills:
|
Completion of the appropriate Introductory Excel course or equivalent knowledge. |
|
Course Description:
|
Course includes: -- Using the formatting toolbar and menus -- Adjusting row height and column width -- Adding borders, colors, and patterns to cells -- Use the format painter to copy formatting -- Creating, applying, and modifying a Style -- Using conditional formatting and merging cells |
|
Current Offerings:
|
There are no courses scheduled at this time. |
| Microsoft Excel 2003: Formulas and Functions | |
|
Intended Audience:
|
Faculty, staff, graduate students |
|
Prerequisite Skills:
|
Completion of the appropriate Introductory Excel course or equivalent knowledge. |
|
Course Description:
|
Course includes: -- Creating simple and intermediate level formulas -- Using "Autosum", "Autofill", and "Range Names" -- Working with Absolute and Relative cell references -- Using financial, statistical, and date functions -- Using IF statements and other conditional formulas -- Linking worksheets and using "Vlookup" to convert values |
|
Current Offerings:
|
There are no courses scheduled at this time. |
| Microsoft Excel 2003: Managing Workbooks | |
|
Intended Audience:
|
Faculty, staff, graduate students |
|
Prerequisite Skills:
|
Completion of the appropriate Introductory Excel course or equivalent knowledge. |
|
Course Description:
|
Course includes: -- Switching between sheets in a workbook -- Inserting, deleting, renaming, and moving worksheets -- Referencing external data -- Creating headers, footers, and page numbers -- Working with print options including: scale, print area, page breaks, and paper size -- Creating and using templates, as well as workbook protection |
|
Current Offerings:
|
There are no courses scheduled at this time. |
| Microsoft Excel 2003: Pivot Tables and Charts | |
|
Intended Audience:
|
Faculty, staff, graduate students |
|
Prerequisite Skills:
|
Completion of the appropriate Introductory Excel course or equivalent knowledge |
|
Course Description:
|
-- Creating a pivot table and specifying the data a pivot table analyzes -- Creating subtotals, using database functions and using "Lookup" functions -- Working with Charts |
|
Current Offerings:
|
There are no courses scheduled at this time. |
| Microsoft Excel 2003: What If Analysis and Databases | |
|
Intended Audience:
|
Faculty, staff, graduate students |
|
Prerequisite Skills:
|
Completion of the appropriate Introductory Excel course or equivalent knowledge |
|
Course Description:
|
Course includes: -- Creating a list and using the data form to add records -- Finding and deleting records, sorting and filtering a list, and creating a custom "Autofilter" -- Filtering a list with an advanced filter -- Using data validation -- Defining a scenario and creating a scenario summary report -- Using a one-and-two-input data table -- Understanding "Goal Seek" and using "Solver" |
|
Current Offerings:
|
There are no courses scheduled at this time. |