|
|
2001-2002 SIG Leaders: Stephen
Rasey and Alan Cherry
|
 | From the Floor: Create attendance lists by family and mentor. |
| Create a timesheet that allows for summing by Task, Client, or Project. Use Pivot Tables |
| Puzzler: Given two columns: a list of Names and a List of Scores. Print out the Names of the 1st Place, 2nd Place, and 3rd Place. Ties are possible. Think of different ways to do this. |
| Simulate rules for investing in a mutual fund. |
| Web Sites and Resources for Help and Assistance. |
| MOUS Expert Certification (what is it like?), |
| Ways to define range names, |
| Data Transmission Services (DTS) - an alternative to MS Query. |
| Summarizing many sheets onto one sheet |
| Linear Regression: plotting data and a best fit line on a chart. |
| Star Office: a free alternative to Microsoft Office. |
| Entering Unique List Items, |
| Braincel, |
| Financial Functions. |
Example Problem: You have just been awarded a prize.
You can accept the money immediately or accept it in installments over time.
The sooner you receive the money, the sooner you can invest it, but it may put you into a higher tax bracket. What portion of the prize should you receive per year to maximize the value of the prize? Use Data Tables to find what decisions are good ones.
When I use Autofilter a table, I want my totals to sum on only the rows that pass the filter, i.e. the visible rows. Use SumProduct in a worksheet and a User Defined Function to determine which rows are visible.
User Defined Function instead of nested IF statements. US Federal Tax example
Create a Bubble Chart from Stock data and Label the Bubbles with the Stock Ticker.
Basic Charts: Column, Bar, Line, and Scatter: Single series, Multiple series
Advanced charting: Techniques to Label your Data (on a Bar Graph), a Second Y-Axis
Puzzler: I have a large table with repeated fields. I want this to look like an Outline Report where the repeated fields are shown once.
Styles
Shared Workbooks
Puzzler: counting unique entries in a list - 11 Solutions
From the Floor: Pivot Table
Effective Formatting: Customizing Format Toolbars, Conditional Formating, Custom Numeric Formats, Foreground, Background, Pattern fills.
For questions or comments concerning content on this
website: Stephen Rasey |
