在Google地圖中匯入大量地點，直接在地圖上把所有地點標示出來！
一、匯入方式
1.先打開支援儲存成微軟.xlsx格式的試算表軟體，在第一列輸入標題，只能是「地名」、「地址」或「經緯度資訊」三者，例如阿正老師就輸入了「地名」及「地址」兩欄資料，如果地名不太會重複、或是不知道地址的話，也可只輸入一欄地名即可。
完成後儲存為 .xlsx格式，支援Unicode字元。
全文網址
https://pcrookie.com/?p=2026
2018年7月5日 星期四
2017年6月22日 星期四
google sheet 試算表排序 (multiple columns)
http://www.wikihow.com/Sort-by-Multiple-Columns-in-Google-Spreadsheets
Google Spreadsheets are an effective way to store and manage data, and have many of the capabilities of popular spreadsheet applications like Microsoft Excel. In addition, Google Spreadsheets make it easy to collaborate with others on the the same documents. Despite their power and flexibility, it's not always intuitive for Excel users to figure out how to do some basic tasks in Google Spreadsheets, such as sorting by multiple columns. Unlike Excel, you can only sort by a single column at a time; this limitation requires you to take a different approach to sorting if you want to organize by multiple columns. Read on to learn how.
Input your data in your spreadsheet.
Decide what order you'd like to sort your information. For the purposes of this example, assume we want to to have the people in the list grouped by city, then last name, then first name.
Sort by the least important, smallest or most narrow grouping in your sort order. In this case, that would be the column with first names. Click on "sort range" then choose if "A-Z" or "Z-A" and press "Sort"
Sort by the next grouping in your sort order. In this case, that would be the column with last names.
Continue sorting by increasingly larger or more important groups in your sort order until you have the list organized as you would like.
Google Spreadsheets are an effective way to store and manage data, and have many of the capabilities of popular spreadsheet applications like Microsoft Excel. In addition, Google Spreadsheets make it easy to collaborate with others on the the same documents. Despite their power and flexibility, it's not always intuitive for Excel users to figure out how to do some basic tasks in Google Spreadsheets, such as sorting by multiple columns. Unlike Excel, you can only sort by a single column at a time; this limitation requires you to take a different approach to sorting if you want to organize by multiple columns. Read on to learn how.
Input your data in your spreadsheet.
Decide what order you'd like to sort your information. For the purposes of this example, assume we want to to have the people in the list grouped by city, then last name, then first name.
Sort by the least important, smallest or most narrow grouping in your sort order. In this case, that would be the column with first names. Click on "sort range" then choose if "A-Z" or "Z-A" and press "Sort"
Sort by the next grouping in your sort order. In this case, that would be the column with last names.
Continue sorting by increasingly larger or more important groups in your sort order until you have the list organized as you would like.
2010年8月9日 星期一
igoogle倒數計時功能
http://www.labpixies.com/gadget_page.php?id=58&source=canvas_footer&footer_item=about_this_gadget&gadget=58
Countdown
igoogle 和 labpixies 已停止服務.
Countdown
igoogle 和 labpixies 已停止服務.
訂閱：
文章 (Atom)