Mail Merge

http://www.microsoft.com/vietnam/products/office/training/mail_merge_2a.aspx

1 ví dụ về Pivot Table

1 ví dụ khá rõ ràng, chi tiết về cách sử dụng Pivot Table

https://sites.google.com/site/excelwebsite/materials/1viduvepivottable/PivotTable.xls

SHORT-KEYS IN EXCEL

SHORT-KEYS IN EXCEL
Ctrl A	Select All		Ctrl -	Delete entire rows / columns
Ctrl F4	Close file		Ctrl Shift +	Insert entire row / column
Ctrl W	Close file		Shift F11	Insert worksheet
Ctrl F9	Minimize workbook		F12	Save as
Ctrl F10	Maximize workbook		Ctrl Shift F12	Print as
Ctrl F5	Restore workbook		Ctrl ;	Insert Today ()
Ctrl F7	Move workbook		Ctrl :	Insert Hour ()
Ctrl F8	Size		F11	Insert Chartsheet
Ctrl Spacebar	Select entire column		Shift F3	Function Wizard
Shift Spacebar	Select entire row		Ctrl Shift %	Convert to %
Alt =	AtutoSum		Ctrl Shift #	Convert to date
Ctrl Shift &	Outline / Borders		Ctrl Shift @	Convert to Time
Ctrl Shift -	Clear Borders		Ctrl Shift ~	Convert to General
F7	Spelling check		Ctrl Shift $	Convert to Money
Shift Delete	Delete permanently		Ctrl Shift !	Convert to comma style
Alt ‘	Display Style		Ctrl ~	Convert value to formula
Ctrl Shift F3	Create Name		Ctrl Shift P	Change font size
Ctrl F2	Show / Hide information		Ctrl Shift F	Change font style
Ctrl ‘	Copy from above cell		Ctrl Shift Arrows	Quick choose
F5 or Ctrl G	Go to		F8 then Arrows	Select area
Ctrl 1	Format Cells		F8 then Mouse	Select area
Ctrl 2/3/4/5	Bold/Italic/Underline/Strikeline		Ctrl F3	Define name
Ctrl 7	Show / Hide Standard Toolbar		F3	Paste name
Ctrl 9	Hide rows		Alt -	Show workbook control
Ctrl 0	Hide columns		Shift F2	Insert Notes
Ctrl Shift (	Unhide rows		Ctrl Tab	Move to other opened files
Ctrl Shift )	Unhide columns		Ctrl H	Replace
Shift F5	Back to current cell / Find		Atl Enter	Folder’s properties
F4 or Ctrl Y	Repeat		Ctrl Shift *	Chhoose current area
Ctrl D	Copy down		Ctrl R	Copy right
Atl ;	Choose visible area (not choose hidden rows / columns)		Ctrl F6	Move between opened worksheets
SHORT-KEYS IN WORD
Shift F3	Change UPPER & lower		Ctrl F2	Print Preview
Shift F5	Back to current pointer		Windows E	Open Explorer
F8 then Mouse	Select area		Windows R	Run
Alt Spacebar	Open master menu		Windows F	Find
Alt Esc	Similar to Atl Tab		Ctrl Alt S	Split pages
Ctrl D	Fonts		Ctrl Alt P	Layout
Ctrl Shift >	Increase font		Ctrl Alt O	Outline
Ctrl ]	Increase font		Ctrl Alt N	Normal
Ctrl Shift <	Decrease font		Ctrl =	Subscript
Ctrl [	Decrease font		Ctrl Shift +	Superscript
Ctrl Shift A	On/Off Capital letter		Ctrl Spacebar	Cancel format
Ctrl Shift W	Underline not blank		Shift F1	View font format
Ctrl Shift D	Double underline		Ctrl T	Hanging indent
Ctrl Shift H	Hide words		Ctrl M	Drop left
Ctrl Shift K	= Shift F3		Ctrl 1	Single sentence space
Ctrl Shift Q	Cange to Symbol font		Ctrl 2	Double sentence space
Ctrl Shift S	Style		Ctrl 5	Half sentence space
			Ctrl 0	Drop one sentence

Microsoft Excel 2010 – What’s new ?

Những điểm mới và cải tiến trong Excel 2010

more http://www.addictivetips.com/windows-tips/microsoft-office-excel-2010-whats-new/

Try Excel 2010 for free http://office.microsoft.com/en-us/try/try-office-2010-FX101868838.aspx