日文檢定，新舊制 比較 差異

官網
https://www.lttc.ntu.edu.tw/JLPT.htm

pdf下載

How to Add PMP to Your LinkedIn

http://work.chron.com/add-pmp-linkedin-9449.html

Adding Suffix

1. Log in to your LinkedIn page and mouse over the "Profile" link.

2. Select "Edit Profile" from the links that pop up.

3. Click the "Edit" button beside your name.

4. Enter "PMP" in the "Last Name" field, after your last name, and click "save changes."

Adding Certification

1. Log in to your LinkedIn page and mouse over the "Profile" link.

2. Select "Edit Profile" from the links that pop up.

3. Scroll down to where it says "Certifications" and click "Add a certification."

4. Enter "Project Management Professional" in the "Certification Name" field and "Project Management Institute" in the "Certification Authority" field. Select the dates for which your certification is valid. Then click "Add Certification."

Excel VBA 刪除空白行的程式

*情境：有個Excel檔，資料表如下

資料1
空白行1
資料2
空白行2
...
...

*撰寫VBA以自動刪除：

Sub delLoop()
Dim i
For i = 1 To 20 Step 1
Rows(i).EntireRow.Delete
Next
End Sub

寫完按F5選Sheet執行就可以

執行前請先複製一張新表，

用程式自動刪的資料是回不去的~

By Sivitry.