1 0 0 1 0 0 0 0 1 1 1 1 1 0 1 C:\Documents and Settings\Joan Thirion\My Documents\Camtasia Studio\inventory2a.camrec C:\Documents and Settings\Joan Thirion\My Documents\Camtasia Studio\inventory2b.camrec C:\Documents and Settings\Joan Thirion\My Documents\Camtasia Studio\inventory2c_fillseries.camrec C:\Documents and Settings\Joan Thirion\My Documents\Camtasia Studio\inventory2d_wrap.camrec 14.TSCTitle 9.TSCTitle 11.TSCTitle 7.TSCTitle TSCRec://c:\documents and settings\joan thirion\my documents\camtasia studio\inventory2c_fillseries.camrec!Screen_Stream.avi 0 5 8 693000000 992333333 0 24 804 540 454000000 0 0 0 454000000 15.000015 1.000000 65535 -1 65535 65535 -1 65535 65535 14 inventory2c_fillseries.camrec!Screen_Stream 0 12.TSCTitle 0 4 4 643000000 693000000 0 32 804 540 0 0 0 0 0 10.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 13 12 0 4 55 0 553000000 623000000 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 12 Untitled 0 4 54 0 475000000 545000000 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 11 Untitled 0 TSCRec://c:\documents and settings\joan thirion\my documents\camtasia studio\inventory2b.camrec!Screen_Stream.avi 0 3 8 475000000 643000000 0 24 804 540 200000000 0 0 0 200000000 15.000015 1.000000 65535 -1 65535 65535 -1 65535 65535 10 inventory2b.camrec!Screen_Stream 0 10.TSCTitle 0 2 4 425000000 475000000 0 32 804 540 0 0 0 0 0 10.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 9 10 0 4 53 0 313000000 355000000 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 8 Untitled 0 4 52 0 286000000 355000000 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 7 Untitled 0 4 51 0 186000000 246000000 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 6 Untitled 0 4 50 0 136000000 206000000 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 5 Untitled 0 4 49 0 56000000 126000000 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 4 Untitled 0 TSCRec://c:\documents and settings\joan thirion\my documents\camtasia studio\inventory2a.camrec!Screen_Stream.avi 0 1 8 45000000 425000000 0 24 804 540 380000000 0 0 0 380000000 15.000015 1.000000 65535 -1 65535 65535 -1 65535 65535 3 inventory2a.camrec!Screen_Stream 0 4 48 0 12000000 45000000 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 2 Untitled 0 4 47 0 0 45000000 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 1 Untitled 0 8.TSCTitle 0 0 4 0 45000000 0 32 804 540 0 0 0 0 0 10.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 0 8 0 4 65 0 693000000 753000000 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 15 Untitled 0 4 66 0 743000000 803000000 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 16 Untitled 0 4 67 0 932757202 992333333 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 17 Untitled 0 15.TSCTitle 0 6 4 992333333 1042333333 0 32 804 540 0 0 0 0 0 10.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 18 15 0 TSCRec://c:\documents and settings\joan thirion\my documents\camtasia studio\inventory2d_wrap.camrec!Screen_Stream.avi 0 7 8 1042333333 1316333333 0 24 804 540 370660000 0 0 0 370660000 15.000015 1.000000 65535 -1 65535 65535 -1 65535 65535 19 inventory2d_wrap.camrec!Screen_Stream 0 4 68 0 1042333333 1113991965 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 20 Untitled 0 4 69 0 1114564935 1184564935 0 0 0 0 0 0 0 0 0 0.000000 1.000000 65535 -1 65535 65535 -1 65535 65535 21 Untitled 0 0 1 0 1 0 0x00000000 1.00 150 480 150 640 10 10 10 10 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}} {\colortbl ;\red0\green0\blue0;} \viewkind4\uc1\pard\qc\cf1\fs36 Steps 7 - 10\par Formatting Cells and filling in Item Numbers\par } 1 134.00 101.00 396.00 273.00 10000000 35000000 10000000 10000000 Rounded Rectangle 1 0 1 47 1 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\roundededgerecttransparent.png 0xFF000000 0xFFFFFFFF 0 16 16 1 0 0 0 0 0 0 0 Rounded Rectangle 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 273 480 396 640 10 10 10 10 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\froman\fcharset0 Times New Roman;}{\f2\fnil\fcharset0 Arial;}} {\colortbl ;\red0\green0\blue0;} \viewkind4\uc1\pard\sb100\sa100\f0\fs28 First, we will format the values as currency. Here's how:\f1\fs24\par \pard\qc\cf1\f2\fs36\par } 1 130.00 283.00 395.00 92.00 22000000 35000000 10000000 10000000 Rounded Rectangle 1 0 1 48 0 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\roundededgerecttransparent.png 0xFF000000 0xFFFFFFFF 0 16 16 1 0 0 0 0 0 0 0 Rounded Rectangle 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 154 540 157 804 40 25 10 40 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}} {\colortbl ;\red0\green0\blue0;} \viewkind4\uc1\pard\qc\cf1\fs36 To Highlight all the unit cells, highlight the first one\par } 1 359.00 103.00 394.00 153.00 21000000 71000000 10000000 10000000 Arrow 3 3 1 49 0 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\arrow_1.png 0xFF000000 0xFFFFFFFF 2 100 100 0 1 1 1 0 0 0 0 Arrow 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 154 540 157 804 40 25 10 40 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}} {\colortbl ;\red0\green0\blue0;} \viewkind4\uc1\pard\qc\cf1\fs36 Then immediately hold down the SHIFT key while you click the last unit cell.\par } 1 350.00 360.00 394.00 180.00 101000000 151000000 10000000 10000000 Arrow 3 3 1 50 0 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\arrow_1.png 0xFF000000 0xFFFFFFFF 2 100 100 0 1 1 1 0 0 0 0 Arrow 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 113 540 224 804 15 10 10 10 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fprq2\fcharset0 Arial;}{\f1\fnil\fcharset0 Arial;}} {\colortbl ;\red0\green0\blue0;} \viewkind4\uc1\pard\qc\cf1\f0\fs28 Whatever is highlighted will be effected by the menu options you choose next. \f1\fs36\par } 1 42.00 243.00 224.00 113.00 151000000 201000000 10000000 0 Filled Rounded Rectangle 5 3 1 51 1 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\roundededgeplainrect.png 0xFF000000 0xFFFFFFFF 0 88 88 1 1 1 1 0 0 0 0 Filled Rounded Rectangle 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 154 540 157 804 40 10 25 40 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}} {\colortbl ;\red0\green0\blue0;} \viewkind4\uc1\pard\qc\cf1\fs28 Click on currency to make it format as currency.\par } 1 31.00 151.00 236.00 181.00 251000000 300000000 10000000 10000000 Arrow 6 3 1 52 0 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\arrow_1.png 0xFF000000 0xFFFFFFFF 0 100 100 0 1 1 1 0 0 0 0 Arrow 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 154 540 157 804 40 10 25 40 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}} {\colortbl ;\red0\green0\blue0;} \viewkind4\uc1\pard\qc\cf1\fs28 And remember to press OK to accept this\par } 1 151.00 349.00 236.00 181.00 278000000 300000000 10000000 10000000 Arrow 6 3 1 53 1 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\arrow_1.png 0xFF000000 0xFFFFFFFF 0 100 100 0 1 1 1 0 0 0 0 Arrow 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 154 540 157 804 10 40 40 25 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}} {\colortbl ;\red0\green0\blue0;} \viewkind4\uc1\pard\qc\cf1\fs28 Clicking on the number 1 highlights the whole row\par } 1 17.00 189.00 181.00 236.00 10000000 60000000 10000000 10000000 Arrow 7 10 1 54 0 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\arrow_1.png 0xFF000000 0xFFFFFFFF 3 100 100 0 1 1 1 0 0 0 0 Arrow 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 154 540 157 804 10 40 40 25 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}} {\colortbl ;\red0\green0\blue0;} \viewkind4\uc1\pard\qc\cf1\fs28 Clicking on the letter D highlights the whole column\par } 1 153.00 179.00 181.00 236.00 88000000 138000000 10000000 10000000 Arrow 8 10 1 55 0 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\arrow_1.png 0xFF000000 0xFFFFFFFF 3 100 100 0 1 1 1 0 0 0 0 Arrow 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 113 540 224 804 15 10 10 10 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}} {\colortbl ;\red0\green0\blue0;} \viewkind4\uc1\pard\qc\cf1\fs28 Then, highlight all the item #'s by clicking the 1 and then holding the SHIFT key and clicking the last item \par } 1 42.00 243.00 224.00 113.00 60000000 110000000 10000000 0 Filled Rounded Rectangle 10 14 1 66 1 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\roundededgeplainrect.png 0xFF000000 0xFFFFFFFF 0 88 88 1 1 1 1 0 0 0 0 Filled Rounded Rectangle 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 113 540 224 804 15 10 10 10 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}} {\colortbl ;\red0\green0\blue0;} \viewkind4\uc1\pard\qc\cf1\fs28 If it didn't work for you, perhaps you forgot to type the first 1 in A2.\par } 1 276.00 224.00 224.00 113.00 249757202 299333333 10000000 0 Filled Rounded Rectangle 11 14 1 67 0 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\roundededgeplainrect.png 0xFF000000 0xFFFFFFFF 0 88 88 1 1 1 1 0 0 0 0 Filled Rounded Rectangle 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 154 540 157 804 40 25 10 40 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}} {\colortbl ;\red0\green0\blue0;} \viewkind4\uc1\pard\qc\cf1\fs36 Hover over the border between the letters B and C until your cursor looks like this. Then hold your mouse down and drag.\par } 1 177.00 44.00 587.00 181.00 10000000 61658632 10000000 10000000 Arrow 13 19 1 68 0 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\arrow_1.png 0xFF000000 0xFFFFFFFF 2 100 100 0 1 1 1 0 0 0 0 Arrow 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 154 540 157 804 40 25 10 40 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\froman\fcharset0 Times New Roman;}{\f2\fnil\fcharset0 Arial;}} {\colortbl ;\red0\green0\blue0;} \viewkind4\uc1\pard\sb100\sa100\f0\fs32 Click on the box between A & 1 to highlight the entire spreadsheet.\f1\fs24\par \pard\qc\cf1\f2\fs36\par } 1 50.00 53.00 587.00 181.00 82231602 132231602 10000000 10000000 Arrow 13 19 1 69 0 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\arrow_1.png 0xFF000000 0xFFFFFFFF 2 100 100 0 1 1 1 0 0 0 0 Arrow 1 0x00000000 2 75 4 4 0 1 0 1 0 0x01B90000 1.00 113 540 224 804 15 10 10 10 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}} {\colortbl ;\red0\green0\blue0;} \viewkind4\uc1\pard\qc\cf1\fs28 You need to type the first item in the series and press Enter.\par } 1 42.00 243.00 224.00 112.00 10000000 60000000 10000000 0 Filled Rounded Rectangle 10 14 1 65 0 0 0x00000000 1 75 2 2 http://www.techsmith.com 0 0 0 1 0 0x00000000 ClipImageAbove C:\PROGRA~1\TECHSM~1\CAMTAS~1\Media\Studio\Callouts\roundededgeplainrect.png 0xFF000000 0xFFFFFFFF 0 88 88 1 1 1 1 0 0 0 0 Filled Rounded Rectangle 1 0x00000000 2 75 4 4 0 0x000003E9 Steps 7 - 10 : Formatting cells and filling item numbers 1 0 0 0 0x000003EA Step 8 : Center the quantities and headings 1 0 9 0 0x000003EB Step 9: Insert the Item Numbers using fill series 1 0 13 0 0x000003EC Step 10: column size and wrap 1 0 18 0 5 0 0 0 30666668 0 0 5 1 0 110000000 166000001 0 0 5 2 0 299333333 367333331 0 0 3 0 0 168000000 200000000 0 0 0 0 0 45000000 72000000 2 0 7 0 0 274000000 370660000 0 12 Step 9: Insert the Item Numbers using fill series 0x00C080FF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fprq2\fcharset0 Arial;}} {\colortbl ;\red0\green0\blue0;} \viewkind4\uc1\pard\qc\cf1\f0\fs48 Step 9: Insert the Item Numbers using fill series\par } 10.00 10.00 784.00 520.00 1 1 804 540 11 Step 9: Insert the Item Numbers using fill series 0x00C080FF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fprq2\fcharset0 Arial;}} {\colortbl ;\red0\green0\blue0;} \viewkind4\uc1\pard\qc\cf1\f0\fs48 Step 9: Insert the Item Numbers using fill series\par } 10.00 10.00 784.00 520.00 1 1 804 540 10 Step 8 : Center the quantities and headings 0x00000000 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}} {\colortbl ;\red255\green255\blue255;} \viewkind4\uc1\pard\qc\cf1\fs36\par } 10.00 10.00 784.00 520.00 1 1 804 540 9 Step 8 : Center the quantities and headings 0x00C080FF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fswiss\fprq2\fcharset0 Arial;}{\f1\fnil\fcharset0 Arial;}} {\colortbl ;\red0\green0\blue0;\red255\green255\blue255;} \viewkind4\uc1\pard\qc\cf1\f0\fs48 Step 8 : Center the quantities and headings \cf2\f1\fs36\par } 10.00 10.00 784.00 520.00 1 1 804 540 8 Steps 7 - 10 : Formatting cells and filling item numbers 0x00C080FF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}} {\colortbl ;\red255\green255\blue255;} \viewkind4\uc1\pard\qc\cf1\fs36\par } 10.00 10.00 620.00 460.00 1 1 640 480 7 Steps 7 - 10 : Formatting cells and filling item numbers 0x00C080FF 2 0 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}} {\colortbl ;\red0\green0\blue0;\red255\green255\blue255;} \viewkind4\uc1\pard\qc\cf1\fs36 Steps 7 - 10 : \par Formatting cells and filling item numbers\cf2\par } 10.00 10.00 620.00 460.00 1 1 640 480 14 Step 10: column size and wrap 0x00C080FF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\fswiss\fprq2\fcharset0 Arial;}} {\colortbl ;\red0\green0\blue0;} \viewkind4\uc1\pard\sb100\sa100\qc\f0\fs56 Make the column sizes what you want \par and wrap all the cells \par \fs40 to start: \fs36 Grab the bar between the B & C to drag it so that most item names fit. \par \par \pard\qc\cf1\f1\fs48\par } 10.00 10.00 784.00 520.00 1 1 804 540 15 Step 10: column size and wrap 0x00C080FF 2 1 1 {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\fswiss\fprq2\fcharset0 Arial;}} {\colortbl ;\red0\green0\blue0;} \viewkind4\uc1\pard\sb100\sa100\qc\f0\fs56 Make the column sizes what you want \par and wrap all the cells \par \fs40 to start: \fs36 Grab the bar between the B & C to drag it so that most item names fit. \par \par \pard\qc\cf1\f1\fs48\par } 10.00 10.00 784.00 520.00 1 1 804 540 32 0 0 1