Category Archives: Windows 7

3 ways to extract data from excel table

針對一個保險從業的佣金計算作出三個方案: 純用方程式和含數; 用vba; 運用pivot table. 純用方程式和含數會使用match, index, iferror, countifs,sumifs,也用上名稱name。(原来也有同事用上的if,small,row,false; 希望他在設計table時能用上data validation 的list去减少鍵入错誤啦!) 用vba 使用macro錄製 advanced filtering (wild card) 和copy range,加按鈕完成。這方式要存檔為xlxm,也要設定新的安全方案。 運用pivot table 彈性較大。最主要是設計和運用容易為初學者所接收。

Posted in Excel, Windows 7 | Comments Off

Shortcut to create VPN connection

1. Create VPN.pbk 2. Double click icon to set 3. Try China IP 61.152.255.31 4. Use flyVPN account to login tutorial from flyVPN

Posted in Windows 7, Windows 8 | Tagged | Comments Off

Windows Icon Refresh

In Command line ie4uinit.exe -ClearIconCache

Posted in Windows 7 | Comments Off

Missing Windows Desktop Icons

Message from answers.microsoft.com Rebuilding the Icon Cache Database 1. Close all folders that are currently open. 2. Start taskmgr.exe 3. Right-click Explorer.exe process and select End Process. 4. Select New Task (Run…) 5. CMD.exe, in command prompt windo, type the … Continue reading

Posted in Windows 7, Windows 8 | Comments Off

How to Open command Prompt from any folder in Windows 7

Simply hold down the Shift key and right-click a folder. The context menu will contain an entry “Open command window here”

Posted in Windows 7 | Comments Off

Cannot delete thumb.db in windows 7

Gpedit.msc Local Computer policy User Configuration Admin Templates Windows Components Windows Explorer “Turn off display of thumbnails” enable

Posted in Windows 7 | Comments Off

How to disable Open file security warning in Windows 7

Using gpedit.msc Goto Local Computer Policy User Configuration Administrative Templates Windows Components Attachment Manager Inclusion list for low file types add file type within In Registry HKCU\Sw\Ms\Wx\Cv\Pl\As “LowRiskFileTypes”

Posted in Windows 7 | Comments Off

Run Regedit as Administrator

In Windows 7, at start button, search regedit, right click the exe and choose “Run as administrator”

Posted in Windows 7 | Comments Off

Speed up your pc

Posted in Windows 7 | Comments Off

Windows 7 failed to login to a network folder

If you are sure you have the right user and password, check your registry for the LmCompatibilityLevel. source

Posted in Windows 7 | Comments Off