|
Name |
Description |
Time |
YouTube Link |
| 1 |
2-up printing |
How to print (almost) any number of pages on a sheet of paper. |
3m 11s |
http://www.youtube.com/watch?v=szg_-aYJDMg |
| 2 |
Calendar 1 |
Learn how easy it is to Create a Calendar |
0m 19s |
http://www.youtube.com/watch?v=G_5tBzfN418 |
| 3 |
Calendar 2 |
Change the appearance of your calendar |
1m 32s |
http://www.youtube.com/watch?v=9T8mOp9y_Bw |
| 4 |
Calendar 3 |
Change the number of days in a week |
1m 23s |
http://www.youtube.com/watch?v=ygak9kQXKm8 |
| 5 |
Calendar 4 |
Change the starting day and language |
1m 57s |
http://www.youtube.com/watch?v=4To9CYegeww |
| 6 |
Color 1 |
Learn how easy it is to color Characters, Words, Sentences and Paragraphs |
0m 59s |
http://www.youtube.com/watch?v=-m8qqKChhDo |
| 7 |
Color 2 |
How to choose the set of colors used in your document |
1m 30s |
http://www.youtube.com/watch?v=AehaIWrirGQ |
| 8 |
Color 3 |
Advanced methods of color selection |
0m 59s |
http://www.youtube.com/watch?v=1Dnbq9TITpY |
| 9 |
Excel Spider Charts 1 |
Toggling Data Series with various mouse-click/keyboard combinations. |
1m 05s |
http://www.youtube.com/watch?v=xA9yJ5nzgFo |
| 10 |
Excel Spider Charts 2 |
Toggling Data Series with various mouse-click/keyboard combinations. |
1m 36s |
http://www.youtube.com/watch?v=DTvB0502G3E |
| 11 |
Excel Spider Charts 3 |
Clicking a Data Point |
1m 16s |
http://www.youtube.com/watch?v=yzNnkkFtHwg |
| 12 |
Excel Spider Charts 4 |
Click on a Category (Radar Axis) Label |
2m 05s |
http://www.youtube.com/watch?v=WmrrZYM4tz4 |
| 13 |
Excel Spider Charts 5 |
Click on an Axis |
1m 34s |
http://www.youtube.com/watch?v=gddd-m10zq4 |
| 14 |
Excel Spider Charts 6 |
Click on a Major Gridline |
0m 59s |
http://www.youtube.com/watch?v=BBq8UJykCpw |
| 15 |
Excel Spider Charts 7 |
Legend Quadrants |
1m 36s |
http://www.youtube.com/watch?v=_mR3CgCJMAE |
| 16 |
Excel Spider Charts 8 |
Legend Entries |
2m 43s |
http://www.youtube.com/watch?v=jFkOP8xc5jE |
| 17 |
Excel Spider Charts 9 |
Legend Key |
1m 51s |
http://www.youtube.com/watch?v=w85eDu1WNMg |
| 18 |
Excel Spider Charts 10 |
Chart Area |
2m 51s |
http://www.youtube.com/watch?v=Z7PEmsfNUjM |
| 19 |
Excel Spider Charts 11 |
Chart Title |
0m 51s |
http://www.youtube.com/watch?v=t4gxLbaU_8c |
| 20 |
Excel Spider Charts 12 |
Plot Area |
1m 42s |
http://www.youtube.com/watch?v=_2JLsgLif4Y |
| 21 |
Excel Spider Charts 13 |
It’s PlayBack time! |
1m 42s |
http://www.youtube.com/watch?v=XDMRDAvKBRg |
| 22 |
Excel Spider Charts 14 |
Flagging Percentiles |
1m 42s |
http://www.youtube.com/watch?v=zdF9nxuTM8o |
| 23 |
Indexer 1 |
Demonstration of Indexer Indexing a 30-page document with just one click |
1m 48s |
http://www.youtube.com/watch?v=TsQ93VrXQkA |
| 24 |
Indexer 2 |
Setting macro security low – the why and how of it |
1m 27s |
http://www.youtube.com/watch?v=lQGqHqU839k |
| 25 |
Indexer 3 |
Installing Indxer using the SetUp template |
1m 39s |
http://www.youtube.com/watch?v=R6J35hJi6pI |
| 26 |
Indexer 4 |
Where is the toolbar? |
1m 28s |
http://www.youtube.com/watch?v=aZwnD5NdUuk |
| 27 |
Indexer 5 |
Obtaining a collection of Interesting Words |
1m 10s |
http://www.youtube.com/watch?v=9z5ino3srlU |
| 28 |
Indexer 6 |
How to call one of indexer’s procedures from another project. |
1m 48s |
http://www.youtube.com/watch?v=TsQ93VrXQkA |
| 29 |
Mouse-less downloads |
How to download a file without using your mouse – remember anything you can do with the mouse, you can do with the keyboard, anything you can do with the keyboard, you can do with the mouse. |
1m 45s |
http://www.youtube.com/watch?v=_CvCzhMcilw |
| 30 |
Proje 1 |
Re-indenting a copy of Normal.dot |
1m 23s |
http://www.youtube.com/watch?v=EJlA5AZHUwQ |
| 31 |
Proje 2 |
Listing the categorized contents of a project |
1m 45s |
http://www.youtube.com/watch?v=Jd_z8IZw1W8 |
| 32 |
Proje 3 |
Sorting procedures in sequence within each module |
1m 20s |
http://www.youtube.com/watch?v=Mr59OpDdnzA |
| 33 |
Proje 4 |
Stripping deadwood – unused procedures – from modules of a project |
1m 10s |
http://www.youtube.com/watch?v=BLG6WbEe0i4 |
| 34 |
Proje 5 |
Harvesting all the VB and VBA code from a hard drive |
1m 30s |
http://www.youtube.com/watch?v=UcbwOqIVYZw |
| 35 |
Proje 6 |
Searching a source library of all the VB and VBA code from a hard drive |
2m 22s |
http://www.youtube.com/watch?v=nsP9eLACk04 |
| 36 |
ReFab 1 |
Manually parse and rebuild a resume section by section, leaving unresolved material at the head of the document for manual intervention. |
2m 21s |
http://www.youtube.com/watch?v=aQs1Htdk4ow |
| 37 |
ReFab 2 |
Automatically parse and rebuild a resume section by section, leaving unresolved material at the head of the document for manual intervention. (part 1) |
3m 10s |
http://www.youtube.com/watch?v=m6BklC5NfN0 |
| 38 |
ReFab 3 |
Automatically parse and rebuild a resume section by section, leaving unresolved material at the head of the document for manual intervention. (part 2) |
2m 46s |
http://www.youtube.com/watch?v=pQv_FyC05II |
| 39 |
ReFab 4 |
Manually parse and rebuild a resume section by section, leaving unresolved material at the head of the document for manual intervention. (reprise) |
8m 42s |
http://www.youtube.com/watch?v=QXYzWcp47SY |
| 40 |
ReFab 5 |
Watch how heuristic lexical analysis is performed to isolate personal details fields in a rules-based system. |
3m04s |
http://www.youtube.com/watch?v=Yw5l7lN2YJs |
| 41 |
Stain 1 |
Learn how to save a new version of the workbook, how to STAIN cells with formulae, simple range name macros |
2m 21s |
http://www.youtube.com/watch?v=JPAtSLXWkq0 |
| 42 |
Stain 2 |
Learn how to delete all range names related to a single cell or a set of cells. List all range names. Make a set of range names. WhatIsMyRangeName? On a single cell. Making names unique by using a collection of string labels. |
2m 23s |
http://www.youtube.com/watch?v=VMZ9f6L50Dw |
| 43 |
Stain 3 |
Smart range name creation. Dumping lists of range names to the worksheet and to the clipboard. |
1m 09s |
http://www.youtube.com/watch?v=HkIBxmVh2AM |
| 44 |
Stain 4 |
Loading the range names retrospectively into cell formulae. |
1m 24s |
http://www.youtube.com/watch?v=-W8-QpSC9-o |
| 45 |
Stain 5 |
Deleting empty columns and rows. Identifying unused range names. |
1m 20s |
http://www.youtube.com/watch?v=QoErtXndsfU |
| 46 |
Transposing data |
How I transpose data by rows to columns in Excel |
0m 47s |
http://www.youtube.com/watch?v=HMUwdVNlKIA |
| 47 |
TrailBlazer |
Blazing a trail through a forest of words using an identified word |
1m 37s |
http://www.youtube.com/watch?v=fdyHY80X-8I |
| 48 |
TrailBlazer |
Blazing a trail through a forest of words using a selected string |
54s |
http://www.youtube.com/watch?v=ziep6dZLuZM |
| 49 |
TrailBlazer |
Blazing a trail through a forest of words using a solicited string |
57s |
http://www.youtube.com/watch?v=qNUeLxy7TsM |
| 50 |
TrailBlazer |
Blaze a hyperlinked trail through a document based on the stored keywords in the document |
1m 02s |
http://www.youtube.com/watch?v=URpcvr8MfBU |