Microsoft Excel
Workshop Information
|
Format used for handouts is Microsoft Word. To save the files, right click on the link, choose "Save Target As..." |
| Excel Basics I: Navigating and Formatting |
2.0 hours |
|
| This workshop assumes no prior experience with Excel. Topics include an introduction to Excel; entering and editing data in cells; cut, copy and paste; formatting fonts, alignments, borders and shading. Lots of shortcuts! |
||
| Excel 2003 | ||
| Workshop Handout |
18 pages |
|
| Instructor Notes | 7 pages |
|
| Excel 2007 | ||
| Workshop Handout | 21 pages |
|
| Instructor Notes | 7 pages |
|
| Excel Basics II: Math and Functions |
2.0 hours |
|
| This workshop assumes minimal experience with Excel, Basics I recommended. Topics include working with series; number formatting; working with formulas; using basic functions; using absolute and relative references; and naming cells and cell ranges. |
||
| Excel 2003 | ||
| Workshop Handout |
10 pages |
|
| Excel 2007 | ||
| Workshop Handout | 11 pages |
|
| ALL VERSIONS | ||
| Instructor Notes | 10 pages |
|
| Excel: Printing and Setup | 1.0 hour |
|
| This workshop assumes some experience with Excel, Basics I recommended. Topics include print preview; printing selections; print areas; page orientation; scaling; margins; centering; headers; footers; printing titles; gridlines; column headings; page break preview; and page breaks. |
||
| Excel 2003 | ||
| Workshop Handout | 14 pages |
|
| Instructor Notes | 4 pages |
|
| Excel 2007 | ||
| Workshop Handout | 16 pages |
|
| Instructor Notes | 5 pages |
|
| ALL VERSIONS | ||
Workshop File |
||
| Excel: Multiple Worksheets | 1.0 hour |
|
| This workshop assumes some experience with simple math within Excel, Basics II recommended. Topics include inserting, deleting and renaming worksheets; linking worksheets; editing and printing multiple worksheets and linking workbooks. |
||
| Excel 2003 | ||
| Workshop Handout | 10 pages |
|
| Instructor Notes | 2 pages |
|
| Excel 2007 | ||
| Workshop Handout | 11 pages |
|
| Instructor Notes | 3 pages |
|
| Excel: Charts and Graphs |
2.0 hours |
|
| This workshop assumes prior experience with Excel, Basics I recommended. Topics include data groupings; creating and modifying charts; chart types; source data; chart options; chart locations; formatting; adding trend lines and error bars. |
||
| Excel 2003 | ||
| Workshop Handout | 14 pages |
|
| Excel 2007 | ||
| Workshop Handout | 15 pages |
|
| Instructor Notes | 3 pages |
|
| ALL VERSIONS | ||
Workshop File |
||
| Excel: Sorting and Filters |
1.5 hours |
|
| This workshop assumes some experience with Excel, Basics I recommended. Topics include single and multilevel sorting; data groupings; subtotals; applying and customizing data filters; and copying and totaling filtered data. |
||
| Excel 2003 | ||
| Workshop Handout | 8 pages |
|
| Excel 2007 | ||
| Workshop Handout | 9 pages |
|
| ALL VERSIONS | ||
Workshop Files |
||
| Excel: Pivot Tables |
1.5 hours |
|
| This workshop assumes some experience with Excel, Basics II recommended. Topics include data groupings, pivot tables, pivot charts, formatting pivot tables, adding and removing data, multiple data forms, and sorting in pivot tables. |
||
| Excel 2003 | ||
| Workshop Handout | 10 pages |
|
| Excel 2007 | ||
| Workshop Handout | 14 pages |
|
| ALL VERSIONS | ||
Workshop Files |
||
| OTHER STUFF... | ||
| How do I create and work with Macros? | 4 pages |
|
| How can I install the Statistical Analysis Tools to use Regression Analysis? | 4 pages |
|
| Excel Text Functions (Upper, Right...) | 5 pages |
|
| Excel Logic Functions (Conditional, If, SumIf...) | 4 pages |
|
| Excel Other Math Functions (Complex) | 11 pages |
|
