Excel: VLOOKUP


VLOOKUP是Excel其中一個函數雖然學起來有些麻煩,但用起來是很方便的。

VLOOKUP可以讓你,在密密麻麻的表格裏,輕鬆的取出,其中你想要的內容,
然後出現在你新製作的表格裏。


例子:


利用"No."來找出"Name"

步驟:
  1. VLOOKUP需要輸入四個數值來運行,第一個 數值是"以那裡作根據",以例子為例即"E2"  
  2. VLOOKUP 第二個 數值是"在那裡找資料",以例子為例即"A2:B11"
  3. VLOOKUP 第三個 數值是"資料在第幾排",以例子為例即"2"
  4. VLOOKUP 第四個 數值是"資料要相似? 或完全相同?"

    • FALSE表示要找完全相同

    • TRUE表示找相似的即可
    以例子為例即"False"




完成後應得出"=VLOOKUP(E2,A2:B11,2,FALSE)",這樣子再拉下去就可以套用下去就可以得出以下結_


Open "MY COMPUTER" SLOW IN XP

Symptom:  

Every time opens "My Computer" in XP, there will be a small flashlight in the search, probably  tens of seconds in order to see the C, D, E, and other disk.

Solution:    


  1. Open the regedit.
  2. Go to location HLM >  SOFTWARE > Microsoft > Windows > CurrentVersion> Explorer > My Computer > NameSpace > DelegateFolders
  3. Delete the default key : 
    • {59031a47-3f72-44a7-89c5-5595fe6b30ee}
    • {640167b4-59b0-47a6-b335-a6b3c0695aea}
    • {E211B736-43FD-11D1-9EFB-0000F8757FCD}



Outlook SecureTemp Files Folder

Have you tried cannot open a attachment in Outlook?


There may be occurs by too many same file name in SecureTemp folder.
Outlook will automatic save a copy in SecureTemp folder when you open the attachment.   
When you try to open the attachment with same name in Outlook, Outlook will create a copy in SecureTemp folder and add the number behind the file name (e.g. abc (1).doc, abc (2).doc....).


If there a more than 100 same file name (e.g. abc (100).doc), you will not able to open in outlook,
so you have to find out the SecureTemp folder location and delete the file.

Find SecureTemp

At start menu, Run, type regedit to open the registry editor.
Browse to this key:
HKEY_CURRENT_USER\Software\Microsoft\Office\xx.0\Outlook\Security
OutlookSecureTempFolder value

(Change xx to reflect the version number of Outlook. 14.0 = Outlook 2010; 12.0 = Outlook 2007; 11.0 = Outlook 2003 and 1.0 = Outlook 2002.)

Double click on OutlookSecureTempFolder to open the value then copy the path. Paste it  into the address bar of Windows Explorer to open the folder.

This folder is normally hidden by the file system.


Ref: http://www.slipstick.com/outlook/securetemp.htm

Can't see Security tab for a floder in XP

Can't see Security tab for a folder in XP?

If the security tab isn't visible on any of your folder properties in XP, you may have "Use Simple File Sharing" selected in your Folder Options.
Open Explorer and go to Tools>Folder Options.
Click the "View" tab and scroll to the bottom of the listbox with the heading "Advanced Settings".
Clear the "Use Simple File Sharing" checkbox.

Cisco Command


近期因為要設定Cisco 2950 Switch,所以把指令重温一遍,以下係小小的總結:

1.設定主機名稱
Switch(config)#hostname 主機名稱
主機名稱(config)#
2.設定密碼
======================enable密碼===============================
Switch(config)#enable password level 1 密碼    //密碼最少4個字元,最多8個字元,level1-15
Switch(config)#enable secret 密碼                     //加密模式密碼,如有設定,會蓋過enable密碼 
======================console密碼==============================
Switch(config)#line console 0
Switch(config-line)#password 密碼  
Switch(config-line)#login
Switch(config-line)#exec-timeout 0                   //閒置登出
Switch(config-line)#logging synchronous          //訊息同步
=====================telnet(vty) 密碼=============================
Switch(config)#line vty 0 15                           // 0-15 共有16vty線路
Switch(config-line)#password 密碼
Switch(config-line)#login
=============================================================
3.介面設定
Switch(config)#int FastEthernet0/12
Switch(config-if)#description 介面描述        //sh int sh run int 內可看到
Switch(config-if)#duplex auto                   //設定雙工模式,預設auto
Switch(config-if)#speed auto                    //設定速度,預設auto
Switch(config-if)#^z
Switch#sh running-config
!
interface FastEthernet0/12
 description 介面描述
!
4.啟動介面
Switch(config)# int 介面                             //介面為e0,S1/0,fa0/15,atm2/3.14,...
Switch(config-if)#no shutdown                 //啟動介面
Switch(config-if)#^z                                 //ctrl+Z 表示快速寫入config
5.ip 設定
Switch(config)#interface vlan 1
Switch(config-if)#ip address 192.168.0.250 255.255.255.0  //設定ipSubnet Mask
Switch(config-if)#no shutdown
Switch(config-if)#exit
Switch(config-if)#ip default-gateway  192.168.0.254            //跨網段管理
Switch(config-if)#^z
6.設定SSH
Switch#configure terminal
Switch(config)#ip domain-name example.com
Switch(config)#crypto key generate rsa
Switch(config)#username netadmin password netadmin
Switch(config)#ip ssh version 2
Switch(config)#line vty 0 15
Switch(config-line)#login local
Switch(config-line)#transport input ssh telnet
7.安全設定
1.Port security 只針對Access modePort設定
2.enable port security
3.(Optional)設定最大MAC數量,預設 1 show不會顯示,Cisco設備預設值通常不顯示
4.違規時switch的動作violation{shutdown預設 | restrict | protect}
5.1~4只防阻MAC Flooding攻擊,每一個port只能有1MAC通過,但還不能防止非法MAC接到設備上,把合法
    MAC寫到table,只要MAC有錯port就會 shutdown
Switch#show mac-address-table                              //Switch上查看MAC-Address-Table
將介面啟用Port-Security,指定只學習一筆MAC,使用Sticky方式學習MAC,並設定違規處理方式為Shutdown
Switch(config)#interface fastEthernet 0/18              //指定介面
Switch(config-if)#switchport mode access                //Port改成Access Mode
Switch(config-if)#switchport port-security                //啟用Port Security
Switch(config-if)#switchport port-security maximum 1  //設定最大的MAC數量
Switch(config-if)#switchport port-security mac-address sticky
Switch(config-if)#switchport port-security violation shutdown  //預設,處理err-disabled
Switch(config-if)#switchport port-security violation restrict          //合法MAC接回就會通
=================================================================
Switch(config-if)#do sh port-security                //檢查有哪些Port啟用Port-security
Switch(config-if)#do sh port-security address  //檢查有哪些Portsticky或手動輸入MAC Address
Switch(config-if)#do sh port-security interface fa 0/18 //檢查Fa0/18Port-security的詳細設定
Switch(config-if)#do sh int fa 0/18                   //檢查Fa0/18的介面狀態(注意err-disabled)
=======================range 多個Port設定=============================
Switch(config)#interface range fastEthernet 0/4 - 7 , fastEthernet 0/9 - 15
Switch(config-if-range)#switchport mode accesss      
=================================================================
Fa0/18接另一台PC,因為Fa0/18有啟用Port-security,並將之前自動學習到的MACSticky記錄,檢查
Fa0/18的介面狀態會出現err-disabled:下面為解決方法
Switch#sh int fa 0/18
FastEthernet0/18 is down, line protocol is down (err-disabled)
Switch#sh run | begin FastEthernet0/18
!
interface FastEthernet0/18
 switchport mode access
 switchport port-security
 switchport port-security mac-address sticky
 switchport port-security mac-address sticky 0020.E22D.9B05  //此行為出問題的MAC address
!
Switch#conf t
Switch(config)#int fa 0/18
Switch(config-if)#no switchport port-security mac-address sticky 0020.E22D.9B05
Switch(config-if)#do sh int fa 0/18
FastEthernet0/18 is down, line protocol is down (err-disabled)
Switch(config-if)#shutdown
Switch(config-if)#no shutdown
Switch#sh interfaces status    //檢查所有界面的狀態
8.停用網域名稱反查
Switch(config)#no ip domain-lookup
9.組態設定
SwitchIOSstartup-config複製到TFTP
Switch#sh flash
Switch#copy flash tftp
Switch#copy running-config startup-config                   //設定寫入NVRAM(組態檔)
Switch#copy startup-config tftp
=========================================================                    
Switch#erase startup-config                                         //刪除啟動組態檔
Switch#delete vlan.dat
Switch#reload
Switch#delete nvram                                                    //刪除啟動組態檔
10.CDP相關設定
=======================查詢鄰近設===========================
Switch#sh cdp neighbors  (Device ID =>ro)
Switch#sh cdp entry router
==================Switch的介面CDP功能關閉=====================
Switch(config)#int fa 0/5
Switch(config-if)#no cdp enable
=====================將設備dcp功能關閉========================
lab2(config)#no cdp run
=========================================================