Tài liệu học và ôn MOS Excel 2010

["Microsoft\u00ae Core Skills Excel 2010 \u0110\u1ecbnh d\u1ea1ng Shapes \u2022 Visual Style \u2013 Ph\u00e1c th\u1ea3o \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc v\u00e0 s\u1ef1 k\u1ebft h\u1ee3p \u0111\u1ea7y m\u00e0u s\u1eafc \u00a9 IIG Vietnam. 10","Microsoft\u00ae Core Skills Excel 2010 11 S\u1eed d\u1ee5ng WordArt \u2022 Hi\u1ec3n th\u1ecb c\u00e1c k\u00fd t\u1ef1 v\u0103n b\u1ea3n trong nhi\u1ec1u c\u00e1ch t\u01b0\u1edfng t\u01b0\u1ee3ng \u2022 Ch\u1ecdn t\u1eeb 30 Quick Styles ban \u0111\u1ea7u \u2022 C\u00f3 th\u1ec3 \u00e1p d\u1ee5ng nhi\u1ec1u hi\u1ec7u \u1ee9ng \u2022 \u0110\u1ec3 ch\u00e8n WordArt, tr\u00ean tab Insert, trong nh\u00f3m Text, b\u1ea5m v\u00e0o WordArt \u2022 Sau khi t\u1ea1o ra, Drawing Tools ribbon c\u00f3 s\u1eb5n \u0111\u1ec3 thay \u0111\u1ed5i shape \u00a9 IIG Vietnam.","Microsoft\u00ae Core Skills Excel 2010 Ch\u00e8n Pictures v\u00e0 Clip Art 12 \u2022 Clip Art \u2013 S\u1ef1 \u0111a d\u1ea1ng c\u1ee7a c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng clip art c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c nh\u1eadp t\u1eeb \u0111\u0129a CD Office 2010, \u0111\u00e3 c\u00f3 s\u1eb5n tr\u00ean h\u1ec7 th\u1ed1ng, ho\u1eb7c t\u1ea3i v\u1ec1 t\u1eeb Internet \u2013 Tr\u00ean tab Insert, trong nh\u00f3m Illustrations, k\u00edch Clip Art \u2013 S\u1eed d\u1ee5ng task pane Clip Art \u0111\u1ec3 t\u00ecm ki\u1ebfm h\u00ecnh \u1ea3nh \u2022 Pictures (h\u00ecnh \u1ea3nh ch\u1ee5p) \u2013 Tr\u00ean tab Insert trong nh\u00f3m Illustrations, k\u00edch Picture \u00a9 IIG Vietnam.","Microsoft\u00ae Core Skills Excel 2010 S\u1eed d\u1ee5ng Image Editor \u2022 C\u00f9ng m\u1ed9t Picture Tools ribbon \u0111\u1ec3 thay \u0111\u1ed5i h\u00ecnh \u1ea3nh v\u00e0 clip art \u2013 M\u1ed9t s\u1ed1 n\u00fat \u0111\u01b0\u1ee3c chuy\u1ec3n sang m\u00e0u x\u00e1m cho clip art: Remove Background v\u00e0 Artistic Effects \u00a9 IIG Vietnam. 13","Microsoft\u00ae Core Skills Excel 2010 Ch\u00e8n Screenshots \u2022 \u0110\u1ec3 ch\u00e8n h\u00ecnh ch\u1ee5p m\u00e0n h\u00ecnh (screenshot) v\u00e0o b\u1ea3ng t\u00ednh, tr\u00ean tab Insert, trong nh\u00f3m Illustrations, k\u00edch Screenshot \u2013 S\u1eed d\u1ee5ng bi\u1ec3u t\u01b0\u1ee3ng thu nh\u1ecf trong tr\u00ecnh \u0111\u01a1n th\u1ea3 xu\u1ed1ng (drop down menu), ho\u1eb7c \u2013 nh\u1ea5p v\u00e0o Screen Clipping \u0111\u1ec3 ch\u1ee5p khu v\u1ef1c h\u00ecnh ch\u1eef nh\u1eadt tr\u00ean m\u00e0n h\u00ecnh c\u1ee7a b\u1ea1n \u00a9 IIG Vietnam. 14","Microsoft\u00ae Core Skills Excel 2010 Thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc (Resizing), t\u00e1i \u0111\u1ecbnh h\u00ecnh (Reshaping), v\u00e0 m\u1edf r\u1ed9ng (Scaling) \u0111\u1ed1i t\u01b0\u1ee3ng \u2022 T\u1ef7 l\u1ec7 khung h\u00ecnh (Aspect ratio) \u2013 kh\u00f3a t\u1ef7 l\u1ec7 b\u1ea5t c\u1ee9 khi n\u00e0o \u0111\u1ed1i t\u01b0\u1ee3ng \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n l\u1edbn h\u01a1n ho\u1eb7c nh\u1ecf h\u01a1n \u2013 c\u00f3 th\u1ec3 t\u1ea1m th\u1eddi kh\u00f3a v\u1ecb tr\u00ed v\u00e0 t\u1ef7 l\u1ec7 b\u1eb1ng chu\u1ed9t: \u2022 ph\u00edm Ctrl kh\u00f3a trung t\u00e2m c\u1ee7a \u0111\u1ed1i t\u01b0\u1ee3ng trong khi thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc v\u00e0 h\u00ecnh d\u1ea1ng \u2022 ph\u00edm Shift kh\u00f3a t\u1ec9 l\u1ec7 khung h\u00ecnh c\u1ee7a \u0111\u1ed1i t\u01b0\u1ee3ng trong khi thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc \u2022 Ctrl + Shift kh\u00f3a c\u1ea3 v\u1ecb tr\u00ed v\u00e0 t\u1ef7 l\u1ec7 khung h\u00ecnh c\u1ee7a \u0111\u1ed1i t\u01b0\u1ee3ng \u2022 \u0110i\u1ec1u ch\u1ec9nh handle Adjustment Handle \u2013 k\u00e9o \u0111\u1ec3 thay \u0111\u1ed5i m\u1ed9t ph\u1ea7n h\u00ecnh d\u1ea1ng c\u1ee7a \u0111\u1ed1i t\u01b0\u1ee3ng \u2013 kh\u00f4ng thay \u0111\u1ed5i h\u00ecnh d\u1ea1ng c\u1ee7a ph\u1ea7n c\u00f2n l\u1ea1i c\u1ee7a \u0111\u1ed1i t\u01b0\u1ee3ng \u2022 Size v\u00e0 H\u1ed9p tho\u1ea1i Properties \u2013\u00a9 IIG Vietnam. thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc v\u00e0 h\u00ecnh d\u1ea1ng c\u1ee7a \u0111\u1ed1i t\u01b0\u1ee3ng 15","Microsoft\u00ae Core Skills Excel 2010 Xoay \u0111\u1ed1i t\u01b0\u1ee3ng \u2022 \u0110\u1ec3 xoay \u0111\u1ed1i t\u01b0\u1ee3ng \u0111\u01b0\u1ee3c ch\u1ecdn: \u2013 K\u00e9o handle m\u00e0u xanh l\u00e1 c\u00e2y theo h\u01b0\u1edbng g\u00f3c quay, ho\u1eb7c \u2013 b\u00ean d\u01b0\u1edbi Drawing Tools, tr\u00ean tab Format, trong nh\u00f3m Arrange, b\u1ea5m Rotate, ho\u1eb7c \u2013 b\u00ean d\u01b0\u1edbi Drawing Tools, tr\u00ean tab Format, trong nh\u00f3m Shape Styles, nh\u1ea5p Dialog Box Launcher, nh\u1ea5p v\u00e0o 3-D Rotation, ho\u1eb7c \u2013 k\u00edch chu\u1ed9t ph\u1ea3i v\u00e0o \u0111\u1ed1i t\u01b0\u1ee3ng, nh\u1ea5p v\u00e0o Format Shape, ch\u1ecdn 3-D Rotation, ho\u1eb7c \u2013 b\u00ean d\u01b0\u1edbi Drawing Tools, tr\u00ean tab Format, trong nh\u00f3m Size, nh\u1ea5p v\u00e0o Dialog Box launcher, nh\u1eadp g\u00f3c xoay trong Rotation, ho\u1eb7c \u2013 k\u00edch chu\u1ed9t ph\u1ea3i v\u00e0o \u0111\u1ed1i t\u01b0\u1ee3ng, nh\u1ea5p v\u00e0o Size and Properties, nh\u1eadp g\u00f3c xoay trong Rotation \u2022 Handle\u00a9 IIG Vietnam. xoay m\u00e0u xanh l\u00e1 c\u00e2y kh\u00e1c h\u01a1n l\u00e0 s\u1eed d\u1ee5ng 3-D Rotation 16","Microsoft\u00ae Core Skills Excel 2010 T\u1ea1o \u0111\u1ed3 h\u1ecda SmartArt \u2022 T\u1eadp c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng d\u1ec5 d\u00e0ng s\u1eed d\u1ee5ng \u0111\u1ec3 truy\u1ec1n \u0111\u1ea1t \u00fd t\u01b0\u1edfng \u2022 Trong ch\u1ebf \u0111\u1ed9 ch\u1ec9nh s\u1eeda, s\u1eed d\u1ee5ng Text pane \u0111\u1ec3 nh\u1eadp v\u0103n b\u1ea3n \u2013 m\u1ed7i \u0111\u1ea7u d\u00f2ng l\u00e0 m\u1ed7i h\u1ed9p v\u0103n b\u1ea3n trong \u0111\u1ed3 h\u1ecda \u2013 c\u00e1c h\u1ed9p v\u0103n b\u1ea3n s\u1eafp x\u1ebfp d\u1ef1a v\u00e0o lo\u1ea1i SmartArt \u2013 c\u00e1c h\u1ed9p v\u0103n b\u1ea3n thay \u0111\u1ed5i k\u00edch c\u1ee1 \u0111\u1ec3 duy tr\u00ec h\u00ecnh d\u1ea1ng \u0111\u1ed1i x\u1ee9ng \u2022 Gi\u1ea3m c\u1ea5p ho\u1eb7c t\u0103ng c\u1ea5p v\u0103n b\u1ea3n \u0111\u1ec3 t\u1ed5 ch\u1ee9c c\u00e1c \u00fd t\u01b0\u1edfng t\u01b0\u01a1ng t\u1ef1 \u00a9 IIG Vietnam. 17","Microsoft\u00ae Core Skills Excel 2010 T\u1ea1o \u0111\u1ed3 h\u1ecda SmartArt \u2022 Kh\u00f4ng th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u1ec3 tham chi\u1ebfu d\u1eef li\u1ec7u \u00f4 trong \u0111\u1ed3 h\u1ecda SmartArt \u2022 Tr\u00ean tab Insert, trong nh\u00f3m Illustrations, ch\u1ecdn SmartArt \u2022 Nhi\u1ec1u lo\u1ea1i kh\u00e1c nhau c\u1ee7a \u0111\u1ed3 h\u1ecda SmartArt \u0111\u1ec3 l\u1ef1a ch\u1ecdn \u00a9 IIG Vietnam. 18","Microsoft\u00ae Core Skills Excel 2010 Microsoft\u00ae Office Excel 2010 B\u00e0i 8: Ph\u00e2n t\u00edch, t\u1ed5 ch\u1ee9c v\u00e0 chia s\u1ebb Workbooks","Microsoft\u00ae Core Skills Excel 2010 M\u1ee5c ti\u00eau \u2022 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u \u2022 t\u1ea1o, ch\u1ec9nh s\u1eeda v\u00e0 x\u00f3a c\u00e1c si\u00eau li\u00ean k\u1ebft \u2022 s\u1eed d\u1ee5ng th\u00f4ng tin AutoFilter \u0111\u1ec3 t\u00ecm d\u1eef li\u1ec7u \u2022 t\u1ea1o v\u00e0 x\u00f3a c\u00e1c nh\u1eadn x\u00e9t c\u1ee5 th\u1ec3 \u2022 s\u1eed d\u1ee5ng Office Backstage \u2022 t\u1ea1o, ch\u1ec9nh s\u1eeda, v\u00e0 x\u00f3a d\u00e3y \u0111\u1ec3 chia s\u1ebb b\u1ea3ng t\u00ednh v\u1edbi nh\u1eefng ng\u01b0\u1eddi d\u00f9ng kh\u00e1c t\u00ean (range names) \u00a9 IIG Vietnam. 2","Microsoft\u00ae Core Skills Excel 2010 S\u1eafp x\u1ebfp d\u1eef li\u1ec7u Single-Level \u2022 C\u00f3 th\u1ec3 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u tr\u00ecnh t\u1ef1 t\u0103ng d\u1ea7n ho\u1eb7c gi\u1ea3m d\u1ea7n \u2022 S\u1eed d\u1ee5ng My data has header \u0111\u1ec3 ng\u0103n ch\u1eb7n c\u00e1c d\u1eef li\u1ec7u ti\u00eau \u0111\u1ec1 \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp v\u1edbi d\u1eef li\u1ec7u \u2022 \u0110\u1ec3 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u: \u2013 tr\u00ean tab Home, trong nh\u00f3m Editing, nh\u1ea5p v\u00e0o Sort & Filter, ho\u1eb7c \u2013 Tr\u00ean tab Data, nh\u00f3m Sort & Filter, h\u00e3y nh\u1ea5p v\u00e0o Sort A to Z ho\u1eb7c Sort Z to A \u00a9 IIG Vietnam. 3","Microsoft\u00ae Core Skills Excel 2010 S\u1eafp x\u1ebfp d\u1eef li\u1ec7u Multi-Level \u2022 C\u00f3 th\u1ec3 ch\u1ecdn l\u00ean \u0111\u1ebfn 64 c\u1ed9t s\u1eafp x\u1ebfp th\u1ee9 t\u1ef1 \u2022 C\u0169ng c\u00f3 th\u1ec3 t\u00f9y ch\u1ec9nh m\u1ed7i c\u1ea5p \u0111\u1ed9 s\u1eafp x\u1ebfp d\u1ef1a tr\u00ean ki\u1ec3u d\u1eef li\u1ec7u v\u00e0 th\u1ee9 t\u1ef1 s\u1eafp x\u1ebfp \u00a9 IIG Vietnam. 4","Microsoft\u00ae Core Skills Excel 2010 L\u1ecdc th\u00f4ng tin \u2022 Khi ho\u1ea1t \u0111\u1ed9ng, bi\u1ec3u t\u01b0\u1ee3ng AutoFilter xu\u1ea5t hi\u1ec7n tr\u00ean ph\u00eda b\u00ean ph\u1ea3i c\u1ee7a m\u1ed7i t\u00ean tr\u01b0\u1eddng \u2013 t\u00ecm c\u00e1c h\u00e0ng n\u01a1i c\u00f3 \u00f4 b\u1eb1ng gi\u00e1 tr\u1ecb c\u1ee5 th\u1ec3 ho\u1eb7c t\u1eadp c\u00e1c gi\u00e1 tr\u1ecb \u2013 t\u00ecm c\u00e1c m\u1ee5c b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c \u0111i\u1ec1u ki\u1ec7n ho\u1eb7c ti\u00eau chu\u1ea9n c\u1ee5 th\u1ec3 \u2013 t\u00ecm tr\u00ean c\u00e1c c\u1ed9t v\u1edbi c\u00e1c con s\u1ed1, v\u0103n b\u1ea3n, ho\u1eb7c gi\u00e1 tr\u1ecb ng\u00e0y \/ gi\u1edd \u2022 Tr\u00ean tab Data, nh\u00f3m Sort & Filter, ch\u1ecdn Filter \u00a9 IIG Vietnam. 5","Microsoft\u00ae Core Skills Excel 2010 L\u1ecdc th\u00f4ng tin \u2022 Menu AutoFilter hi\u1ec3n th\u1ecb danh s\u00e1ch c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb duy nh\u1ea5t trong c\u1ed9t hi\u1ec7n t\u1ea1i \u2022 T\u1ea1o ra b\u1ed9 l\u1ecdc b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u1ed9p ki\u1ec3m tra (check box) \u2013 ho\u1eb7c t\u1ea1o ra m\u1ed9t AutoFilter t\u00f9y ch\u1ec9nh b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng lo\u1ea1t c\u00e1c gi\u00e1 tr\u1ecb (range of values) \u00a9 IIG Vietnam. 6","Microsoft\u00ae Core Skills Excel 2010 T\u1ea1o ph\u1ea1m vi \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean (Named Ranges) \u2022 \u0110\u1ec3 \u0111\u1eb7t t\u00ean ph\u1ea1m vi, ch\u1ecdn ph\u1ea1m vi v\u00e0 sau \u0111\u00f3: \u2013 Tr\u00ean tab Formulas, trong nh\u00f3m Defined Names, nh\u1ea5p v\u00e0o Define Name; \u2013 Nh\u1ea5n chu\u1ed9t ph\u1ea3i v\u00e0o ph\u1ea1m vi c\u1ee7a c\u00e1c \u00f4 \u0111\u01b0\u1ee3c l\u1ef1a ch\u1ecdn v\u00e0 sau \u0111\u00f3 nh\u1ea5p v\u00e0o Define Name \u2022 T\u00ean \u0111\u01b0\u1ee3c \u0111\u1eb7t c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong c\u00e1c c\u00f4ng th\u1ee9c \u2022 T\u00ean ph\u1ea1m vi c\u00f3 th\u1ec3 d\u00e0i t\u1eeb 1 \u0111\u1ebfn 255 k\u00fd t\u1ef1 \u2022 C\u00f3 th\u1ec3 nhanh ch\u00f3ng ch\u1ecdn ph\u1ea1m vi \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean b\u1eb1ng c\u00e1ch ch\u1ecdn t\u1eeb danh s\u00e1ch Name Box \u00a9 IIG Vietnam. 7","Microsoft\u00ae Core Skills Excel 2010 S\u1eeda \u0111\u1ed5i v\u00e0 x\u00f3a Named Ranges \u2022 S\u1eed d\u1ee5ng Name Manager \u0111\u1ec3: \u2013 c\u1eadp nh\u1eadt ph\u1ea1m vi \u00f4 tham chi\u1ebfu \u2013 thay \u0111\u1ed5i \u0111\u1ec3 \u0111\u1eb7t t\u00ean ph\u1ea1m vi x\u00e1c \u0111\u1ecbnh \u2013 x\u00f3a t\u00ean d\u00e3y (named range) \u2022 Tr\u00ean tab Formulas, trong nh\u00f3m Defined Names, nh\u1ea5p v\u00e0o Name Manager \u00a9 IIG Vietnam. 8","Microsoft\u00ae Core Skills Excel 2010 Ch\u00e8n si\u00eau li\u00ean k\u1ebft (Hyperlinks) \u2022 C\u00f3 th\u1ec3 l\u00e0 v\u0103n b\u1ea3n ho\u1eb7c h\u00ecnh \u1ea3nh tr\u00ean trang nh\u1ea3y ho\u1eb7c li\u00ean k\u1ebft \u0111\u1ebfn m\u1ed9t \u0111\u1ecba \u0111i\u1ec3m kh\u00e1c \u2022 C\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb t\u00e0i li\u1ec7u tham chi\u1ebfu d\u01b0\u1edbi h\u00ecnh th\u1ee9c c\u1ee7a URL \u2022 \u0110\u1ec3 ch\u00e8n si\u00eau li\u00ean k\u1ebft: \u2013 Tr\u00ean tab Insert, trong nh\u00f3m Links, nh\u1ea5p Hyperlink; ho\u1eb7c \u2013 nh\u1ea5n Ctrl + K \u00a9 IIG Vietnam. 9","Microsoft\u00ae Core Skills Excel 2010 S\u1eeda \u0111\u1ed5i v\u00e0 x\u00f3a Hyperlinks \u2022 N\u1ebfu t\u1eadp tin tham chi\u1ebfu di chuy\u1ec3n ho\u1eb7c \u0111\u1ed5i t\u00ean, ph\u1ea3i thay \u0111\u1ed5i li\u00ean k\u1ebft \u2013 thay \u0111\u1ed5i v\u0103n b\u1ea3n hi\u1ec3n th\u1ecb cho li\u00ean k\u1ebft, ho\u1eb7c th\u00eam ScreenTip t\u00f9y bi\u1ebfn \u2022 Khi kh\u00f4ng c\u00f2n c\u1ea7n si\u00eau li\u00ean k\u1ebft, lo\u1ea1i b\u1ecf n\u00f3 \u2013 v\u0103n b\u1ea3n si\u00eau li\u00ean k\u1ebft v\u1eabn c\u00f2n \u2022 \u0110\u1ec3 ch\u1ec9nh s\u1eeda hyperlink: \u2013 K\u00edch chu\u1ed9t ph\u1ea3i v\u00e0o li\u00ean k\u1ebft v\u00e0 nh\u1ea5p v\u00e0o Edit Hyperlink, ho\u1eb7c \u2013 di chuy\u1ec3n \u0111\u1ebfn \u00f4 c\u00f3 ch\u1ee9a li\u00ean k\u1ebft v\u00e0 tr\u00ean tab Insert, trong nh\u00f3m Links, nh\u1ea5p Hyperlink \u2022 \u0110\u1ec3 x\u00f3a hyperlink: \u2013 K\u00edch chu\u1ed9t ph\u1ea3i v\u00e0o hyperlink v\u00e0 k\u00edch Remove Hyperlink; \u2013 di chuy\u1ec3n \u0111\u1ebfn \u00f4 c\u00f3 ch\u1ee9a li\u00ean k\u1ebft v\u00e0 tr\u00ean tab Insert, trong nh\u00f3m Links, nh\u1ea5p Hyperlink, h\u00e3y nh\u1ea5p v\u00e0o Remove Link. \u00a9 IIG Vietnam. 10","Microsoft\u00ae Core Skills Excel 2010 S\u1eed d\u1ee5ng b\u00ecnh lu\u1eadn (Comments) \u2022 T\u01b0\u01a1ng t\u1ef1 nh\u01b0 c\u00e1ch \u0111\u1eb7t c\u00e1c ghi ch\u00fa d\u00e1n tr\u00ean m\u1ed9t t\u00e0i li\u1ec7u \u2013 Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng th\u00eam t\u00ean hi\u1ec7n t\u1ea1i c\u1ee7a ng\u01b0\u1eddi s\u1eed d\u1ee5ng \u2013 nhi\u1ec1u ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 ch\u00fa th\u00edch c\u00e1c worksheet \u2013 h\u1eefu \u00edch khi nh\u1eafc nh\u1edf ho\u1eb7c \u0111\u1ec3 cung c\u1ea5p th\u00eam th\u00f4ng tin \u2022 \u0110\u1ec3 th\u00eam l\u1eddi b\u00ecnh v\u00e0o worksheet: \u2013 Ch\u1ecdn cell, tr\u00ean tab Review, trong nh\u00f3m Comments, nh\u1ea5p v\u00e0o New Comment, ho\u1eb7c \u2013 nh\u1ea5n Shift + F2; ho\u1eb7c \u2013 k\u00edch chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4 c\u1ea7n b\u00ecnh lu\u1eadn v\u00e0 nh\u1ea5n Insert Comment \u2022 \u0110\u1ec3 t\u1ea1m th\u1eddi hi\u1ec3n th\u1ecb n\u1ed9i dung b\u00ecnh lu\u1eadn, ri\u00eang l\u1ebb \u0111\u1eb7t v\u1ecb tr\u00ed c\u1ee7a con tr\u1ecf tr\u00ean \u00f4 c\u00f3 ch\u1ee9a b\u00ecnh lu\u1eadn \u2013 Khi \u0111i ra kh\u1ecfi \u00f4, b\u00ecnh lu\u1eadn \u1ea9n l\u1ea1i \u00a9 IIG Vietnam. 11","Microsoft\u00ae Core Skills Excel 2010 S\u1eed d\u1ee5ng b\u00ecnh lu\u1eadn (Comments) \u2022 \u0110\u1ec3 b\u1eaft bu\u1ed9c b\u00ecnh lu\u1eadn \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb: 12 \u2013 Ch\u1ecdn cell v\u1edbi b\u00ecnh lu\u1eadn, sau \u0111\u00f3 tr\u00ean tab Review, trong nh\u00f3m Comments, nh\u1ea5p v\u00e0o Show \/ Hide Comment, ho\u1eb7c. \u2013 k\u00edch chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4 c\u00f3 b\u00ecnh lu\u1eadn c\u1ea7n v\u00e0 nh\u1ea5p v\u00e0o Show \/ Hide Comment \u2022 \u0110\u1ec3 hi\u1ec3n th\u1ecb n\u1ed9i dung c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c b\u00ecnh lu\u1eadn ki\u1ebfn, tr\u00ean tab Review, nh\u00f3m trong Comments, nh\u1ea5p v\u00e0o Show All Comments. \u2022 \u0110\u1ec3 x\u00f3a b\u00ecnh lu\u1eadn: \u2013 Ch\u1ecdn cell c\u00f3 b\u00ecnh lu\u1eadn, sau \u0111\u00f3 v\u00e0o tab Review trong nh\u00f3m Comments, nh\u1ea5n Delete; \u2013 ph\u1ea3i nh\u1ea5p chu\u1ed9t v\u00e0o \u00f4 v\u00e0 tr\u00ean tab Review trong nh\u00f3m Comments, h\u00e3y nh\u1ea5p v\u00e0o Delete Comment; \u2013 ch\u1ecdn \u00f4 v\u1edbi b\u00ecnh lu\u1eadn, sau \u0111\u00f3 v\u00e0o tab Home, trong nh\u00f3m Editing, \u00a9 IIG Vietnam. nh\u1ea5n Clear, v\u00e0 nh\u1ea5p v\u00e0o Delete Comments","Microsoft\u00ae Core Skills Excel 2010 Nh\u1eadp v\u00e0o v\u00e0 xu\u1ea5t ra d\u1eef li\u1ec7u Nh\u1eadp v\u00e0o c\u00e1c t\u1eadp tin d\u1eef li\u1ec7u \u2022 Excel c\u00f3 th\u1ec3 chuy\u1ec3n \u0111\u1ed5i c\u00e1c t\u1eadp tin d\u1eef li\u1ec7u b\u00ean ngo\u00e0i b\u1eb1ng c\u00e1ch nh\u1eadp ch\u00fang v\u00e0o \u2022 Tr\u00ean tab Data, trong nh\u00f3m Get External Data, ch\u1ecdn From Other Sources \u00a9 IIG Vietnam. 13","Microsoft\u00ae Core Skills Excel 2010 Nh\u1eadp v\u00e0o v\u00e0 xu\u1ea5t ra d\u1eef li\u1ec7u T\u1eeb Access Nh\u1eadp v\u00e0o tr\u1ef1c ti\u1ebfp t\u1eeb c\u01a1 s\u1edf d\u1eef li\u1ec7u Microsoft Access. T\u1eeb Web Nh\u1eadp v\u00e0o d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb c\u00e1c v\u1ecb tr\u00ed c\u1ee5 th\u1ec3 c\u1ee7a T\u1eeb Text trang web. Nh\u1eadp v\u00e0o d\u1eef li\u1ec7u t\u1eeb t\u1eadp tin ch\u1ee9a c\u00e1c d\u1eef li\u1ec7u s\u1ed1 v\u00e0 k\u00fd t\u1ef1 trong \u0111\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n. T\u1eeb SQL Server Nh\u1eadp v\u00e0o d\u1eef li\u1ec7u t\u1eeb c\u01a1 s\u1edf d\u1eef li\u1ec7u Microsoft SQL Server. T\u1eeb Analysis Services Nh\u1eadp v\u00e0o d\u1eef li\u1ec7u t\u1eeb Analysis Services module, m\u1ed9t th\u00e0nh ph\u1ea7n c\u1ee7a Microsoft SQL Server. T\u1eeb XML Data Import Nh\u1eadp v\u00e0o d\u1eef li\u1ec7u t\u1eeb c\u00e1c t\u1eadp tin \u0111\u1ecbnh d\u1ea1ng XML. T\u1eeb Data Connection Nh\u1eadp v\u00e0o d\u1eef li\u1ec7u b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng m\u1ed9t k\u1ebft n\u1ed1i d\u1eef li\u1ec7u Wizard \u0111\u1ebfn m\u1ed9t h\u1ec7 th\u1ed1ng kh\u00e1c. T\u1eeb Microsoft Query Nh\u1eadp v\u00e0o d\u1eef li\u1ec7u b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng Microsoft Query module. \u00a9 IIG Vietnam. 14","Microsoft\u00ae Core Skills Excel 2010 Nh\u1eadp v\u00e0o v\u00e0 xu\u1ea5t ra d\u1eef li\u1ec7u \u2022 \u0110\u1ecbnh d\u1ea1ng v\u0103n b\u1ea3n c\u00f3 \u00edt nh\u1ea5t l\u00e0 ba \u0111\u1ecbnh d\u1ea1ng con: \u2013 Ph\u00e2n c\u00e1ch (Delimited) \u2022 D\u1eef li\u1ec7u v\u0103n b\u1ea3n \u0111\u01b0\u1ee3c ph\u00e2n c\u00e1ch b\u1eb1ng k\u00fd t\u1ef1 \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh tr\u01b0\u1edbc \u2022 T\u00e1ch d\u00f2ng v\u0103n b\u1ea3n v\u00e0o c\u00e1c gi\u00e1 tr\u1ecb ri\u00eang bi\u1ec7t \u0111\u1ec3 ch\u00e8n v\u00e0o m\u1ed7i \u00f4 b\u1ea3ng t\u00ednh \u2013 Chi\u1ec1u r\u1ed9ng c\u1ed1 \u0111\u1ecbnh (Fixed width) \u2022 M\u1ed7i gi\u00e1 tr\u1ecb c\u00f3 v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u v\u00e0 k\u1ebft th\u00fac c\u1ee5 th\u1ec3 trong m\u1ed7i d\u00f2ng v\u0103n b\u1ea3n \u2022 V\u1ecb tr\u00ed c\u1ee7a v\u0103n b\u1ea3n chia t\u00e1ch d\u1eef li\u1ec7u v\u00e0o m\u1ed7i \u00f4 b\u1ea3ng t\u00ednh \u00a9 IIG Vietnam. 15","Microsoft\u00ae Core Skills Excel 2010 Nh\u1eadp v\u00e0o v\u00e0 xu\u1ea5t ra d\u1eef li\u1ec7u Xu\u1ea5t ra d\u1eef li\u1ec7u \u2022 S\u1eed d\u1ee5ng danh s\u00e1ch Save as type \u0111\u1ec3 ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng kh\u00e1c nhau \u0111\u1ec3 l\u01b0u d\u1eef li\u1ec7u b\u1ea3ng t\u00ednh \u2022 Ph\u01b0\u01a1ng ph\u00e1p kh\u00e1c l\u00e0 s\u1eed d\u1ee5ng Windows Clipboard \u2013 Sao ch\u00e9p d\u1eef li\u1ec7u t\u1eeb Excel v\u00e0o clipboard, v\u00e0 d\u00e1n d\u1eef li\u1ec7u v\u00e0o ch\u01b0\u01a1ng tr\u00ecnh Windows kh\u00e1c \u00a9 IIG Vietnam. 16","Microsoft\u00ae Core Skills Excel 2010 Thay \u0111\u1ed5i thu\u1ed9c t\u00ednh Workbook \u2022 C\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb c\u00e1c thu\u1ed9c t\u00ednh c\u1ee7a workbook tr\u01b0\u1edbc khi m\u1edf n\u00f3 \u2013 H\u1eefu \u00edch khi nhi\u1ec1u workbook \u0111\u01b0\u1ee3c l\u01b0u c\u00f3 t\u00ean r\u1ea5t gi\u1ed1ng nhau \u2022 Xem thu\u1ed9c t\u00ednh t\u00e0i li\u1ec7u tr\u01b0\u1edbc khi l\u01b0u workbook cho l\u1ea7n \u0111\u1ea7u ti\u00ean ho\u1eb7c g\u1eedi cho ng\u01b0\u1eddi kh\u00e1c \u2022 Nh\u1ea5p v\u00e0o n\u00fat File, ch\u1ecdn Info, ch\u1ecdn Properties, nh\u1ea5p v\u00e0o Show Document Panel \u00a9 IIG Vietnam. 17","Microsoft\u00ae Core Skills Excel 2010 Chia s\u1ebb Workbook qua E-mail \u2022 Tr\u00ean tab File, ch\u1ecdn Share, nh\u1ea5n v\u00e0o Send Using E-mail \u2022 E-mail t\u1ea1o ra v\u1edbi workbook \u0111\u00ednh k\u00e8m trong \u0111\u1ecbnh d\u1ea1ng \u0111\u01b0\u1ee3c ch\u1ecdn ho\u1eb7c nh\u01b0 l\u00e0 t\u00e0i li\u1ec7u Internet fax \u00a9 IIG Vietnam. 18","Microsoft\u00ae Core Skills Excel 2010 Chia s\u1ebb Workbook qua SkyDrive \u2022 Tr\u00ean tab File, ch\u1ecdn Share, nh\u1ea5p v\u00e0o Save to SkyDrive \u2022 L\u01b0u workbook v\u00e0o SkyDrive \u0111\u01b0\u1ee3c k\u00e8m theo t\u00e0i kho\u1ea3n Windows Live \u2022 SkyDrive ho\u1ea1t \u0111\u1ed9ng nh\u01b0 \u1ed5 c\u1ee9ng, nh\u01b0ng l\u00e0 tr\u00ean Internet \u00a9 IIG Vietnam. 19","Microsoft\u00ae Core Skills Excel 2010 Chia s\u1ebb Workbook qua SharePoint \u2022 Tr\u00ean tab File, ch\u1ecdn Share, nh\u1ea5n Save to SharePoint \u2022 L\u01b0u workbook v\u00e0o SharePoint site c\u1ee7a c\u00f4ng ty \u00a9 IIG Vietnam. 20","Microsoft\u00ae Core Skills Excel 2010 Microsoft Office 1 Word 2010 B\u00e0i t\u1eadp luy\u1ec7n thi MOS Excel 2010 Core \u00a9 IIG Vietnam.","Microsoft\u00ae Core Skills Excel 2010 M\u1ee5c ti\u00eau 1. Qu\u1ea3n l\u00fd m\u00f4i tr\u01b0\u1eddng Worksheet 2. T\u1ea1o \u00f4 d\u1eef li\u1ec7u 3. \u0110\u1ecbnh d\u1ea1ng Cells v\u00e0 Worksheets 4. Qu\u1ea3n l\u00fd Worksheets v\u00e0 Workbooks 5. \u00c1p d\u1ee5ng c\u00f4ng th\u1ee9c v\u00e0 h\u00e0m 6. Tr\u00ecnh b\u00e0y d\u1eef li\u1ec7u tr\u1ef1c quan 7. Chia s\u1ebb d\u1eef li\u1ec7u Worksheet v\u1edbi ng\u01b0\u1eddi d\u00f9ng kh\u00e1c 8. Ph\u00e2n t\u00edch v\u00e0 t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u \u00a9 IIG Vietnam. 2","Microsoft\u00ae Core Skills Excel 2010 1. Qu\u1ea3n l\u00fd m\u00f4i tr\u01b0\u1eddng Worksheet \u20221.1 \u0110i\u1ec1u h\u01b0\u1edbng trong m\u1ed9t Worksheet \u20221.2 In m\u1ed9t Worksheet ho\u1eb7c Workbook \u20221.3 C\u00e1 nh\u00e2n ho\u00e1 m\u00f4i tr\u01b0\u1eddng Excel \u00a9 IIG Vietnam. 3","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 1.1 \u2022 C\u00e1c t\u1eadp tin th\u1ef1c h\u00e0nh cho c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u01b0 m\u1ee5c Excel \\\\ Objective1. N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nhi\u1ec7m v\u1ee5, l\u01b0u ch\u00fang trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1eb1ng c\u00e1ch th\u00eam t\u1eeb My tr\u01b0\u1edbc t\u00ean t\u1eadp tin \u0111\u1ec3 b\u1ea1n kh\u00f4ng ghi \u0111\u00e8 l\u00ean t\u1eadp tin th\u1ef1c h\u00e0nh ban \u0111\u1ea7u. \u2013 M\u1edf workbook PopiulationData. S\u1eed d\u1ee5ng c\u00e1c k\u1ef9 thu\u1eadt m\u00f4 t\u1ea3 trong ph\u1ea7n n\u00e0y, di chuy\u1ec3n \u0111\u1ebfn \u00f4 J6 c\u1ee7a worksheet NST03. \u2013 S\u1eed d\u1ee5ng c\u00e1c k\u1ef9 thu\u1eadt \u0111\u01b0\u1ee3c m\u00f4 t\u1ea3 trong ph\u1ea7n n\u00e0y, di chuy\u1ec3n \u00f4 worksheet \u0111\u1ea7u ti\u00ean c\u00f3 ch\u1ee9a m\u1ed9t b\u00ecnh lu\u1eadn. \u2013 Di chuy\u1ec3n ph\u1ea1m vi \u00f4 c\u00f3 t\u00ean l\u00e0 US_2006. \u2013 Di chuy\u1ec3n \u0111\u1ebfn \u00f4 d\u00e2n c\u01b0 cu\u1ed1i c\u00f9ng trong worksheet. \u00a9 IIG Vietnam. 4","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 1.2 \u2022 C\u00e1c t\u1eadp tin th\u1ef1c h\u00e0nh cho c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u01b0 m\u1ee5c Excel \\\\ Objective1. N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nhi\u1ec7m v\u1ee5, l\u01b0u ch\u00fang trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1eb1ng c\u00e1ch th\u00eam t\u1eeb My tr\u01b0\u1edbc t\u00ean t\u1eadp tin \u0111\u1ec3 b\u1ea1n kh\u00f4ng ghi \u0111\u00e8 l\u00ean t\u1eadp tin th\u1ef1c h\u00e0nh ban \u0111\u1ea7u. \u2013 C\u1ea5u h\u00ecnh worksheet SalesByCategory c\u1ee7a workbook PrintArea \u0111\u1ec3 in \u1ea5n v\u1edbi c\u00e1c thi\u1ebft l\u1eadp m\u1eb7c \u0111\u1ecbnh s\u1ebd ch\u1ec9 in nh\u1eefng c\u1ed9t B v\u00e0 C v\u1edbi gridlines. \u00a9 IIG Vietnam. 5","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 1.2 (tt) \u2013 M\u1edf worksheet Orders c\u1ee7a workbook PageBreaks, ch\u00e8n m\u1ed9t ng\u1eaft trang tr\u01b0\u1edbc h\u00e0ng 31. Sau \u0111\u00f3, xem x\u00e9t c\u00e1c ng\u1eaft trang, v\u00e0 \u0111\u1ea3m b\u1ea3o r\u1eb1ng ch\u1ec9 c\u00e1c c\u1ed9t t\u1eeb A \u0111\u1ebfn D s\u1ebd xu\u1ea5t hi\u1ec7n tr\u00ean trang \u0111\u1ea7u ti\u00ean. \u2013 Trong workbook HeaderFooter, t\u1ea1o m\u1ed9t header s\u1ebd in tr\u00ean t\u1ea5t c\u1ea3 c\u00e1c trang c\u1ee7a worksheet Orders, ngo\u1ea1i tr\u1eeb trang \u0111\u1ea7u ti\u00ean. \u1ede b\u00ean tr\u00e1i, nh\u1eadp v\u00e0o ng\u00e0y hi\u1ec7n t\u1ea1i, \u1edf gi\u1eefa, nh\u1eadp t\u00ean c\u1ee7a workbook, v\u00e0 b\u00ean ph\u1ea3i, nh\u1eadp s\u1ed1 trang. Quay l\u1ea1i \u0111\u1ec3 xem b\u00ecnh th\u01b0\u1eddng (Normal), v\u00e0 sau \u0111\u00f3 thay \u0111\u1ed5i ph\u1ea7n gi\u1eefa c\u1ee7a header \u0111\u1ec3 ph\u1ea3n \u00e1nh t\u00ean c\u1ee7a worksheet thay v\u00ec c\u1ee7a workbook. \u2013 C\u1ea5u h\u00ecnh c\u00e1c thi\u1ebft l\u1eadp in c\u1ee7a workbook HeaderFooter \u0111\u1ec3 c\u00e1c s\u1ed1 trang in \u1edf d\u01b0\u1edbi c\u00f9ng c\u1ee7a m\u1ed7i trang thay v\u00ec tr\u00ean c\u00f9ng. \u00a9 IIG Vietnam. 6","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 1.3 \u2022 C\u00e1c t\u1eadp tin th\u1ef1c h\u00e0nh cho c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u01b0 m\u1ee5c Excel \\\\ Objective1. N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nhi\u1ec7m v\u1ee5, l\u01b0u ch\u00fang trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1eb1ng c\u00e1ch th\u00eam t\u1eeb My tr\u01b0\u1edbc t\u00ean t\u1eadp tin \u0111\u1ec3 b\u1ea1n kh\u00f4ng ghi \u0111\u00e8 l\u00ean t\u1eadp tin th\u1ef1c h\u00e0nh ban \u0111\u1ea7u. \u2013 \u0110\u00ednh k\u00e8m t\u1eeb kho\u00e1 magazine v\u00e0 advertising v\u00e0o workbook Properties. \u2013 C\u1ea5u h\u00ecnh Excel \u0111\u1ec3 n\u00f3 kh\u00f4ng cung c\u1ea5p th\u00f4ng tin AutoComplete c\u00f4ng th\u1ee9c m\u00e0 b\u1ea1n nh\u1eadp v\u00e0o. Ki\u1ec3m tra c\u00e1c thi\u1ebft l\u1eadp b\u1eb1ng c\u00e1ch nh\u1eadp =SUM (trong m\u1ed9t \u00f4 b\u1ea3ng t\u00ednh v\u00e0 x\u00e1c minh r\u1eb1ng m\u1ed9t tooltip hi\u1ec3n th\u1ecb c\u1ea5u tr\u00fac c\u00f4ng th\u1ee9c \u0111\u00fang kh\u00f4ng xu\u1ea5t hi\u1ec7n. \u2013 C\u1ea5u h\u00ecnh Excel \u0111\u1ec3 di chuy\u1ec3n \u0111\u1ebfn c\u00e1c \u00f4 ti\u1ebfp theo sang b\u00ean ph\u1ea3i khi b\u1ea1n nh\u1ea5n Enter. ki\u1ec3m tra c\u00e1c thi\u1ebft l\u1eadp b\u1eb1ng c\u00e1ch nh\u1eadp n\u1ed9i dung v\u00e0o m\u1ed9t \u00f4 b\u1ea3ng t\u00ednh v\u00e0 sau \u0111\u00f3 nh\u1ea5n Enter. \u00a9 IIG Vietnam. 7","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 1.3 (tt) \u2013 Hi\u1ec3n th\u1ecb tab Developer tr\u00ean ribbon. Sau \u0111\u00f3, lo\u1ea1i b\u1ecf c\u00e1c nh\u00f3m Macros t\u1eeb tab View. \u2013 N\u00fat Quick Print kh\u00f4ng c\u00f3 s\u1eb5n theo m\u1eb7c \u0111\u1ecbnh tr\u00ean b\u1ea5t k\u1ef3 tab ribbon. Th\u00eam n\u00fat n\u00e0y v\u00e0o Quick Access Toolbar, \u0111\u1eb7t n\u00f3 v\u00e0o n\u00fat ngo\u00e0i c\u00f9ng b\u00ean tr\u00e1i, v\u00e0 t\u00e1ch bi\u1ec7t tr\u1ef1c quan so v\u1edbi c\u00e1c n\u00fat kh\u00e1c. \u2013 \u0110\u1ed1i v\u1edbi c\u00e1c workbook hi\u1ec7n t\u1ea1i, t\u1ea1o ra m\u1ed9t thanh c\u00f4ng c\u1ee5 Quick Access c\u00f3 ch\u1ee9a n\u00fat \u0111\u1ec3 ch\u00e8n h\u00ecnh \u1ea3nh, bi\u1ec3u \u0111\u1ed3, v\u00e0 c\u00e1c b\u1ea3ng. Sau \u0111\u00f3 hi\u1ec3n th\u1ecb thanh c\u00f4ng c\u1ee5 Quick Access n\u00e0y ph\u00eda d\u01b0\u1edbi v\u00f9ng Ribbon. \u2013 H\u1ee7y b\u1ecf c\u00e1c t\u00f9y ch\u1ec9nh c\u1ee7a b\u1ea1n t\u1eeb h\u1ed9p tho\u1ea1i Excel Options ribbon, v\u00e0 c\u1ea3 hai thanh c\u00f4ng c\u1ee5 Quick Access, v\u00e0 ch\u1ec9 hi\u1ec3n th\u1ecb Quick Access Toolbar ti\u00eau chu\u1ea9n tr\u00ean ribbon. \u00a9 IIG Vietnam. 8","Microsoft\u00ae Core Skills Excel 2010 2. T\u1ea1o \u00f4 d\u1eef li\u1ec7u \u20222.1 X\u00e2y d\u1ef1ng \u00f4 d\u1eef li\u1ec7u \u20222.2 \u00c1p d\u1ee5ng Auto Fill \u20222,3 \u00c1p d\u1ee5ng v\u00e0 thao t\u00e1c c\u00e1c Hyperlink \u00a9 IIG Vietnam. 9","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 2.1 \u2022 C\u00e1c t\u1eadp tin th\u1ef1c h\u00e0nh cho c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u01b0 m\u1ee5c Excel \\\\ Objective2. N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nhi\u1ec7m v\u1ee5, l\u01b0u ch\u00fang trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1eb1ng c\u00e1ch th\u00eam t\u1eeb My tr\u01b0\u1edbc t\u00ean t\u1eadp tin \u0111\u1ec3 b\u1ea1n kh\u00f4ng ghi \u0111\u00e8 l\u00ean t\u1eadp tin th\u1ef1c h\u00e0nh ban \u0111\u1ea7u. \u2013 Trong workbook InsertingDeleting, chuy\u1ec3n c\u00e1c t\u00ean trong c\u1ed9t Magazine tr\u00ean worksheet Ad Buy Constraints v\u00e0o h\u00e0ng \u0111\u1ea7u ti\u00ean c\u1ee7a m\u1ed9t worksheet m\u1edbi. \u00a9 IIG Vietnam. 10","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 2.1 (tt) \u2013 Trong workbook InsertingDeleting, th\u1ef1c h\u00e0nh d\u00e1n ch\u1ec9 c\u00f3 c\u00e1c gi\u00e1 tr\u1ecb (c\u00f3 ho\u1eb7c kh\u00f4ng c\u00f3 \u0111\u01b0\u1eddng vi\u1ec1n), c\u00f4ng th\u1ee9c, v\u00e0 \u0111\u1ecbnh d\u1ea1ng c\u1ee7a c\u00e1c \u00f4 B4: G9 tr\u00ean worksheet Ad Buy Constraints. \u2013 tr\u00ean worksheet Ad Buy Constraints c\u1ee7a workbook InsertingDeleting, x\u00f3a c\u00e1c h\u00e0ng \u0111\u1ec3 di chuy\u1ec3n c\u00e1c ti\u00eau \u0111\u1ec1 c\u1ed9t \u0111\u1ebfn h\u00e0ng 1. Xo\u00e1 c\u00e1c c\u1ed9t \u0111\u1ec3 di chuy\u1ec3n c\u1ed9t Magazine sang c\u1ed9t A. C\u1eaft d\u1eef li\u1ec7u t\u1eeb h\u00e0ng Mag3 (B4: F4) v\u00e0 ch\u00e8n n\u00f3 v\u00e0o h\u00e0ng Mag2 (B3: F3). Di chuy\u1ec3n d\u1eef li\u1ec7u Ad Cost Per sang tr\u00e1i c\u1ee7a c\u00e1c \u00f4 Total Cost. Cu\u1ed1i c\u00f9ng, ch\u00e8n hai \u00f4 \u1edf v\u1ecb tr\u00ed B8:B9, chuy\u1ec3n d\u1ecbch b\u1ea5t k\u1ef3 d\u1eef li\u1ec7u hi\u1ec7n c\u00f3. \u00a9 IIG Vietnam. 11","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 2.2 \u2022 C\u00e1c t\u1eadp tin th\u1ef1c h\u00e0nh cho c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u01b0 m\u1ee5c Excel \\\\ Objective2. N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nhi\u1ec7m v\u1ee5, l\u01b0u ch\u00fang trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1eb1ng c\u00e1ch th\u00eam t\u1eeb My tr\u01b0\u1edbc t\u00ean t\u1eadp tin \u0111\u1ec3 b\u1ea1n kh\u00f4ng ghi \u0111\u00e8 l\u00ean t\u1eadp tin th\u1ef1c h\u00e0nh ban \u0111\u1ea7u. \u2013 Tr\u00ean worksheet Sheet1 c\u1ee7a workbook FillSeries, \u0111i\u1ec1n v\u00e0o \u00f4 A2:A21 v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb Item 1, Item 2, Item 3, v\u00e0 nh\u01b0 v\u1eady cho \u0111\u1ebfn Item 20. \u0110i\u1ec1n v\u00e0o c\u00e1c \u00f4 B2:B21 v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb 10, 20, 30, v\u00e0 nh\u01b0 v\u1eady cho \u0111\u1ebfn 200. Sau \u0111\u00f3 \u0111i\u1ec1n v\u00e0o c\u00e1c \u00f4 C2:C21 v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb $ 3,00, $ 2,95, $ 2,90, v\u00e0 nh\u01b0 v\u1eady cho \u0111\u1ebfn $ 2,05. \u00a9 IIG Vietnam. 12","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 2.2 (tt) \u2013 M\u1edf worksheet Sheet1 c\u1ee7a workbook FillSeries, sao ch\u00e9p c\u00e1c n\u1ec1n v\u00e0 ph\u00f4ng ch\u1eef \u0111\u1ecbnh d\u1ea1ng t\u1eeb \u00f4 A1 sang c\u00e1c \u00f4 A2:A21. \u2013 M\u1edf worksheet Sheet1 c\u1ee7a workbook FillCustom, \u0111i\u1ec1n v\u00e0o c\u00e1c \u00f4 B1:K1 v\u1edbi c\u00e1c ng\u00e0y t\u1eeb Monday \u0111\u1ebfn Friday, l\u1eb7p \u0111i l\u1eb7p l\u1ea1i hai l\u1ea7n. \u2013 M\u1edf worksheet Sheet1 c\u1ee7a workbook FillCustom, t\u1ea1o ra m\u1ed9t t\u00f9y ch\u1ec9nh h\u00e0ng lo\u1ea1t (series) b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c t\u00ean (name) \u0111\u01b0\u1ee3c nh\u1eadp trong c\u00e1c \u00f4 B2:B7. \u0110i\u1ec1n v\u00e0o h\u00e0ng lo\u1ea1t (series) trong m\u1ed7i h\u00e0ng \u0111\u1ec3 t\u1ea1o ra m\u1ed9t b\u1ea3ng ph\u00e2n c\u00f4ng nhi\u1ec7m v\u1ee5 xoay trong hai tu\u1ea7n. \u2013 M\u1edf worksheet Term Schedule c\u1ee7a workbook FillCopies, ch\u1ecdn c\u00e1c \u00f4 A2: F14. S\u1eed d\u1ee5ng c\u00e1c ch\u1ee9c n\u0103ng l\u1ea5p \u0111\u1ea7y, t\u1ea1o ra m\u1ed9t b\u1ea3n sao c\u1ee7a term schedule \u0111\u00e3 ch\u1ecdn v\u00e0 theo sau h\u00e0ng tr\u1ed1ng ngay b\u00ean d\u01b0\u1edbi b\u1ea3n g\u1ed1c. \u0110\u1ea3m b\u1ea3o r\u1eb1ng c\u1ed9t Period trong c\u00e1c b\u1ea3n sao c\u1ee7a schedule hi\u1ec3n th\u1ecb kho\u1ea3ng t\u1eeb 1 \u0111\u1ebfn 8. \u00a9 IIG Vietnam. 13","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 2.3 \u2022 C\u00e1c t\u1eadp tin th\u1ef1c h\u00e0nh cho c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u01b0 m\u1ee5c Excel \\\\ Objective2. N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nhi\u1ec7m v\u1ee5, l\u01b0u ch\u00fang trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1eb1ng c\u00e1ch th\u00eam t\u1eeb My tr\u01b0\u1edbc t\u00ean t\u1eadp tin \u0111\u1ec3 b\u1ea1n kh\u00f4ng ghi \u0111\u00e8 l\u00ean t\u1eadp tin th\u1ef1c h\u00e0nh ban \u0111\u1ea7u. \u2013 Tr\u00ean worksheet Employees c\u1ee7a workbook Hyperlink trong \u00f4 A12, nh\u1eadp hyperlink \u0111\u1ebfn website \u0111\u1eb7t t\u1ea1i www.otsi.com. \u2013 Ch\u1ec9nh s\u1eeda hyperlink m\u00e0 b\u1ea1n t\u1ea1o ra trong \u00f4 A12 \u0111\u1ec3 \u00f4 hi\u1ec3n th\u1ecb \u201cPlease visit our website\u201d thay cho \u0111\u1ecba ch\u1ec9 URL. \u00a9 IIG Vietnam. 14","Microsoft\u00ae Core Skills Excel 2010 3. \u0110\u1ecbnh d\u1ea1ng Cells v\u00e0 Worksheets \u2022 3.1 \u00c1p d\u1ee5ng v\u00e0 s\u1eeda \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng Cell \u2022 3.2 H\u1ee3p nh\u1ea5t ho\u1eb7c chia \u00f4 \u2022 3.3 T\u1ea1o ti\u00eau \u0111\u1ec1 h\u00e0ng v\u00e0 c\u1ed9t \u2022 3.4 \u1ea8n ho\u1eb7c kh\u00f4ng \u1ea9n h\u00e0ng v\u00e0 c\u1ed9t \u2022 3.5 Thao t\u00e1c t\u00f9y ch\u1ecdn Page Setup cho Worksheets \u2022 3.6 T\u1ea1o v\u00e0 \u00e1p d\u1ee5ng c\u00e1c Styles Cell \u00a9 IIG Vietnam. 15","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 3.1 \u2022 C\u00e1c t\u1eadp tin th\u1ef1c h\u00e0nh cho c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u01b0 m\u1ee5c Excel \\\\ Objective3. N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nhi\u1ec7m v\u1ee5, l\u01b0u ch\u00fang trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1eb1ng c\u00e1ch th\u00eam t\u1eeb My tr\u01b0\u1edbc t\u00ean t\u1eadp tin \u0111\u1ec3 b\u1ea1n kh\u00f4ng ghi \u0111\u00e8 l\u00ean t\u1eadp tin th\u1ef1c h\u00e0nh ban \u0111\u1ea7u. \u2013 Tr\u00ean worksheet Expense Statement c\u1ee7a workbook FormatCells, \u0111\u1ecbnh d\u1ea1ng \u00f4 K10 \u0111\u1ec3 hi\u1ec3n th\u1ecb n\u1ed9i dung c\u1ee7a n\u00f3 trong b\u1ea5t k\u1ef3 m\u1ed9t trong c\u00e1c \u0111\u1ecbnh d\u1ea1ng s\u1ed1 (Number, Currency, ho\u1eb7c Accounting) kh\u00f4ng c\u00f3 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n. Sau \u0111\u00f3 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng t\u01b0\u01a1ng t\u1ef1 cho c\u00e1c \u00f4 K11:K23. \u00a9 IIG Vietnam. 16","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 3.1 (tt) \u2013 M\u1edf worksheet Expense Statement c\u1ee7a workbook FormatCells, \u00e1p d\u1ee5ng s\u1ed1 t\u00f9y ch\u1ec9nh \u0111\u1ecbnh d\u1ea1ng v\u1edbi gi\u00e1 tr\u1ecb TOTAL \u1edf \u00f4 K23 \u0111\u1ec3 n\u00f3 \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb trong m\u00e0u xanh l\u00e1 c\u00e2y n\u1ebfu n\u00f3 l\u00e0 m\u1ed9t s\u1ed1 d\u01b0\u01a1ng v\u00e0 \u0111\u1ecf n\u1ebfu n\u00f3 l\u00e0 m\u1ed9t s\u1ed1 \u00e2m. Kh\u00f4ng th\u00eam \u0111\u1ecbnh d\u1ea1ng cho c\u00e1c gi\u00e1 tr\u1ecb 0 ho\u1eb7c v\u0103n b\u1ea3n. X\u00e1c minh c\u00e1c \u0111\u1ecbnh d\u1ea1ng b\u1eb1ng c\u00e1ch nh\u1eadp m\u1ed9t gi\u00e1 tr\u1ecb 3,000 trong \u00f4 K22. \u2013 Tr\u00ean worksheet Expense Statement c\u1ee7a workbook FormatCells, thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc font ch\u1eef c\u1ee7a c\u00e1c header trong c\u00e1c \u00f4 A9:K9. Trong c\u00e1c \u00f4 A9:K9 v\u00e0 K10:K19, \u00e1p d\u1ee5ng m\u1ed9t m\u00e0u n\u1ec1n l\u00e0 hai m\u00e0u \u0111\u1eadm h\u01a1n so v\u1edbi hi\u1ec7n t\u1ea1i. Cu\u1ed1i c\u00f9ng, \u0111\u1eb7t m\u1ed9t \u0111\u01b0\u1eddng vi\u1ec1n h\u1ed9p d\u00e0y xung quanh c\u00e1c \u00f4 b\u1ecb s\u00e1p nh\u1eadp trong h\u00e0ng 2. \u00a9 IIG Vietnam. 17","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 3.1 (tt) \u2013 M\u1edf worksheet Expense Statement c\u1ee7a workbook RowColumnFormatting, thi\u1ebft l\u1eadp to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh \u0111\u1ec3 b\u1ecdc t\u1ea5t c\u1ea3 c\u00e1c m\u1ee5c trong c\u00e1c \u00f4 c\u1ee7a ch\u00fang. Right-align c\u00e1c m\u1ee5c trong c\u1ed9t A, v\u00e0 bottom-align c\u00e1c ti\u00eau \u0111\u1ec1 trong h\u00e0ng 9. Cu\u1ed1i c\u00f9ng, t\u1eaft ch\u1ee9c n\u0103ng text wrapping trong d\u00f2ng 4, 5, v\u00e0 9, v\u00e0 xoay ngang c\u00e1c header trong h\u00e0ng 9 \u1edf m\u1ed9t g\u00f3c 45 \u0111\u1ed9. \u2013 M\u1edf worksheet Inventory List c\u1ee7a workbook HeightWidth, thi\u1ebft l\u1eadp chi\u1ec1u cao c\u1ee7a h\u00e0ng 4 l\u00e0 6,00, v\u00e0 sau \u0111\u00f3 k\u00e9o h\u00e0ng 3 \u0111\u1ea5n chi\u1ec1u cao l\u00e0 45,00. Sau \u0111\u00f3, \u0111\u1ed3ng th\u1eddi thi\u1ebft l\u1eadp chi\u1ec1u r\u1ed9ng c\u1ee7a c\u00e1c c\u1ed9t F, G v\u00e0 H l\u00e0 10. Cu\u1ed1i c\u00f9ng, thi\u1ebft l\u1eadp l\u1ea1i \u0111\u1ed9 r\u1ed9ng c\u1ee7a c\u1ed9t B \u0111\u1ec3 ph\u00f9 h\u1ee3p v\u1edbi m\u1ee5c nh\u1eadp c\u1ee7a n\u00f3 d\u00e0i nh\u1ea5t. \u00a9 IIG Vietnam. 18","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 3.2 \u2022 C\u00e1c t\u1eadp tin th\u1ef1c h\u00e0nh cho c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u01b0 m\u1ee5c Excel \\\\ Objective3. N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nhi\u1ec7m v\u1ee5, l\u01b0u ch\u00fang trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1eb1ng c\u00e1ch th\u00eam t\u1eeb My tr\u01b0\u1edbc t\u00ean t\u1eadp tin \u0111\u1ec3 b\u1ea1n kh\u00f4ng ghi \u0111\u00e8 l\u00ean t\u1eadp tin th\u1ef1c h\u00e0nh ban \u0111\u1ea7u. \u2013 Tr\u00ean worksheet Employees c\u1ee7a workbook Hyperlink, h\u1ee3p nh\u1ea5t c\u00e1c \u00f4 A12:C13 \u0111\u1ec3 hyperlink \u0111\u01b0\u1ee3c canh gi\u1eefa \u1edf ph\u00eda d\u01b0\u1edbi c\u00f9ng c\u1ee7a ba c\u1ed9t. Sau \u0111\u00f3 h\u1ee7y h\u1ee3p nh\u1ea5t c\u00e1c \u00f4 \u0111\u1ec3 hyperlink xu\u1ea5t hi\u1ec7n trong ch\u1ec9 trong \u00f4 A12. \u00a9 IIG Vietnam. 19","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 3.3 \u2022 C\u00e1c t\u1eadp tin th\u1ef1c h\u00e0nh cho c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u01b0 m\u1ee5c Excel \\\\ Objective3. N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nhi\u1ec7m v\u1ee5, l\u01b0u ch\u00fang trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1eb1ng c\u00e1ch th\u00eam t\u1eeb My tr\u01b0\u1edbc t\u00ean t\u1eadp tin \u0111\u1ec3 b\u1ea1n kh\u00f4ng ghi \u0111\u00e8 l\u00ean t\u1eadp tin th\u1ef1c h\u00e0nh ban \u0111\u1ea7u. \u2013 Trong workbook HeightWidth, c\u1ea5u h\u00ecnh worksheet Inventory List \u0111\u1ec3 in ti\u00eau \u0111\u1ec1 h\u00e0ng v\u00e0 c\u1ed9t tr\u00ean t\u1eebng trang. \u00a9 IIG Vietnam. 20","Microsoft\u00ae Core Skills Excel 2010 Nhi\u1ec7m v\u1ee5 th\u1ef1c h\u00e0nh 3.4 \u2022 C\u00e1c t\u1eadp tin th\u1ef1c h\u00e0nh cho c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u01b0\u1ee3c \u0111\u1eb7t trong th\u01b0 m\u1ee5c Excel \\\\ Objective3. N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a nhi\u1ec7m v\u1ee5, l\u01b0u ch\u00fang trong c\u00f9ng th\u01b0 m\u1ee5c v\u1edbi b\u1eb1ng c\u00e1ch th\u00eam t\u1eeb My tr\u01b0\u1edbc t\u00ean t\u1eadp tin \u0111\u1ec3 b\u1ea1n kh\u00f4ng ghi \u0111\u00e8 l\u00ean t\u1eadp tin th\u1ef1c h\u00e0nh ban \u0111\u1ea7u. \u2013 Tr\u00ean worksheet Inventory List c\u1ee7a workbook Hiding, \u1ea9n c\u1ed9t c\u00f3 ch\u1ee9a Inventory ID v\u00e0 h\u00e0ng c\u00f3 ch\u1ee9a c\u00e1c ghi ch\u00fa ngu\u1ed3n d\u1eef li\u1ec7u. Sau \u0111\u00f3, th\u00f4i \u1ea9n c\u00e1c h\u00e0ng, nh\u01b0ng kh\u00f4ng th\u1ef1c hi\u1ec7n v\u1edbi c\u1ed9t c\u1ed9t. \u00a9 IIG Vietnam. 21"]