¦U¦ì¡J
è§Ë¤F¤@ÓExcel±Ð¾Çºô¯¸¡A¬Ý¬Ý§A̬O§_¦X¥Î¡AÁ¡C
http://sites.google.com/site/exceltkk2/tutorial-classification-3
¥H¤U¬O¤§«eªºÃD¥Ø¡J
Pivot Table ¼Ï¯Ã¤ÀªRªí
How to Create Simple Pivot Table - Oct 26, 2010
¦p¦ó»s§@°ò¥»ªº¼Ï¯Ã¤ÀªRªí - ¤G¹s¤@¹s¦~¤Q¤ë¤G¤Q¤»¤é
How to Sort in Pivot Table - Oct 26, 2010
¦p¦ó¦b¼Ï¯Ã¤ÀªRªí¤W±Æ§Ç - ¤G¹s¤@¹s¦~¤Q¤ë¤G¤Q¤»¤é
How to view related Data in a summarized Figure - Oct 26, 2010
¦p¦ó¦b¼Ï¯Ã¤ÀªRªíªº滙Á`¸Ì§ä¥X¬ÛÃöªº¼Æ¾Ú - ¤G¹s¤@¹s¦~¤Q¤ë¤G¤Q¤»¤é
How to Separate Report for Different Regions - Oct 26, 2010
¦p¦ó¦b¼Ï¯Ã¤ÀªRªí¸Ì¬l¤À¤À°Ï³øªí (¥u«ö¤@Ó«ö¶s) - ¤G¹s¤@¹s¦~¤Q¤ë¤G¤Q¤»¤é
How to count Number of records of a Figure in Pivot Table - Oct 26, 2010
¦p¦ó¦b¼Ï¯Ã¤ÀªRªí¸Ì²Îp¸Ó¤@Ó¶×Á`¸Ì¦³¦h¤ÖÓ°O¿ý - ¤G¹s¤@¹s¦~¤Q¤ë¤G¤Q¤»¤é
How to add percentage of total in Pivot Table - Oct 27, 2010
¦p¦ó¥i¥H¦b¼Ï¯Ã¤ÀªRªí¸Ì¥[¤W滙Á`¤Î¦Ê¤À¤ñ - ¤G¹s¤@¹s¦~¤Q¤ë¤G¤Q¤C¤é
How to Create Custom Layout - Oct 28, 2010
¦p¦ó¦Û³] ¼Ï¯Ã¤ÀªRªí ª©± - ¤G¹s¤@¹s¦~¤Q¤ë¤G¤Q¤K¤é
How to Create Dynaimc Data Source in Pivot Table 1 - Oct 29, 2010
¦p¦ó¦Û°Ê§ó·s¼Ï¯Ã¤ÀªRªí¼Æ¾Ú - ¤G¹s¤@¹s¦~¤Q¤ë¤G¤Q¤E¤é
How to Show and Hide Items in Pivot Table - Nov 03, 2010
¦p¦óÅã¥Ü¤ÎÁôÂüϯäÀªRªíªº¶µ¥Ø - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤G¤é
How to Group Fields in Pivot Table - Dec 16, 2010
¦p¦ó¦b¼Ï¯Ã¤ÀªRªí¤¤¸s²Õ - ¤G¹s¤@¹s¦~¤Q¤G¤ë¤Q¤»¤é
Chart & Dashboard ¹Ïªí ¤Î ¸ê°Tªí
How to Create Dynamic Chart 1 - 1 - Oct 24, 2010
¦p¦ó»s§@¼u©ÊÅܰʹϪí 1 - 1 - ¤G¹s¤@¹s¦~¤Q¤ë¤G¤Q¥|¤é
How to Create Dynamic Chart 1 - 2 - Oct 24, 2010
¦p¦ó»s§@¼u©ÊÅܰʹϪí 1 - 2 - ¤G¹s¤@¹s¦~¤Q¤ë¤G¤Q¥|¤é
How to Create Simple Project Plan with Conditional Formatting - Oct 23, 2010
¦p¦ó¥H®æ¦¡±ø¥ó¤Æ¥\¯à»s§@²³æªº¶µ¥Øp¹º - ¤G¹s¤@¹s¦~¤Q¤ë¤G¤Q¤T¤é
How to make an album with Excel 1 - Nov 07, 2010
¦p¦ó¥ÎExcel »s§@¬Ûï - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤C¤é
How to Copy picture to point of chart - Nov 07, 2010
¦p¦ó½Æ»s¹Ï¤ù¨ì´Î«¬¹Ï¤W - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤C¤é
How to use Scroll bar with if formula - Nov 12, 2010
¦p¦ó²V¦X¨Ï¥Î±²¶b ¤Î if ¤½¦¡ - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤Q¤G¤é
How to use xy(Scatter) Chart to create moving pig - Nov 17, 2010
¦p¦ó¥Î xy(¤À´²)¹Ïªí»s§@¥i¥H²¾°Êªº¹Ï¤ù
- ¤G¹s¤@¹s¦~¤Q¤@¤ë¤Q¤C¤é
How to Create Project Plan with Bar Chart (Gantt Chart) - Nov 18, 2010
¦p¦ó¥Î´Î«¬¹Ï»s§@¶µ¥Ø®É¶¡ªí (¥Ì¯S¹Ï) - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤Q¤K¤é
How to make an album with Excel 2 - Nov 22, 2010
¦p¦ó¥Î Excel »s§@¬Ûï 2 - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤G¤Q¤T¤é
Compare Same Month expenses Figure in Different Years - Cluster Stack Chart
Nov 26, 2010
¦p¦ó¥Î¹Ïªí¤ñ¸û¤£¦P¦~«×¦P¤@Ó¤ë¥÷ªº¸g¶O¶µ¥Ø - ¸s²Õ¦¡°ïÅ|¹Ïªí
¤G¹s¤@¹s¦~¤Q¤@¤ë¤G¤Q¤»¤é
Copy & Paste Function ½Æ»s ¤Î ¶K¤W¥\¯à
How to Transpose Data - Oct 23, 2010
¦p¦ó¶i¦æ¼Æ¾ÚË´« - ¤G¹s¤@¹s¦~¤Q¤ë¤G¤Q¤T¤é
How to Copy multiple cells - Quick Tip - Dec 14, 2010
¦p¦ó¤@¦¸Ó½Æ»s¦hÓÀx¦s®æ - ¤G¹s¤@¹s¦~¤Q¤G¤ë¤Q¥|¤é
Name Range ¬°Àx¦s®æ½d³ò©w¦W
How to Create Dynamic Range - Example 1 - Oct 28, 2010
¦p¦ó»s§@½d³ò¦Û°Ê§ó·s¦WºÙ - ½d¨Ò1 ¤G¹s¤@¹s¦~¤Q¤ë¤G¤Q¤K¤é
How to Give a name to a range - Dec 06, 2010
¦p¦ó¬°¤@ÓÀx¦s®æ½d³ò©w¦W - ¤G¹s¤@¹s¦~¤Q¤G¤ë¤»¤é
Conditional Formatting ±ø¥ó¤Æ®æ¦¡
Change the Color of a text if meet criteria - Oct 29, 2010
»P±ø¥ó²Å¦X´NÂàÅÜ顔¦â - ¤G¹s¤@¹s¦~¤Q¤ë¤G¤Q¤E¤é
Change other cells color if a cell value change - Oct 29, 2010
ÂàÅܤ@ÓÀx¦s®æ¦ìªºÈ¨Ï¥t¤@¨ÇÀx¦s®æªºÃC¦â§ïÅÜ - ¤G¹s¤@¹s¦~¤Q¤ë¤G¤Q¤E¤é
How to Create Simple Project Plan with Conditional Formatting - Oct 23, 2010
¦p¦ó¥H±ø¥ó¤Æ®æ¦¡¥\¯à»s§@²³æªº¶µ¥Øp¹º - ¤G¹s¤@¹s¦~¤Q¤ë¤G¤Q¤T¤é
Introduction of VBA VBA ²¤¶
What should do before writing VBA -Nov 23, 2010
¦b¼g VBA ¥¨¶°¤§«en°µªº¨Æ - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤G¤Q¤T¤é
What is an add-in and How to add it to Excel -Nov 23, 2010
¬Æ»ò¬O¼W¯q¶° ¤Î¦p¦ó§â¥¦¥[¤J¦b Excel ¤¤ - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤G¤Q¤T¤é
VBA Syntax - on error resume next - Oct 29, 2010
VBA »yªk - on error resume next - ¤G¹s¤@¹s¦~¤Q¤ë¤G¤Q¤E¤é
VBA Syntax - Format - Oct 29, 2010
VBA »yªk - Format - ¤G¹s¤@¹s¦~¤Q¤ë¤G¤Q¤E¤é
How to use Excel to read Stocks trend of Hong Kong Stock market - VBA Syntax - Worksheet Change - Nov 04, 2010
¦p¦ó¥ÎExcel ¬ÝªÑ²¼°T®§ - VBA »yªk - worksheet change - ¤G¹s¤@¹s¦~¤Q¤@¤ë¥|¤é
Useful tools for creating macro VBA - Nov 05, 2010
»s§@ VBA ®É¥²¥Îªº¤u¨ã - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤¤é
How to Use Record Macro Function - Nov 06, 2010
¦p¦ó¨Ï¥Î¿ý»s¥¨¶°¥\¯à - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤»¤é
How to Create First VBA - VBA Syntax - Msgbox - Nov 08, 2010
¦p¦ó»s§@²Ä¤@Ó VBA µ{¦¡ - VBA »yªk - Msgbox - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤K¤é
VBA Syntax - For ... Next - Nov 09, 2010
VBA »yªk - For ... Next - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤E¤é
VBA Syntax - If .. End if - Nov 10, 2010
VBA »yªk - If .. End if - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤Q¤é
How to use Excel to Compare Stocks - VBA Syntax - Mod - Nov 13, 2010
¦p¦ó¨Ï¥ÎExcel ¤ñ¸û¤£¦PªºªÑ²¼¨«¶Õ - VBA »yªk Mod - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤Q¤T¤é
VBA Syntax - Select Range Change cell color - Nov 14, 2010
VBA »yªk - ¿ï¨úÀx¦s®æ½d³ò¨Ã¥[¤WÃC¦â - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤Q¥|¤é
Speak Excel - VBA Structure - Main and Sub Program - Nov 21, 2010
·|»¡¸Üªº Excel - VBA µ²ºc - ¥D ¤Î °Æµ{¦¡ - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤G¤Q¤@¤é
VBA Syntax - Select Case ¡K End Select - Dec 01, 2010
VBA »yªk- Select Case ¡K End Select - ¤G¹s¤@¹s¦~¤Q¤G¤ë¤@¤é
How to Create your own Excel Function ¡V VBA Syntax Function - Dec 04, 2010
¦p¦ó¦Û»s Excel ¤½¦¡ ¡V VBA »yªk Function - ¤G¹s¤@¹s¦~¤Q¤G¤ë¥|¤é
How to create a form for input value -VBA Syntax - Inputbox - Dec 08, 2010
¦p¦ó¥Î VBA »yªk»s§@¤@Ó¿é¤J¤å¦rªºµøµ¡ - ¤G¹s¤@¹s¦~¤Q¤G¤ë¤K¤é
Formula ¤½¦¡
Step on Learning Excel Formula - Oct 29, 2010
¾Ç²ß Excel ¤½¦¡ªº¨ä¤¤¤@Ó¤èªk - ¤G¹s¤@¹s¦~¤Q¤ë¤G¤Q¤E¤é
How to use vlookup to lookup different sheet data - Nov 02, 2010
¦p¦ó¨Ï¥Î Vlookup ¤½¦¡§ä¥X¤£¦P¶±¬ÛÃö¹ïÀ³¤å¦r - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤G¤é
How to clear the error symbol in the result of vlookup - Nov 02, 2010
¦p¦ó§â Vlookup #N/A ²Å¸¹µ²ªG²M°£ - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤G¤é
How to Find the Second and Third match records with Vlookup - Nov 11, 2010
¦p¦ó¥Î Vlookup §ä´M²Ä¤GÓ ¤Î ²Ä¤TӬ۹諸¬ÛÃö¸ê®Æ - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤Q¤@¤é
How to use vlookup to identify which group a value in - Nov 15, 2010
¦p¦ó¥Î vlookup §ä¥X¤@ÓȪº©ÒÄݸs²Õ - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤Q¤¤é
How to Vlookup Part of Data Equal - Nov 18, 2010
¦p¦ó¥ÎVlookup §ä¥X³¡¤À¬Û¦Pªº¸ê®Æ - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤Q¤K¤é
How to use Excel to find out the Effect of Earthquake with vlookup - Nov 20, 2010
¦p¦ó¥ÎExcel vlookup¥\¯à§ä¥X¤£¦P¦a¾_¯Å¼Æ©Ò±a¨Óªº®ÄªG - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤G¤Q¤é
How to lookup Horizontal Data - Hlookup - Nov 29, 2010
¦p¦ó´M§ä¤ô¥¼Æ¾Ú - Hlookup - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤G¤Q¤E¤é
How to sum up multiple sheets data with sum formula - Dec 05, 2010
¦p¦ó±N¤£¦P¶±ªº¼Æ¾Ú¥Î sum ¤½¦¡¤@¦¸Ó¥[Á` - ¤G¹s¤@¹s¦~¤Q¤G¤ë¤¤é
Camera Function ¼v¹³§ë¼v¥\¯à
Usage of Camera Function in Excel - Print different sheets in one page - Oct 30, 2010
¦p¦ó¨Ï¥Î Excel ªº¼v¹³§ë¼v¥\¯à - ©ó¦P¤@Ó¶±¤W¨Ò¦L¦h¶ªº¸ê®Æ
¤G¹s¤@¹s¦~¤Q¤ë¤T¤Q¤é
Filter Function ¿z¿ï¥\¯à
How to use Autofilter to filter Horizontal data - Nov 16, 2010
¦p¦ó¥Î¦Û°Ê¿z¿ï¥\¯à¿z¿ï¾î¦V¼Æ¾Ú - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤Q¤»¤é
Cannot see data in autofilter drop down box How to solve - Nov 23, 2010
¦b¦Û°Ê¿z¿ïªº¤U©Ô¦¡²M³æ¤¤¬Ý¤£¨ì¥ô¦ó¼Æ¾Ú¡A«ç»ò¿ì¡H - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤G¤Q¤T¤é
How to filter more than 3 Criteria - advanced Filter - Nov 25, 2010
¦p¦ó¥i¥H°õ¦æ¦hÓ3Ó±ø¥óªº¿z¿ï - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤G¤Q¤¤é
Quick Tips ²³æ§Þ¥©
How to Copy Range as picture ¡V First Quick Tips - Dec 07, 2010
¦p¦ó±N½Æ»sÀx¦s®æ½d³òÅܦ¨¹Ï¤ù - ¤G¹s¤@¹s¦~¤Q¤G¤ë¤C¤é
Tips on Fill Down Same value data ¡V Quick Tip - Dec 11, 2010
¦V¤U¶ñ¤W¬Û¦P¼Æ¾Úªº¤èªk - ¤G¹s¤@¹s¦~¤Q¤G¤ë¤Q¤@¤é
Forget Password ¡V Crack Excel Worksheet Protection Password - Dec 12, 2010
§Ñ°O±K½X ¡V ¯}¸Ñ Excel ¤u§@ªí±K½X - ¤G¹s¤@¹s¦~¤Q¤G¤ë¤Q¤G¤é
How to Copy multiple cells - Quick Tip - Dec 14, 2010
¦p¦ó¤@¦¸Ó½Æ»s¦hÓÀx¦s®æ - ¤G¹s¤@¹s¦~¤Q¤G¤ë¤Q¥|¤é
How to Delete thousands of blank rows in data - Quick Tip - Dec 17, 2010
¦p¦ó§R°£¼Æ¾Ú¤¤¤j¶qªÅ¥Õªº¦C - ¤G¹s¤@¹s¦~¤Q¤G¤ë¤Q¤C¤é
Other ¨ä¥L
Dilbert Comic about Spreadsheet - Oct 23, 2010
»P Excel ¬ÛÃöªº Dilbert º©µe - ¤G¹s¤@¹s¦~¤Q¤ë¤G¤Q¤T¤é
How to Find this web page in Google - Oct 30, 2010
¦p¦ó¦b Google ¤W§ä¨ì¥»ºô¯¸ - ¤G¹s¤@¹s¦~¤Q¤ë¤T¤Q¤é
Excel ShortCut Key - Nov 09, 2010
Excel §Ö±¶Áä - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤E¤é
How to Convert Excel to PDF - Nov 10, 2010
¦p¦ó±N Excel ÀÉÂàÅܬ° PDF ÀÉ - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤Q¤é
Password Configuration in Excel - 7 tips - Nov 28, 2010
Excel ±K½X³]©wªº 7 Ó¦ì¸m - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤G¤Q¤K¤é
How to Sum up same group of item with subtotal - Nov 29, 2010
¦p¦ó¥Î¤pp¥\¯à±N¦UÓ¶µ¥Ø¥[Á` - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤G¤Q¤E¤é
Use Excel to Draw gundam - Group and Upgroup Technique - Nov 30, 2010
¥ÎExcel µe°ª¹F ¡V ¸s²Õ ¤Î¨ú®ø¸s²Õ§Þ³N - ¤G¹s¤@¹s¦~¤Q¤@¤ë¤T¤Q¤é
How to Extract Excel File Details from a folder to a List ¡V JMT Utilities ¡V Show Folder Details - Dec 02, 2010
¦p¦ó§â¯S©w¸ê®Æ§¨ªº Excel ÀɥΦCªí§Î¦¡Åã¥Ü - JMT Utilities ¡V Show Folder Details
¤G¹s¤@¹s¦~¤Q¤G¤ë¤G¤é
How to use Excel in PowerPoint - Dec 03, 10
¦p¦ó¦b PowerPoint ¤¤¨Ï¥Î Excel - ¤G¹s¤@¹s¦~¤Q¤G¤ë¤T¤é
How deep you know Excel? ¡V The game Snake - Dec 09, 10
§A¹ï Excel »{ÃѦ³¦h²`¤J¡H - ³g¹³D¹CÀ¸ - ¤G¹s¤@¹s¦~¤Q¤G¤ë¤E¤é
Main difference on how to Protect worksheet and word document - Dec 15, 10
«OÅ@ Excel ¤u§@ªí ¤Î Word ªº¤å¥ó»s§@®É¥Dnªº¤À§O - ¤G¹s¤@¹s¦~¤Q¤G¤ë¤Q¤¤é
Learn Excel on Creation ±q»s§@¤¤¾Ç²ß Excel
Learn Excel by Creating a Sale Ticket System - Dec 10, 10
±q»s§@°â²¼¨t²Î¤¤¾Ç²ß Excel - ¤G¹s¤@¹s¦~¤Q¤G¤ë¤Q¤é
How to create a simple Calendar Template with Excel - Dec 13, 10
¦p¦ó¥Î Excel »s§@²³æ¤é¾ä½d¥» - ¤G¹s¤@¹s¦~¤Q¤G¤ë¤Q¤T¤é