tong quat ve excel

1 - ?ޮh nghܡ

+> Ch??ng tr׮h b?ng tݮh l? h֠th讧 ch??ng tr׮h m? phᮧ m鴠b?ng c?ng t?c c񡠫ՠto?n vi?n tr?n m?n h׮h v? cho phа ng?ꩠdﮧ nh󮧠c?c c?ng th? v?o ?Ӡth?֮ c?c phа tݮh ?詠v�c?c d?ֵ nh׮ thʹ.

+> Microsoft Excel l? phǮ mҭ b?ng tݮh ?i֮ t??u biӵ do Microsoft ph?t triӮ, ??y l? phǮ mҭ chuy?n dﮧ cho c?ng t?c kՠto?n, v?n ph߮g ??triӮ khai tr?n m?i tr?ꮧ Windows.

+> B?ng tݮh

Trong c?c ch??ng tr׮h b?ng tݮh, ??y l? m鴠ma trˮ hai chiҵ g孠c?c h?ng v? c?c c鴠m? ng?ꩠdﮧ sϠnh˰ c?c ?ǵ ?Ҭ c?c con s謠v? c?c c?ng th?o ?㮍

2 - Tݮh n?ng v? ??c񡠥xcel

- Th?֮ ??nhiҵ phа tݮh t?n gi?n ?ծ ph?p.

- T栣h? l?u tr??ng tin d?�d?ng b?ng nh? b?ng l??ng, b?ng kՠto?n, b?ng thanh to?n, b?ng th讧 k?, b?ng d?n...

- Thao t?c tr?n b?ng tݮh c㠴hӠt?o ra c?c b?o c?o t殧 hhoƣ ph?n tݣh c㠫̭ theo c?c biӵ ?嬠h׮h vϠminh ho?...

3 - ?ƣ ?iӭ

- HiӮ thޠvﮧ l?m vi֣ d?�d?ng m?ng 2 chiҵ.

- T?g c˰ nh˴ khi d?ֵ ngu宠bޠthay ?橮

- ChuyӮ ?橠dԠd?ng t? liֵ sang h׮h vϮ

II - Gi�thiֵ m?n h׮h microsoft excel

1 - Kh멠?鮧 Excel

Th?ng th?ꮧ sau khi c?i ?ƴ b頣h??ng tr׮h Office 2000, shortcut c񡠍icrosoft Excel ???ƴ 렐rograms trong Start menu. C߮ 렴r?n ?ܡ ch??ng tr׮h n?y ???ƴ trong C:\Program Files\Microsoft Office\Office. Vנv˹ ?Ӡkh멠?鮧 Excel c㠴hӠth?֮ b?ng m鴠trong 2 c?ch sau :

C?ch 1 : Kݣh chu鴠v?o Start menu ch䮠Programs r婠ch䮠Microsoft Excel.

C?ch 2 (dﮧ khi kh?ng c㠢iӵ t? c񡠅xcel) : Kݣh chu鴠v?o Start menu ch䮠Run... r婠nh˰ d߮g l֮h :

"C:\Program Files\Microsoft Office\Office\ EXCEL.EXE"

2 - M?n h׮h Excel

VҠc? b?n c?栅xcel t??ng t? c?栣񡠰hǮ mҭ so?n th?o Microsoft Word, vנv˹ 렮?y chؠtr׮h b?y chi tiմ th?m c?c th?nh phǮ ?ƣ tr?ng nh? :

<+> Formula Bar (thanh c?ng th? hiӮ thޠto? ?頫 hi֮ h?nh, n󴠨u?p (Cancel), n󴠮h˰ (Enter), n󴠳o?n th?o c?ng th? n驠dung d?ֵ c񡠫 hi֮ h?nh.

<+> Workbook Window l? c?栣h?i dung tְ. T?n tְ (workbook) hi֮ tr?n thanh ti?u ?Ҡc?栶�phǮ m렲鮧 ?ޮh s?n l? XLS. T?n tְ Workbook mƣ nhi?n l? Book# ( # l? s蠴h?t??ng ?�nh?lǮ m렴ְ ). C?c th?nh phǮ c񡠗orkbook Window l? :

- ??ꮧ viҮ ngang (Column Border) ghi k? c鴠t??i sang ph?i theo ch?i A, B, C,..., Z, AA, AB,... , ZZ. C鴠(Column) l? m鴠t˰ hnh?? theo chiҵ d䣮 ?頲鮧 ngǭ ?ޮh l? 8 k?c㠴hӠthay ?橠gi? trޠn?y t??ծ 255). C㠴殧 c鮧 256 c鴮

- ??ꮧ viҮ d䣠(Row Border) ghi s蠴h?d߮g t??n xu讧 d?� D߮g (Row) l? m鴠t˰ hnh?? theo chiҵ ngang. Chiҵ cao mƣ nhi?n l? 12.75 chʭ ?iӭ (c㠴hӠthay ?橠gi? trޠn?y t??ծ 409). C㠴殧 c鮧 16384 d߮g.

- ? (Cell) l? giao c񡠭鴠d߮g v�m鴠c鴮 ?ޡ chؠc񡠭鴠? x?c ?ޮh b?ng t?n c鴠v? t?n h?ng. Vݠd?B6 l? ?ޡ chؠc񡠫 n?m tr?n c鴠B, h?ng th?

? hi֮ h?nh (Select cell) l? ? c㠫hung viҮ quanh.

- B?ng tݮh (Sheet) l? m鴠b?ng g孠c㠲56 c鴯16384 h?ng h׮h th?nh tr?n 4 triֵ ? d?ֵ. T?n b?ng tݮh mƣ nhi?n l? Sheet# (# l? s蠴h?. Theo chՠ?頮gǭ ?ޮh, m鴠tְ Workbook c㠱6 Sheet, ??liִ k? t?eet1 ?ծ Sheet16 (c㠴hӠn?ng gi? trޠn?y l?n ?ծ 255). Tr?n m?n h׮h Microsoft Excel ?ang ch䮠b?ng tݮh Sheet1 c񡠴ְ Book1.