Excel Workshops or Online Tips Archive

Excel Basics
Identify parts of Excel window, add and rename sheets; learn selection and navigation techniques; enter and edit data; create simple formulas; discover print options.

Excel Beyond Basics
Learn various move and copy techniques; insert rows and columns; create a series, use two common functions; introduction to absolute references; make better sense of spreadsheets with freeze and split window features; add borders; create a quick chart. Prerequisites: Excel Basics or equivalent experience.

Work Faster in Excel
See how mixed references, control+enter, autocomplete, and naming can all save time. Ditto for custom views, complex series, and templates! Prerequisites: Excel Basics and Beyond Basics or equivalent experience.

Clearer and More Accurate Spreadsheets
This two hour workshop shows how to define dynamic color coding, improve printouts with labels and custom page breaks, add explanatory notes, navigate by hyperlinks, enter decimals more quickly, create data links for auto updating, define rules data must meet and automatic notifications for when it fails, audit a cell to discover dependency, protect formulas from change yet leaving other cells open to change. Prerequisites: Excel Basics and Beyond Basics or equivalent experience.

Excel Charting Basics
Create charts and apply different formats. See how to change the appearance of chart parts plus what chart options are available. Add data to a chart and edit with the chart wizard. Prerequisites: Excel Basics and Beyond Basics or equivalent experience.

Excel's Math-Date Functions
Covers these Excel functions: Product, Round, Int, Power, Sqrt, Abs, Roman, Today, Now, Days360, NetWorkDays. Prerequisites: Excel Basics and Beyond Basics or equivalent experience.

Excel's Statistical-Logical Functions
Covers these functions: Max, Min, Median, StDev, Count, logical functions including If. Prerequisites: Excel Basics and Beyond Basics or equivalent experience.

Excel's Financial-Lookup Functions
Use the Paste Function feature to calculate these: payments, interest rates, time, plus present and future values. Then see how the Lookup function helps in retrieving certain values from lists--fast! Prerequisites: Excel Basics and Beyond Basics or equivalent experience.

Online Here and Now (offered also as a workshop):  Working with Multiple Excel Worksheets: Gradebook Example
Try formatting multiple worksheets and entering data onto them at once. Then see how worksheets can draw data from other worksheets. Prerequisites: Excel Basics and Beyond Basics or equivalent experience.

Excel for Database-type Lists
Need a list you can filter and perhaps summarize numerically but don't have time to learn a database program? Try an Excel list. Topics coverered in this workshop:

• Setting up a list
• Entering records via a data form
• Simple sorting and custom sorting
• Displaying subsets of data using autofilter and advanced filters
• Subtotals by groups
• Creating formulas with functions relevant to lists

Online Here and Now: What's New in Excel 2007
Looks at the latest version of Excel--new and revamped features including the ribbon, quick access toolbar, file types, increased capacity, mini toolbar, improved status bar, tab manipulation, formula helps, appearance options, conditional formatting changes, using tables, chart tools. Also includes a handy reference: Frequently-Used Commands.

Last updated 5/04/07 To sign up for workshops, write or call Peggy at 6836. URL: http://training.hanover.edu/Workshops/Excel/exdescribe.htm