{"id":10507,"date":"2025-01-14T11:39:01","date_gmt":"2025-01-14T11:39:01","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/huong-dan-tien-ich-watch-window-trong-excel-de-kiem-tra-ket-qua\/"},"modified":"2025-01-14T11:39:01","modified_gmt":"2025-01-14T11:39:01","slug":"huong-dan-tien-ich-watch-window-trong-excel-de-kiem-tra-ket-qua","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/huong-dan-tien-ich-watch-window-trong-excel-de-kiem-tra-ket-qua\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn ti\u1ec7n \u00edch Watch Window trong Excel \u0111\u1ec3 ki\u1ec3m tra k\u1ebft qu\u1ea3"},"content":{"rendered":"
\n

B\u1ea1n c\u00f3 bao gi\u1edd c\u1ea3m th\u1ea5y b\u1ea5t ti\u1ec7n khi theo d\u00f5i c\u00e1c k\u1ebft qu\u1ea3 c\u1ee7a m\u00f4t \u00f4 t\u00ednh, c\u00e1i m\u00e0 kh\u00f4ng n\u1eb1m tr\u00ean m\u00e0n h\u00ecnh hi\u1ec3n th\u1ecb hi\u1ec7n t\u1ea1i, m\u00e0 \u0111\u00f2i h\u1ecfi ta ph\u1ea3i cu\u1ed9n xu\u1ed1ng d\u01b0\u1edbi c\u00f9ng trang t\u00ednh ho\u1eb7c ph\u1ea3i chuy\u1ec3n sang trang t\u00ednh kh\u00e1c \u0111\u1ec3 xem? \u0110\u1ea5y l\u00e0 \u0111i\u1ec1u th\u01b0\u1eddng g\u1eb7p trong M\u00f4 h\u00ecnh t\u00e0i ch\u00ednh<\/a> khi c\u00e1c c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n li\u00ean k\u1ebft v\u1edbi nhau v\u00e0 kh\u1ed1i l\u01b0\u1ee3ng d\u1eef li\u1ec7u v\u00e0 c\u00f4ng th\u1ee9c l\u00e0 nhi\u1ec1u v\u00f4 k\u1ec3, ta kh\u00f4ng th\u1ec3 hi\u1ec7n th\u1ecb t\u1ea5t c\u1ea3 ch\u1ec9 tr\u00ean m\u1ed9t m\u00e0n h\u00ecnh m\u00e1y t\u00ednh. V\u1edbi m\u1ed7i s\u1ed1 li\u1ec7u thay \u0111\u1ed5i trong 1 \u00f4 t\u00ednh, c\u00e1c gi\u00e1 tr\u1ecb li\u00ean quan t\u1ea1i c\u00e1c \u00f4 t\u00ednh kh\u00e1c c\u0169ng thay \u0111\u1ed5i theo v\u00e0 ta mu\u1ed1n bi\u1ebft s\u1ef1 thay \u0111\u1ed5i \u0111\u00f3 ra sao ngay l\u1eadp t\u1ee9c. Ti\u1ec7n \u00edch \u201cWatch window\u201d trong Excel s\u1ebd gi\u00fap b\u1ea1n r\u1ea5t nhi\u1ec1u.<\/em><\/p>\n

\u00a0<\/em><\/p>\n

V\u00ed d\u1ee5 c\u1ee5 th\u1ec3, ch\u00fang ta c\u00f3 m\u1ed9t b\u1ea3ng t\u00ednh \u0111\u00e3 \u0111\u01b0\u1ee3c x\u00e2y d\u1ef1ng d\u1ef1a tr\u00ean hai trang t\u00ednh. M\u1ed9t trang t\u00ednh ch\u1ee9a c\u00e1c y\u1ebfu t\u1ed1 \u0111\u1ea7u v\u00e0o v\u00e0 m\u1ed9t trang t\u00ednh kh\u00e1c ch\u1ee9a m\u1ed9t s\u1ed1 ph\u00e9p t\u00ednh v\u00e0 k\u1ebft qu\u1ea3 \u0111\u1ea7u ra. V\u00e0 tr\u00ean trang t\u00ednh k\u1ebft qu\u1ea3, ch\u00fang ta c\u00f3 hai \u00f4 r\u1ea5t quan tr\u1ecdng l\u00e0 \u00f4 IRR v\u00e0 \u00f4 NPV. Ch\u00fang ta mu\u1ed1n xem \u0111i\u1ec1u g\u00ec x\u1ea3y ra v\u1edbi nh\u1eefng \u00f4 n\u00e0y khi \u0111ang b\u1eadt trang t\u00ednh \u0111\u1ea7u v\u00e0o v\u00e0 thay \u0111\u1ed5i \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n cho c\u00e1c \u00f4 \u0111\u1ea7u v\u00e0o, nh\u01b0ng th\u1eadt s\u1ef1 b\u1ea5t ti\u1ec7n n\u1ebfu c\u1ee9 chuy\u1ec3n gi\u1eefa c\u00e1c trang t\u00ednh. V\u00ec v\u1eady, nh\u1eefng g\u00ec ta c\u00f3 th\u1ec3 l\u00e0m l\u00e0 Excel WATCH WINDOW.<\/p>\n

N\u00fat Watch Window s\u1ebd kh\u1edfi ch\u1ea1y m\u1ed9t h\u1ed9p tho\u1ea1i cho ph\u00e9p b\u1ea1n xem th\u00f4ng tin v\u1ec1 c\u00e1c \u00f4 c\u1ee5 th\u1ec3, th\u1eadm ch\u00ed l\u00e0 c\u00e1c \u00f4 kh\u00f4ng hi\u1ec3n th\u1ecb tr\u00ean m\u00e0n h\u00ecnh hi\u1ec7n t\u1ea1i. \u0110i\u1ec1u n\u00e0y r\u1ea5t h\u1eefu \u00edch \u0111\u1ec3 b\u1ea1n kh\u00f4ng ph\u1ea3i ti\u1ebfp t\u1ee5c cu\u1ed9n trong trang t\u00ednh (sheet) hay chuy\u1ec3n gi\u1eefa c\u00e1c sheet \u0111\u1ec3 ki\u1ec3m tra k\u1ebft qu\u1ea3 c\u1ee7a m\u00ecnh. H\u1ed9p tho\u1ea1i n\u00e0y c\u00f3 th\u1ec3 hi\u1ec7n th\u1ecb gi\u00e1 tr\u1ecb c\u1ee7a b\u1ea5t c\u1ee9 \u00f4 n\u00e0o n\u1eb1m trong to\u00e0n b\u1ed9 s\u1ed5 l\u00e0m vi\u1ec7c (workbook). \u00dd ngh\u0129a l\u00e0 khi ta thay \u0111\u1ed5i gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t \u00f4, c\u1eeda s\u1ed5 n\u00e0y cho ph\u00e9p ta xem t\u00e1c \u0111\u1ed9ng c\u1ee7a s\u1ef1 thay \u0111\u1ed5i n\u00e0y l\u00ean c\u00e1c \u00f4 chiu \u1ea3nh h\u01b0\u1edfng tr\u00ean to\u00e0n b\u1ed9 workbook. H\u1ed9p tho\u1ea1i hay c\u1eeda s\u1ed5 n\u00e0y c\u0169ng hi\u1ec7n th\u1ecb th\u00f4ng tin v\u1ec1 s\u1ed5 l\u00e0m vi\u1ec7c, trang t\u00ednh, t\u00ean \u00f4, gi\u00e1 tr\u1ecb \u00f4 v\u00e0 c\u00f4ng th\u1ee9c c\u1ee7a \u00f4 c\u1ea7n theo d\u00f5i.<\/p>\n

C\u00e1c b\u01b0\u1edbc b\u1eadt t\u00ednh n\u0103ng Watch window<\/em><\/strong><\/p>\n

Chuy\u1ec3n \u0111\u1ebfn tab C\u00f4ng th\u1ee9c (Formula Tab) => Chuy\u1ec3n \u0111\u1ebfn nh\u00f3m Auditing (Formula Auditing Group) => Ch\u1ecdn t\u00f9y ch\u1ecdn \u2018Watch window\u2019<\/p>\n

<\/p>\n

M\u1ed9t c\u1eeda s\u1ed5 nh\u1ecf s\u1ebd m\u1edf ra, trong \u0111\u00f3 b\u1ea1n s\u1ebd ph\u1ea3i ch\u1ecdn t\u00f9y ch\u1ecdn \u201cAdd watch\u201d. Sau \u0111\u00f3 ch\u1ecdn \u00f4 tham chi\u1ebfu m\u00e0 b\u1ea1n c\u1ea7n xem, l\u00e0 \u00f4 k\u1ebft qu\u1ea3 v\u1edbi c\u00e1c c\u00f4ng th\u1ee9c li\u00ean quan \u0111\u1ebfn \u00f4 d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o v\u00e0 s\u1ebd thay \u0111\u1ed5i khi d\u1eef li\u1ec7u \u0111\u1ea7u v\u00e0o thay \u0111\u1ed5i, v\u00ed d\u1ee5 IRR v\u00e0 NPV. V\u00ed d\u1ee5 ta add \u00f4 IRR, s\u1ebd c\u00f3 m\u1ed9t d\u00f2ng tr\u00ean h\u1ed9p tho\u1ea1i Watch window th\u1ec3 hi\u1ec7n gi\u00e1 tr\u1ecb \u00f4 IRR, t\u01b0\u01a1ng t\u1ef1 NPV c\u0169ng v\u1eady. Khi \u0111\u00f3, ch\u1ec9 c\u1ea7n nh\u00ecn v\u00e0o c\u1eeda s\u1ed5\/ h\u1ed9p tho\u1ea1i Watch window n\u00e0y v\u00e0 thay \u0111\u1ed5i c\u00e1c y\u1ebfu t\u1ed1 \u0111\u1ea7u v\u00e0o, ta s\u1ebd nh\u00ecn th\u1ea5y gi\u00e1 tr\u1ecb IRR v\u00e0 NPV \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n trong Watch window thay \u0111\u1ed5i t\u01b0\u01a1ng \u1ee9ng, m\u00e0 kh\u00f4ng c\u1ea7n t\u00ecm n\u00f3 \u1edf c\u00e1c sheet kh\u00e1c hay ph\u1ea3i xu\u1ed1ng t\u1eadn cu\u1ed1i sheet.<\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n

\u00a0<\/p>\n

<\/p>\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\n
\n
\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10508,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10507","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10507","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=10507"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10507\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10508"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10507"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10507"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10507"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}