Description
It explains a comprehensive guide to various tips and tricks in Microsoft xls.
TEXT Entries to Time
Avg ACD Time Avg ACW Time Other Time Staffed Time
Agent Name
ACD Calls
% Idle
ACD Time ACW Time
AUX Time Avail Time
Agent 01 Agent 02 Agent 03 Agent 04 Agent 05 Agent 06 Agent 07 Agent 08 Agent 09 Agent 10 Agent 11 Agent 12 Agent 13 Agent 14 Agent 15 Agent 16 Agent 17 Agent 18 Agent 19 Agent 20 Agent 21 Agent 22 Agent 23 Agent 24 Agent 25 Agent 26 Agent 27 Agent 28 Agent 29 Agent 30 Agent 31 Agent 32 Agent 33 Agent 34 Agent 35 Agent 36 Agent 37 Agent 38 Agent 39
24 9 4 0 25 0 11 21 2 16 26 27 23 25 3 23 30 30 13 8 12 19 20 22 16 6 22 31 0 20 16 14 13 23 13 25 16 17 26
26.88% 7.29% 5.45% 0.00% 16.66% 0.00% 9.04% 26.48% 0.00% 13.10% 29.98% 26.36% 21.78% 24.05% 2.30% 16.91% 30.02% 28.43% 17.69% 3.58% 10.46% 20.80% 21.75% 17.56% 15.01% 5.67% 19.85% 32.27% 0.00% 22.59% 12.83% 14.39% 13.87% 13.58% 8.31% 20.92% 8.11% 17.84% 30.59%
00:07:40 00:06:05 00:04:44 00:00:00 00:07:37 00:00:00 00:06:08 00:05:31 00:07:55 00:08:33 00:06:42 00:07:19 00:07:42 00:07:44 00:14:18 00:09:43 00:04:34 00:06:22 00:06:30 00:07:34 00:07:11 00:05:05 00:07:53 00:11:43 00:14:40 00:07:06 00:08:10 00:05:26 00:00:00 00:07:09 00:11:54 00:06:28 00:08:59 00:10:27 00:10:10 00:06:42 00:09:13 00:11:59 00:06:35
00:00:00 00:00:00 00:15:56 00:00:00 00:01:22 00:00:00 00:00:00 00:00:00 00:00:04 00:01:18 00:00:14 00:00:00 00:01:08 00:00:00 00:04:40 00:02:22 00:00:00 00:00:45 00:00:05 00:00:31 00:00:44 00:02:21 00:01:31 00:00:01 00:00:00 00:00:00 00:02:12 00:00:38 00:00:00 00:01:26 00:03:53 00:01:42 00:03:57 00:02:32 00:03:51 00:02:07 00:05:30 00:00:11 00:00:00
03:04:07 00:54:47 00:18:57 00:00:00 03:10:37 00:00:00 01:07:31 01:55:47 00:15:50 02:16:49 02:54:17 03:17:42 02:56:57 03:13:09 00:42:54 03:43:35 02:17:02 03:11:11 01:24:27 01:00:31 01:26:13 01:36:33 02:37:45 04:17:45 03:54:43 00:42:35 02:59:37 02:48:41 00:00:00 02:22:57 03:10:20 01:30:28 01:56:46 04:00:25 02:12:14 02:47:37 02:27:30 03:23:51 02:51:15
00:00:00 00:00:00 01:03:44 00:00:00 00:33:59 00:00:00 00:00:02 00:00:00 00:00:07 00:20:53 00:05:52 00:00:00 00:26:07 00:00:00 00:14:01 00:54:28 00:00:00 00:22:16 00:01:07 00:04:10 00:08:46 00:44:43 00:30:18 00:00:32 00:00:00 00:00:00 00:48:30 00:19:33 00:00:00 00:28:40 01:02:14 00:23:54 00:51:20 00:58:14 00:49:58 00:52:49 01:27:59 00:03:10 00:00:00
00:07:30 00:00:32 00:03:19 00:00:00 00:04:38 00:00:00 00:00:14 00:02:36 00:01:07 00:02:41 00:00:23 00:27:30 00:08:27 00:09:08 00:01:10 00:21:45 00:03:20 00:02:05 00:00:44 00:03:14 00:14:06 00:09:43 00:28:03 00:27:51 00:16:29 00:06:57 00:06:58 00:22:58 00:00:00 00:18:42 00:32:37 00:10:25 00:16:23 00:17:19 00:23:20 00:30:38 00:19:46 00:15:53 00:11:26
02:55:41 06:59:00 06:37:44 00:30:50 03:16:11 08:29:56 06:21:10 04:17:13 00:02:03 04:40:14 02:57:26 02:09:03 03:08:12 03:01:58 07:18:52 02:04:07 03:36:20 02:30:02 05:36:37 06:51:56 05:47:07 04:13:53 03:02:57 01:58:27 03:04:41 07:33:10 02:54:08 02:14:34 08:30:45 03:18:35 02:41:44 05:09:29 04:17:14 02:16:50 04:23:53 02:34:23 03:31:22 03:43:21 02:51:16
02:15:01 00:37:19 00:27:52 00:00:00 01:25:02 00:00:00 00:44:36 02:15:18 00:00:00 01:06:24 02:33:17 02:06:47 01:51:18 02:01:42 00:11:41 01:26:18 02:33:01 02:25:12 01:30:53 00:17:48 00:53:18 01:46:21 01:50:56 01:26:11 01:17:00 00:30:14 01:41:20 02:44:46 00:00:00 01:53:29 01:05:48 01:13:01 01:11:09 01:11:10 00:42:31 01:47:14 00:41:10 01:36:54 02:36:00
08:22:19 08:31:39 08:31:36 00:30:50 08:30:27 08:29:56 08:13:33 08:30:54 00:19:07 08:27:01 08:31:15 08:01:02 08:31:01 08:25:57 08:28:38 08:30:13 08:29:43 08:30:46 08:33:48 08:17:39 08:29:30 08:31:13 08:29:59 08:10:46 08:32:53 08:52:56 08:30:33 08:30:32 08:30:45 08:22:23 08:32:43 08:27:17 08:32:52 08:43:58 08:31:56 08:32:41 08:27:47 09:03:10 08:29:57
Steps: 1. Enter a zero in a blank cell. 2. Copy the cell with the zero using Ctrl+C. 3. Highlight the text cells. 4. From the menu, choose Edit – Paste Special – Values – Add – OK. 5. By adding a zero to the text cells, they will be converted to real numbers. Else 1. Enter a 1 in a blank cell. 2. Copy the cell with the zero using Ctrl+C. 3. Highlight the text cells. 4. From the menu, choose Edit – Paste Special – Values – Multiply – OK. 5. By multiplying a 1 to the text cells, they will be converted to real numbers. Note: You can also use the Mouse Shortcut of Right Click - Paste Special - Values - Multiply or Add - OK
Filter Unique Names
Mar - 2005 Pallavi Jadhav Sonal Gupta Devika Rane Imran Bakali Malavika Shirva Sharlotte Fernandes Ainy Almerhi Anil Malhotra Roshan D'souza Maneesh Shahani Shilpa Saraf Nicola Arunasalam Monidipa Sengupta Manuel D'souza Maradona Fernandes Neeta Narang Taranjit Khalsi Vishal Khandwala Serena Louis Sunita Fernandes Charmaine Rao Nilesh Gosrani Kavita Singh Nilesh Satam Balasubramaniam Iyer Kunal Singh Vijaypal Singh Jean Rodrigues Pradnya Pednekar Bhavna Singh Gabriello Gomes Devendra Kate Zohar Rueben Naqqash Merchant Iyer Balasubramaniam Saleem Shaikh Subhash Vijan Rupali Panvelkar Philomena Nazareth Apr - 2005 Pallavi Jadhav Sonal Gupta Devika Rane Imran Bakali Malavika Shirva Sharlotte Fernandes Ainy Almerhi Anil Malhotra Roshan D'souza Maneesh Shahani Shilpa Saraf Nicola Arunasalam Monidipa Sengupta Manuel D'souza Maradona Fernandes Neeta Narang Taranjit Khalsi Vishal Khandwala Serena Louis Sunita Fernandes Charmaine Rao Nilesh Gosrani Kavita Singh Nilesh Satam Balasubramaniam Iyer Kunal Singh Vijaypal Singh Jean Rodrigues Pradnya Pednekar Bhavna Singh Gabriello Gomes Devendra Kate Zohar Rueben Naqqash Merchant Iyer Balasubramaniam Saleem Shaikh Subhash Vijan Rupali Panvelkar Philomena Nazareth May - 2005 Pallavi Jadhav Sonal Gupta Devika Rane Imran Bakali Malavika Shirva Sharlotte Fernandes Ainy Almerhi Anil Malhotra Roshan D'souza Maneesh Shahani Shilpa Saraf Nicola Arunasalam Monidipa Sengupta Manuel D'souza Maradona Fernandes Charmaine Rao Nilesh Gosrani Kavita Singh Nilesh Satam Balasubramaniam Iyer Kunal Singh Vijaypal Singh Jean Rodrigues Pradnya Pednekar Bhavna Singh Gabriello Gomes Devendra Kate Zohar Rueben Naqqash Merchant Iyer Balasubramaniam Saleem Shaikh Subhash Vijan Rupali Panvelkar Philomena Nazareth Reshmi Jasani Tejas Prabhu Dilbaug Bhui Geetika Gosain George Lazarus Steps: 1. On a Blank Workbook or On a New Sheet, Copy Paste the Name 2. Do not leave any Blank Rows in between 2 Ranges of Data 4. If your names start in cell A1, formula to be entered in cell B1 is 5. Drag the formula till the End of the Range 7. Go to the First Filled Cell in the New Range and Apply a Filter 8. Select Blanks in the Filter Drop Down List
3. In the Column next to the ones containing the names, type the f
6. Copy the range generated through formulas and Paste Special as
9. Select the Range by using the Keyboard Shortcut Shift Ctrl Down
10. Delete all Blank Rows by using the Keyboard Shortcut Ctrl and t
11. Go to the Cell where the filter was applied and Select All from th
Reshmi Jasani Tejas Prabhu Dilbaug Bhui Geetika Gosain George Lazarus Malcom Coelho Sameep Chamate Sameer Vaswani John Lonan Manisha Shevade Vernon Dmello Gaurav Chowdhur Jyotin Pandya Lydia Fernandes Sennen Pareira Smita jadhav Sudhakar Dinda Maria Pareira Shihas Moidoo Kinjal Vyas Ronald Saldanha Johar Menezes Alexander Valladares Parver Kazi Richard Thomas Mineta Singh Pearl Leo Juned Syed Pratik Bhatia Seema Wagle Shikta Chaturvedi Komal Bagul Nikunj Joshi Rohan Kanchan Venessa D'costa Silvester Dhaser Rickin Magdani Steve Pinto Kajal Shah Dipa Lulla Srimantini Roy Yadul Jayraj Bhagyashree Vichare Mitesh Rajani
Reshmi Jasani Tejas Prabhu Dilbaug Bhui Geetika Gosain George Lazarus Malcom Coelho Sameep Chamate Sameer Vaswani John Lonan Manisha Shevade Vernon Dmello Gaurav Chowdhur Jyotin Pandya Lydia Fernandes Sennen Pareira Smita jadhav Sudhakar Dinda Maria Pareira Shihas Moidoo Kinjal Vyas Ronald Saldanha Johar Menezes Alexander Valladares Juned Syed Pratik Bhatia Seema Wagle Shikta Chaturvedi Komal Bagul Nikunj Joshi Rohan Kanchan Venessa D'costa Silvester Dhaser Rickin Magdani Steve Pinto Kajal Shah Dipa Lulla Srimantini Roy Yadul Jayraj Bhagyashree Vichare Mitesh Rajani Sandeep Lalla Rishi Utmani Savio dias Serjeel Shaikh
Malcom Coelho Sameep Chamate Sameer Vaswani John Lonan Manisha Shevade Vernon Dmello Gaurav Chowdhur Jyotin Pandya Lydia Fernandes Sennen Pareira Smita jadhav Sudhakar Dinda Maria Pareira Shihas Moidoo Kinjal Vyas Ronald Saldanha Johar Menezes Juned Syed Pratik Bhatia Seema Wagle Shikta Chaturvedi Komal Bagul Nikunj Joshi Rohan Kanchan Venessa D'costa Silvester Dhaser Rickin Magdani Steve Pinto Kajal Shah Dipa Lulla Srimantini Roy Yadul Jayraj Bhagyashree Vichare Mitesh Rajani Sandeep Lalla Rishi Utmani Savio dias Serjeel Shaikh Nisar Aly Sardar Anslem Menezes Mitul Modi Elton Hendricks Poonam Chugh Smita Mascarenhas
Sandeep Lalla
Nisar Aly Sardar
Reshma Makhija
ok or On a New Sheet, Copy Paste the Name Ranges one below the other
ank Rows in between 2 Ranges of Data
to the ones containing the names, type the following formula the End of the Range Cell in the New Range and Apply a Filter using the Keyboard Shortcut Shift Ctrl Down Arrow Key
in cell A1, formula to be entered in cell B1 is =if(countif($A$1:A1,A1)>1,"",A1)
erated through formulas and Paste Special as Values to remove the formulas
Filter Drop Down List
ws by using the Keyboard Shortcut Ctrl and the - (Number Pad)
re the filter was applied and Select All from the Drop Down List
Add Comments to Your Formulas
Vlookup Example Jan Feb Mar 10 80 97 20 90 69 30 100 45 40 110 51 50 120 77
Type a month to look for : Which column needs to be picked out : The result is :
Feb 4 100
Formula entered in Cell F14 and the Notes given below should be enough to explain this Tip Note: It turns out that N of a number is the number and N of any text is zero. Thus, you can add several N functions to a formula without changing the result, provided that they contain text. Thus, if you have figured out some obscure formula, you can leave yourself notes about the formula. This function will work only if your original formula's output is numerical in nature.
Print Page Headings on Each Page Countrywise Salesperson Report for 2003 - 2005
Country UK UK USA USA USA USA UK UK USA USA USA USA USA USA USA UK UK USA USA USA USA UK USA UK UK USA UK USA USA USA USA USA USA USA USA USA USA USA USA USA USA UK USA UK USA USA USA USA UK UK UK USA USA USA USA UK USA USA USA USA UK USA USA USA USA USA USA USA Salesperson Buchanan Suyama Peacock Leverling Peacock Leverling Buchanan Dodsworth Leverling Peacock Davolio Peacock Peacock Peacock Callahan Dodsworth Suyama Fuller Leverling Peacock Callahan Buchanan Davolio Suyama Suyama Leverling Suyama Davolio Callahan Fuller Callahan Callahan Fuller Peacock Peacock Leverling Peacock Davolio Callahan Callahan Peacock King Callahan Suyama Davolio Davolio Peacock Fuller Suyama Buchanan Suyama Peacock Fuller Callahan Peacock King Davolio Callahan Davolio Fuller King Leverling Callahan Davolio Fuller Fuller Davolio Peacock Order Date 16-Jul-03 10-Jul-03 12-Jul-03 15-Jul-03 11-Jul-03 16-Jul-03 23-Jul-03 15-Jul-03 17-Jul-03 22-Jul-03 23-Jul-03 25-Jul-03 29-Jul-03 30-Jul-03 25-Jul-03 31-Jul-03 23-Aug-03 12-Aug-03 31-Jul-03 6-Aug-03 2-Aug-03 9-Aug-03 2-Aug-03 30-Aug-03 6-Aug-03 12-Aug-03 16-Aug-03 9-Aug-03 14-Aug-03 13-Aug-03 16-Aug-03 16-Aug-03 12-Sep-03 21-Aug-03 21-Aug-03 23-Aug-03 27-Aug-03 26-Aug-03 30-Aug-03 28-Aug-03 3-Sep-03 28-Aug-03 3-Sep-03 4-Sep-03 2-Sep-03 11-Sep-03 5-Sep-03 10-Sep-03 11-Sep-03 10-Sep-03 11-Sep-03 13-Sep-03 18-Sep-03 17-Sep-03 9-Oct-03 18-Sep-03 17-Sep-03 9-Oct-03 23-Sep-03 25-Sep-03 24-Sep-03 23-Oct-03 27-Sep-03 26-Sep-03 3-Oct-03 4-Oct-03 4-Oct-03 3-Oct-03 OrderID 10248 10249 10250 10251 10252 10253 10254 10255 10256 10257 10258 10259 10260 10261 10262 10263 10264 10265 10266 10267 10268 10269 10270 10271 10272 10273 10274 10275 10276 10277 10278 10279 10280 10281 10282 10283 10284 10285 10286 10287 10288 10289 10290 10291 10292 10293 10294 10295 10296 10297 10298 10299 10300 10301 10302 10303 10304 10305 10306 10307 10308 10309 10310 10311 10312 10313 10314 10315 Order Amount $440.00 $1,863.40 $1,552.60 $654.06 $3,597.90 $1,444.80 $556.62 $2,490.50 $517.80 $1,119.90 $1,614.88 $100.80 $1,504.65 $448.00 $584.00 $1,873.80 $695.62 $1,176.00 $346.56 $3,536.60 $1,101.20 $642.20 $1,376.00 $48.00 $1,456.00 $2,037.28 $538.60 $291.84 $420.00 $1,200.80 $1,488.80 $351.00 $613.20 $86.50 $155.40 $1,414.80 $1,170.37 $1,743.36 $3,016.00 $819.00 $80.10 $479.40 $2,169.00 $497.52 $1,296.00 $848.70 $1,887.60 $121.60 $1,050.60 $1,420.00 $2,645.00 $349.50 $608.00 $755.00 $2,708.80 $1,117.80 $954.40 $3,741.30 $498.50 $424.00 $88.80 $1,762.00 $336.00 $268.80 $1,614.80 $182.40 $2,094.30 $516.80 Note: Similar steps to be followed to repeat Columns on the Left on Every Print Out which spans across the Width of the Worksheet. Steps: 1. Select Page Setup from the File menu 2. The dialog box offers four tabs. Select the fourth tab, called Sheet. 3. Enter 1:6 in the box called Rows to Repeat at Top in order to have rows 1 through 5 repeated at the top of each printed page. 4. Select Print Preview to ensure that the results are what you desire.
Excel Training
14th September 2005
Rohan Fernandes
USA UK USA UK UK USA UK USA UK USA USA USA USA USA USA UK USA UK USA UK UK USA USA USA USA UK USA USA USA USA USA USA USA UK UK USA USA UK USA UK UK USA UK UK USA USA USA USA USA USA USA UK USA USA UK USA UK USA USA USA USA USA UK USA USA USA USA USA USA USA UK USA USA USA
Davolio Suyama Callahan King Buchanan Leverling King Peacock Dodsworth Davolio Peacock Fuller Peacock Peacock Leverling Dodsworth Leverling Buchanan Callahan King King Peacock Peacock Fuller Davolio King Peacock Peacock Peacock Fuller Leverling Peacock Peacock King Suyama Davolio Leverling King Callahan Suyama Suyama Davolio Buchanan Buchanan Peacock Davolio Leverling Peacock Davolio Leverling Callahan King Fuller Callahan Suyama Davolio Buchanan Peacock Davolio Leverling Davolio Davolio Buchanan Fuller Callahan Leverling Peacock Callahan Leverling Davolio Dodsworth Davolio Fuller Peacock
8-Oct-03 10-Oct-03 4-Oct-03 11-Oct-03 18-Oct-03 11-Oct-03 23-Oct-03 14-Oct-03 10-Oct-03 14-Oct-03 14-Oct-03 14-Oct-03 17-Oct-03 23-Oct-03 28-Oct-03 21-Oct-03 21-Oct-03 25-Oct-03 28-Oct-03 24-Oct-03 25-Oct-03 29-Oct-03 29-Oct-03 4-Nov-03 8-Nov-03 5-Nov-03 4-Nov-03 6-Nov-03 5-Nov-03 11-Nov-03 8-Nov-03 8-Nov-03 15-Nov-03 15-Nov-03 3-Dec-03 20-Nov-03 18-Nov-03 25-Nov-03 20-Nov-03 20-Nov-03 27-Nov-03 2-Dec-03 27-Nov-03 26-Nov-03 2-Dec-03 3-Dec-03 28-Nov-03 4-Dec-03 4-Dec-03 2-Dec-03 30-Dec-03 2-Dec-03 2-Dec-03 9-Dec-03 27-Dec-03 24-Dec-03 9-Dec-03 11-Dec-03 9-Dec-03 9-Dec-03 13-Dec-03 13-Dec-03 19-Dec-03 13-Dec-03 16-Jan-04 13-Dec-03 16-Dec-03 18-Dec-03 20-Dec-03 23-Dec-03 25-Dec-03 20-Dec-03 20-Dec-03 24-Dec-03
10316 10317 10318 10319 10320 10321 10322 10323 10324 10325 10326 10327 10328 10329 10330 10331 10332 10333 10334 10335 10336 10337 10338 10339 10340 10341 10342 10343 10344 10345 10346 10347 10348 10349 10350 10351 10352 10353 10354 10355 10356 10357 10358 10359 10360 10361 10362 10363 10364 10365 10366 10367 10368 10369 10370 10371 10372 10373 10374 10375 10376 10377 10378 10379 10380 10381 10382 10383 10384 10385 10386 10387 10388 10389
$2,835.00 $288.00 $240.40 $1,191.20 $516.00 $144.00 $112.00 $164.40 $5,275.71 $1,497.00 $982.00 $1,810.00 $1,168.00 $4,578.43 $1,649.00 $88.50 $1,786.88 $877.20 $144.80 $2,036.16 $285.12 $2,467.00 $934.50 $3,354.00 $2,436.18 $352.60 $1,840.64 $1,584.00 $2,296.00 $2,924.80 $1,618.88 $814.42 $363.60 $141.60 $642.06 $5,398.72 $136.30 $8,593.28 $568.80 $480.00 $1,106.40 $1,167.68 $429.40 $3,471.68 $7,390.20 $2,046.24 $1,549.60 $447.20 $950.00 $403.20 $136.00 $834.20 $1,689.78 $2,390.40 $1,117.60 $72.96 $9,210.90 $1,366.40 $459.00 $338.00 $399.00 $863.60 $103.20 $863.28 $1,313.82 $112.00 $2,900.00 $899.00 $2,222.40 $691.20 $166.00 $1,058.40 $1,228.80 $1,832.80
Excel Training
14th September 2005
Rohan Fernandes
UK USA USA USA USA UK USA UK USA USA USA USA USA USA USA USA UK USA USA USA USA UK USA USA USA USA USA USA USA USA USA USA USA UK UK UK USA USA UK USA USA USA USA USA USA USA USA USA USA UK USA USA USA USA USA USA UK USA USA USA USA USA USA USA USA USA USA USA UK USA USA USA USA UK
Suyama Leverling Fuller Davolio Davolio Suyama Davolio Buchanan Fuller Callahan Davolio Davolio Callahan Peacock Fuller Davolio King Fuller Callahan Leverling Leverling Dodsworth Callahan Leverling Fuller Leverling Callahan Peacock Peacock Peacock Leverling Callahan Fuller Suyama King Suyama Peacock Peacock King Leverling Peacock Peacock Leverling Leverling Leverling Callahan Leverling Callahan Leverling Suyama Peacock Leverling Leverling Callahan Leverling Leverling Suyama Peacock Peacock Leverling Callahan Peacock Callahan Davolio Peacock Callahan Callahan Fuller King Peacock Callahan Davolio Fuller Buchanan
26-Dec-03 31-Dec-03 1-Jan-04 3-Jan-04 3-Jan-04 3-Jan-04 6-Jan-04 2-Jan-04 9-Jan-04 8-Jan-04 16-Jan-04 10-Jan-04 10-Jan-04 9-Jan-04 8-Jan-04 22-Jan-04 13-Jan-04 30-Jan-04 14-Jan-04 14-Jan-04 15-Jan-04 21-Jan-04 15-Jan-04 16-Jan-04 17-Jan-04 24-Jan-04 27-Jan-04 28-Jan-04 24-Jan-04 30-Jan-04 27-Jan-04 27-Jan-04 31-Jan-04 24-Feb-04 27-Jan-04 14-Feb-04 6-Feb-04 3-Mar-04 4-Feb-04 7-Feb-04 3-Feb-04 7-Feb-04 7-Feb-04 4-Mar-04 13-Feb-04 7-Feb-04 11-Feb-04 12-Feb-04 14-Feb-04 10-Feb-04 28-Feb-04 14-Mar-04 18-Feb-04 14-Feb-04 21-Feb-04 20-Feb-04 19-Feb-04 7-Mar-04 24-Feb-04 27-Feb-04 11-Mar-04 12-Mar-04 26-Feb-04 26-Feb-04 25-Feb-04 3-Mar-04 28-Feb-04 3-Mar-04 4-Mar-04 28-Feb-04 3-Mar-04 5-Mar-04 18-Mar-04 6-Mar-04
10390 10391 10392 10393 10394 10395 10396 10397 10398 10399 10400 10401 10402 10403 10404 10405 10406 10407 10408 10409 10410 10411 10412 10413 10414 10415 10416 10417 10418 10419 10420 10421 10422 10423 10424 10425 10426 10427 10428 10429 10430 10431 10432 10433 10434 10435 10436 10437 10438 10439 10440 10441 10442 10443 10444 10445 10446 10447 10448 10449 10450 10451 10452 10453 10454 10455 10456 10457 10458 10459 10460 10461 10462 10463
$2,090.88 $86.40 $1,440.00 $2,556.95 $442.00 $2,122.92 $1,903.80 $716.72 $2,505.60 $1,765.60 $3,063.00 $3,868.60 $2,713.50 $855.01 $1,591.25 $400.00 $1,830.78 $1,194.00 $1,622.40 $319.20 $802.00 $966.80 $334.80 $2,123.20 $224.83 $102.40 $720.00 $11,188.40 $1,814.80 $2,097.60 $1,707.84 $1,194.27 $49.80 $1,020.00 $9,194.56 $360.00 $338.20 $651.00 $192.00 $1,441.37 $4,899.20 $1,892.25 $485.00 $851.20 $321.12 $631.60 $1,994.52 $393.00 $454.00 $1,078.00 $4,924.13 $1,755.00 $1,792.00 $517.44 $1,031.70 $174.90 $246.24 $914.40 $443.40 $1,838.20 $425.12 $3,849.66 $2,018.50 $407.70 $331.20 $2,684.00 $557.60 $1,584.00 $3,891.00 $1,659.20 $176.10 $1,538.70 $156.00 $713.30
Excel Training
14th September 2005
Rohan Fernandes
USA USA USA USA USA USA USA USA USA USA UK UK USA UK USA USA UK USA USA UK USA USA USA USA USA UK UK USA USA USA USA USA UK UK USA USA UK UK USA UK USA USA UK UK USA USA UK USA UK UK USA USA USA USA USA UK UK USA USA UK USA USA USA UK UK UK USA UK UK USA USA USA USA USA
Peacock Davolio Peacock Callahan Leverling Davolio Peacock Fuller Callahan Davolio Buchanan Dodsworth Callahan Buchanan Fuller Leverling Suyama Callahan Davolio King Leverling Peacock Davolio Fuller Callahan Suyama King Callahan Leverling Peacock Peacock Leverling King King Callahan Peacock Suyama Dodsworth Fuller Suyama Peacock Leverling Dodsworth King Davolio Peacock Suyama Peacock King King Leverling Fuller Fuller Leverling Peacock Suyama King Callahan Peacock King Davolio Davolio Peacock King Suyama Buchanan Leverling King King Callahan Callahan Peacock Leverling Davolio
14-Mar-04 14-Mar-04 13-Mar-04 11-Mar-04 12-Mar-04 14-Mar-04 14-Mar-04 18-Mar-04 19-Mar-04 21-Mar-04 21-Mar-04 4-Apr-04 24-Mar-04 25-Mar-04 26-Mar-04 21-Mar-04 24-Mar-04 25-Mar-04 10-Apr-04 25-Apr-04 1-Apr-04 31-Mar-04 2-Apr-04 28-Mar-04 2-Apr-04 9-Apr-04 3-Apr-04 8-Apr-04 11-Apr-04 10-Apr-04 9-Apr-04 11-Apr-04 7-Apr-04 7-Apr-04 11-Apr-04 16-Apr-04 17-Apr-04 16-Apr-04 29-Apr-04 16-Apr-04 18-Apr-04 21-Apr-04 2-May-04 22-Apr-04 13-May-04 29-Apr-04 28-Apr-04 21-Apr-04 24-Apr-04 28-Apr-04 16-May-04 23-May-04 1-May-04 29-Apr-04 5-May-04 1-May-04 1-May-04 2-May-04 6-May-04 30-May-04 7-May-04 23-May-04 15-May-04 7-May-04 9-May-04 9-May-04 12-May-04 19-May-04 12-May-04 22-May-04 14-May-04 21-May-04 6-Jun-04 19-May-04
10464 10465 10466 10467 10468 10469 10470 10471 10472 10473 10474 10475 10476 10477 10478 10479 10480 10481 10482 10483 10484 10485 10486 10487 10488 10489 10490 10491 10492 10493 10494 10495 10496 10497 10498 10499 10500 10501 10502 10503 10504 10505 10506 10507 10508 10509 10510 10511 10512 10513 10514 10515 10516 10517 10518 10519 10520 10521 10522 10523 10524 10525 10526 10527 10528 10529 10530 10531 10532 10533 10534 10535 10536 10537
$1,609.28 $2,518.00 $216.00 $235.20 $717.60 $956.67 $1,820.80 $1,328.00 $1,036.80 $230.40 $1,249.10 $1,505.18 $180.48 $558.00 $471.20 $10,495.60 $756.00 $1,472.00 $147.00 $668.80 $386.20 $1,584.00 $1,272.00 $889.70 $1,512.00 $439.20 $3,163.20 $259.50 $851.20 $608.40 $912.00 $278.00 $190.00 $1,380.60 $575.00 $1,412.00 $523.26 $149.00 $816.30 $2,048.50 $1,388.50 $147.90 $415.80 $749.06 $240.00 $136.80 $4,707.54 $2,550.00 $525.30 $1,942.00 $8,623.45 $9,921.30 $2,381.05 $352.00 $4,150.05 $2,314.20 $200.00 $225.50 $2,318.24 $2,444.31 $3,192.65 $818.40 $1,151.40 $1,503.00 $392.20 $946.00 $4,180.00 $110.00 $796.35 $2,222.20 $465.70 $1,940.85 $1,645.00 $1,823.80
Excel Training
14th September 2005
Rohan Fernandes
UK UK USA USA USA USA USA USA USA USA USA UK UK USA USA USA USA UK USA UK USA UK USA USA USA USA USA USA UK USA USA UK USA USA USA UK USA UK USA UK USA USA USA USA USA USA USA UK UK USA USA USA USA USA USA UK USA USA USA UK USA UK USA UK USA USA USA USA USA UK USA UK USA UK
Dodsworth Suyama Leverling Fuller Davolio Callahan Peacock Callahan Davolio Leverling Leverling Buchanan King Peacock Fuller Fuller Peacock Suyama Fuller Dodsworth Davolio Suyama Callahan Fuller Davolio Fuller Peacock Callahan Dodsworth Davolio Leverling Buchanan Leverling Callahan Leverling King Peacock Buchanan Leverling Dodsworth Peacock Davolio Peacock Leverling Leverling Fuller Peacock King Dodsworth Davolio Fuller Callahan Peacock Davolio Leverling King Leverling Fuller Callahan King Davolio Suyama Peacock King Callahan Callahan Davolio Davolio Peacock Buchanan Peacock King Callahan Suyama
16-May-04 23-May-04 13-Jun-04 29-May-04 26-May-04 23-May-04 30-May-04 26-Jun-04 27-May-04 2-Jun-04 2-Jun-04 30-May-04 6-Jun-04 6-Jun-04 5-Jun-04 3-Jun-04 5-Jun-04 4-Jun-04 13-Jun-04 6-Jun-04 10-Jun-04 13-Jun-04 9-Jun-04 9-Jun-04 12-Jun-04 24-Jun-04 16-Jun-04 18-Jun-04 18-Jun-04 17-Jun-04 9-Jul-04 11-Jul-04 19-Jun-04 4-Jul-04 25-Jun-04 20-Jun-04 30-Jun-04 30-Jun-04 30-Jun-04 30-Jun-04 25-Jul-04 4-Jul-04 1-Jul-04 2-Jul-04 14-Jul-04 4-Jul-04 4-Jul-04 10-Jul-04 9-Jul-04 9-Jul-04 10-Jul-04 14-Jul-04 14-Jul-04 16-Jul-04 16-Jul-04 13-Aug-04 16-Jul-04 14-Jul-04 12-Aug-04 18-Jul-04 18-Jul-04 21-Jul-04 21-Jul-04 22-Jul-04 22-Jul-04 8-Aug-04 29-Jul-04 29-Jul-04 31-Jul-04 25-Jul-04 1-Aug-04 30-Jul-04 6-Aug-04 1-Aug-04
10538 10539 10540 10541 10542 10543 10544 10545 10546 10547 10548 10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 10584 10585 10586 10587 10588 10589 10590 10591 10592 10593 10594 10595 10596 10597 10598 10599 10600 10601 10602 10603 10604 10605 10606 10607 10608 10609 10610 10611
$139.80 $355.50 $10,191.70 $1,946.52 $469.11 $1,504.50 $417.20 $210.00 $2,812.00 $1,792.80 $240.10 $3,554.27 $683.30 $1,677.30 $880.50 $1,546.30 $1,728.52 $2,944.40 $835.20 $1,152.50 $2,142.90 $520.41 $1,072.42 $2,844.50 $488.70 $965.00 $1,234.05 $639.90 $1,761.00 $2,519.00 $155.00 $890.00 $2,465.25 $550.59 $1,501.08 $2,082.00 $764.30 $2,147.40 $838.45 $569.00 $477.00 $317.75 $1,013.74 $310.00 $330.00 $2,237.50 $593.75 $142.50 $23.80 $807.38 $3,120.00 $72.00 $1,101.00 $812.50 $516.46 $1,994.40 $565.50 $4,725.00 $1,180.88 $718.08 $2,388.50 $493.00 $479.80 $2,285.00 $48.75 $1,483.00 $230.85 $4,109.69 $1,130.40 $6,475.40 $1,064.00 $424.00 $299.25 $808.00
Excel Training
14th September 2005
Rohan Fernandes
USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA UK USA USA USA UK USA UK USA USA UK UK USA USA UK USA UK UK UK USA USA USA UK USA UK USA USA UK USA UK USA USA USA USA UK UK USA USA USA USA UK USA USA UK USA USA UK USA USA USA USA USA USA USA
Davolio Peacock Callahan Fuller Davolio Peacock Davolio Leverling Fuller Peacock Peacock Callahan Peacock Leverling Davolio Callahan Peacock Peacock Davolio Callahan Callahan King Peacock Callahan Peacock Suyama Leverling King Peacock Peacock King Suyama Leverling Peacock Dodsworth Peacock Buchanan Buchanan Buchanan Callahan Peacock Davolio Buchanan Davolio Suyama Fuller Peacock King Callahan King Leverling Fuller Davolio Davolio King King Davolio Fuller Peacock Davolio Dodsworth Fuller Peacock Buchanan Fuller Davolio King Callahan Davolio Leverling Leverling Fuller Leverling Peacock
1-Aug-04 1-Aug-04 1-Aug-04 6-Aug-04 5-Aug-04 4-Aug-04 8-Aug-04 7-Aug-04 14-Aug-04 11-Aug-04 11-Aug-04 12-Aug-04 19-Aug-04 14-Aug-04 20-Aug-04 21-Aug-04 20-Aug-04 20-Aug-04 19-Aug-04 15-Aug-04 19-Aug-04 18-Aug-04 21-Aug-04 21-Aug-04 26-Aug-04 26-Aug-04 1-Sep-04 27-Aug-04 28-Aug-04 26-Aug-04 5-Sep-04 2-Sep-04 1-Sep-04 2-Sep-04 3-Sep-04 3-Sep-04 9-Sep-04 29-Aug-04 3-Sep-04 11-Sep-04 8-Sep-04 19-Sep-04 11-Sep-04 11-Sep-04 10-Sep-04 15-Sep-04 8-Sep-04 10-Sep-04 15-Oct-04 15-Sep-04 18-Sep-04 3-Oct-04 19-Sep-04 17-Sep-04 22-Sep-04 19-Sep-04 23-Sep-04 22-Sep-04 18-Sep-04 24-Sep-04 26-Sep-04 19-Sep-04 30-Sep-04 23-Sep-04 29-Sep-04 26-Sep-04 16-Oct-04 30-Sep-04 26-Sep-04 30-Sep-04 1-Oct-04 1-Oct-04 30-Sep-04 3-Oct-04
10612 10613 10614 10615 10616 10617 10618 10619 10620 10621 10622 10623 10624 10625 10626 10627 10628 10629 10630 10631 10632 10633 10634 10635 10636 10637 10638 10639 10640 10641 10642 10643 10644 10645 10646 10647 10648 10649 10650 10651 10652 10653 10654 10655 10656 10657 10658 10659 10660 10661 10662 10663 10664 10665 10666 10667 10668 10669 10670 10671 10672 10673 10674 10675 10676 10677 10678 10679 10680 10681 10682 10683 10684 10685
$6,375.00 $353.20 $464.00 $120.00 $4,806.99 $1,402.50 $2,697.50 $1,260.00 $57.50 $758.50 $560.00 $1,336.95 $1,393.24 $479.75 $1,503.60 $1,185.75 $450.00 $2,775.05 $903.60 $55.80 $589.00 $5,510.59 $4,985.50 $1,326.22 $629.50 $2,761.94 $2,720.05 $500.00 $708.75 $2,054.00 $696.00 $814.50 $1,371.80 $1,535.00 $1,446.00 $636.00 $372.37 $1,434.00 $1,779.20 $397.80 $318.84 $1,083.15 $601.83 $154.40 $604.21 $4,371.60 $4,464.60 $1,227.02 $1,701.00 $562.60 $125.00 $1,930.40 $1,288.39 $1,295.00 $4,666.94 $1,536.80 $625.27 $570.00 $2,301.75 $920.10 $3,815.25 $412.35 $45.00 $1,423.00 $534.85 $813.36 $5,256.50 $660.00 $1,261.88 $1,287.40 $375.50 $63.00 $1,768.00 $801.10
Excel Training
14th September 2005
Rohan Fernandes
USA UK USA USA USA USA USA USA USA UK USA USA USA USA USA UK USA UK UK UK USA USA UK USA USA UK USA USA UK USA USA USA USA USA USA UK USA USA USA USA USA USA USA USA UK UK USA USA USA UK UK USA USA USA USA USA USA USA UK UK USA UK USA USA UK USA USA USA UK USA USA UK USA USA
Fuller Dodsworth Peacock Davolio Davolio Fuller Peacock Leverling Callahan King Callahan Leverling Peacock Leverling Leverling Suyama Peacock Suyama Suyama Dodsworth Callahan Peacock Suyama Davolio Davolio Buchanan Leverling Davolio Buchanan Leverling Peacock Davolio Davolio Callahan Callahan Buchanan Callahan Leverling Callahan Peacock Peacock Fuller Peacock Callahan Buchanan King Leverling Davolio Fuller Suyama Dodsworth Fuller Fuller Leverling Peacock Peacock Leverling Davolio Suyama Dodsworth Davolio Suyama Leverling Peacock Dodsworth Leverling Fuller Leverling Suyama Peacock Callahan Suyama Leverling Leverling
8-Oct-04 30-Oct-04 7-Oct-04 7-Oct-04 3-Oct-04 22-Oct-04 13-Oct-04 10-Oct-04 9-Oct-04 14-Oct-04 14-Oct-04 14-Oct-04 17-Oct-04 13-Oct-04 16-Oct-04 15-Oct-04 21-Oct-04 20-Oct-04 7-Nov-04 18-Nov-04 21-Oct-04 23-Oct-04 5-Nov-04 20-Nov-04 23-Oct-04 29-Oct-04 31-Oct-04 24-Oct-04 27-Oct-04 29-Oct-04 27-Oct-04 29-Oct-04 29-Oct-04 5-Nov-04 5-Nov-04 31-Oct-04 4-Nov-04 25-Nov-04 5-Nov-04 5-Nov-04 5-Dec-04 5-Dec-04 11-Nov-04 14-Nov-04 14-Nov-04 14-Nov-04 7-Nov-04 10-Nov-04 12-Nov-04 21-Nov-04 21-Nov-04 18-Nov-04 18-Nov-04 17-Nov-04 25-Nov-04 18-Nov-04 18-Nov-04 21-Nov-04 24-Nov-04 27-Nov-04 21-Nov-04 26-Nov-04 28-Nov-04 19-Dec-04 24-Nov-04 3-Dec-04 28-Nov-04 27-Nov-04 27-Nov-04 28-Nov-04 2-Dec-04 15-Dec-04 4-Dec-04 12-Dec-04
10686 10687 10688 10689 10690 10691 10692 10693 10694 10695 10696 10697 10698 10699 10700 10701 10702 10703 10704 10705 10706 10707 10708 10709 10710 10711 10712 10713 10714 10715 10716 10717 10718 10719 10720 10721 10722 10723 10724 10725 10726 10727 10728 10729 10730 10731 10732 10733 10734 10735 10736 10737 10738 10739 10740 10741 10742 10743 10744 10745 10746 10747 10748 10749 10750 10751 10752 10753 10754 10755 10756 10757 10758 10759
$1,404.45 $4,960.90 $3,160.60 $472.50 $862.50 $10,164.80 $878.00 $2,071.20 $4,825.00 $642.00 $996.00 $805.43 $3,436.45 $114.00 $1,638.40 $2,864.50 $330.00 $2,545.00 $595.50 $378.00 $1,893.00 $1,641.00 $180.40 $3,424.00 $93.50 $4,451.70 $1,233.48 $2,827.90 $2,205.75 $1,296.00 $706.00 $1,270.75 $3,463.00 $844.25 $550.00 $923.87 $1,570.00 $468.45 $638.50 $287.80 $655.00 $1,624.50 $1,296.75 $1,850.00 $484.25 $1,890.50 $360.00 $1,459.00 $1,498.35 $536.40 $997.00 $139.80 $52.35 $240.00 $1,416.00 $228.00 $3,118.00 $319.20 $736.00 $4,529.80 $2,311.70 $1,912.85 $2,196.00 $1,080.00 $1,590.56 $1,631.48 $252.00 $88.00 $55.20 $1,948.50 $1,990.00 $3,082.00 $1,644.60 $320.00
Excel Training
14th September 2005
Rohan Fernandes
USA UK USA USA UK USA USA USA USA USA USA UK USA USA USA UK USA UK USA USA USA USA UK USA USA USA USA USA USA USA UK UK USA USA UK USA USA UK USA UK USA USA USA USA UK USA USA USA USA UK USA USA UK USA USA USA USA USA UK USA USA USA UK UK USA USA UK USA UK UK USA USA USA UK
Peacock Buchanan Leverling Leverling Suyama Leverling Peacock Peacock Leverling Leverling Callahan Dodsworth Leverling Davolio Peacock King Davolio King Leverling Leverling Fuller Fuller Dodsworth Peacock Peacock Davolio Callahan Fuller Davolio Davolio Suyama Suyama Davolio Leverling Suyama Callahan Leverling King Fuller Dodsworth Davolio Peacock Peacock Peacock Suyama Fuller Leverling Peacock Fuller King Fuller Callahan Buchanan Davolio Leverling Fuller Peacock Leverling King Fuller Leverling Davolio Suyama Buchanan Callahan Davolio Suyama Davolio Dodsworth Dodsworth Peacock Leverling Fuller Suyama
10-Dec-04 8-Dec-04 9-Dec-04 8-Dec-04 8-Dec-04 9-Dec-04 9-Dec-04 15-Dec-04 15-Dec-04 12-Dec-04 17-Dec-04 2-Jan-04 19-Dec-04 16-Dec-04 12-Dec-04 26-Dec-04 18-Dec-04 21-Jan-05 24-Dec-04 14-Jan-05 25-Dec-04 19-Dec-04 22-Dec-04 19-Dec-04 22-Dec-04 24-Dec-04 23-Dec-04 26-Dec-04 19-Jan-05 31-Dec-04 26-Dec-04 1-Jan-05 31-Dec-04 8-Jan-05 2-Jan-05 20-Jan-05 14-Jan-05 5-Jan-05 5-Jan-05 5-Jan-05 5-Jan-05 31-Dec-04 2-Jan-05 6-Jan-05 7-Jan-05 9-Jan-05 5-Jan-05 30-Jan-05 9-Jan-05 7-Jan-05 7-Jan-05 8-Jan-05 12-Jan-05 9-Jan-05 14-Jan-05 14-Jan-05 4-Feb-05 13-Jan-05 12-Jan-05 16-Jan-05 13-Jan-05 15-Jan-05 16-Jan-05 13-Jan-05 30-Jan-05 14-Jan-05 6-Feb-05 6-Feb-05 4-Feb-05 23-Jan-05 21-Jan-05 23-Jan-05 19-Jan-05 23-Jan-05
10760 10761 10762 10763 10764 10765 10766 10767 10768 10769 10770 10771 10772 10773 10774 10775 10776 10777 10778 10779 10780 10781 10782 10783 10784 10785 10786 10787 10788 10789 10790 10791 10792 10793 10794 10795 10796 10797 10798 10799 10800 10801 10802 10803 10804 10805 10806 10807 10808 10809 10810 10811 10812 10813 10814 10815 10816 10817 10818 10819 10820 10821 10822 10823 10824 10825 10826 10827 10828 10829 10830 10831 10832 10833
$2,917.00 $507.00 $4,337.00 $616.00 $2,286.00 $1,515.60 $2,310.00 $28.00 $1,477.00 $1,684.27 $236.25 $344.00 $3,603.22 $2,030.40 $868.75 $228.00 $6,635.27 $224.00 $96.50 $1,335.00 $720.00 $975.88 $12.50 $1,442.50 $1,488.00 $387.50 $1,531.08 $2,622.76 $731.50 $3,687.00 $722.50 $1,829.76 $399.85 $191.10 $314.76 $2,158.00 $2,341.36 $420.00 $446.60 $1,553.50 $1,468.93 $3,026.85 $2,942.81 $1,193.01 $2,278.40 $2,775.00 $439.60 $18.40 $1,411.00 $140.00 $187.00 $852.00 $1,692.80 $602.40 $1,788.45 $40.00 $8,446.45 $10,952.84 $833.00 $477.00 $1,140.00 $678.00 $237.90 $2,826.00 $250.80 $1,030.76 $730.00 $843.00 $932.00 $1,764.00 $1,974.00 $2,684.40 $475.11 $906.93
Excel Training
14th September 2005
Rohan Fernandes
USA USA UK UK USA USA USA UK USA USA USA USA USA USA UK UK USA UK USA UK USA USA USA USA USA USA USA USA USA USA USA USA UK UK UK UK UK UK UK USA UK USA UK USA USA USA UK USA USA USA USA UK USA USA USA UK UK UK USA UK USA USA UK USA USA UK USA USA USA USA USA UK USA UK
Davolio Davolio King Dodsworth Leverling Leverling Peacock Buchanan Davolio Peacock Callahan Callahan Fuller Peacock King Dodsworth Davolio Buchanan Callahan Dodsworth Leverling Leverling Leverling Callahan Fuller Davolio Leverling Peacock Callahan Peacock Peacock Fuller Buchanan Suyama King Buchanan Buchanan Dodsworth Buchanan Peacock Buchanan Peacock King Davolio Peacock Leverling King Peacock Peacock Callahan Peacock Suyama Davolio Callahan Davolio Dodsworth King King Peacock Dodsworth Davolio Leverling King Leverling Peacock Buchanan Davolio Peacock Davolio Leverling Leverling Dodsworth Peacock Suyama
19-Jan-05 21-Jan-05 21-Jan-05 23-Jan-05 23-Jan-05 22-Jan-05 16-Feb-05 29-Jan-05 29-Jan-05 26-Jan-05 26-Jan-05 30-Jan-05 23-Jan-05 10-Feb-05 29-Jan-05 30-Jan-05 30-Jan-05 2-Feb-05 30-Jan-05 3-Feb-05 5-Feb-05 4-Feb-05 10-Feb-05 6-Feb-05 3-Feb-05 2-Feb-05 4-Feb-05 17-Feb-05 2-Feb-05 17-Feb-05 9-Feb-05 12-Feb-05 12-Feb-05 11-Feb-05 23-Feb-05 9-Feb-05 13-Feb-05 10-Feb-05 9-Feb-05 9-Feb-05 11-Feb-05 3-Mar-05 12-Feb-05 19-Feb-05 12-Feb-05 12-Feb-05 18-Feb-05 18-Feb-05 20-Feb-05 20-Feb-05 13-Feb-05 18-Feb-05 2-Mar-05 16-Feb-05 23-Feb-05 23-Feb-05 18-Feb-05 19-Feb-05 19-Feb-05 20-Feb-05 20-Feb-05 23-Feb-05 27-Feb-05 25-Feb-05 6-Mar-05 26-Feb-05 4-Mar-05 26-Feb-05 3-Mar-05 4-Mar-05 27-Feb-05 6-Mar-05 3-Mar-05 27-Feb-05
10834 10835 10836 10837 10838 10839 10840 10841 10842 10843 10844 10845 10846 10847 10848 10849 10850 10851 10852 10853 10854 10855 10856 10857 10858 10859 10860 10861 10862 10863 10864 10865 10866 10867 10868 10869 10870 10871 10872 10873 10874 10875 10876 10877 10878 10879 10880 10881 10882 10883 10884 10885 10886 10887 10888 10889 10890 10891 10892 10893 10894 10895 10896 10897 10898 10899 10900 10901 10902 10903 10904 10905 10906 10907
$1,432.71 $845.80 $4,705.50 $1,064.50 $1,938.38 $827.55 $211.20 $4,581.00 $975.00 $159.00 $735.00 $3,812.70 $1,112.00 $4,931.92 $931.50 $967.82 $629.00 $2,603.00 $2,984.00 $625.00 $2,966.50 $2,227.89 $660.00 $2,048.22 $649.00 $1,078.69 $519.00 $3,523.40 $581.00 $441.15 $282.00 $16,387.50 $1,096.20 $98.40 $1,920.60 $1,630.00 $160.00 $1,979.23 $2,058.46 $336.80 $310.00 $709.55 $917.00 $1,955.13 $1,539.00 $611.30 $1,500.00 $150.00 $892.64 $36.00 $1,378.07 $1,209.00 $3,127.50 $70.00 $605.00 $11,380.00 $860.10 $368.93 $2,090.00 $5,502.11 $2,753.10 $6,379.40 $750.50 $10,835.24 $30.00 $122.40 $33.75 $934.50 $863.43 $932.05 $1,924.25 $342.00 $427.50 $108.50
Excel Training
14th September 2005
Rohan Fernandes
USA USA USA USA USA USA UK USA USA USA USA USA USA USA UK UK USA USA USA USA USA UK USA USA USA UK USA USA USA UK USA USA USA UK UK USA UK USA USA USA USA USA USA UK USA UK UK USA UK USA UK UK USA USA USA UK USA UK USA USA USA USA UK USA USA UK USA USA USA USA UK USA USA USA
Peacock Davolio Davolio Leverling Fuller Peacock Suyama Fuller Davolio Peacock Leverling Fuller Peacock Davolio Buchanan King Leverling Leverling Peacock Peacock Davolio Suyama Peacock Peacock Callahan Suyama Leverling Peacock Leverling King Leverling Fuller Callahan King Dodsworth Peacock Suyama Peacock Davolio Leverling Leverling Fuller Davolio Dodsworth Davolio Dodsworth Buchanan Callahan Suyama Callahan King Suyama Leverling Callahan Callahan Dodsworth Leverling Suyama Peacock Fuller Davolio Davolio Dodsworth Fuller Peacock Suyama Leverling Davolio Davolio Callahan Dodsworth Callahan Peacock Davolio
6-Mar-05 10-Mar-05 4-Mar-05 5-Mar-05 18-Mar-05 4-Mar-05 2-Mar-05 2-Mar-05 9-Mar-05 11-Mar-05 11-Mar-05 4-Mar-05 9-Mar-05 9-Mar-05 5-Mar-05 13-Mar-05 8-Apr-05 13-Mar-05 11-Mar-05 8-Apr-05 18-Mar-05 12-Mar-05 18-Mar-05 19-Mar-05 24-Mar-05 16-Mar-05 12-Mar-05 18-Mar-05 18-Mar-05 13-Mar-05 16-Mar-05 13-Mar-05 23-Mar-05 20-Mar-05 18-Mar-05 19-Mar-05 13-Mar-05 18-Mar-05 19-Mar-05 16-Mar-05 19-Mar-05 17-Mar-05 23-Mar-05 7-Apr-05 24-Mar-05 25-Mar-05 20-Mar-05 20-Mar-05 20-Mar-05 27-Mar-05 27-Mar-05 23-Mar-05 8-Apr-05 30-Mar-05 23-Mar-05 26-Mar-05 24-Mar-05 30-Mar-05 8-Apr-05 2-Apr-05 1-Apr-05 30-Mar-05 24-Apr-05 2-Apr-05 26-Mar-05 27-Mar-05 3-Apr-05 27-Mar-05 3-Apr-05 10-Apr-05 23-Apr-05 31-Mar-05 17-Apr-05 2-Apr-05
10908 10909 10910 10911 10912 10913 10914 10915 10916 10917 10918 10919 10920 10921 10922 10923 10924 10925 10926 10927 10928 10929 10930 10931 10932 10933 10934 10935 10936 10937 10938 10939 10940 10941 10942 10943 10944 10945 10946 10947 10948 10949 10950 10951 10952 10953 10954 10955 10956 10957 10958 10959 10960 10961 10962 10963 10964 10965 10966 10967 10968 10969 10970 10971 10972 10973 10974 10975 10976 10977 10978 10979 10980 10981
$663.10 $670.00 $452.90 $858.00 $6,200.55 $768.75 $537.50 $539.50 $686.70 $365.89 $1,447.50 $1,122.80 $390.00 $1,936.00 $742.50 $748.80 $1,835.70 $475.15 $514.40 $800.00 $137.50 $1,174.75 $2,255.50 $799.20 $1,788.63 $920.60 $500.00 $619.50 $456.00 $644.80 $2,731.87 $637.50 $360.00 $4,011.75 $560.00 $711.00 $1,025.33 $245.00 $1,407.50 $220.00 $2,362.25 $4,422.00 $110.00 $458.74 $471.20 $4,441.25 $1,659.53 $74.40 $677.00 $1,762.70 $781.00 $131.75 $265.35 $1,119.90 $3,584.00 $57.80 $2,052.50 $848.00 $1,098.46 $910.40 $1,408.00 $108.00 $224.00 $1,733.06 $251.50 $291.55 $439.00 $717.50 $912.00 $2,233.00 $1,303.19 $4,813.50 $248.00 $15,810.00
Excel Training
14th September 2005
Rohan Fernandes
USA USA USA USA USA USA USA USA USA USA USA UK USA USA USA USA USA UK USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA UK UK USA USA USA USA USA UK USA USA USA USA UK UK USA UK USA USA USA UK USA USA USA UK USA USA UK UK USA USA USA USA
Fuller Fuller Davolio Fuller Callahan Callahan Leverling Fuller Fuller Davolio Davolio King Fuller Davolio Peacock Callahan Callahan Suyama Fuller Fuller Peacock Leverling Leverling Fuller Leverling Callahan Fuller Fuller Leverling Davolio Fuller Fuller Fuller Dodsworth Dodsworth Peacock Fuller Leverling Davolio Peacock Suyama Peacock Davolio Fuller Peacock King Suyama Fuller King Callahan Fuller Callahan King Davolio Leverling Fuller Buchanan Peacock Callahan King King Leverling Fuller Callahan Leverling
8-Apr-05 6-Apr-05 3-Apr-05 2-Apr-05 21-Apr-05 6-Apr-05 10-Apr-05 2-Apr-05 7-Apr-05 7-Apr-05 3-Apr-05 10-Apr-05 9-Apr-05 6-Apr-05 10-Apr-05 13-Apr-05 17-Apr-05 10-Apr-05 14-Apr-05 14-Apr-05 16-Apr-05 8-Apr-05 20-Apr-05 10-Apr-05 15-Apr-05 13-Apr-05 10-Apr-05 21-Apr-05 13-Apr-05 17-Apr-05 10-Apr-05 15-Apr-05 20-Apr-05 13-Apr-05 20-Apr-05 16-Apr-05 16-Apr-05 21-Apr-05 24-Apr-05 20-Apr-05 24-Apr-05 28-Apr-05 20-Apr-05 22-Apr-05 27-Apr-05 27-Apr-05 24-Apr-05 23-Apr-05 23-Apr-05 27-Apr-05 24-Apr-05 22-Apr-05 27-Apr-05 30-Apr-05 28-Apr-05 1-May-05 29-Apr-05 1-May-05 24-Apr-05 1-May-05 30-Apr-05 1-May-05 29-Apr-05 1-May-05 1-May-05
10982 10983 10984 10985 10986 10987 10988 10989 10990 10991 10992 10993 10994 10995 10996 10997 10998 10999 11000 11001 11002 11003 11004 11005 11006 11007 11009 11010 11011 11012 11013 11014 11015 11016 11017 11018 11020 11021 11023 11024 11025 11026 11027 11028 11029 11030 11031 11032 11033 11034 11035 11036 11037 11038 11041 11042 11043 11044 11046 11047 11048 11052 11053 11056 11057
$1,014.00 $720.90 $1,809.75 $2,023.38 $2,220.00 $2,772.00 $3,574.80 $1,353.60 $4,288.85 $2,296.00 $69.60 $4,895.44 $940.50 $1,196.00 $560.00 $1,885.00 $686.00 $1,197.95 $903.75 $2,769.00 $1,811.10 $326.00 $295.38 $586.00 $329.69 $2,633.90 $616.50 $645.00 $933.50 $2,825.30 $361.00 $243.18 $622.35 $491.50 $6,750.00 $1,575.00 $632.40 $6,306.24 $1,500.00 $1,966.81 $270.00 $1,030.00 $877.72 $2,160.00 $1,286.80 $12,615.05 $2,393.50 $8,902.50 $3,232.80 $539.40 $1,754.50 $1,692.00 $60.00 $732.60 $1,773.00 $405.75 $210.00 $591.60 $1,485.80 $817.87 $525.00 $1,332.00 $3,055.00 $3,740.00 $45.00
Excel Training
14th September 2005
Rohan Fernandes
Multiple Charts on One Chart Window
Chart 1 Jan 10 Chart 2 Jan North South East West Chart 3 North South East West Chart 4 7:00 7:30 8:00 8:30 9:00 9:30 176 333 357 329 345 380 162 297 298 Regions 289 280 339 East South North 0 West 40 30 20 10 50 80 70 60 50 100 90 200 90 100 200 300 10 20 30 40 Feb 50 60 70 80 Mar Numbers 90 100 200 300 Feb 50 Mar 90 100 90 80 70 60 50 40 30 20 10 0 Jan Feb Month 10 50
Monthly Numbers
Regional Sales
100
150
200
Numbers Steps : 1. Create charts as usual, placing them in a worksheet 2. Select any blank cell in the worksheet and press F11; this creates an empty Chart sheet to hold the embedded charts. 3. Reactivate your worksheet, click an embedded chart, and select Chart, Location to display the Chart Location dialog box. 4. Choose "As object in" and specify the empty Chart sheet. 5. Excel will transfer the embedded chart to your Chart sheet. 6. Select your remaining charts, and use Chart, Location to move them to the Chart sheet. 7. Now you can arrange and size the charts any way you like.
Mar Feb Jan
8. Putting multiple charts on a single Chart sheet lets you use the View, Sized with Window command (available when the Chart sheet is active) to sca
Regional Numbers
90
90 300 200 100
Mar
North South East West
Periodic AHT and ATT
300 400 350 300 Numbers 250 200 150 100 250 300 350 50 0 7:00 7:30 8:00 Periods 8:30 9:00 9:30 176 162 333 297 357 298 329 289 345 280 380 339
the Chart sheet is active) to scale the charts to the window size and dimensions.
380 339
Time Subtraction
Sr No. Agent Hours Worked 35:00 37:40 32:29 32:15 33:57 31:13 37:30 39:40 Paid 37:30 37:30 37:30 37:30 37:30 37:30 37:30 37:30 Difference
1 2 3 4 5 6 7 8 Steps:
Agent 01 Agent 02 Agent 03 Agent 04 Agent 05 Agent 06 Agent 07 Agent 08
2:30 ######### 5:01 5:15 3:33 6:17 0:00 #########
1. By default, Excel uses a date system that begins with January 1, 1900 2. A negative time value generates a date/time combination that falls before this date, which is invalid. 3. The solution is to use the optional 1904 date system. 4. Select Tools, Options, click the Calculation tab, and check the 1904 date system box. 5. Your negative times will now be displayed correctly, as shown below. Notes: 1. Be careful if you workbook contains links to other files that don't use the 1904 date system. 2. In such a case, the mismatch of date systems could cause erroneous results.
Replace Formulas
Example Col 1 109 289 181 938 995 539 227 583 41 289 202 433 687 496 596 432 61 577 713 510 75 721 677 299 449 Col 2 410 125 486 266 118 795 483 395 581 859 34 531 910 350 242 130 713 971 437 886 428 418 415 538 470 Col 3 704 353 248 895 220 430 480 499 22 792 59 551 741 494 417 793 862 43 404 148 406 845 759 80 739 Col 4 357 325 469 342 89 704 714 554 659 276 240 373 203 286 558 566 819 884 578 512 350 931 651 4 184 Total 519 414 667 1204 1113 1334 710 978 622 1148 236 964 1597 846 838 562 774 1548 1150 1396 503 1139 1092 837 919 35094 Notes: Steps: 2. Invoke the Find Replace Dialog box by using the Keyboard Shortcut Ctrl H 3. In the Find What text Box, Enter C 4. In the Replace With text Box, Enter E 5. Click on Replace All to change the formulas in Range F6:F31
1. Select the Range containing the formulas that you need to change. In the E
1. The Replace function shall only work when the Find What and Replace With
i.e: If the values you are replacing require an additional bracket to be added a
2. Be careful what you are replacing. While changing C to E in the above exa
Eg: Changing C to D in the formula =COUNTIF(B6:C31,">100") will lead the f
Confidential
ormulas that you need to change. In the Example it would be from F6:F31
ox by using the Keyboard Shortcut Ctrl H
formulas in Range F6:F31
ork when the Find What and Replace With values don't change the Structure of the Formula.
equire an additional bracket to be added at the End, the Replace process will throw you an error.
. While changing C to E in the above example was fine a similar thing in the following formula would return an Error.
=COUNTIF(B6:C31,">100") will lead the formula to look like =DOUNTIF(B6
31,">100") which would result in Error.
Confidential
Control Settings For Every New Workbook And Worksheet
Notes: There are two files that control the defaults for new workbooks and inserted worksheets. You can easily customize a blank workbook to contain your favorite settings and then save the file as book.xlt or sheet.xlt.
Any time that you choose either the New Workbook icon, or the Insert – Worksheet command, the new book or sheet will inherit the settings from th Steps: Follow these steps to create book.xlt. 1. In Excel, open a new blank workbook by using the New icon in the Standard toolbar. 2. Customize the workbook. Feel free to make adjustments to any of the following: • File – Page Setup • File – Set Print Area • Cell Styles • Format – Cells • Data – Validation settings • Number and type of sheets in the workbook • Window view options from the Tools – Options – View tab 3. Select File – Save As. In the Save As dialog, Save as Type dropdown, choose Template, 4. Browse to the following path on your Computer : C:\Program Files\Microsoft Office\Office\XLStart 5. Save the file as Book.xlt 6. All subsequent new workbooks will inherit the settings from this file. 7. You can also set up a workbook with one worksheet. Save this workbook as Sheet.XLT. 8. All inserted worksheets will inherit the settings from this file.
Confidential
will inherit the settings from these files.
Confidential
Navigating Excel's Sheets
1. Every Excel user knows that you can activate a different sheet in a workbook by clicking its sheet tab. 2. You can press Ctrl-Page Up to activate the previous sheet, and Ctrl-Page Down to activate the next sheet. 4. Here's a little-known trick that will allow you to bypass repeated scrolling or typing: 6. Select a sheet from the list, and you're there in a flash.
3. But if your workbook contains many sheets, and not all of the sheets' tabs fit on the screen, you may find it tedious to scroll through the tabs or us
5. Display a pop-up list of sheet names by right-clicking one of the arrows to the left of the sheet tabs that are located at the bottom of the workshee
Confidential
to scroll through the tabs or use the keyboard to activate a distant sheet.
d at the bottom of the worksheet window
Confidential
doc_228414767.xls
It explains a comprehensive guide to various tips and tricks in Microsoft xls.
TEXT Entries to Time
Avg ACD Time Avg ACW Time Other Time Staffed Time
Agent Name
ACD Calls
% Idle
ACD Time ACW Time
AUX Time Avail Time
Agent 01 Agent 02 Agent 03 Agent 04 Agent 05 Agent 06 Agent 07 Agent 08 Agent 09 Agent 10 Agent 11 Agent 12 Agent 13 Agent 14 Agent 15 Agent 16 Agent 17 Agent 18 Agent 19 Agent 20 Agent 21 Agent 22 Agent 23 Agent 24 Agent 25 Agent 26 Agent 27 Agent 28 Agent 29 Agent 30 Agent 31 Agent 32 Agent 33 Agent 34 Agent 35 Agent 36 Agent 37 Agent 38 Agent 39
24 9 4 0 25 0 11 21 2 16 26 27 23 25 3 23 30 30 13 8 12 19 20 22 16 6 22 31 0 20 16 14 13 23 13 25 16 17 26
26.88% 7.29% 5.45% 0.00% 16.66% 0.00% 9.04% 26.48% 0.00% 13.10% 29.98% 26.36% 21.78% 24.05% 2.30% 16.91% 30.02% 28.43% 17.69% 3.58% 10.46% 20.80% 21.75% 17.56% 15.01% 5.67% 19.85% 32.27% 0.00% 22.59% 12.83% 14.39% 13.87% 13.58% 8.31% 20.92% 8.11% 17.84% 30.59%
00:07:40 00:06:05 00:04:44 00:00:00 00:07:37 00:00:00 00:06:08 00:05:31 00:07:55 00:08:33 00:06:42 00:07:19 00:07:42 00:07:44 00:14:18 00:09:43 00:04:34 00:06:22 00:06:30 00:07:34 00:07:11 00:05:05 00:07:53 00:11:43 00:14:40 00:07:06 00:08:10 00:05:26 00:00:00 00:07:09 00:11:54 00:06:28 00:08:59 00:10:27 00:10:10 00:06:42 00:09:13 00:11:59 00:06:35
00:00:00 00:00:00 00:15:56 00:00:00 00:01:22 00:00:00 00:00:00 00:00:00 00:00:04 00:01:18 00:00:14 00:00:00 00:01:08 00:00:00 00:04:40 00:02:22 00:00:00 00:00:45 00:00:05 00:00:31 00:00:44 00:02:21 00:01:31 00:00:01 00:00:00 00:00:00 00:02:12 00:00:38 00:00:00 00:01:26 00:03:53 00:01:42 00:03:57 00:02:32 00:03:51 00:02:07 00:05:30 00:00:11 00:00:00
03:04:07 00:54:47 00:18:57 00:00:00 03:10:37 00:00:00 01:07:31 01:55:47 00:15:50 02:16:49 02:54:17 03:17:42 02:56:57 03:13:09 00:42:54 03:43:35 02:17:02 03:11:11 01:24:27 01:00:31 01:26:13 01:36:33 02:37:45 04:17:45 03:54:43 00:42:35 02:59:37 02:48:41 00:00:00 02:22:57 03:10:20 01:30:28 01:56:46 04:00:25 02:12:14 02:47:37 02:27:30 03:23:51 02:51:15
00:00:00 00:00:00 01:03:44 00:00:00 00:33:59 00:00:00 00:00:02 00:00:00 00:00:07 00:20:53 00:05:52 00:00:00 00:26:07 00:00:00 00:14:01 00:54:28 00:00:00 00:22:16 00:01:07 00:04:10 00:08:46 00:44:43 00:30:18 00:00:32 00:00:00 00:00:00 00:48:30 00:19:33 00:00:00 00:28:40 01:02:14 00:23:54 00:51:20 00:58:14 00:49:58 00:52:49 01:27:59 00:03:10 00:00:00
00:07:30 00:00:32 00:03:19 00:00:00 00:04:38 00:00:00 00:00:14 00:02:36 00:01:07 00:02:41 00:00:23 00:27:30 00:08:27 00:09:08 00:01:10 00:21:45 00:03:20 00:02:05 00:00:44 00:03:14 00:14:06 00:09:43 00:28:03 00:27:51 00:16:29 00:06:57 00:06:58 00:22:58 00:00:00 00:18:42 00:32:37 00:10:25 00:16:23 00:17:19 00:23:20 00:30:38 00:19:46 00:15:53 00:11:26
02:55:41 06:59:00 06:37:44 00:30:50 03:16:11 08:29:56 06:21:10 04:17:13 00:02:03 04:40:14 02:57:26 02:09:03 03:08:12 03:01:58 07:18:52 02:04:07 03:36:20 02:30:02 05:36:37 06:51:56 05:47:07 04:13:53 03:02:57 01:58:27 03:04:41 07:33:10 02:54:08 02:14:34 08:30:45 03:18:35 02:41:44 05:09:29 04:17:14 02:16:50 04:23:53 02:34:23 03:31:22 03:43:21 02:51:16
02:15:01 00:37:19 00:27:52 00:00:00 01:25:02 00:00:00 00:44:36 02:15:18 00:00:00 01:06:24 02:33:17 02:06:47 01:51:18 02:01:42 00:11:41 01:26:18 02:33:01 02:25:12 01:30:53 00:17:48 00:53:18 01:46:21 01:50:56 01:26:11 01:17:00 00:30:14 01:41:20 02:44:46 00:00:00 01:53:29 01:05:48 01:13:01 01:11:09 01:11:10 00:42:31 01:47:14 00:41:10 01:36:54 02:36:00
08:22:19 08:31:39 08:31:36 00:30:50 08:30:27 08:29:56 08:13:33 08:30:54 00:19:07 08:27:01 08:31:15 08:01:02 08:31:01 08:25:57 08:28:38 08:30:13 08:29:43 08:30:46 08:33:48 08:17:39 08:29:30 08:31:13 08:29:59 08:10:46 08:32:53 08:52:56 08:30:33 08:30:32 08:30:45 08:22:23 08:32:43 08:27:17 08:32:52 08:43:58 08:31:56 08:32:41 08:27:47 09:03:10 08:29:57
Steps: 1. Enter a zero in a blank cell. 2. Copy the cell with the zero using Ctrl+C. 3. Highlight the text cells. 4. From the menu, choose Edit – Paste Special – Values – Add – OK. 5. By adding a zero to the text cells, they will be converted to real numbers. Else 1. Enter a 1 in a blank cell. 2. Copy the cell with the zero using Ctrl+C. 3. Highlight the text cells. 4. From the menu, choose Edit – Paste Special – Values – Multiply – OK. 5. By multiplying a 1 to the text cells, they will be converted to real numbers. Note: You can also use the Mouse Shortcut of Right Click - Paste Special - Values - Multiply or Add - OK
Filter Unique Names
Mar - 2005 Pallavi Jadhav Sonal Gupta Devika Rane Imran Bakali Malavika Shirva Sharlotte Fernandes Ainy Almerhi Anil Malhotra Roshan D'souza Maneesh Shahani Shilpa Saraf Nicola Arunasalam Monidipa Sengupta Manuel D'souza Maradona Fernandes Neeta Narang Taranjit Khalsi Vishal Khandwala Serena Louis Sunita Fernandes Charmaine Rao Nilesh Gosrani Kavita Singh Nilesh Satam Balasubramaniam Iyer Kunal Singh Vijaypal Singh Jean Rodrigues Pradnya Pednekar Bhavna Singh Gabriello Gomes Devendra Kate Zohar Rueben Naqqash Merchant Iyer Balasubramaniam Saleem Shaikh Subhash Vijan Rupali Panvelkar Philomena Nazareth Apr - 2005 Pallavi Jadhav Sonal Gupta Devika Rane Imran Bakali Malavika Shirva Sharlotte Fernandes Ainy Almerhi Anil Malhotra Roshan D'souza Maneesh Shahani Shilpa Saraf Nicola Arunasalam Monidipa Sengupta Manuel D'souza Maradona Fernandes Neeta Narang Taranjit Khalsi Vishal Khandwala Serena Louis Sunita Fernandes Charmaine Rao Nilesh Gosrani Kavita Singh Nilesh Satam Balasubramaniam Iyer Kunal Singh Vijaypal Singh Jean Rodrigues Pradnya Pednekar Bhavna Singh Gabriello Gomes Devendra Kate Zohar Rueben Naqqash Merchant Iyer Balasubramaniam Saleem Shaikh Subhash Vijan Rupali Panvelkar Philomena Nazareth May - 2005 Pallavi Jadhav Sonal Gupta Devika Rane Imran Bakali Malavika Shirva Sharlotte Fernandes Ainy Almerhi Anil Malhotra Roshan D'souza Maneesh Shahani Shilpa Saraf Nicola Arunasalam Monidipa Sengupta Manuel D'souza Maradona Fernandes Charmaine Rao Nilesh Gosrani Kavita Singh Nilesh Satam Balasubramaniam Iyer Kunal Singh Vijaypal Singh Jean Rodrigues Pradnya Pednekar Bhavna Singh Gabriello Gomes Devendra Kate Zohar Rueben Naqqash Merchant Iyer Balasubramaniam Saleem Shaikh Subhash Vijan Rupali Panvelkar Philomena Nazareth Reshmi Jasani Tejas Prabhu Dilbaug Bhui Geetika Gosain George Lazarus Steps: 1. On a Blank Workbook or On a New Sheet, Copy Paste the Name 2. Do not leave any Blank Rows in between 2 Ranges of Data 4. If your names start in cell A1, formula to be entered in cell B1 is 5. Drag the formula till the End of the Range 7. Go to the First Filled Cell in the New Range and Apply a Filter 8. Select Blanks in the Filter Drop Down List
3. In the Column next to the ones containing the names, type the f
6. Copy the range generated through formulas and Paste Special as
9. Select the Range by using the Keyboard Shortcut Shift Ctrl Down
10. Delete all Blank Rows by using the Keyboard Shortcut Ctrl and t
11. Go to the Cell where the filter was applied and Select All from th
Reshmi Jasani Tejas Prabhu Dilbaug Bhui Geetika Gosain George Lazarus Malcom Coelho Sameep Chamate Sameer Vaswani John Lonan Manisha Shevade Vernon Dmello Gaurav Chowdhur Jyotin Pandya Lydia Fernandes Sennen Pareira Smita jadhav Sudhakar Dinda Maria Pareira Shihas Moidoo Kinjal Vyas Ronald Saldanha Johar Menezes Alexander Valladares Parver Kazi Richard Thomas Mineta Singh Pearl Leo Juned Syed Pratik Bhatia Seema Wagle Shikta Chaturvedi Komal Bagul Nikunj Joshi Rohan Kanchan Venessa D'costa Silvester Dhaser Rickin Magdani Steve Pinto Kajal Shah Dipa Lulla Srimantini Roy Yadul Jayraj Bhagyashree Vichare Mitesh Rajani
Reshmi Jasani Tejas Prabhu Dilbaug Bhui Geetika Gosain George Lazarus Malcom Coelho Sameep Chamate Sameer Vaswani John Lonan Manisha Shevade Vernon Dmello Gaurav Chowdhur Jyotin Pandya Lydia Fernandes Sennen Pareira Smita jadhav Sudhakar Dinda Maria Pareira Shihas Moidoo Kinjal Vyas Ronald Saldanha Johar Menezes Alexander Valladares Juned Syed Pratik Bhatia Seema Wagle Shikta Chaturvedi Komal Bagul Nikunj Joshi Rohan Kanchan Venessa D'costa Silvester Dhaser Rickin Magdani Steve Pinto Kajal Shah Dipa Lulla Srimantini Roy Yadul Jayraj Bhagyashree Vichare Mitesh Rajani Sandeep Lalla Rishi Utmani Savio dias Serjeel Shaikh
Malcom Coelho Sameep Chamate Sameer Vaswani John Lonan Manisha Shevade Vernon Dmello Gaurav Chowdhur Jyotin Pandya Lydia Fernandes Sennen Pareira Smita jadhav Sudhakar Dinda Maria Pareira Shihas Moidoo Kinjal Vyas Ronald Saldanha Johar Menezes Juned Syed Pratik Bhatia Seema Wagle Shikta Chaturvedi Komal Bagul Nikunj Joshi Rohan Kanchan Venessa D'costa Silvester Dhaser Rickin Magdani Steve Pinto Kajal Shah Dipa Lulla Srimantini Roy Yadul Jayraj Bhagyashree Vichare Mitesh Rajani Sandeep Lalla Rishi Utmani Savio dias Serjeel Shaikh Nisar Aly Sardar Anslem Menezes Mitul Modi Elton Hendricks Poonam Chugh Smita Mascarenhas
Sandeep Lalla
Nisar Aly Sardar
Reshma Makhija
ok or On a New Sheet, Copy Paste the Name Ranges one below the other
ank Rows in between 2 Ranges of Data
to the ones containing the names, type the following formula the End of the Range Cell in the New Range and Apply a Filter using the Keyboard Shortcut Shift Ctrl Down Arrow Key
in cell A1, formula to be entered in cell B1 is =if(countif($A$1:A1,A1)>1,"",A1)
erated through formulas and Paste Special as Values to remove the formulas
Filter Drop Down List
ws by using the Keyboard Shortcut Ctrl and the - (Number Pad)
re the filter was applied and Select All from the Drop Down List
Add Comments to Your Formulas
Vlookup Example Jan Feb Mar 10 80 97 20 90 69 30 100 45 40 110 51 50 120 77
Type a month to look for : Which column needs to be picked out : The result is :
Feb 4 100
Formula entered in Cell F14 and the Notes given below should be enough to explain this Tip Note: It turns out that N of a number is the number and N of any text is zero. Thus, you can add several N functions to a formula without changing the result, provided that they contain text. Thus, if you have figured out some obscure formula, you can leave yourself notes about the formula. This function will work only if your original formula's output is numerical in nature.
Print Page Headings on Each Page Countrywise Salesperson Report for 2003 - 2005
Country UK UK USA USA USA USA UK UK USA USA USA USA USA USA USA UK UK USA USA USA USA UK USA UK UK USA UK USA USA USA USA USA USA USA USA USA USA USA USA USA USA UK USA UK USA USA USA USA UK UK UK USA USA USA USA UK USA USA USA USA UK USA USA USA USA USA USA USA Salesperson Buchanan Suyama Peacock Leverling Peacock Leverling Buchanan Dodsworth Leverling Peacock Davolio Peacock Peacock Peacock Callahan Dodsworth Suyama Fuller Leverling Peacock Callahan Buchanan Davolio Suyama Suyama Leverling Suyama Davolio Callahan Fuller Callahan Callahan Fuller Peacock Peacock Leverling Peacock Davolio Callahan Callahan Peacock King Callahan Suyama Davolio Davolio Peacock Fuller Suyama Buchanan Suyama Peacock Fuller Callahan Peacock King Davolio Callahan Davolio Fuller King Leverling Callahan Davolio Fuller Fuller Davolio Peacock Order Date 16-Jul-03 10-Jul-03 12-Jul-03 15-Jul-03 11-Jul-03 16-Jul-03 23-Jul-03 15-Jul-03 17-Jul-03 22-Jul-03 23-Jul-03 25-Jul-03 29-Jul-03 30-Jul-03 25-Jul-03 31-Jul-03 23-Aug-03 12-Aug-03 31-Jul-03 6-Aug-03 2-Aug-03 9-Aug-03 2-Aug-03 30-Aug-03 6-Aug-03 12-Aug-03 16-Aug-03 9-Aug-03 14-Aug-03 13-Aug-03 16-Aug-03 16-Aug-03 12-Sep-03 21-Aug-03 21-Aug-03 23-Aug-03 27-Aug-03 26-Aug-03 30-Aug-03 28-Aug-03 3-Sep-03 28-Aug-03 3-Sep-03 4-Sep-03 2-Sep-03 11-Sep-03 5-Sep-03 10-Sep-03 11-Sep-03 10-Sep-03 11-Sep-03 13-Sep-03 18-Sep-03 17-Sep-03 9-Oct-03 18-Sep-03 17-Sep-03 9-Oct-03 23-Sep-03 25-Sep-03 24-Sep-03 23-Oct-03 27-Sep-03 26-Sep-03 3-Oct-03 4-Oct-03 4-Oct-03 3-Oct-03 OrderID 10248 10249 10250 10251 10252 10253 10254 10255 10256 10257 10258 10259 10260 10261 10262 10263 10264 10265 10266 10267 10268 10269 10270 10271 10272 10273 10274 10275 10276 10277 10278 10279 10280 10281 10282 10283 10284 10285 10286 10287 10288 10289 10290 10291 10292 10293 10294 10295 10296 10297 10298 10299 10300 10301 10302 10303 10304 10305 10306 10307 10308 10309 10310 10311 10312 10313 10314 10315 Order Amount $440.00 $1,863.40 $1,552.60 $654.06 $3,597.90 $1,444.80 $556.62 $2,490.50 $517.80 $1,119.90 $1,614.88 $100.80 $1,504.65 $448.00 $584.00 $1,873.80 $695.62 $1,176.00 $346.56 $3,536.60 $1,101.20 $642.20 $1,376.00 $48.00 $1,456.00 $2,037.28 $538.60 $291.84 $420.00 $1,200.80 $1,488.80 $351.00 $613.20 $86.50 $155.40 $1,414.80 $1,170.37 $1,743.36 $3,016.00 $819.00 $80.10 $479.40 $2,169.00 $497.52 $1,296.00 $848.70 $1,887.60 $121.60 $1,050.60 $1,420.00 $2,645.00 $349.50 $608.00 $755.00 $2,708.80 $1,117.80 $954.40 $3,741.30 $498.50 $424.00 $88.80 $1,762.00 $336.00 $268.80 $1,614.80 $182.40 $2,094.30 $516.80 Note: Similar steps to be followed to repeat Columns on the Left on Every Print Out which spans across the Width of the Worksheet. Steps: 1. Select Page Setup from the File menu 2. The dialog box offers four tabs. Select the fourth tab, called Sheet. 3. Enter 1:6 in the box called Rows to Repeat at Top in order to have rows 1 through 5 repeated at the top of each printed page. 4. Select Print Preview to ensure that the results are what you desire.
Excel Training
14th September 2005
Rohan Fernandes
USA UK USA UK UK USA UK USA UK USA USA USA USA USA USA UK USA UK USA UK UK USA USA USA USA UK USA USA USA USA USA USA USA UK UK USA USA UK USA UK UK USA UK UK USA USA USA USA USA USA USA UK USA USA UK USA UK USA USA USA USA USA UK USA USA USA USA USA USA USA UK USA USA USA
Davolio Suyama Callahan King Buchanan Leverling King Peacock Dodsworth Davolio Peacock Fuller Peacock Peacock Leverling Dodsworth Leverling Buchanan Callahan King King Peacock Peacock Fuller Davolio King Peacock Peacock Peacock Fuller Leverling Peacock Peacock King Suyama Davolio Leverling King Callahan Suyama Suyama Davolio Buchanan Buchanan Peacock Davolio Leverling Peacock Davolio Leverling Callahan King Fuller Callahan Suyama Davolio Buchanan Peacock Davolio Leverling Davolio Davolio Buchanan Fuller Callahan Leverling Peacock Callahan Leverling Davolio Dodsworth Davolio Fuller Peacock
8-Oct-03 10-Oct-03 4-Oct-03 11-Oct-03 18-Oct-03 11-Oct-03 23-Oct-03 14-Oct-03 10-Oct-03 14-Oct-03 14-Oct-03 14-Oct-03 17-Oct-03 23-Oct-03 28-Oct-03 21-Oct-03 21-Oct-03 25-Oct-03 28-Oct-03 24-Oct-03 25-Oct-03 29-Oct-03 29-Oct-03 4-Nov-03 8-Nov-03 5-Nov-03 4-Nov-03 6-Nov-03 5-Nov-03 11-Nov-03 8-Nov-03 8-Nov-03 15-Nov-03 15-Nov-03 3-Dec-03 20-Nov-03 18-Nov-03 25-Nov-03 20-Nov-03 20-Nov-03 27-Nov-03 2-Dec-03 27-Nov-03 26-Nov-03 2-Dec-03 3-Dec-03 28-Nov-03 4-Dec-03 4-Dec-03 2-Dec-03 30-Dec-03 2-Dec-03 2-Dec-03 9-Dec-03 27-Dec-03 24-Dec-03 9-Dec-03 11-Dec-03 9-Dec-03 9-Dec-03 13-Dec-03 13-Dec-03 19-Dec-03 13-Dec-03 16-Jan-04 13-Dec-03 16-Dec-03 18-Dec-03 20-Dec-03 23-Dec-03 25-Dec-03 20-Dec-03 20-Dec-03 24-Dec-03
10316 10317 10318 10319 10320 10321 10322 10323 10324 10325 10326 10327 10328 10329 10330 10331 10332 10333 10334 10335 10336 10337 10338 10339 10340 10341 10342 10343 10344 10345 10346 10347 10348 10349 10350 10351 10352 10353 10354 10355 10356 10357 10358 10359 10360 10361 10362 10363 10364 10365 10366 10367 10368 10369 10370 10371 10372 10373 10374 10375 10376 10377 10378 10379 10380 10381 10382 10383 10384 10385 10386 10387 10388 10389
$2,835.00 $288.00 $240.40 $1,191.20 $516.00 $144.00 $112.00 $164.40 $5,275.71 $1,497.00 $982.00 $1,810.00 $1,168.00 $4,578.43 $1,649.00 $88.50 $1,786.88 $877.20 $144.80 $2,036.16 $285.12 $2,467.00 $934.50 $3,354.00 $2,436.18 $352.60 $1,840.64 $1,584.00 $2,296.00 $2,924.80 $1,618.88 $814.42 $363.60 $141.60 $642.06 $5,398.72 $136.30 $8,593.28 $568.80 $480.00 $1,106.40 $1,167.68 $429.40 $3,471.68 $7,390.20 $2,046.24 $1,549.60 $447.20 $950.00 $403.20 $136.00 $834.20 $1,689.78 $2,390.40 $1,117.60 $72.96 $9,210.90 $1,366.40 $459.00 $338.00 $399.00 $863.60 $103.20 $863.28 $1,313.82 $112.00 $2,900.00 $899.00 $2,222.40 $691.20 $166.00 $1,058.40 $1,228.80 $1,832.80
Excel Training
14th September 2005
Rohan Fernandes
UK USA USA USA USA UK USA UK USA USA USA USA USA USA USA USA UK USA USA USA USA UK USA USA USA USA USA USA USA USA USA USA USA UK UK UK USA USA UK USA USA USA USA USA USA USA USA USA USA UK USA USA USA USA USA USA UK USA USA USA USA USA USA USA USA USA USA USA UK USA USA USA USA UK
Suyama Leverling Fuller Davolio Davolio Suyama Davolio Buchanan Fuller Callahan Davolio Davolio Callahan Peacock Fuller Davolio King Fuller Callahan Leverling Leverling Dodsworth Callahan Leverling Fuller Leverling Callahan Peacock Peacock Peacock Leverling Callahan Fuller Suyama King Suyama Peacock Peacock King Leverling Peacock Peacock Leverling Leverling Leverling Callahan Leverling Callahan Leverling Suyama Peacock Leverling Leverling Callahan Leverling Leverling Suyama Peacock Peacock Leverling Callahan Peacock Callahan Davolio Peacock Callahan Callahan Fuller King Peacock Callahan Davolio Fuller Buchanan
26-Dec-03 31-Dec-03 1-Jan-04 3-Jan-04 3-Jan-04 3-Jan-04 6-Jan-04 2-Jan-04 9-Jan-04 8-Jan-04 16-Jan-04 10-Jan-04 10-Jan-04 9-Jan-04 8-Jan-04 22-Jan-04 13-Jan-04 30-Jan-04 14-Jan-04 14-Jan-04 15-Jan-04 21-Jan-04 15-Jan-04 16-Jan-04 17-Jan-04 24-Jan-04 27-Jan-04 28-Jan-04 24-Jan-04 30-Jan-04 27-Jan-04 27-Jan-04 31-Jan-04 24-Feb-04 27-Jan-04 14-Feb-04 6-Feb-04 3-Mar-04 4-Feb-04 7-Feb-04 3-Feb-04 7-Feb-04 7-Feb-04 4-Mar-04 13-Feb-04 7-Feb-04 11-Feb-04 12-Feb-04 14-Feb-04 10-Feb-04 28-Feb-04 14-Mar-04 18-Feb-04 14-Feb-04 21-Feb-04 20-Feb-04 19-Feb-04 7-Mar-04 24-Feb-04 27-Feb-04 11-Mar-04 12-Mar-04 26-Feb-04 26-Feb-04 25-Feb-04 3-Mar-04 28-Feb-04 3-Mar-04 4-Mar-04 28-Feb-04 3-Mar-04 5-Mar-04 18-Mar-04 6-Mar-04
10390 10391 10392 10393 10394 10395 10396 10397 10398 10399 10400 10401 10402 10403 10404 10405 10406 10407 10408 10409 10410 10411 10412 10413 10414 10415 10416 10417 10418 10419 10420 10421 10422 10423 10424 10425 10426 10427 10428 10429 10430 10431 10432 10433 10434 10435 10436 10437 10438 10439 10440 10441 10442 10443 10444 10445 10446 10447 10448 10449 10450 10451 10452 10453 10454 10455 10456 10457 10458 10459 10460 10461 10462 10463
$2,090.88 $86.40 $1,440.00 $2,556.95 $442.00 $2,122.92 $1,903.80 $716.72 $2,505.60 $1,765.60 $3,063.00 $3,868.60 $2,713.50 $855.01 $1,591.25 $400.00 $1,830.78 $1,194.00 $1,622.40 $319.20 $802.00 $966.80 $334.80 $2,123.20 $224.83 $102.40 $720.00 $11,188.40 $1,814.80 $2,097.60 $1,707.84 $1,194.27 $49.80 $1,020.00 $9,194.56 $360.00 $338.20 $651.00 $192.00 $1,441.37 $4,899.20 $1,892.25 $485.00 $851.20 $321.12 $631.60 $1,994.52 $393.00 $454.00 $1,078.00 $4,924.13 $1,755.00 $1,792.00 $517.44 $1,031.70 $174.90 $246.24 $914.40 $443.40 $1,838.20 $425.12 $3,849.66 $2,018.50 $407.70 $331.20 $2,684.00 $557.60 $1,584.00 $3,891.00 $1,659.20 $176.10 $1,538.70 $156.00 $713.30
Excel Training
14th September 2005
Rohan Fernandes
USA USA USA USA USA USA USA USA USA USA UK UK USA UK USA USA UK USA USA UK USA USA USA USA USA UK UK USA USA USA USA USA UK UK USA USA UK UK USA UK USA USA UK UK USA USA UK USA UK UK USA USA USA USA USA UK UK USA USA UK USA USA USA UK UK UK USA UK UK USA USA USA USA USA
Peacock Davolio Peacock Callahan Leverling Davolio Peacock Fuller Callahan Davolio Buchanan Dodsworth Callahan Buchanan Fuller Leverling Suyama Callahan Davolio King Leverling Peacock Davolio Fuller Callahan Suyama King Callahan Leverling Peacock Peacock Leverling King King Callahan Peacock Suyama Dodsworth Fuller Suyama Peacock Leverling Dodsworth King Davolio Peacock Suyama Peacock King King Leverling Fuller Fuller Leverling Peacock Suyama King Callahan Peacock King Davolio Davolio Peacock King Suyama Buchanan Leverling King King Callahan Callahan Peacock Leverling Davolio
14-Mar-04 14-Mar-04 13-Mar-04 11-Mar-04 12-Mar-04 14-Mar-04 14-Mar-04 18-Mar-04 19-Mar-04 21-Mar-04 21-Mar-04 4-Apr-04 24-Mar-04 25-Mar-04 26-Mar-04 21-Mar-04 24-Mar-04 25-Mar-04 10-Apr-04 25-Apr-04 1-Apr-04 31-Mar-04 2-Apr-04 28-Mar-04 2-Apr-04 9-Apr-04 3-Apr-04 8-Apr-04 11-Apr-04 10-Apr-04 9-Apr-04 11-Apr-04 7-Apr-04 7-Apr-04 11-Apr-04 16-Apr-04 17-Apr-04 16-Apr-04 29-Apr-04 16-Apr-04 18-Apr-04 21-Apr-04 2-May-04 22-Apr-04 13-May-04 29-Apr-04 28-Apr-04 21-Apr-04 24-Apr-04 28-Apr-04 16-May-04 23-May-04 1-May-04 29-Apr-04 5-May-04 1-May-04 1-May-04 2-May-04 6-May-04 30-May-04 7-May-04 23-May-04 15-May-04 7-May-04 9-May-04 9-May-04 12-May-04 19-May-04 12-May-04 22-May-04 14-May-04 21-May-04 6-Jun-04 19-May-04
10464 10465 10466 10467 10468 10469 10470 10471 10472 10473 10474 10475 10476 10477 10478 10479 10480 10481 10482 10483 10484 10485 10486 10487 10488 10489 10490 10491 10492 10493 10494 10495 10496 10497 10498 10499 10500 10501 10502 10503 10504 10505 10506 10507 10508 10509 10510 10511 10512 10513 10514 10515 10516 10517 10518 10519 10520 10521 10522 10523 10524 10525 10526 10527 10528 10529 10530 10531 10532 10533 10534 10535 10536 10537
$1,609.28 $2,518.00 $216.00 $235.20 $717.60 $956.67 $1,820.80 $1,328.00 $1,036.80 $230.40 $1,249.10 $1,505.18 $180.48 $558.00 $471.20 $10,495.60 $756.00 $1,472.00 $147.00 $668.80 $386.20 $1,584.00 $1,272.00 $889.70 $1,512.00 $439.20 $3,163.20 $259.50 $851.20 $608.40 $912.00 $278.00 $190.00 $1,380.60 $575.00 $1,412.00 $523.26 $149.00 $816.30 $2,048.50 $1,388.50 $147.90 $415.80 $749.06 $240.00 $136.80 $4,707.54 $2,550.00 $525.30 $1,942.00 $8,623.45 $9,921.30 $2,381.05 $352.00 $4,150.05 $2,314.20 $200.00 $225.50 $2,318.24 $2,444.31 $3,192.65 $818.40 $1,151.40 $1,503.00 $392.20 $946.00 $4,180.00 $110.00 $796.35 $2,222.20 $465.70 $1,940.85 $1,645.00 $1,823.80
Excel Training
14th September 2005
Rohan Fernandes
UK UK USA USA USA USA USA USA USA USA USA UK UK USA USA USA USA UK USA UK USA UK USA USA USA USA USA USA UK USA USA UK USA USA USA UK USA UK USA UK USA USA USA USA USA USA USA UK UK USA USA USA USA USA USA UK USA USA USA UK USA UK USA UK USA USA USA USA USA UK USA UK USA UK
Dodsworth Suyama Leverling Fuller Davolio Callahan Peacock Callahan Davolio Leverling Leverling Buchanan King Peacock Fuller Fuller Peacock Suyama Fuller Dodsworth Davolio Suyama Callahan Fuller Davolio Fuller Peacock Callahan Dodsworth Davolio Leverling Buchanan Leverling Callahan Leverling King Peacock Buchanan Leverling Dodsworth Peacock Davolio Peacock Leverling Leverling Fuller Peacock King Dodsworth Davolio Fuller Callahan Peacock Davolio Leverling King Leverling Fuller Callahan King Davolio Suyama Peacock King Callahan Callahan Davolio Davolio Peacock Buchanan Peacock King Callahan Suyama
16-May-04 23-May-04 13-Jun-04 29-May-04 26-May-04 23-May-04 30-May-04 26-Jun-04 27-May-04 2-Jun-04 2-Jun-04 30-May-04 6-Jun-04 6-Jun-04 5-Jun-04 3-Jun-04 5-Jun-04 4-Jun-04 13-Jun-04 6-Jun-04 10-Jun-04 13-Jun-04 9-Jun-04 9-Jun-04 12-Jun-04 24-Jun-04 16-Jun-04 18-Jun-04 18-Jun-04 17-Jun-04 9-Jul-04 11-Jul-04 19-Jun-04 4-Jul-04 25-Jun-04 20-Jun-04 30-Jun-04 30-Jun-04 30-Jun-04 30-Jun-04 25-Jul-04 4-Jul-04 1-Jul-04 2-Jul-04 14-Jul-04 4-Jul-04 4-Jul-04 10-Jul-04 9-Jul-04 9-Jul-04 10-Jul-04 14-Jul-04 14-Jul-04 16-Jul-04 16-Jul-04 13-Aug-04 16-Jul-04 14-Jul-04 12-Aug-04 18-Jul-04 18-Jul-04 21-Jul-04 21-Jul-04 22-Jul-04 22-Jul-04 8-Aug-04 29-Jul-04 29-Jul-04 31-Jul-04 25-Jul-04 1-Aug-04 30-Jul-04 6-Aug-04 1-Aug-04
10538 10539 10540 10541 10542 10543 10544 10545 10546 10547 10548 10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 10579 10580 10581 10582 10583 10584 10585 10586 10587 10588 10589 10590 10591 10592 10593 10594 10595 10596 10597 10598 10599 10600 10601 10602 10603 10604 10605 10606 10607 10608 10609 10610 10611
$139.80 $355.50 $10,191.70 $1,946.52 $469.11 $1,504.50 $417.20 $210.00 $2,812.00 $1,792.80 $240.10 $3,554.27 $683.30 $1,677.30 $880.50 $1,546.30 $1,728.52 $2,944.40 $835.20 $1,152.50 $2,142.90 $520.41 $1,072.42 $2,844.50 $488.70 $965.00 $1,234.05 $639.90 $1,761.00 $2,519.00 $155.00 $890.00 $2,465.25 $550.59 $1,501.08 $2,082.00 $764.30 $2,147.40 $838.45 $569.00 $477.00 $317.75 $1,013.74 $310.00 $330.00 $2,237.50 $593.75 $142.50 $23.80 $807.38 $3,120.00 $72.00 $1,101.00 $812.50 $516.46 $1,994.40 $565.50 $4,725.00 $1,180.88 $718.08 $2,388.50 $493.00 $479.80 $2,285.00 $48.75 $1,483.00 $230.85 $4,109.69 $1,130.40 $6,475.40 $1,064.00 $424.00 $299.25 $808.00
Excel Training
14th September 2005
Rohan Fernandes
USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA UK USA USA USA UK USA UK USA USA UK UK USA USA UK USA UK UK UK USA USA USA UK USA UK USA USA UK USA UK USA USA USA USA UK UK USA USA USA USA UK USA USA UK USA USA UK USA USA USA USA USA USA USA
Davolio Peacock Callahan Fuller Davolio Peacock Davolio Leverling Fuller Peacock Peacock Callahan Peacock Leverling Davolio Callahan Peacock Peacock Davolio Callahan Callahan King Peacock Callahan Peacock Suyama Leverling King Peacock Peacock King Suyama Leverling Peacock Dodsworth Peacock Buchanan Buchanan Buchanan Callahan Peacock Davolio Buchanan Davolio Suyama Fuller Peacock King Callahan King Leverling Fuller Davolio Davolio King King Davolio Fuller Peacock Davolio Dodsworth Fuller Peacock Buchanan Fuller Davolio King Callahan Davolio Leverling Leverling Fuller Leverling Peacock
1-Aug-04 1-Aug-04 1-Aug-04 6-Aug-04 5-Aug-04 4-Aug-04 8-Aug-04 7-Aug-04 14-Aug-04 11-Aug-04 11-Aug-04 12-Aug-04 19-Aug-04 14-Aug-04 20-Aug-04 21-Aug-04 20-Aug-04 20-Aug-04 19-Aug-04 15-Aug-04 19-Aug-04 18-Aug-04 21-Aug-04 21-Aug-04 26-Aug-04 26-Aug-04 1-Sep-04 27-Aug-04 28-Aug-04 26-Aug-04 5-Sep-04 2-Sep-04 1-Sep-04 2-Sep-04 3-Sep-04 3-Sep-04 9-Sep-04 29-Aug-04 3-Sep-04 11-Sep-04 8-Sep-04 19-Sep-04 11-Sep-04 11-Sep-04 10-Sep-04 15-Sep-04 8-Sep-04 10-Sep-04 15-Oct-04 15-Sep-04 18-Sep-04 3-Oct-04 19-Sep-04 17-Sep-04 22-Sep-04 19-Sep-04 23-Sep-04 22-Sep-04 18-Sep-04 24-Sep-04 26-Sep-04 19-Sep-04 30-Sep-04 23-Sep-04 29-Sep-04 26-Sep-04 16-Oct-04 30-Sep-04 26-Sep-04 30-Sep-04 1-Oct-04 1-Oct-04 30-Sep-04 3-Oct-04
10612 10613 10614 10615 10616 10617 10618 10619 10620 10621 10622 10623 10624 10625 10626 10627 10628 10629 10630 10631 10632 10633 10634 10635 10636 10637 10638 10639 10640 10641 10642 10643 10644 10645 10646 10647 10648 10649 10650 10651 10652 10653 10654 10655 10656 10657 10658 10659 10660 10661 10662 10663 10664 10665 10666 10667 10668 10669 10670 10671 10672 10673 10674 10675 10676 10677 10678 10679 10680 10681 10682 10683 10684 10685
$6,375.00 $353.20 $464.00 $120.00 $4,806.99 $1,402.50 $2,697.50 $1,260.00 $57.50 $758.50 $560.00 $1,336.95 $1,393.24 $479.75 $1,503.60 $1,185.75 $450.00 $2,775.05 $903.60 $55.80 $589.00 $5,510.59 $4,985.50 $1,326.22 $629.50 $2,761.94 $2,720.05 $500.00 $708.75 $2,054.00 $696.00 $814.50 $1,371.80 $1,535.00 $1,446.00 $636.00 $372.37 $1,434.00 $1,779.20 $397.80 $318.84 $1,083.15 $601.83 $154.40 $604.21 $4,371.60 $4,464.60 $1,227.02 $1,701.00 $562.60 $125.00 $1,930.40 $1,288.39 $1,295.00 $4,666.94 $1,536.80 $625.27 $570.00 $2,301.75 $920.10 $3,815.25 $412.35 $45.00 $1,423.00 $534.85 $813.36 $5,256.50 $660.00 $1,261.88 $1,287.40 $375.50 $63.00 $1,768.00 $801.10
Excel Training
14th September 2005
Rohan Fernandes
USA UK USA USA USA USA USA USA USA UK USA USA USA USA USA UK USA UK UK UK USA USA UK USA USA UK USA USA UK USA USA USA USA USA USA UK USA USA USA USA USA USA USA USA UK UK USA USA USA UK UK USA USA USA USA USA USA USA UK UK USA UK USA USA UK USA USA USA UK USA USA UK USA USA
Fuller Dodsworth Peacock Davolio Davolio Fuller Peacock Leverling Callahan King Callahan Leverling Peacock Leverling Leverling Suyama Peacock Suyama Suyama Dodsworth Callahan Peacock Suyama Davolio Davolio Buchanan Leverling Davolio Buchanan Leverling Peacock Davolio Davolio Callahan Callahan Buchanan Callahan Leverling Callahan Peacock Peacock Fuller Peacock Callahan Buchanan King Leverling Davolio Fuller Suyama Dodsworth Fuller Fuller Leverling Peacock Peacock Leverling Davolio Suyama Dodsworth Davolio Suyama Leverling Peacock Dodsworth Leverling Fuller Leverling Suyama Peacock Callahan Suyama Leverling Leverling
8-Oct-04 30-Oct-04 7-Oct-04 7-Oct-04 3-Oct-04 22-Oct-04 13-Oct-04 10-Oct-04 9-Oct-04 14-Oct-04 14-Oct-04 14-Oct-04 17-Oct-04 13-Oct-04 16-Oct-04 15-Oct-04 21-Oct-04 20-Oct-04 7-Nov-04 18-Nov-04 21-Oct-04 23-Oct-04 5-Nov-04 20-Nov-04 23-Oct-04 29-Oct-04 31-Oct-04 24-Oct-04 27-Oct-04 29-Oct-04 27-Oct-04 29-Oct-04 29-Oct-04 5-Nov-04 5-Nov-04 31-Oct-04 4-Nov-04 25-Nov-04 5-Nov-04 5-Nov-04 5-Dec-04 5-Dec-04 11-Nov-04 14-Nov-04 14-Nov-04 14-Nov-04 7-Nov-04 10-Nov-04 12-Nov-04 21-Nov-04 21-Nov-04 18-Nov-04 18-Nov-04 17-Nov-04 25-Nov-04 18-Nov-04 18-Nov-04 21-Nov-04 24-Nov-04 27-Nov-04 21-Nov-04 26-Nov-04 28-Nov-04 19-Dec-04 24-Nov-04 3-Dec-04 28-Nov-04 27-Nov-04 27-Nov-04 28-Nov-04 2-Dec-04 15-Dec-04 4-Dec-04 12-Dec-04
10686 10687 10688 10689 10690 10691 10692 10693 10694 10695 10696 10697 10698 10699 10700 10701 10702 10703 10704 10705 10706 10707 10708 10709 10710 10711 10712 10713 10714 10715 10716 10717 10718 10719 10720 10721 10722 10723 10724 10725 10726 10727 10728 10729 10730 10731 10732 10733 10734 10735 10736 10737 10738 10739 10740 10741 10742 10743 10744 10745 10746 10747 10748 10749 10750 10751 10752 10753 10754 10755 10756 10757 10758 10759
$1,404.45 $4,960.90 $3,160.60 $472.50 $862.50 $10,164.80 $878.00 $2,071.20 $4,825.00 $642.00 $996.00 $805.43 $3,436.45 $114.00 $1,638.40 $2,864.50 $330.00 $2,545.00 $595.50 $378.00 $1,893.00 $1,641.00 $180.40 $3,424.00 $93.50 $4,451.70 $1,233.48 $2,827.90 $2,205.75 $1,296.00 $706.00 $1,270.75 $3,463.00 $844.25 $550.00 $923.87 $1,570.00 $468.45 $638.50 $287.80 $655.00 $1,624.50 $1,296.75 $1,850.00 $484.25 $1,890.50 $360.00 $1,459.00 $1,498.35 $536.40 $997.00 $139.80 $52.35 $240.00 $1,416.00 $228.00 $3,118.00 $319.20 $736.00 $4,529.80 $2,311.70 $1,912.85 $2,196.00 $1,080.00 $1,590.56 $1,631.48 $252.00 $88.00 $55.20 $1,948.50 $1,990.00 $3,082.00 $1,644.60 $320.00
Excel Training
14th September 2005
Rohan Fernandes
USA UK USA USA UK USA USA USA USA USA USA UK USA USA USA UK USA UK USA USA USA USA UK USA USA USA USA USA USA USA UK UK USA USA UK USA USA UK USA UK USA USA USA USA UK USA USA USA USA UK USA USA UK USA USA USA USA USA UK USA USA USA UK UK USA USA UK USA UK UK USA USA USA UK
Peacock Buchanan Leverling Leverling Suyama Leverling Peacock Peacock Leverling Leverling Callahan Dodsworth Leverling Davolio Peacock King Davolio King Leverling Leverling Fuller Fuller Dodsworth Peacock Peacock Davolio Callahan Fuller Davolio Davolio Suyama Suyama Davolio Leverling Suyama Callahan Leverling King Fuller Dodsworth Davolio Peacock Peacock Peacock Suyama Fuller Leverling Peacock Fuller King Fuller Callahan Buchanan Davolio Leverling Fuller Peacock Leverling King Fuller Leverling Davolio Suyama Buchanan Callahan Davolio Suyama Davolio Dodsworth Dodsworth Peacock Leverling Fuller Suyama
10-Dec-04 8-Dec-04 9-Dec-04 8-Dec-04 8-Dec-04 9-Dec-04 9-Dec-04 15-Dec-04 15-Dec-04 12-Dec-04 17-Dec-04 2-Jan-04 19-Dec-04 16-Dec-04 12-Dec-04 26-Dec-04 18-Dec-04 21-Jan-05 24-Dec-04 14-Jan-05 25-Dec-04 19-Dec-04 22-Dec-04 19-Dec-04 22-Dec-04 24-Dec-04 23-Dec-04 26-Dec-04 19-Jan-05 31-Dec-04 26-Dec-04 1-Jan-05 31-Dec-04 8-Jan-05 2-Jan-05 20-Jan-05 14-Jan-05 5-Jan-05 5-Jan-05 5-Jan-05 5-Jan-05 31-Dec-04 2-Jan-05 6-Jan-05 7-Jan-05 9-Jan-05 5-Jan-05 30-Jan-05 9-Jan-05 7-Jan-05 7-Jan-05 8-Jan-05 12-Jan-05 9-Jan-05 14-Jan-05 14-Jan-05 4-Feb-05 13-Jan-05 12-Jan-05 16-Jan-05 13-Jan-05 15-Jan-05 16-Jan-05 13-Jan-05 30-Jan-05 14-Jan-05 6-Feb-05 6-Feb-05 4-Feb-05 23-Jan-05 21-Jan-05 23-Jan-05 19-Jan-05 23-Jan-05
10760 10761 10762 10763 10764 10765 10766 10767 10768 10769 10770 10771 10772 10773 10774 10775 10776 10777 10778 10779 10780 10781 10782 10783 10784 10785 10786 10787 10788 10789 10790 10791 10792 10793 10794 10795 10796 10797 10798 10799 10800 10801 10802 10803 10804 10805 10806 10807 10808 10809 10810 10811 10812 10813 10814 10815 10816 10817 10818 10819 10820 10821 10822 10823 10824 10825 10826 10827 10828 10829 10830 10831 10832 10833
$2,917.00 $507.00 $4,337.00 $616.00 $2,286.00 $1,515.60 $2,310.00 $28.00 $1,477.00 $1,684.27 $236.25 $344.00 $3,603.22 $2,030.40 $868.75 $228.00 $6,635.27 $224.00 $96.50 $1,335.00 $720.00 $975.88 $12.50 $1,442.50 $1,488.00 $387.50 $1,531.08 $2,622.76 $731.50 $3,687.00 $722.50 $1,829.76 $399.85 $191.10 $314.76 $2,158.00 $2,341.36 $420.00 $446.60 $1,553.50 $1,468.93 $3,026.85 $2,942.81 $1,193.01 $2,278.40 $2,775.00 $439.60 $18.40 $1,411.00 $140.00 $187.00 $852.00 $1,692.80 $602.40 $1,788.45 $40.00 $8,446.45 $10,952.84 $833.00 $477.00 $1,140.00 $678.00 $237.90 $2,826.00 $250.80 $1,030.76 $730.00 $843.00 $932.00 $1,764.00 $1,974.00 $2,684.40 $475.11 $906.93
Excel Training
14th September 2005
Rohan Fernandes
USA USA UK UK USA USA USA UK USA USA USA USA USA USA UK UK USA UK USA UK USA USA USA USA USA USA USA USA USA USA USA USA UK UK UK UK UK UK UK USA UK USA UK USA USA USA UK USA USA USA USA UK USA USA USA UK UK UK USA UK USA USA UK USA USA UK USA USA USA USA USA UK USA UK
Davolio Davolio King Dodsworth Leverling Leverling Peacock Buchanan Davolio Peacock Callahan Callahan Fuller Peacock King Dodsworth Davolio Buchanan Callahan Dodsworth Leverling Leverling Leverling Callahan Fuller Davolio Leverling Peacock Callahan Peacock Peacock Fuller Buchanan Suyama King Buchanan Buchanan Dodsworth Buchanan Peacock Buchanan Peacock King Davolio Peacock Leverling King Peacock Peacock Callahan Peacock Suyama Davolio Callahan Davolio Dodsworth King King Peacock Dodsworth Davolio Leverling King Leverling Peacock Buchanan Davolio Peacock Davolio Leverling Leverling Dodsworth Peacock Suyama
19-Jan-05 21-Jan-05 21-Jan-05 23-Jan-05 23-Jan-05 22-Jan-05 16-Feb-05 29-Jan-05 29-Jan-05 26-Jan-05 26-Jan-05 30-Jan-05 23-Jan-05 10-Feb-05 29-Jan-05 30-Jan-05 30-Jan-05 2-Feb-05 30-Jan-05 3-Feb-05 5-Feb-05 4-Feb-05 10-Feb-05 6-Feb-05 3-Feb-05 2-Feb-05 4-Feb-05 17-Feb-05 2-Feb-05 17-Feb-05 9-Feb-05 12-Feb-05 12-Feb-05 11-Feb-05 23-Feb-05 9-Feb-05 13-Feb-05 10-Feb-05 9-Feb-05 9-Feb-05 11-Feb-05 3-Mar-05 12-Feb-05 19-Feb-05 12-Feb-05 12-Feb-05 18-Feb-05 18-Feb-05 20-Feb-05 20-Feb-05 13-Feb-05 18-Feb-05 2-Mar-05 16-Feb-05 23-Feb-05 23-Feb-05 18-Feb-05 19-Feb-05 19-Feb-05 20-Feb-05 20-Feb-05 23-Feb-05 27-Feb-05 25-Feb-05 6-Mar-05 26-Feb-05 4-Mar-05 26-Feb-05 3-Mar-05 4-Mar-05 27-Feb-05 6-Mar-05 3-Mar-05 27-Feb-05
10834 10835 10836 10837 10838 10839 10840 10841 10842 10843 10844 10845 10846 10847 10848 10849 10850 10851 10852 10853 10854 10855 10856 10857 10858 10859 10860 10861 10862 10863 10864 10865 10866 10867 10868 10869 10870 10871 10872 10873 10874 10875 10876 10877 10878 10879 10880 10881 10882 10883 10884 10885 10886 10887 10888 10889 10890 10891 10892 10893 10894 10895 10896 10897 10898 10899 10900 10901 10902 10903 10904 10905 10906 10907
$1,432.71 $845.80 $4,705.50 $1,064.50 $1,938.38 $827.55 $211.20 $4,581.00 $975.00 $159.00 $735.00 $3,812.70 $1,112.00 $4,931.92 $931.50 $967.82 $629.00 $2,603.00 $2,984.00 $625.00 $2,966.50 $2,227.89 $660.00 $2,048.22 $649.00 $1,078.69 $519.00 $3,523.40 $581.00 $441.15 $282.00 $16,387.50 $1,096.20 $98.40 $1,920.60 $1,630.00 $160.00 $1,979.23 $2,058.46 $336.80 $310.00 $709.55 $917.00 $1,955.13 $1,539.00 $611.30 $1,500.00 $150.00 $892.64 $36.00 $1,378.07 $1,209.00 $3,127.50 $70.00 $605.00 $11,380.00 $860.10 $368.93 $2,090.00 $5,502.11 $2,753.10 $6,379.40 $750.50 $10,835.24 $30.00 $122.40 $33.75 $934.50 $863.43 $932.05 $1,924.25 $342.00 $427.50 $108.50
Excel Training
14th September 2005
Rohan Fernandes
USA USA USA USA USA USA UK USA USA USA USA USA USA USA UK UK USA USA USA USA USA UK USA USA USA UK USA USA USA UK USA USA USA UK UK USA UK USA USA USA USA USA USA UK USA UK UK USA UK USA UK UK USA USA USA UK USA UK USA USA USA USA UK USA USA UK USA USA USA USA UK USA USA USA
Peacock Davolio Davolio Leverling Fuller Peacock Suyama Fuller Davolio Peacock Leverling Fuller Peacock Davolio Buchanan King Leverling Leverling Peacock Peacock Davolio Suyama Peacock Peacock Callahan Suyama Leverling Peacock Leverling King Leverling Fuller Callahan King Dodsworth Peacock Suyama Peacock Davolio Leverling Leverling Fuller Davolio Dodsworth Davolio Dodsworth Buchanan Callahan Suyama Callahan King Suyama Leverling Callahan Callahan Dodsworth Leverling Suyama Peacock Fuller Davolio Davolio Dodsworth Fuller Peacock Suyama Leverling Davolio Davolio Callahan Dodsworth Callahan Peacock Davolio
6-Mar-05 10-Mar-05 4-Mar-05 5-Mar-05 18-Mar-05 4-Mar-05 2-Mar-05 2-Mar-05 9-Mar-05 11-Mar-05 11-Mar-05 4-Mar-05 9-Mar-05 9-Mar-05 5-Mar-05 13-Mar-05 8-Apr-05 13-Mar-05 11-Mar-05 8-Apr-05 18-Mar-05 12-Mar-05 18-Mar-05 19-Mar-05 24-Mar-05 16-Mar-05 12-Mar-05 18-Mar-05 18-Mar-05 13-Mar-05 16-Mar-05 13-Mar-05 23-Mar-05 20-Mar-05 18-Mar-05 19-Mar-05 13-Mar-05 18-Mar-05 19-Mar-05 16-Mar-05 19-Mar-05 17-Mar-05 23-Mar-05 7-Apr-05 24-Mar-05 25-Mar-05 20-Mar-05 20-Mar-05 20-Mar-05 27-Mar-05 27-Mar-05 23-Mar-05 8-Apr-05 30-Mar-05 23-Mar-05 26-Mar-05 24-Mar-05 30-Mar-05 8-Apr-05 2-Apr-05 1-Apr-05 30-Mar-05 24-Apr-05 2-Apr-05 26-Mar-05 27-Mar-05 3-Apr-05 27-Mar-05 3-Apr-05 10-Apr-05 23-Apr-05 31-Mar-05 17-Apr-05 2-Apr-05
10908 10909 10910 10911 10912 10913 10914 10915 10916 10917 10918 10919 10920 10921 10922 10923 10924 10925 10926 10927 10928 10929 10930 10931 10932 10933 10934 10935 10936 10937 10938 10939 10940 10941 10942 10943 10944 10945 10946 10947 10948 10949 10950 10951 10952 10953 10954 10955 10956 10957 10958 10959 10960 10961 10962 10963 10964 10965 10966 10967 10968 10969 10970 10971 10972 10973 10974 10975 10976 10977 10978 10979 10980 10981
$663.10 $670.00 $452.90 $858.00 $6,200.55 $768.75 $537.50 $539.50 $686.70 $365.89 $1,447.50 $1,122.80 $390.00 $1,936.00 $742.50 $748.80 $1,835.70 $475.15 $514.40 $800.00 $137.50 $1,174.75 $2,255.50 $799.20 $1,788.63 $920.60 $500.00 $619.50 $456.00 $644.80 $2,731.87 $637.50 $360.00 $4,011.75 $560.00 $711.00 $1,025.33 $245.00 $1,407.50 $220.00 $2,362.25 $4,422.00 $110.00 $458.74 $471.20 $4,441.25 $1,659.53 $74.40 $677.00 $1,762.70 $781.00 $131.75 $265.35 $1,119.90 $3,584.00 $57.80 $2,052.50 $848.00 $1,098.46 $910.40 $1,408.00 $108.00 $224.00 $1,733.06 $251.50 $291.55 $439.00 $717.50 $912.00 $2,233.00 $1,303.19 $4,813.50 $248.00 $15,810.00
Excel Training
14th September 2005
Rohan Fernandes
USA USA USA USA USA USA USA USA USA USA USA UK USA USA USA USA USA UK USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA UK UK USA USA USA USA USA UK USA USA USA USA UK UK USA UK USA USA USA UK USA USA USA UK USA USA UK UK USA USA USA USA
Fuller Fuller Davolio Fuller Callahan Callahan Leverling Fuller Fuller Davolio Davolio King Fuller Davolio Peacock Callahan Callahan Suyama Fuller Fuller Peacock Leverling Leverling Fuller Leverling Callahan Fuller Fuller Leverling Davolio Fuller Fuller Fuller Dodsworth Dodsworth Peacock Fuller Leverling Davolio Peacock Suyama Peacock Davolio Fuller Peacock King Suyama Fuller King Callahan Fuller Callahan King Davolio Leverling Fuller Buchanan Peacock Callahan King King Leverling Fuller Callahan Leverling
8-Apr-05 6-Apr-05 3-Apr-05 2-Apr-05 21-Apr-05 6-Apr-05 10-Apr-05 2-Apr-05 7-Apr-05 7-Apr-05 3-Apr-05 10-Apr-05 9-Apr-05 6-Apr-05 10-Apr-05 13-Apr-05 17-Apr-05 10-Apr-05 14-Apr-05 14-Apr-05 16-Apr-05 8-Apr-05 20-Apr-05 10-Apr-05 15-Apr-05 13-Apr-05 10-Apr-05 21-Apr-05 13-Apr-05 17-Apr-05 10-Apr-05 15-Apr-05 20-Apr-05 13-Apr-05 20-Apr-05 16-Apr-05 16-Apr-05 21-Apr-05 24-Apr-05 20-Apr-05 24-Apr-05 28-Apr-05 20-Apr-05 22-Apr-05 27-Apr-05 27-Apr-05 24-Apr-05 23-Apr-05 23-Apr-05 27-Apr-05 24-Apr-05 22-Apr-05 27-Apr-05 30-Apr-05 28-Apr-05 1-May-05 29-Apr-05 1-May-05 24-Apr-05 1-May-05 30-Apr-05 1-May-05 29-Apr-05 1-May-05 1-May-05
10982 10983 10984 10985 10986 10987 10988 10989 10990 10991 10992 10993 10994 10995 10996 10997 10998 10999 11000 11001 11002 11003 11004 11005 11006 11007 11009 11010 11011 11012 11013 11014 11015 11016 11017 11018 11020 11021 11023 11024 11025 11026 11027 11028 11029 11030 11031 11032 11033 11034 11035 11036 11037 11038 11041 11042 11043 11044 11046 11047 11048 11052 11053 11056 11057
$1,014.00 $720.90 $1,809.75 $2,023.38 $2,220.00 $2,772.00 $3,574.80 $1,353.60 $4,288.85 $2,296.00 $69.60 $4,895.44 $940.50 $1,196.00 $560.00 $1,885.00 $686.00 $1,197.95 $903.75 $2,769.00 $1,811.10 $326.00 $295.38 $586.00 $329.69 $2,633.90 $616.50 $645.00 $933.50 $2,825.30 $361.00 $243.18 $622.35 $491.50 $6,750.00 $1,575.00 $632.40 $6,306.24 $1,500.00 $1,966.81 $270.00 $1,030.00 $877.72 $2,160.00 $1,286.80 $12,615.05 $2,393.50 $8,902.50 $3,232.80 $539.40 $1,754.50 $1,692.00 $60.00 $732.60 $1,773.00 $405.75 $210.00 $591.60 $1,485.80 $817.87 $525.00 $1,332.00 $3,055.00 $3,740.00 $45.00
Excel Training
14th September 2005
Rohan Fernandes
Multiple Charts on One Chart Window
Chart 1 Jan 10 Chart 2 Jan North South East West Chart 3 North South East West Chart 4 7:00 7:30 8:00 8:30 9:00 9:30 176 333 357 329 345 380 162 297 298 Regions 289 280 339 East South North 0 West 40 30 20 10 50 80 70 60 50 100 90 200 90 100 200 300 10 20 30 40 Feb 50 60 70 80 Mar Numbers 90 100 200 300 Feb 50 Mar 90 100 90 80 70 60 50 40 30 20 10 0 Jan Feb Month 10 50
Monthly Numbers
Regional Sales
100
150
200
Numbers Steps : 1. Create charts as usual, placing them in a worksheet 2. Select any blank cell in the worksheet and press F11; this creates an empty Chart sheet to hold the embedded charts. 3. Reactivate your worksheet, click an embedded chart, and select Chart, Location to display the Chart Location dialog box. 4. Choose "As object in" and specify the empty Chart sheet. 5. Excel will transfer the embedded chart to your Chart sheet. 6. Select your remaining charts, and use Chart, Location to move them to the Chart sheet. 7. Now you can arrange and size the charts any way you like.
Mar Feb Jan
8. Putting multiple charts on a single Chart sheet lets you use the View, Sized with Window command (available when the Chart sheet is active) to sca
Regional Numbers
90
90 300 200 100
Mar
North South East West
Periodic AHT and ATT
300 400 350 300 Numbers 250 200 150 100 250 300 350 50 0 7:00 7:30 8:00 Periods 8:30 9:00 9:30 176 162 333 297 357 298 329 289 345 280 380 339
the Chart sheet is active) to scale the charts to the window size and dimensions.
380 339
Time Subtraction
Sr No. Agent Hours Worked 35:00 37:40 32:29 32:15 33:57 31:13 37:30 39:40 Paid 37:30 37:30 37:30 37:30 37:30 37:30 37:30 37:30 Difference
1 2 3 4 5 6 7 8 Steps:
Agent 01 Agent 02 Agent 03 Agent 04 Agent 05 Agent 06 Agent 07 Agent 08
2:30 ######### 5:01 5:15 3:33 6:17 0:00 #########
1. By default, Excel uses a date system that begins with January 1, 1900 2. A negative time value generates a date/time combination that falls before this date, which is invalid. 3. The solution is to use the optional 1904 date system. 4. Select Tools, Options, click the Calculation tab, and check the 1904 date system box. 5. Your negative times will now be displayed correctly, as shown below. Notes: 1. Be careful if you workbook contains links to other files that don't use the 1904 date system. 2. In such a case, the mismatch of date systems could cause erroneous results.
Replace Formulas
Example Col 1 109 289 181 938 995 539 227 583 41 289 202 433 687 496 596 432 61 577 713 510 75 721 677 299 449 Col 2 410 125 486 266 118 795 483 395 581 859 34 531 910 350 242 130 713 971 437 886 428 418 415 538 470 Col 3 704 353 248 895 220 430 480 499 22 792 59 551 741 494 417 793 862 43 404 148 406 845 759 80 739 Col 4 357 325 469 342 89 704 714 554 659 276 240 373 203 286 558 566 819 884 578 512 350 931 651 4 184 Total 519 414 667 1204 1113 1334 710 978 622 1148 236 964 1597 846 838 562 774 1548 1150 1396 503 1139 1092 837 919 35094 Notes: Steps: 2. Invoke the Find Replace Dialog box by using the Keyboard Shortcut Ctrl H 3. In the Find What text Box, Enter C 4. In the Replace With text Box, Enter E 5. Click on Replace All to change the formulas in Range F6:F31
1. Select the Range containing the formulas that you need to change. In the E
1. The Replace function shall only work when the Find What and Replace With
i.e: If the values you are replacing require an additional bracket to be added a
2. Be careful what you are replacing. While changing C to E in the above exa
Eg: Changing C to D in the formula =COUNTIF(B6:C31,">100") will lead the f
Confidential
ormulas that you need to change. In the Example it would be from F6:F31
ox by using the Keyboard Shortcut Ctrl H
formulas in Range F6:F31
ork when the Find What and Replace With values don't change the Structure of the Formula.
equire an additional bracket to be added at the End, the Replace process will throw you an error.
. While changing C to E in the above example was fine a similar thing in the following formula would return an Error.
=COUNTIF(B6:C31,">100") will lead the formula to look like =DOUNTIF(B6
31,">100") which would result in Error.Confidential
Control Settings For Every New Workbook And Worksheet
Notes: There are two files that control the defaults for new workbooks and inserted worksheets. You can easily customize a blank workbook to contain your favorite settings and then save the file as book.xlt or sheet.xlt.
Any time that you choose either the New Workbook icon, or the Insert – Worksheet command, the new book or sheet will inherit the settings from th Steps: Follow these steps to create book.xlt. 1. In Excel, open a new blank workbook by using the New icon in the Standard toolbar. 2. Customize the workbook. Feel free to make adjustments to any of the following: • File – Page Setup • File – Set Print Area • Cell Styles • Format – Cells • Data – Validation settings • Number and type of sheets in the workbook • Window view options from the Tools – Options – View tab 3. Select File – Save As. In the Save As dialog, Save as Type dropdown, choose Template, 4. Browse to the following path on your Computer : C:\Program Files\Microsoft Office\Office\XLStart 5. Save the file as Book.xlt 6. All subsequent new workbooks will inherit the settings from this file. 7. You can also set up a workbook with one worksheet. Save this workbook as Sheet.XLT. 8. All inserted worksheets will inherit the settings from this file.
Confidential
will inherit the settings from these files.
Confidential
Navigating Excel's Sheets
1. Every Excel user knows that you can activate a different sheet in a workbook by clicking its sheet tab. 2. You can press Ctrl-Page Up to activate the previous sheet, and Ctrl-Page Down to activate the next sheet. 4. Here's a little-known trick that will allow you to bypass repeated scrolling or typing: 6. Select a sheet from the list, and you're there in a flash.
3. But if your workbook contains many sheets, and not all of the sheets' tabs fit on the screen, you may find it tedious to scroll through the tabs or us
5. Display a pop-up list of sheet names by right-clicking one of the arrows to the left of the sheet tabs that are located at the bottom of the workshee
Confidential
to scroll through the tabs or use the keyboard to activate a distant sheet.
d at the bottom of the worksheet window
Confidential
doc_228414767.xls