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

["Microsoft\u00ae Core Skills Excel 2010 Thay \u0111\u1ed5i chi\u1ec1u r\u1ed9ng c\u1ed9t \u2022 \u0110\u1ec3 thay \u0111\u1ed5i chi\u1ec1u r\u1ed9ng c\u1ed9t: \u2013 Tr\u00ean tab Home, trong nh\u00f3m Cells, nh\u1ea5n Format.Style v\u00e0 sau \u0111\u00f3 nh\u1ea5p v\u00e0o \u0111\u1ed9 r\u1ed9ng c\u1ee7a c\u1ed9t, ho\u1eb7c \u2013 \u0111\u1eb7t con tr\u1ecf chu\u1ed9t tr\u00ean \u0111\u01b0\u1eddng th\u1eb3ng \u0111\u1ee9ng \u1edf b\u00ean ph\u1ea3i c\u1ee7a ti\u00eau \u0111\u1ec1 c\u1ed9t v\u00e0 k\u00e9o \u0111\u1ebfn chi\u1ec1u r\u1ed9ng th\u00edch h\u1ee3p, ho\u1eb7c \u2013 k\u00edch chu\u1ed9t ph\u1ea3i v\u00e0o ti\u00eau \u0111\u1ec1 c\u1ed9t, v\u00e0 sau \u0111\u00f3 nh\u1ea5p v\u00e0o \u0111\u1ed9 r\u1ed9ng c\u1ee7a c\u1ed9t S\u1eed d\u1ee5ng AutoFit \u2022 \u0110\u1ec3 Excel t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc c\u1ed9t cho n\u1ed9i dung \u2013 Ch\u1ecdn \u00f4 v\u1edbi chi\u1ec1u r\u1ed9ng mong mu\u1ed1n, sau \u0111\u00f3 v\u00e0o tab Home, trong nh\u00f3m Cells, nh\u1ea5n Format v\u00e0 sau \u0111\u00f3 nh\u1ea5p v\u00e0o AutoFit Column Width, ho\u1eb7c \u2013 k\u00edch \u0111\u00fap v\u00e0o ph\u00eda b\u00ean ph\u1ea3i c\u1ee7a c\u1ed9t \u0111\u1ec3 \u0111i\u1ec1u ch\u1ec9nh \u0111\u1ebfn chi\u1ec1u r\u1ed9ng c\u1ee7a \u00a9 IIG Vietnam. gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t trong to\u00e0n b\u1ed9 c\u1ed9t 16","Microsoft\u00ae Core Skills Excel 2010 \u0110i\u1ec1u ch\u1ec9nh \u0111\u1ed9 cao c\u1ee7a h\u00e0ng \u2022 C\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c thay \u0111\u1ed5i b\u1eb1ng tay ho\u1eb7c b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng AutoFit \u2022 \u0110\u1ec3 thay \u0111\u1ed5i chi\u1ec1u cao h\u00e0ng: \u2013 Tr\u00ean tab Home, trong nh\u00f3m Cells, nh\u1ea5n Format v\u00e0 sau \u0111\u00f3 nh\u1ea5p v\u00e0o Row Height, ho\u1eb7c \u2013 \u0110\u1eb7t con tr\u1ecf chu\u1ed9t \u1edf ph\u00eda d\u01b0\u1edbi ti\u00eau \u0111\u1ec1 d\u00f2ng, sau \u0111\u00f3 k\u00e9o \u0111\u1ebfn chi\u1ec1u cao m\u1edbi \u2022 \u0110\u1ec3 AutoFit chi\u1ec1u cao h\u00e0ng: \u2013 Tr\u00ean tab Home, trong nh\u00f3m Cells, nh\u1ea5n Format v\u00e0 sau \u0111\u00f3 nh\u1ea5p v\u00e0o AutoFit Row Height, ho\u1eb7c \u2013 k\u00edch \u0111\u00fap v\u00e0o d\u01b0\u1edbi c\u00f9ng c\u1ee7a d\u00f2ng ti\u00eau \u0111\u1ec1 \u00a9 IIG Vietnam. 17","Microsoft\u00ae Core Skills Excel 2010 \u1ea8n \/ hi\u1ec7n (hide \/ unhide )h\u00e0ng v\u00e0 c\u1ed9t \u2022 \u1ea8n c\u00e1c h\u00e0ng ho\u1eb7c c\u1ed9t b\u1edfi v\u00ec: \u2013 C\u1ea7n \u0111\u1ec3 in worksheet l\u1edbn, \u1ea9n h\u00e0ng ho\u1eb7c c\u1ed9t \u00edt quan tr\u1ecdng h\u01a1n \u0111\u1ec3 c\u1ea3i thi\u1ec7n kh\u1ea3 n\u0103ng \u0111\u1ecdc t\u1ed5ng th\u1ec3 worksheet \u2013 \u1ea8n c\u00e1c c\u1ed9t ho\u1eb7c c\u00e1c h\u00e0ng l\u01b0u tr\u1eef c\u00e1c t\u00ednh to\u00e1n trung gian cho c\u00e1c c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p \u2013 \u1ea8n c\u00e1c c\u1ed9t ho\u1eb7c c\u00e1c h\u00e0ng c\u00f3 ch\u1ee9a d\u1eef li\u1ec7u b\u00ed m\u1eadt \u2022 C\u00f3 th\u1ec3 ph\u00e1t hi\u1ec7n h\u00e0ng ho\u1eb7c c\u1ed9t \u1ea9n b\u1eb1ng nh\u1eefng kho\u1ea3ng tr\u1ed1ng trong ti\u00eau \u0111\u1ec1 h\u00e0ng ho\u1eb7c c\u1ed9t \u2022 V\u1eabn c\u00f2n \u1ea9n cho \u0111\u1ebfn khi b\u1ecf \u1ea9n \u2022 C\u00f4ng th\u1ee9c trong c\u00e1c \u00f4 c\u00f3 th\u1ec3 nh\u00ecn th\u1ea5y \u1ea9n ho\u1eb7c c\u00e1c \u00f4 tham chi\u1ebfu \u1ea9n v\u1eabn ti\u1ebfp t\u1ee5c \u0111\u01b0\u1ee3c t\u00ednh to\u00e1n m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c \u2022 C\u00e1c h\u00e0ng v\u00e0 c\u1ed9t \u1ea9n kh\u00f4ng xu\u1ea5t hi\u1ec7n khi in \u1ea5n worksheet cho \u0111\u1ebfn khi b\u1ecf \u1ea9n \u00a9 IIG Vietnam. 18","Microsoft\u00ae Core Skills Excel 2010 \u1ea8n \/ hi\u1ec7n h\u00e0ng v\u00e0 c\u1ed9t \u2022 \u0110\u1ec3 \u1ea9n h\u00e0ng ho\u1eb7c c\u1ed9t, \u0111\u1ea7u ti\u00ean ch\u1ecdn ti\u00eau \u0111\u1ec1: \u2013 Tr\u00ean tab Home, trong nh\u00f3m Cells, nh\u1ea5p v\u00e0o Format, nh\u1ea5n Hide & Unhide, v\u00e0 sau \u0111\u00f3 Hide Columns ho\u1eb7c Hide Rows, ho\u1eb7c \u2013 k\u00edch chu\u1ed9t ph\u1ea3i v\u00e0o l\u1ef1a ch\u1ecdn c\u00e1c h\u00e0ng ho\u1eb7c c\u1ed9t v\u00e0 sau \u0111\u00f3 nh\u1ea5p v\u00e0o Hide, ho\u1eb7c \u2013 k\u00e9o c\u1ea1nh b\u00ean ph\u1ea3i c\u1ee7a ti\u00eau \u0111\u1ec1 c\u1ed9t \u0111\u1ebfn c\u1ea1nh b\u00ean tr\u00e1i, ho\u1eb7c c\u1ea1nh d\u01b0\u1edbi l\u00ean tr\u00ean d\u00f2ng ti\u00eau \u0111\u1ec1 \u2022 \u0110\u1ec3 th\u00f4i \u1ea9n h\u00e0ng ho\u1eb7c c\u1ed9t, ch\u1ecdn c\u00e1c ti\u00eau \u0111\u1ec1 m\u1ee5c tr\u00ean c\u1ea3 hai c\u1ea1nh c\u1ee7a c\u00e1c h\u00e0ng ho\u1eb7c c\u1ed9t \u1ea9n: \u2013 Tr\u00ean tab Home, trong nh\u00f3m Cells, nh\u1ea5p v\u00e0o Format, nh\u1ea5n Hide & Unhide, v\u00e0 sau \u0111\u00f3 Unhide Columns ho\u1eb7c Unhide Rows, ho\u1eb7c \u2013 k\u00edch chu\u1ed9t ph\u1ea3i v\u00e0o c\u00e1c h\u00e0ng ho\u1eb7c c\u1ed9t \u0111\u01b0\u1ee3c ch\u1ecdn v\u00e0 sau \u0111\u00f3 nh\u1ea5p v\u00e0o Unhide, ho\u1eb7c \u2013 k\u00e9o c\u1ea1nh b\u00ean ph\u1ea3i c\u1ee7a c\u1ed9t \u1ea9n sang ph\u1ea3i, ho\u1eb7c c\u1ea1nh d\u01b0\u1edbi c\u00f9ng d\u00f2ng \u1ea9n xu\u1ed1ng\u00a9 IIG Vietnam. 19","Microsoft\u00ae Core Skills Excel 2010 T\u00ecm ki\u1ebfm v\u00e0 thay th\u1ebf d\u1eef li\u1ec7u T\u00ecm ki\u1ebfm d\u1eef li\u1ec7u \u2022 Tr\u00ean tab Home, trong nh\u00f3m Editing, nh\u1ea5p v\u00e0o Find & Select, sau \u0111\u00f3 nh\u1ea5p v\u00e0o Find \u00a9 IIG Vietnam. Slide 2-20","Microsoft\u00ae Core Skills Excel 2010 T\u00ecm ki\u1ebfm v\u00e0 thay th\u1ebf d\u1eef li\u1ec7u Thay th\u1ebf d\u1eef li\u1ec7u \u2022 Tr\u00ean tab Home, trong nh\u00f3m Editing, nh\u1ea5p v\u00e0o Find & Select, sau \u0111\u00f3 nh\u1ea5p v\u00e0o Replace \u00a9 IIG Vietnam. 21","Microsoft\u00ae Core Skills Excel 2010 S\u1eed d\u1ee5ng AutoFill Copy Cells C\u00e1c v\u0103n b\u1ea3n, c\u00e1c gi\u00e1 tr\u1ecb ho\u1eb7c c\u00f4ng th\u1ee9c sao ch\u00e9p v\u1edbi \u0111\u1ecbnh d\u1ea1ng c\u1ee7a ch\u00fang. Kh\u00f4ng t\u1ea1o ra h\u00e0ng lo\u1ea1t. Fill Series T\u1ea1o chu\u1ed7i tuy\u1ebfn t\u00ednh \u0111\u01a1n gi\u1ea3n v\u00e0 sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng c\u1ee7a \u00f4 Fill Formatting ngu\u1ed3n. Only Sao ch\u00e9p c\u00e1c \u0111\u1ecbnh d\u1ea1ng t\u1eeb \u00f4 ngu\u1ed3n, nh\u01b0ng \u0111\u1ec3 l\u1ea1i n\u1ed9i dung c\u1ee7a c\u00e1c \u00f4 m\u1ee5c ti\u00eau kh\u00f4ng thay \u0111\u1ed5i. Fill Without T\u1ea1o chu\u1ed7i tuy\u1ebfn t\u00ednh \u0111\u01a1n gi\u1ea3n m\u00e0 kh\u00f4ng c\u1ea7n sao ch\u00e9p \u0111\u1ecbnh Formatting d\u1ea1ng c\u1ee7a \u00f4 ngu\u1ed3n. Fill Months S\u1eed d\u1ee5ng cho chu\u1ed7i t\u00ean th\u00e1ng. \u00a9 IIG Vietnam. Slide 2-22","Microsoft\u00ae Core Skills Excel 2010 Qu\u1ea3n l\u00fd Worksheets \u2022 Workbook l\u00e0 t\u1eadp h\u1ee3p c\u1ee7a nhi\u1ec1u worksheet \u2013 M\u1ed7i worksheet c\u00f3 th\u1ec3 \u0111\u1ed9c l\u1eadp v\u1edbi c\u00e1i kh\u00e1c, ho\u1eb7c li\u00ean quan v\u1edbi nhau \u2013 H\u00e3y th\u1eed \u0111\u1ec3 l\u01b0u tr\u1eef th\u00f4ng tin li\u00ean quan trong m\u1ed9t workbook \u0111\u1ec3 thu\u1eadn ti\u1ec7n v\u00e0 t\u0103ng n\u0103ng su\u1ea5t \u2022 Workbook m\u1edbi s\u1ebd t\u1ef1 \u0111\u1ed9ng bao g\u1ed3m 3 worksheet \u2022 S\u1eed d\u1ee5ng c\u00e1c n\u00fat di chuy\u1ec3n tab \u0111\u1ec3 hi\u1ec3n th\u1ecb c\u00e1c tab worksheet First Sheet kh\u00e1c Previous Sheet \u2022 H\u1ee7y b\u1ecf c\u00e1c worksheet kh\u00f4ng c\u00f2n c\u1ea7n thi\u1ebft Next Sheet Last Sheet \u2013 Kh\u00f4ng th\u1ec3 ho\u00e0n t\u00e1c worksheet b\u1ecb x\u00f3a \u00a9 IIG Vietnam. 23","Microsoft\u00ae Core Skills Excel 2010 \u0110\u1ed5i t\u00ean Worksheets \u2022 C\u00f3 th\u1ec3 ch\u1ec9 \u0111\u1ecbnh t\u00ean nhi\u1ec1u m\u00f4 t\u1ea3 h\u01a1n \u2022 Excel s\u1ebd \u0111i\u1ec1u ch\u1ec9nh k\u00edch th\u01b0\u1edbc tab theo s\u1ed1 k\u00fd t\u1ef1 trong t\u00ean \u2013 Gi\u1eef t\u00ean tab cho d\u1ec5 d\u00e0ng chuy\u1ec3n h\u01b0\u1edbng \u2022 \u0110\u1ec3 \u0111\u1ed5i t\u00ean tab worksheet: \u2013 Nh\u1ea5p \u0111\u00fap chu\u1ed9t v\u00e0o tab sheet \u0111\u1ec3 \u0111\u1ed5i t\u00ean, ho\u1eb7c \u2013 K\u00edch chu\u1ed9t ph\u1ea3i v\u00e0o tab sheet v\u00e0 sau \u0111\u00f3 nh\u1ea5p v\u00e0o Rename \u00a9 IIG Vietnam. 24","Microsoft\u00ae Core Skills Excel 2010 Ch\u00e8n ho\u1eb7c x\u00f3a Worksheets \u2022 \u0110\u1ec3 ch\u00e8n blank worksheet: \u2013 b\u1ea5m v\u00e0o \u1edf cu\u1ed1i tab worksheet, ho\u1eb7c \u2013 Tr\u00ean tab Home, trong nh\u00f3m Cells, nh\u1ea5p v\u00e0o m\u0169i t\u00ean d\u01b0\u1edbi Insert v\u00e0 sau \u0111\u00f3 nh\u1ea5p v\u00e0o Insert Sheet, ho\u1eb7c \u2013 K\u00edch chu\u1ed9t ph\u1ea3i v\u00e0o tab sheet n\u01a1i worksheet \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o, b\u1ea5m Insert, b\u1ea5m v\u00e0o m\u1eabu Worksheet v\u00e0 nh\u1ea5n OK \u2022 \u0110\u1ec3 x\u00f3a worksheet: \u2013 Tr\u00ean tab Home, trong nh\u00f3m Cells, b\u00e2m Delete, v\u00e0 nh\u1ea5n Delete sheet, ho\u1eb7c \u2013 k\u00edch chu\u1ed9t ph\u1ea3i v\u00e0o tab sheet v\u00e0 nh\u1ea5n Delete \u00a9 IIG Vietnam. 25","Microsoft\u00ae Core Skills Excel 2010 Di chuy\u1ec3n ho\u1eb7c x\u00f3a Worksheets \u2022 T\u1ed5 ch\u1ee9c c\u00e1c workbook nhi\u1ec1u worksheet, ho\u1eb7c t\u1ea1o ra b\u1ea3n sao c\u1ee7a worksheet hi\u1ec7n c\u00f3 \u2022 \u0110\u1ec3 di chuy\u1ec3n ho\u1eb7c sao ch\u00e9p worksheet trong workbook: \u2013 K\u00edch chu\u1ed9t ph\u1ea3i v\u00e0o tab sheet di chuy\u1ec3n ho\u1eb7c sao ch\u00e9p v\u00e0 nh\u1ea5p v\u00e0o Move or Copy, ho\u1eb7c \u2013 \u0111\u1ec3 nhanh ch\u00f3ng di chuy\u1ec3n worksheet, k\u00e9o tab sheet \u0111\u1ebfn v\u1ecb tr\u00ed m\u1edbi, ho\u1eb7c \u2013 \u0111\u1ec3 nhanh ch\u00f3ng sao ch\u00e9p b\u1ea3ng t\u00ednh, nh\u1ea5p v\u00e0o tab sheet, nh\u1ea5n Ctrl v\u00e0 k\u00e9o \u0111\u1ebfn v\u1ecb tr\u00ed m\u1edbi \u2022 C\u00f3 th\u1ec3 k\u00e9o tab worksheet v\u00e0o ph\u1ea7n tr\u1ed1ng c\u1ee7a c\u1eeda s\u1ed5 \u1ee9ng d\u1ee5ng Excel \u0111\u1ec3 t\u1ea1o workbook m\u1edbi v\u1edbi worksheet \u0111\u00f3. \u00a9 IIG Vietnam. 26","Microsoft\u00ae Core Skills Excel 2010 \u1ea8n \/ hi\u1ec7n Worksheets \u2022 Ng\u0103n ng\u01b0\u1eddi d\u00f9ng kh\u00e1c xem d\u1eef li\u1ec7u, c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u2022 C\u00f3 th\u1ec3 \u1ea9n nhi\u1ec1u worksheet trong workbook khi c\u1ea7n thi\u1ebft, theo th\u1ee9 t\u1ef1 b\u1ea5t k\u1ef3 \u2022 Ph\u1ea3i c\u00f3 \u00edt nh\u1ea5t m\u1ed9t worksheet kh\u00f4ng \u1ea9n \u2022 Khi hi\u1ec7n c\u00e1c worksheet, ch\u1ecdn worksheet th\u00f4i \u1ea9n t\u1eeb h\u1ed9p tho\u1ea1i hi\u1ec3n th\u1ecb t\u1ea5t c\u1ea3 c\u00e1c c\u00e1c worksheet \u1ea9n? \u2022 \u0110\u1ec3 \u1ea9n ho\u1eb7c b\u1ecf \u1ea9n m\u1ed9t worksheet: \u2013 Tr\u00ean tab Home, trong nh\u00f3m Cells, nh\u1ea5p v\u00e0o Format, tr\u1ecf t\u1ea1i Hide & Unhide, sau \u0111\u00f3 nh\u1ea5p v\u00e0o Hide Sheet ho\u1eb7c Unhide Sheet, ho\u1eb7c \u2013 K\u00edch chu\u1ed9t ph\u1ea3i v\u00e0o tab worksheet, nh\u1ea5n Hide Sheet ho\u1eb7c Unhide Sheet \u00a9 IIG Vietnam. 27","Microsoft\u00ae Core Skills Excel 2010 Th\u00eam m\u00e0u s\u1eafc cho tab Worksheet \u2022 S\u1eed d\u1ee5ng m\u00e0u s\u1eafc tr\u00ean c\u00e1c tab worksheet \u0111\u1ec3 gi\u00fap x\u00e1c \u0111\u1ecbnh c\u00e1c worksheet \u2022 M\u00e0u s\u1eafc s\u1ebd xu\u1ea5t hi\u1ec7n nh\u01b0 d\u00f2ng b\u00ean d\u01b0\u1edbi t\u00ean worksheet khi worksheet ho\u1ea1t \u0111\u1ed9ng, v\u1edbi n\u1ec1n m\u00e0u khi kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng \u2022 C\u00f3 th\u1ec3 l\u1ef1a ch\u1ecdn m\u00e0u s\u1eafc ti\u00eau chu\u1ea9n ho\u1eb7c ch\u1ee7 \u0111\u1ec1 cho c\u00e1c tab worksheet. \u2022 \u0110\u1ec3 hi\u1ec3n th\u1ecb b\u1ea3ng m\u00e0u cho c\u00e1c tab worksheet, h\u00e3y nh\u1ea5p v\u00e0o tab worksheet v\u00e0 sau \u0111\u00f3: \u2013 Tr\u00ean tab Home, trong nh\u00f3m Cells, nh\u1ea5p v\u00e0o Format v\u00e0 nh\u1ea5n Tab Color, ho\u1eb7c \u2013 k\u00edch chu\u1ed9t ph\u1ea3i v\u00e0o tab worksheet v\u00e0 nh\u1ea5n Tab Color. \u00a9 IIG Vietnam. 28","Microsoft\u00ae Core Skills Excel 2010 Microsoft\u00ae Office Excel 2010 B\u00e0i 3: S\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c","Microsoft\u00ae Core Skills Excel 2010 M\u1ee5c ti\u00eau \u2022 c\u00f4ng th\u1ee9c l\u00e0 g\u00ec \u2022 s\u1eed d\u1ee5ng c\u00e1c tham chi\u1ebfu \u00f4 \u2022 t\u1ea1o v\u00e0 ch\u1ec9nh s\u1eeda c\u00e1c c\u00f4ng tuy\u1ec7t \u0111\u1ed1i v\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i th\u1ee9c \u0111\u01a1n gi\u1ea3n \u2022 s\u1eed d\u1ee5ng c\u00e1c \u0111\u1ecba ch\u1ec9 \u00f4 tuy\u1ec7t \u0111\u1ed1i v\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i h\u1ed7n h\u1ee3p \u2022 tham chi\u1ebfu worksheet kh\u00e1c \u2022 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m ph\u1ed5 bi\u1ebfn \u2022 hi\u1ec3n th\u1ecb v\u00e0 in c\u00f4ng th\u1ee9c \u2022 s\u1eed d\u1ee5ng h\u00e0m c\u00f3 \u0111i\u1ec1u ki\u1ec7n \u00a9 IIG Vietnam. 2","Microsoft\u00ae Core Skills Excel 2010 T\u1ea1o v\u00e0 ch\u1ec9nh s\u1eeda c\u00e1c c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n \u2022 T\u00ednh to\u00e1n b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nh\u1eadp tr\u1ef1c ti\u1ebfp ho\u1eb7c t\u1eeb c\u00e1c \u00f4 kh\u00e1c, v\u00e0 c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c h\u00e0m \u2022 T\u00ednh n\u0103ng m\u1ea1nh m\u1ebd c\u1ee7a c\u00f4ng th\u1ee9c l\u00e0 kh\u1ea3 n\u0103ng \u0111\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u t\u1eeb c\u00e1c \u00f4 worksheet kh\u00e1c b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 \u2022 B\u1eaft \u0111\u1ea7u c\u00f4ng th\u1ee9c trong \u00f4 n\u01a1i m\u00e0 \u0111\u00e1p \u1ee9ng v\u1edbi hi\u1ec3n th\u1ecb hi\u1ec7n b\u1eb1ng c\u00e1ch g\u00f5 = \u2022 C\u00f4ng th\u1ee9c c\u00f3 th\u1ec3 c\u00f3 nhi\u1ec1u h\u01a1n m\u1ed9t tham chi\u1ebfu \u00f4 \u2022 K\u1ebft qu\u1ea3 c\u00f4ng th\u1ee9c t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c thay \u0111\u1ed5i b\u1ea5t c\u1ee9 l\u00fac n\u00e0o (ho\u1eb7c th\u00eam v\u00e0o ho\u1eb7c x\u00f3a) \u00a9 IIG Vietnam. 3","Microsoft\u00ae Core Skills Excel 2010 T\u1ea1o v\u00e0 ch\u1ec9nh s\u1eeda c\u00e1c c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n \u2022 C\u00f3 th\u1ec3 nh\u1eadp tham chi\u1ebfu \u00f4 v\u00e0o c\u00f4ng th\u1ee9c b\u1eb1ng c\u00e1ch g\u00f5 ho\u1eb7c tr\u1ecf \u0111\u1ebfn c\u00e1c \u00f4 \u2022 C\u00f4ng th\u1ee9c t\u1ef1 n\u00f3 kh\u00f4ng hi\u1ec3n th\u1ecb, ch\u1ec9 hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 c\u1ee7a c\u00f4ng th\u1ee9c \u2022 C\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c sao ch\u00e9p v\u00e0o c\u00e1c \u00f4 kh\u00e1c, Excel s\u1ebd \u0111i\u1ec1u ch\u1ec9nh c\u00e1c tham chi\u1ebfu chi\u1ebfu \u00f4 \u0111\u1ec3 b\u00f9 \u0111\u1eafp kho\u1ea3ng c\u00e1ch v\u00e0 h\u01b0\u1edbng \u2022 Th\u1ef1c hi\u1ec7n c\u00e1c t\u00ednh to\u00e1n trong \\\"tr\u1eadt t\u1ef1 t\u1ef1 nhi\u00ean\\\" (\u01b0u ti\u00ean): 1. S\u1ed1 m\u0169 v\u00e0 g\u1ed1c 2. Nh\u00e2n v\u00e0 chia 3. C\u1ed9ng v\u00e0 tr\u1eeb \u00a9 IIG Vietnam. 4","Microsoft\u00ae Core Skills Excel 2010 T\u1ea1o v\u00e0 ch\u1ec9nh s\u1eeda c\u00e1c c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n \u2022 C\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c thay \u0111\u1ed5i b\u1eb1ng c\u00e1ch \u0111\u1eb7t c\u00e1c th\u00e0nh ph\u1ea7n c\u1ee7a c\u00f4ng th\u1ee9c trong d\u1ea5u ngo\u1eb7c \u0111\u01a1n \u2022 C\u00e1c nh\u00e0 to\u00e1n t\u1eed to\u00e1n h\u1ecdc ti\u00eau chu\u1ea9n: * Ph\u00e9p nh\u00e2n \/ Ph\u00e9p chia + Ph\u00e9p c\u1ed9ng - Ph\u00e9p tr\u1eeb \u00a9 IIG Vietnam. 5","Microsoft\u00ae Core Skills Excel 2010 T\u1ea1o v\u00e0 ch\u1ec9nh s\u1eeda c\u00e1c c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n \u2022 N\u1ebfu Excel ph\u00e1t hi\u1ec7n l\u1ed7i ho\u1eb7c kh\u00f4ng th\u1ed1ng nh\u1ea5t trong c\u00f4ng th\u1ee9c, hi\u1ec3n th\u1ecb th\u00f4ng \u0111i\u1ec7p v\u1edbi l\u1eddi \u0111\u1ec1 ngh\u1ecb v\u1ec1 c\u00e1ch s\u1eeda ch\u1eefa \u2022 Hi\u1ec3n th\u1ecb \u0111\u1ec3 \u0111\u00e1nh d\u1ea5u c\u00f4ng th\u1ee9c n\u00e0y l\u00e0 kh\u00e1c kh\u1ecfi c\u00e1c c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong c\u00e1c \u00f4 li\u1ec1n k\u1ec1 \u2022 Nh\u1ea5p v\u00e0o tag smart hi\u1ec3n th\u1ecb m\u1ed9t menu t\u00f9y ch\u1ecdn: \u00a9 IIG Vietnam. 6","Microsoft\u00ae Core Skills Excel 2010 Tham chi\u1ebfu c\u00e1c worksheet kh\u00e1c \u2022 C\u00f3 th\u1ec3 tham chi\u1ebfu c\u00e1c \u00f4 trong c\u00e1c worksheet kh\u00e1c trong c\u00f9ng m\u1ed9t workbook \u2022 \u0110\u1ecbnh d\u1ea1ng chung l\u00e0: '<worksheet name>'! <cell reference> \u2013 ! cho th\u1ea5y \u00f4 \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y trong worksheet kh\u00e1c nhau \u2013 c\u1ea7n d\u1ea5u ngo\u1eb7c \u0111\u01a1n n\u1ebfu t\u00ean worksheet c\u00f3 kho\u1ea3ng tr\u1eafng \u2022 C\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u01b0\u01a1ng th\u1ee9c tr\u1ecf v\u00e0 nh\u1ea5n (point-and-click) v\u00e0o tham chi\u1ebfu \u00f4 \u00a9 IIG Vietnam. 7","Microsoft\u00ae Core Skills Excel 2010 S\u1eed d\u1ee5ng c\u00e1c h\u00e0m th\u01b0\u1eddng g\u1eb7p v\u1edbi Cell Ranges \u2022 Th\u01b0 vi\u1ec7n l\u1edbn c\u1ee7a c\u00e1c h\u00e0m cho c\u00e1c ho\u1ea1t \u0111\u1ed9ng to\u00e1n h\u1ecdc v\u00e0 d\u1eef li\u1ec7u \u2022 C\u00e1c h\u00e0m ch\u1ea5p nh\u1eadn gi\u00e1 tr\u1ecb (th\u01b0\u1eddng l\u00e0 s\u1ed1) v\u00e0 tham chi\u1ebfu \u00f4 \u0111\u1ed9ng d\u01b0\u1edbi d\u1ea1ng c\u00e1c \u0111\u1ed1i s\u1ed1 trong ngo\u1eb7c \u0111\u01a1n \u2022 \u0110\u1ecbnh d\u1ea1ng chung: = FUNCTION (con s\u1ed1 ho\u1eb7c gi\u00e1 tr\u1ecb ho\u1eb7c tham chi\u1ebfu \u00f4) \u2022 \u0110\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn nh\u1ea5t l\u00e0 c\u00e1c h\u00e0m SUM, MIN, MAX, AVERAGE, v\u00e0 COUNT \u00a9 IIG Vietnam. 8","Microsoft\u00ae Core Skills Excel 2010 S\u1eed d\u1ee5ng c\u00e1c h\u00e0m th\u01b0\u1eddng g\u1eb7p v\u1edbi Cell Ranges \u2022 AutoSum l\u00e0 ph\u01b0\u01a1ng th\u1ee9c t\u1eaft \u0111\u1ec3 nh\u1eadp v\u00e0o m\u1ed9t h\u00e0m SUM: \u2013 T\u1ea1i tab Formulas trong nh\u00f3m Function Library, b\u1ea5m v\u00e0o AutoSum, ho\u1eb7c \u2013 tr\u00ean tab Home, trong nh\u00f3m Editing, nh\u1ea5p v\u00e0o Sum, ho\u1eb7c \u2013 b\u1ea5m v\u00e0o Insert Function \u2022 Lu\u00f4n lu\u00f4n x\u00e1c minh c\u00f3 cell range ch\u00ednh x\u00e1c trong c\u00f4ng th\u1ee9c \u2013 Excel t\u1ef1 \u0111\u1ed9ng l\u1ef1a ch\u1ecdn ph\u1ea1m vi c\u1ee7a c\u00e1c \u00f4 ngay l\u1eadp t\u1ee9c \u1edf tr\u00ean ho\u1eb7c b\u00ean tr\u00e1i c\u1ee7a \u00f4 \u0111\u01b0\u1ee3c l\u1ef1a ch\u1ecdn, v\u00e0 hi\u1ec3n th\u1ecb n\u00f3 \u0111\u1ec3 ch\u1ea5p nh\u1eadn ho\u1eb7c thay \u0111\u1ed5i \u2022 M\u0169i t\u00ean cho AutoSum s\u1ebd hi\u1ec3n th\u1ecb c\u00e1c c\u00e1c h\u00e0m ph\u1ed5 bi\u1ebfn kh\u00e1c \u00a9 IIG Vietnam. 9","Microsoft\u00ae Core Skills Excel 2010 H\u00e0m \u0111i\u1ec1u ki\u1ec7n (Conditional Function) =IF(logical test,value if true,value if false) \u2022 Logical Test c\u00f3 th\u1ec3 bao g\u1ed3m c\u00e1c to\u00e1n t\u1eed so s\u00e1nh: = Equal to (or the same as) > Greater than < Less than >= Greater than or equal to <= Less than or equal to <> Not equal to \u2022 Value if True\/False c\u00f3 th\u1ec3 ch\u1ee9a c\u00e1c chu\u1ed7i v\u0103n b\u1ea3n, c\u00e1c gi\u00e1 tr\u1ecb, ho\u1eb7c c\u00e1c h\u00e0m kh\u00e1c \u2022 V\u00ed d\u1ee5: =IF(B10=0,0,C10\/B10) \u00a9 IIG Vietnam. 10","Microsoft\u00ae Core Skills Excel 2010 H\u00e0m \u0111i\u1ec1u ki\u1ec7n (Conditional Function) \u2022 C\u00e1c h\u00e0m IF l\u1ed3ng nhau =IF(A1=10, \u201ctext A\u201d, IF(A1=20, \u201ctext B\u201d, \u201ctext C\u201d)) N\u1ebfu A1 ch\u1ee9a Th\u00ec k\u1ebft qu\u1ea3 s\u1ebd hi\u1ec3n th\u1ecb 10 text A 20 text B text C gi\u00e1 tr\u1ecb b\u1ea5t k\u00ec \u00a9 IIG Vietnam. 11","Microsoft\u00ae Core Skills Excel 2010 S\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i v\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i \u2022 Most formulas use relative addressing \u2013 when formula is copied, cells automatically adjusts for new location \u2013 address is not adjusted if formula is moved to another location \u2022 Absolute addressing - cell addresses are not adjusted when copied elsewhere on worksheet \u2022 To change to absolute cell address: \u2013 type dollar sign before row number and\/or column letter, or \u2013 press F4 \u2022 first time makes both column and row reference absolute \u2022 second time makes only row references absolute \u2022 third time makes only column reference absolute \u2022 fourth time removes absolute references on both column and row \u00a9 IIG Vietnam. 12","Microsoft\u00ae Core Skills Excel 2010 S\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i v\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i \u2022 Ch\u1ecdn nh\u1eefng g\u00ec c\u1ea7n ph\u1ea3i gi\u1eef l\u1ea1i tuy\u1ec7t \u0111\u1ed1i khi sao ch\u00e9p c\u00f4ng th\u1ee9c: Column D\u1eef li\u1ec7u ph\u1ea3i c\u00f9ng m\u1ed9t c\u1ed9t =C10*$D2 Row D\u1eef li\u1ec7u ph\u1ea3i c\u00f9ng m\u1ed9t h\u00e0ng =C10*D$2 Both Lu\u00f4n lu\u00f4n ph\u1ea3i l\u00e0 \u00f4 n\u00e0y =C10*$D$2 \u00a9 IIG Vietnam. 13","Microsoft\u00ae Core Skills Excel 2010 Hi\u1ec3n th\u1ecb v\u00e0 in c\u00f4ng th\u1ee9c \u2022 \u0110\u1ec3 xem c\u00f4ng th\u1ee9c, ch\u1ecdn \u00f4 b\u00e0o, ki\u1ec3m tra trong thanh c\u00f4ng th\u1ee9c \u2022 \u0110\u1ec3 xem t\u1ea5t c\u1ea3 c\u00e1c c\u00f4ng th\u1ee9c t\u1ea1i c\u00f9ng m\u1ed9t th\u1eddi \u0111i\u1ec3m, tr\u00ean tab File, nh\u1ea5n v\u00e0o Options, nh\u1ea5n Advanced, nh\u1ea5p v\u00e0o Show formulas in cells instead of their calculated results \u2022 H\u1eefu \u00edch cho vi\u1ec7c x\u00e1c minh t\u00ednh ch\u00ednh x\u00e1c c\u1ee7a b\u1ea3ng t\u00ednh \u00a9 IIG Vietnam. 14","Microsoft\u00ae Core Skills Excel 2010 Microsoft\u00ae Office Excel 2010 B\u00e0i 4: \u0110\u1ecbnh d\u1ea1ng Worksheet \u00a9 IIG Vietnam. 1","Microsoft\u00ae Core Skills Excel 2010 M\u1ee5c ti\u00eau \u2022 \u0111\u1ecbnh d\u1ea1ng s\u1ed1 v\u00e0 ch\u1eef s\u1ed1 \u2022 s\u1eed d\u1ee5ng Format Painter th\u1eadp ph\u00e2n \u2022 x\u00f3a n\u1ed9i dung v\u00e0 \u0111\u1ecbnh d\u1ea1ng \u2022 thay \u0111\u1ed5i c\u0103n ch\u1ec9nh, font c\u1ee7a \u00f4 ch\u1eef, k\u00edch th\u01b0\u1edbc font ch\u1eef \u2022 s\u1eed d\u1ee5ng c\u00e1c ki\u1ec3u \u00f4 c\u1ee7a n\u1ed9i dung \u00f4 \u2022 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u \u2022 \u00e1p d\u1ee5ng \u0111\u01b0\u1eddng vi\u1ec1n v\u00e0 t\u00f4 ki\u1ec7n b\u00f3ng cho c\u00e1c c\u00e1c \u00f4 \u2022 \u00e1p d\u1ee5ng v\u00e0 thay \u0111\u1ed5i ch\u1ee7 \u0111\u1ec1 \u00a9 IIG Vietnam. 2","Microsoft\u00ae Core Skills Excel 2010 \u0110\u1ecbnh d\u1ea1ng m\u1ed9t \u00f4 \u2022 \u0110\u1ec1 c\u1eadp \u0111\u1ebfn c\u00e1ch d\u1eef li\u1ec7u xu\u1ea5t hi\u1ec7n \u2022 C\u00f3 th\u1ec3 \u0111\u1ecbnh d\u1ea1ng c\u00e1c \u00f4 \u1edf b\u1ea5t k\u1ef3 th\u1eddi \u0111i\u1ec3m n\u00e0o \u2022 \u00d4 v\u1eabn c\u00f2n \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng khi x\u00f3a n\u1ed9i dung tr\u1eeb khi x\u00f3a \u0111\u1ecbnh d\u1ea1ng ho\u1eb7c \u0111\u1ecbnh d\u1ea1ng l\u1ea1i \u2022 \u0110\u1ecbnh d\u1ea1ng sao ch\u00e9p n\u1ed9i dung \u00f4 \u2022 C\u00e1c tu\u1ef3 ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng ph\u1ed5 bi\u1ebfn nh\u1ea5t tr\u00ean tab Home ho\u1eb7c thanh c\u00f4ng c\u1ee5 Mini Toolbars \u2022 Live Preview \u2013 \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng worksheet t\u1ea1m th\u1eddi trong khi tr\u1ecf v\u00e0o \u0111\u1ecbnh d\u1ea1ng t\u00f9y ch\u1ecdn tr\u00ean thanh Ribbon \u2013 Khi chu\u1ed9t \u0111\u01b0\u1ee3c di chuy\u1ec3n \u0111i, \u0111\u1ecbnh d\u1ea1ng tr\u1edf l\u1ea1i t\u00ecnh tr\u1ea1ng hi\u1ec7n t\u1ea1i \u2013 Kh\u00f4ng \u00e1p d\u1ee5ng cho t\u1ea5t c\u1ea3 c\u00e1c n\u00fat \u0111\u1ecbnh d\u1ea1ng trong Ribbon \u00a9 IIG Vietnam. 3","Microsoft\u00ae Core Skills Excel 2010 \u0110\u1ecbnh d\u1ea1ng s\u1ed1 v\u00e0 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n \u2022 \u0110\u1ec3 \u0111\u1ecbnh d\u1ea1ng \u00f4, c\u00e1c \u00f4 l\u1ef1a ch\u1ecdn v\u00e0 sau \u0111\u00f3: \u2013 Tr\u00ean tab Home, trong Font, nh\u00f3m Alignment ho\u1eb7c Number, h\u00e3y nh\u1ea5p v\u00e0o n\u00fat th\u00edch h\u1ee3p, ho\u1eb7c \u2013 nh\u1ea5n Ctrl +1, ho\u1eb7c \u2013 nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn Format Cells, \u2013 tr\u00ean tab Home, trong Font, nh\u00f3m Alignment ho\u1eb7c Number, nh\u1ea5n Dialog Box launcher cho nh\u00f3m th\u00edch h\u1ee3p \u2013 nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0 nh\u1ea5p v\u00e0o \u0111\u1ecbnh d\u1ea1ng t\u1eeb Mini toolbar \u00a9 IIG Vietnam. 4","Microsoft\u00ae Core Skills Excel 2010 \u0110\u1ecbnh d\u1ea1ng s\u1ed1 v\u00e0 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n \u2022 Th\u1ec3 lo\u1ea1i General \u2013 \u0111\u1ecbnh d\u1ea1ng m\u1eb7c \u0111\u1ecbnh cho t\u1ea5t c\u1ea3 c\u00e1c \u00f4 \u2013 s\u1ed1 hi\u1ec3n th\u1ecb ch\u00ednh x\u00e1c nh\u01b0 \u0111\u00e3 nh\u1eadp v\u00e0o \u2022 d\u1ea5u s\u1ed1 kh\u00f4ng sau khi \u0111i\u1ec3m s\u1ed1 th\u1eadp ph\u00e2n gi\u1ea3m xu\u1ed1ng \u2013 kh\u00f4ng ph\u00f9 h\u1ee3p cho c\u00e1c s\u1ed1 c\u00f3 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n s\u1ed1 \u2013 s\u1ed1 l\u1edbn h\u01a1n nhi\u1ec1u so v\u1edbi s\u1ef1 thay \u0111\u1ed5i chi\u1ec1u r\u1ed9ng \u00f4 \u0111\u1ed9ng \u0111\u1ec3 \u0111\u1ecbnh d\u1ea1ng Scientific \u00a9 IIG Vietnam. 5","Microsoft\u00ae Core Skills Excel 2010 \u0110\u1ecbnh d\u1ea1ng s\u1ed1 v\u00e0 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n \u2022 Th\u1ec3 lo\u1ea1i Number \u2013 ti\u00eau chu\u1ea9n \u0111\u1ecbnh d\u1ea1ng cho s\u1ed1 \u2013 hi\u1ec3n th\u1ecb d\u1ea5u ph\u00e2n c\u00e1ch 1000 cho gi\u00e1 tr\u1ecb tr\u00ean 999 \u2013 m\u1eb7c \u0111\u1ecbnh 2 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n \u2013 s\u1ed1 \u00e2m c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb m\u00e0u \u0111\u1ecf, c\u00f3 d\u1ea5u tr\u1eeb ho\u1eb7c d\u1ea5u ngo\u1eb7c \u00a9 IIG Vietnam. 6","Microsoft\u00ae Core Skills Excel 2010 \u0110\u1ecbnh d\u1ea1ng s\u1ed1 v\u00e0 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n \u2022 Th\u1ec3 lo\u1ea1i Currency \u2013 t\u01b0\u01a1ng t\u1ef1 nh\u01b0 \u0111\u1ecbnh d\u1ea1ng Number \u2013 t\u1ef1 \u0111\u1ed9ng hi\u1ec3n th\u1ecb v\u1edbi bi\u1ec3u t\u01b0\u1ee3ng ti\u1ec1n t\u1ec7 v\u00e0 d\u1ea5u ph\u00e2n c\u00e1ch 1000 \u00a9 IIG Vietnam. 7","Microsoft\u00ae Core Skills Excel 2010 \u0110\u1ecbnh d\u1ea1ng s\u1ed1 v\u00e0 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n \u2022 Th\u1ec3 lo\u1ea1i Accounting \u2013 t\u01b0\u01a1ng t\u1ef1 nh\u01b0 Currency \u2013 s\u1ed1 \u00e2m hi\u1ec3n th\u1ecb hi\u1ec7n trong ngo\u1eb7c \u0111\u01a1n \u2013 bi\u1ec3u t\u01b0\u1ee3ng ti\u1ec1n t\u1ec7 xu\u1ea5t hi\u1ec7n \u1edf b\u00ean tr\u00e1i c\u1ee7a \u00f4 \u00a9 IIG Vietnam. 8","Microsoft\u00ae Core Skills Excel 2010 \u0110\u1ecbnh d\u1ea1ng s\u1ed1 v\u00e0 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n \u2022 Th\u1ec3 lo\u1ea1i Percentage \u2013 lu\u00f4n lu\u00f4n hi\u1ec3n th\u1ecb gi\u00e1 tr\u1ecb l\u00e0 s\u1ed1 100 l\u1ea7n \u2013 cho th\u1ea5y d\u1ea5u ph\u1ea7n tr\u0103m \u1edf b\u00ean ph\u1ea3i c\u1ee7a \u00f4 \u2013 m\u1eb7c \u0111\u1ecbnh l\u00e0 2 ch\u1eef s\u1ed1 \u2013 th\u1eadp ph\u00e2n \u00a9 IIG Vietnam. 9","Microsoft\u00ae Core Skills Excel 2010 \u0110\u1ecbnh d\u1ea1ng s\u1ed1 v\u00e0 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n \u2022 Th\u1ec3 lo\u1ea1i Fraction \u2013 chuy\u1ec3n \u0111\u1ed5i ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n c\u00e1c gi\u00e1 tr\u1ecb ph\u00e2n \u0111o\u1ea1n \u2013 d\u1ef1a tr\u00ean c\u01a1 s\u1edf lo\u1ea1i ph\u00e2n \u0111o\u1ea1n \u00a9 IIG Vietnam. 10","Microsoft\u00ae Core Skills Excel 2010 \u0110\u1ecbnh d\u1ea1ng s\u1ed1 v\u00e0 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n \u2022 Th\u1ec3 lo\u1ea1i Scientific \u2013 th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong c\u00e1c \u1ee9ng d\u1ee5ng khoa h\u1ecdc cho s\u1ed1 l\u01b0\u1ee3ng r\u1ea5t l\u1edbn ho\u1eb7c r\u1ea5t nh\u1ecf \u2013 ch\u1ec9 c\u00f3 m\u1ed9t ch\u1eef s\u1ed1 hi\u1ec3n th\u1ecb b\u00ean tr\u00e1i d\u1ea5u th\u1eadp ph\u00e2n \u00a9 IIG Vietnam. 11","Microsoft\u00ae Core Skills Excel 2010 \u0110\u1ecbnh d\u1ea1ng s\u1ed1 v\u00e0 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n \u2022 Th\u1ec3 lo\u1ea1i Date \u2013 Thay \u0111\u1ed5i hi\u1ec3n th\u1ecb c\u1ee7a c\u00e1c gi\u00e1 tr\u1ecb ng\u00e0y \u2013 \u0111\u1ecbnh d\u1ea1ng m\u1eb7c \u0111\u1ecbnh l\u00e0 dd-mmm-yy \u00a9 IIG Vietnam. 12","Microsoft\u00ae Core Skills Excel 2010 \u0110\u1ecbnh d\u1ea1ng s\u1ed1 v\u00e0 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n \u2022 Th\u1ec3 lo\u1ea1i Special \u2013 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng cho c\u00e1c h\u1ea1ng m\u1ee5c c\u1ee5 th\u1ec3 n\u01a1i m\u00e0 kh\u00f4ng c\u1ea7n thi\u1ebft t\u00ednh to\u00e1n v\u00e0 kh\u00f4ng \u0111\u01b0\u1ee3c x\u1eed l\u00fd nh\u01b0 l\u00e0 v\u0103n b\u1ea3n \u00a9 IIG Vietnam. 13","Microsoft\u00ae Core Skills Excel 2010 \u0110\u1ecbnh d\u1ea1ng s\u1ed1 v\u00e0 ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n \u2022 Th\u1ec3 lo\u1ea1i Custom \u2013 n\u1ebfu b\u1ea1n kh\u00f4ng th\u1ec3 t\u00ecm th\u1ea5y \u0111\u1ecbnh d\u1ea1ng ch\u00ednh x\u00e1c trong c\u00e1c th\u1ec3 lo\u1ea1i kh\u00e1c \u2013 t\u1ea1o ra \u0111\u1ecbnh d\u1ea1ng c\u1ee7a ri\u00eang b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c t\u00f9y ch\u1ecdn , ho\u1eb7c l\u00e0m h\u01b0\u1edbng d\u1eabn \u00a9 IIG Vietnam. 14","Microsoft\u00ae Core Skills Excel 2010 Thay \u0111\u1ed5i canh l\u1ec1 \u00f4 \u2022 Thay \u0111\u1ed5i v\u1ecb tr\u00ed ho\u1eb7c n\u01a1i \u0111\u1eb7t c\u1ee7a d\u1eef li\u1ec7u \u2022 S\u1eafp x\u1ebfp n\u1ed9i dung theo chi\u1ec1u ngang, chi\u1ec1u d\u1ecdc, ho\u1eb7c qua m\u1ed9t s\u1ed1 \u00f4 \u2022 \u0110\u1ec3 thay \u0111\u1ed5i canh ch\u1ec9nh sau khi ch\u1ecdn \u00f4: \u2013 Tr\u00ean tab Home, trong nh\u00f3m Alignment, b\u1ea5m v\u00e0o n\u00fat alignment, ho\u1eb7c \u2013 Nh\u1ea5n Ctrl +1 v\u00e0 nh\u1ea5p v\u00e0o tab Alignment, ho\u1eb7c \u2013 nh\u1ea5p chu\u1ed9t ph\u1ea3i, nh\u1ea5p v\u00e0o Format Cells, v\u00e0 sau \u0111\u00f3 nh\u1ea5p v\u00e0o tab Alignment, ho\u1eb7c \u2013 tr\u00ean tab Home, trong nh\u00f3m Alignment, b\u1ea5m Dialog Box launcher v\u00e0 nh\u1ea5p v\u00e0o tab Alignment \u00a9 IIG Vietnam. 15","Microsoft\u00ae Core Skills Excel 2010 Thay \u0111\u1ed5i ph\u00f4ng ch\u1eef v\u00e0 k\u00edch c\u1ee1 \u2022 Font l\u00e0 phong c\u00e1ch c\u1ee7a v\u0103n b\u1ea3n \u2022 C\u00f3 th\u1ec3 \u00e1p d\u1ee5ng c\u00e1c thay \u0111\u1ed5i ph\u00f4ng ch\u1eef b\u1ea5t k\u1ef3 d\u1eef li\u1ec7u \u2022 Thay \u0111\u1ed5i \u00e1p d\u1ee5ng to\u00e0n \u00f4 ho\u1eb7c ph\u1ea1m vi l\u1ef1a ch\u1ecdn \u2013 C\u0169ng c\u00f3 th\u1ec3 \u0111\u1ecbnh d\u1ea1ng c\u00e1c k\u00fd t\u1ef1 ho\u1eb7c s\u1ed1 ri\u00eang l\u1ebb trong n\u1ed9i dung \u00a9 IIG Vietnam. 16","Microsoft\u00ae Core Skills Excel 2010 \u00c1p d\u1ee5ng \u0111\u01b0\u1eddng vi\u1ec1n \u00f4 (Cell Borders) \u2022 T\u00e1ch d\u1eef li\u1ec7u cho d\u1ec5 \u0111\u1ecdc \u2022 V\u1ebd \u0111\u01b0\u1eddng xung quanh m\u1ed9t ho\u1eb7c t\u1ea5t c\u1ea3 c\u00e1c c\u1ea1nh c\u1ee7a \u00f4 ho\u1eb7c ph\u1ea1m vi c\u1ee7a c\u00e1c \u00f4 \u2022 \u0110\u1ec3 \u00e1p d\u1ee5ng \u0111\u01b0\u1eddng vi\u1ec1n, ch\u1ecdn c\u00e1c \u00f4: \u2013 Tr\u00ean tab Home, trong nh\u00f3m Cells, b\u1ea1n nh\u1ea5n Format v\u00e0 nh\u1ea5p v\u00e0o tab Border, ho\u1eb7c \u2013 Nh\u1ea5n Ctrl +1 v\u00e0 nh\u1ea5p v\u00e0o tab Border, ho\u1eb7c \u2013 nh\u1ea5p chu\u1ed9t ph\u1ea3i, nh\u1ea5p v\u00e0o Format Cells v\u00e0 nh\u1ea5p v\u00e0o tab Border, ho\u1eb7c \u2013 nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0 nh\u1ea5p v\u00e0o ki\u1ec3u \u0111\u01b0\u1eddng vi\u1ec1n tr\u00ean Mini toolbar, \u2013 tr\u00ean tab Home, nh\u00f3m Font, b\u1ea5m Dialog Box launcher v\u00e0 nh\u1ea5p v\u00e0o tab Border \u00a9 IIG Vietnam. 17","Microsoft\u00ae Core Skills Excel 2010 \u00c1p d\u1ee5ng \u0111\u01b0\u1eddng vi\u1ec1n \u00f4 (Cell Borders) \u2022 C\u0169ng c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng tr\u1ef1c ti\u1ebfp \u0111\u01b0\u1eddng vi\u1ec1n \u2013 Tr\u00ean tab Home, nh\u00f3m Font, b\u1ea5m \u2022 Options trong Borders \u0111\u1ec3 \u00e1p d\u1ee5ng \u0111\u01b0\u1eddng vi\u1ec1n t\u1ef1 \u0111\u1ed9ng \u0111\u1ebfn c\u00e1c \u00f4 \u0111\u01b0\u1ee3c l\u1ef1a ch\u1ecdn \u2022 S\u1eed d\u1ee5ng Draw Borders \u0111\u1ec3 v\u1ebd \u0111\u01b0\u1eddng vi\u1ec1n cho c\u00e1c \u00f4 c\u1ee5 th\u1ec3 \u00a9 IIG Vietnam. 18","Microsoft\u00ae Core Skills Excel 2010 S\u1eed d\u1ee5ng m\u00e0u s\u1eafc v\u00e0 c\u00e1c m\u1eabu \u2022 \u00c1p d\u1ee5ng c\u00e1c m\u00e0u n\u1ec1n \u0111\u1ec3 t\u0103ng t\u00ednh h\u1ea5p d\u1eabn tr\u1ef1c quan \u2022 B\u1ea3ng m\u00e0u c\u00f3 hai b\u1ed9 c\u1ee7a m\u00e0u s\u1eafc: \u2013 H\u00e0ng d\u01b0\u1edbi c\u00f9ng c\u1ee7a m\u00e0u s\u1eafc l\u00e0 m\u00e0u s\u1eafc ti\u00eau chu\u1ea9n \u2013 Ph\u1ea7n Theme Colors cung c\u1ea5p ph\u1ea1m vi c\u00e1c t\u00f4ng d\u1ef1a tr\u00ean c\u00e1c ch\u1ee7 \u0111\u1ec1 hi\u1ec7n t\u1ea1i \u2022 \u0110\u1ec3 hi\u1ec3n th\u1ecb b\u1ea3ng m\u00e0u, ch\u1ecdn c\u00e1c \u00f4: \u2013 Tr\u00ean tab Home, nh\u00f3m Font, nh\u1ea5p chu\u1ed9t, ho\u1eb7c \u2013 Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4 v\u00e0 k\u00edch Fill Color trong Mini toolbar \u00a9 IIG Vietnam. 19","Microsoft\u00ae Core Skills Excel 2010 D\u00e1n v\u1edbi Live Preview \u2022 Xem tr\u01b0\u1edbc khi d\u00e1n v\u00e0o worksheet v\u1edbi c\u00e1c t\u00f9y ch\u1ecdn: \u2013 C\u00e1c gi\u00e1 tr\u1ecb d\u1eef li\u1ec7u (c\u00f4ng th\u1ee9c \u0111\u00e3 \u0111\u01b0\u1ee3c chuy\u1ec3n \u0111\u1ed5i) \u2013 C\u00f4ng th\u1ee9c \u2013 \u0110\u1ecbnh d\u1ea1ng \u2013 C\u00f3 ho\u1eb7c kh\u00f4ng c\u00f3 \u0111\u01b0\u1eddng vi\u1ec1n \u2013 Ho\u00e1n chuy\u1ec3n (Transpose) \u2013 Li\u00ean k\u1ebft (Link) \u2022 C\u00e1c \u00f4 ph\u1ee5c h\u1ed3i tr\u1edf l\u1ea1i khi b\u1ea5m v\u00e0o b\u00ean ngo\u00e0i tr\u00ecnh \u0111\u01a1n Paste \u2022 \u0110\u1ec3 d\u00e1n v\u1edbi Live Preview, h\u00e3y ch\u1ecdn c\u00e1c \u00f4: \u2013 Tr\u00ean tab Home, trong nh\u00f3m Clipboard, nh\u1ea5p v\u00e0o m\u0169i t\u00ean d\u01b0\u1edbi Paste \u00a9 IIG Vietnam. 20","Microsoft\u00ae Core Skills Excel 2010 S\u1eed d\u1ee5ng Format Painter \u2022 Nh\u00e2n b\u1ea3n \u0111\u1ecbnh d\u1ea1ng \\\"ti\u00eau chu\u1ea9n\\\" trong b\u1ea3ng t\u00ednh \u2022 Ph\u1ea3i nh\u1ea5p chu\u1ed9t v\u00e0o \u00f4 v\u1edbi \u0111\u1ecbnh d\u1ea1ng ph\u1ea3i sao ch\u00e9p, v\u00e0 sau \u0111\u00f3 tr\u00ean tab Home, trong nh\u00f3m Clipboard: \u2013 cho m\u1ed9t \u1ee9ng d\u1ee5ng, nh\u1ea5p chu\u1ed9t , sau \u0111\u00f3 nh\u1ea5p chu\u1ed9t v\u00e0o \u00f4 c\u00f3 c\u00f9ng \u0111\u1ecbnh d\u1ea1ng \u2013 \u0111\u1ed1i v\u1edbi nhi\u1ec1u \u1ee9ng d\u1ee5ng, nh\u1ea5p \u0111\u00fap v\u00e0o , sau \u0111\u00f3 b\u1ea5m v\u00e0o m\u1ed7i \u00f4 v\u00e0o c\u00f3 c\u00e1c t\u00f9y ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng \u00a9 IIG Vietnam. 21","Microsoft\u00ae Core Skills Excel 2010 Xo\u00e1 n\u1ed9i dung v\u00e0 \u0111\u1ecbnh d\u1ea1ng trong \u00f4 \u2022 Ch\u1ecdn c\u00e1c \u00f4 v\u00e0 sau \u0111\u00f3 Edit, Clear \u2013 S\u1eed dung All \u0111\u1ec3 lo\u1ea1i b\u1ecf t\u1ea5t c\u1ea3 c\u00e1c d\u1eef li\u1ec7u, \u0111\u1ecbnh d\u1ea1ng \u00f4, v\u00e0 c\u00e1c nh\u1eadn x\u00e9t \u2013 S\u1eed d\u1ee5ng Format ch\u1ec9 \u0111\u1ec3 lo\u1ea1i b\u1ecf \u0111\u1ecbnh d\u1ea1ng \u2013 S\u1eed d\u1ee5ng Contents \u0111\u1ec3 ch\u1ec9 lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u \u2013 S\u1eed d\u1ee5ng Comments ch\u1ec9 \u0111\u1ec3 lo\u1ea1i b\u1ecf c\u00e1c b\u00ecnh lu\u1eadn \u2022 L\u1ec7nh Delete lo\u1ea1i b\u1ecf c\u00e1c \u00f4, h\u00e0ng ho\u1eb7c c\u1ed9t \u0111\u01b0\u1ee3c l\u1ef1a ch\u1ecdn kh\u1ecfi worksheet \u2022 \u0110\u1ec3 lo\u1ea1i b\u1ecf n\u1ed9i dung c\u1ee7a \u00f4 m\u00e0 kh\u00f4ng c\u1ea7n lo\u1ea1i b\u1ecf \u0111\u1ecbnh d\u1ea1ng, nh\u1ea5n Delete \u00a9 IIG Vietnam. 22","Microsoft\u00ae Core Skills Excel 2010 \u00c1p d\u1ee5ng ch\u1ee7 \u0111\u1ec1 (Themes) \u00a9 IIG Vietnam. \u2022 R\u1ea5t h\u1eefu \u00edch cho vi\u1ec7c t\u1ea1o ra c\u00e1i nh\u00ecn nh\u1ea5t qu\u00e1n cho c\u00e1c t\u00e0i li\u1ec7u \u2013 t\u1ea1o ra b\u1ea3n s\u1eafc \u0111\u1ec3 nh\u1eadn bi\u1ebft nhanh ch\u00f3ng \u2022 B\u1ed9 m\u00e0u s\u1eafc, ph\u00f4ng ch\u1eef, v\u00e0 c\u00e1c hi\u1ec7u \u1ee9ng hi\u1ec3n th\u1ecb ch\u1ee7 \u0111\u1ec1 \u2022 M\u1eb7c \u0111\u1ecbnh l\u00e0 ch\u1ee7 \u0111\u1ec1 Office \u2013 m\u1ed9t s\u1ed1 \u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng trong c\u00e1c ch\u1ee7 \u0111\u1ec1 \u2013 c\u00f3 th\u1ec3 t\u1ea1o ra c\u00e1c ch\u1ee7 \u0111\u1ec1 c\u1ee7a ri\u00eang b\u1ea1n \u2022 \u0110\u1ec3 hi\u1ec3n th\u1ecb c\u00e1c ch\u1ee7 \u0111\u1ec1, tr\u00ean tab Page Layout, nh\u00f3m Themes, nh\u1ea5p v\u00e0o Themes 23"]