IT Glitch

Remember the MS Office training in the office i was gonna conduct on Monday?



Well, I think i screwed it up!



I had printed my notes for distribution. Notebook and projector set up. Everybody in...



First part, keyboard shortcuts went well. But i kept worrying that they might think, "Er.. what is this for? I dont need to use this." and blank out.



Problem No 1: Notebook doesnt have a real mouse = troublesome / slow.

Problem No 2: Notebook doesnt have the right-click button featured on my notes!! NONSENSe!



Second part is PowerPoint.



Problem No 3: The damned notebook i used had 2003 version.



But my notes and preparations were from 2000 version! There's a HUGE HUGE diff in PowerPoint where the custom animation's concerned. So in the end, i just roughly showed them the options. and i was like in a SUPER rambling-mode. If i were them i'd prolly be saying, "So u think you're an expert huh? NOT!"



No no... im certainly NOT an expert but just wanted to share some stuffs with my colleague so hopefully they wont come to me to ask (altho its nice sometimes to be needed) all the time or at the very least be able to do on their own when im on leave or whatever.



Im so disappointed i didnt get to really show them the works! Ah!



3rd Part was supposed to be for the rest of the ladies... but the guys were still in. So all the more i feel pressured to make my "training" simple so as not to turn them off.

So i quickly went thru the list of

1. Paste Special
2. Copy visible cells only
3. Protection
4. Subtotal
5. Average
6. Len formula
7. Right formula
8. Left formula
9. Month formula
10. Year formula
11. Constant in formula $A$1
12. Insert HyperLink
13. Validation - to create a drop down list restriction
14. Custom filtering
15. How to "find" / search

When it came to Protection, i had a problem No 4 Bcos even after i protected the worksheet, can still type over! Not supposed to be able to do that when i worked on it!

And i didnt even touch on Macro cos i dont wanna embarass myself further. Bcos the last time Problem No 5 occurred. When i ran the macro again, it jumped back to the row that i used for recording it! What went wrong? It worked the last time i used it. Is it bcos i use mouse instead of keyboard? But it worked before lah!

And i just rambled on Thru Len, Right and Left formulas. Tho i know they understand, not sure if they truly appreciate the value of it as i doubt they'd ever need to use it lah. But i promised to share with them this conversion formula i've created in Excel. To turn a non-date format to date format. You know how sometimes pple record date as 22.12.2007 or 20071222 and Excel just CANT capture is as date even after u formatted the cell to date? I have the shortcut to change it without manually keying in the dates all over again to reduce human error factor.

Onwards to graph.

It's really too simple that i felt silly showing it to them. Basically, click the create graph, highlight the data range and wala~

I didnt show them how to CREATE pivot table but i showed them what a pivot table can do from my existing file. From my 1000 over rows of data, it can be converted to a very simple summarised table with it for eg: to find how much of what type of business did a client give us in a certain month! Another table is to find out the exact $$ of which types of business for a particular month of your choice. Just choose the month and wala~

And before i knew it, it was 11:30am!!! So Mail Merge is skipped. Not that i intend to explain it anyway not being very proficient with it myself.

So i ended the session with, "I hope you all have benefitted something from this. and sorry i didnt get to show you much about PowerPoint." Mathieu being polite as ever said, "Oh Yes definitely we learnt something." Amos being the straight forward kind said, "But definitely we will still ask you." LOL!!

But yeah altho i could sense some tension or boredom at one time or other, i really appreciate the questions they posed to me. Shows that they were truly listening. Note to self: ask questions next time somebody gives a presentation.

What a way to start a Monday!