|
|
| |
Clicks
Difficulty: Low |
Great mouse skills builder. Look along the bottom at all the sheet tabs and face the different challenges! |
| |
Critical Skills
Difficulty: Low/Mod |
This is what we use to see if folks have mid level competence. If you have been to our training and have problems with this email Jon Sysel and ask for help!
jsysel@ip-convergence.com |
| |
Absolute v Relative
Difficulty: Mod |
Two sheet tabs at the bottom. One empty, the other done. Be sure to READ what's in the formula bar! |
| |
Lottery
Difficulty: Mod |
Creative Exercise with lots of formatting and formula challenges. This is the raw file - get to work! :>) |
| |
States
Difficulty: Low |
Databse of States, Capitols and State Birds too! |
| |
People
Difficulty: Low |
Database of ficticious people.
Great for FILTERS n SORTS! No real persons intended, just random combination match ups. |
| |
People - csv file |
Practice DATA - IMPORT with this comma seperated value file! |
|
|
Casino Pivot Table & Report
Difficulty: Hi |
Play with a pivot table and pivot chart report. Remember, you can flexibly drag stuff on/off the table and chart to allow for data analysis. Cool one, all players and prizes fictional. |
Running Total
Difficulty: Mod |
Perennial favorite. Someone asks me every class. Here is a simple one based on all subtraction. You could accomodate deposits and withdrawls by always adding, then using negative numbers whenever it is a withdrawl. |
Concatenate Function
Difficulty: Mod |
Join data from a bunch of cells in to one place.
I Saved my contract employer $15k (I estimate) with this function once. |
| |
|
| |
|
|
|
