<style>/*<link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=602305327945510887&zx=3d680cf6-3436-423e-9265-b6e524b02268' media='none' onload='if(media!='all')media='all'' rel='stylesheet'/><noscript><link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=602305327945510887&zx=3d680cf6-3436-423e-9265-b6e524b02268' rel='stylesheet'/></noscript>
<meta name='google-adsense-platform-account' content='ca-host-pub-1556223355139109'/>
<meta name='google-adsense-platform-domain' content='blogspot.com'/>

<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-4385357534878672&host=ca-host-pub-1556223355139109" crossorigin="anonymous"></script>

<!-- data-ad-client=ca-pub-4385357534878672 -->

</head><body>*/</style>

Quản lý dữ liệu trong Trang tính

AGS CHI HR

21 thg 3, 2024

1. Thực hiện các thao tác cơ bản

Hầu hết các thao tác cơ bản đều hoạt động theo cách tương tự trong Trang tính và Microsoft Excel®, chẳng hạn như:

Di chuyển hàng và cột
Thêm hay xóa hàng hoặc cột
Thêm hàm (cùng một hàm)
In bảng tính
Sao chép và dán dữ liệu

2. Tìm kiếm dữ liệu

3. Xem các thay đổi đối với dữ liệu

4. Hạn chế chia sẻ dữ liệu

Trang tính: Tùy chọn hạn chế chia sẻ

Trong bảng tính mà bạn sở hữu, hãy nhấp vào Chia sẻ.
Nhấp vào Nâng cao.
Chọn một hoặc cả hai hộp sau:

Không cho người chỉnh sửa thay đổi quyền truy cập và thêm người mới
Tắt tùy chọn tải xuống, in và sao chép đối với người nhận xét và người xem

Nhấp vào Lưu thay đổi.
Nhấp vào Xong.

5. Sử dụng phím tắt

Trang tính: Xem toàn bộ danh sách các phím tắt

Mở Trang tính.
Đối với Windows và Chrome OS, hãy nhấn tổ hợp phím Ctrl+/.
Đối với máy Mac, hãy nhấn tổ hợp phím ⌘+/.

Nguồn: https://support.google.com/docs/answer/9331279?hl=vi&ref_topic=9296611&sjid=7970961094719178486-AP

Kỹnăng_Excel

<style>/*
<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/1455187647-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AOuZoY54yhGi3X3CdKHt6j6tFDXFJSY07A:1743632149491';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d602305327945510887','//ketoan.ags-vina.com/2024/03/quan-ly-du-lieu-trong-trang-tinh.html','602305327945510887');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '602305327945510887', 'title': 'C\xf4ng ty D\u1ecbch v\u1ee5 K\u1ebf to\xe1n v\xe0 Ki\u1ec3m to\xe1n Nh\u1eadt b\u1ea3n.(AGS-VINA)', 'url': 'https://ketoan.ags-vina.com/2024/03/quan-ly-du-lieu-trong-trang-tinh.html', 'canonicalUrl': 'https://ketoan.ags-vina.com/2024/03/quan-ly-du-lieu-trong-trang-tinh.html', 'homepageUrl': 'https://ketoan.ags-vina.com/', 'searchUrl': 'https://ketoan.ags-vina.com/search', 'canonicalHomepageUrl': 'https://ketoan.ags-vina.com/', 'blogspotFaviconUrl': 'https://ketoan.ags-vina.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': 'G-YHV6E4SXZ4', 'analytics4': true, 'encoding': 'UTF-8', 'locale': 'vi', 'localeUnderscoreDelimited': 'vi', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22C\xf4ng ty D\u1ecbch v\u1ee5 K\u1ebf to\xe1n v\xe0 Ki\u1ec3m to\xe1n Nh\u1eadt b\u1ea3n.(AGS-VINA) - Atom\x22 href\x3d\x22https://ketoan.ags-vina.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22C\xf4ng ty D\u1ecbch v\u1ee5 K\u1ebf to\xe1n v\xe0 Ki\u1ec3m to\xe1n Nh\u1eadt b\u1ea3n.(AGS-VINA) - RSS\x22 href\x3d\x22https://ketoan.ags-vina.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22C\xf4ng ty D\u1ecbch v\u1ee5 K\u1ebf to\xe1n v\xe0 Ki\u1ec3m to\xe1n Nh\u1eadt b\u1ea3n.(AGS-VINA) - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/602305327945510887/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22C\xf4ng ty D\u1ecbch v\u1ee5 K\u1ebf to\xe1n v\xe0 Ki\u1ec3m to\xe1n Nh\u1eadt b\u1ea3n.(AGS-VINA) - Atom\x22 href\x3d\x22https://ketoan.ags-vina.com/feeds/6730794389574471663/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseClientId': 'ca-pub-4385357534878672', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': true, 'adsenseAutoAds': true, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/88857c833b4750f1', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Nh\u1eadn \u0111\u01b0\u1eddng li\xean k\u1ebft', 'key': 'link', 'shareMessage': 'Nh\u1eadn \u0111\u01b0\u1eddng li\xean k\u1ebft', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Chia s\u1ebb v\u1edbi Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'Chia s\u1ebb v\u1edbi X', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Chia s\u1ebb v\u1edbi Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27vi\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': true, 'jumpLinkMessage': 'Read more \xbb', 'pageType': 'item', 'postId': '6730794389574471663', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuMyYuC5cQwJr6LdwYJxO4aq2R_ISxvJ7dfxqVMiZBoJBrV2VB92-nUyQRmcywqAU1Fe1dDVHkfmX3CBffv-Blhucg58CTmon73EuISosyh-xUH9KE1REsekgrAyFmJ8Rm0i8pCVv7wwM7u1NWKScv1KJ7vjs1ceRpFSRqFQxtDgI-pfLuv55jwQM3/s72-c/Screenshot%202024-03-21%20142639.png', 'postImageUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuMyYuC5cQwJr6LdwYJxO4aq2R_ISxvJ7dfxqVMiZBoJBrV2VB92-nUyQRmcywqAU1Fe1dDVHkfmX3CBffv-Blhucg58CTmon73EuISosyh-xUH9KE1REsekgrAyFmJ8Rm0i8pCVv7wwM7u1NWKScv1KJ7vjs1ceRpFSRqFQxtDgI-pfLuv55jwQM3/s320/Screenshot%202024-03-21%20142639.png', 'pageName': 'Qu\u1ea3n l\xfd d\u1eef li\u1ec7u trong Trang t\xednh', 'pageTitle': 'C\xf4ng ty D\u1ecbch v\u1ee5 K\u1ebf to\xe1n v\xe0 Ki\u1ec3m to\xe1n Nh\u1eadt b\u1ea3n.(AGS-VINA): Qu\u1ea3n l\xfd d\u1eef li\u1ec7u trong Trang t\xednh', 'metaDescription': ''}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Ch\u1ec9nh s\u1eeda', 'linkCopiedToClipboard': '\u0110\xe3 sao ch\xe9p \u0111\u01b0\u1eddng li\xean k\u1ebft v\xe0o b\u1ea3ng nh\u1edb t\u1ea1m!', 'ok': 'Ok', 'postLink': 'Li\xean k\u1ebft b\xe0i \u0111\u0103ng'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'T\xf9y ch\u1ec9nh', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'Qu\u1ea3n l\xfd d\u1eef li\u1ec7u trong Trang t\xednh', 'description': 'Nh\u1eadt B\u1ea3n, k\u1ebf to\xe1n, thu\u1ebf, ki\u1ec3m to\xe1n, th\xe0nh l\u1eadp c\xf4ng ty/v\u0103n ph\xf2ng \u0111\u1ea1i di\u1ec7n, gi\u1ea5y ph\xe9p lao \u0111\u1ed9ng, VISA', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuMyYuC5cQwJr6LdwYJxO4aq2R_ISxvJ7dfxqVMiZBoJBrV2VB92-nUyQRmcywqAU1Fe1dDVHkfmX3CBffv-Blhucg58CTmon73EuISosyh-xUH9KE1REsekgrAyFmJ8Rm0i8pCVv7wwM7u1NWKScv1KJ7vjs1ceRpFSRqFQxtDgI-pfLuv55jwQM3/s320/Screenshot%202024-03-21%20142639.png', 'url': 'https://ketoan.ags-vina.com/2024/03/quan-ly-du-lieu-trong-trang-tinh.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 6730794389574471663}}, {'name': 'widgets', 'data': [{'title': 'Upload Image', 'type': 'Image', 'sectionId': 'upload-image', 'id': 'Image10'}, {'title': 'Logo', 'type': 'HTML', 'sectionId': 'header-main', 'id': 'HTML10'}, {'title': 'Icons, Dark, Search', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList10'}, {'title': 'Menu', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList11'}, {'title': 'Featured Post', 'type': 'FeaturedPost', 'sectionId': 'before-blog', 'id': 'FeaturedPost1', 'postId': '8218421950964000988'}, {'title': 'B\xe0i \u0111\u0103ng tr\xean Blog', 'type': 'Blog', 'sectionId': 'blog-post', 'id': 'Blog1', 'posts': [{'id': '6730794389574471663', 'title': 'Qu\u1ea3n l\xfd d\u1eef li\u1ec7u trong Trang t\xednh', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuMyYuC5cQwJr6LdwYJxO4aq2R_ISxvJ7dfxqVMiZBoJBrV2VB92-nUyQRmcywqAU1Fe1dDVHkfmX3CBffv-Blhucg58CTmon73EuISosyh-xUH9KE1REsekgrAyFmJ8Rm0i8pCVv7wwM7u1NWKScv1KJ7vjs1ceRpFSRqFQxtDgI-pfLuv55jwQM3/s320/Screenshot%202024-03-21%20142639.png', 'showInlineAds': false}], 'headerByline': {'regionName': 'header1', 'items': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': 'B\u1edfi'}, {'name': 'timestamp', 'label': 'd MMM, yyyy'}]}, 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'comments', 'label': 'Comment'}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': '\x27s label'}]}], 'allBylineItems': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': 'B\u1edfi'}, {'name': 'timestamp', 'label': 'd MMM, yyyy'}, {'name': 'comments', 'label': 'Comment'}, {'name': 'labels', 'label': '\x27s label'}]}, {'title': '#You may also like', 'type': 'HTML', 'sectionId': 'ads-post', 'id': 'HTML15'}, {'title': 'Popular Posts', 'type': 'PopularPosts', 'sectionId': 'sidebar-static', 'id': 'PopularPosts10', 'posts': [{'title': '[V\u1ecb tr\xed] T\u1ed5ng h\u1ee3p t\u1ea5t c\u1ea3 v\u1ecb tr\xed tuy\u1ec3n d\u1ee5ng', 'id': 5739623661548307469}, {'title': 'Sinh Vi\xean \u0110i L\xe0m Th\xeam C\xf3 Ph\u1ea3i \u0110\xf3ng Thu\u1ebf Thu Nh\u1eadp C\xe1 Nh\xe2n Kh\xf4ng?', 'id': 3867792101327074401}, {'title': 'L\xe0m th\u1ebf n\xe0o \u0111\u1ec3 nhanh h\xf2a nh\u1eadp v\u1edbi m\xf4i tr\u01b0\u1eddng m\u1edbi t\u1ea1i AGS?', 'id': 2377159422795101179}, {'title': 'Doanh Thu K\u1ebf To\xe1n v\xe0 Doanh Thu T\xednh Thu\u1ebf \u2013 Kh\xe1c Nhau Nh\u01b0 Th\u1ebf N\xe0o?', 'id': 3205598615709459572}, {'title': 'IFAC l\xe0 g\xec? T\xecm hi\u1ec3u v\u1ec1 Li\xean \u0111o\xe0n K\u1ebf to\xe1n Qu\u1ed1c t\u1ebf v\xe0 Chu\u1ea9n m\u1ef1c To\xe0n c\u1ea7u', 'id': 3658919881491977534}, {'title': 'R\u1ee7i Ro Ki\u1ec3m To\xe1n L\xe0 G\xec? Ph\xe2n Lo\u1ea1i, Nguy\xean Nh\xe2n \x26 Bi\u1ec7n Ph\xe1p Ki\u1ec3m So\xe1t', 'id': 1850081890000638490}, {'title': 'So s\xe1nh chu\u1ea9n m\u1ef1c ki\u1ec3m to\xe1n Vi\u1ec7t Nam (VSA) 700 v\xe0 ISA 700', 'id': 2346727038448909228}]}, {'title': 'Categories', 'type': 'Label', 'sectionId': 'sidebar-static', 'id': 'Label10'}, {'title': 'Hashtag', 'type': 'Label', 'sectionId': 'sidebar-static', 'id': 'Label11'}, {'title': '#Recent Post', 'type': 'HTML', 'sectionId': 'sidebar-static', 'id': 'HTML19'}, {'title': 'About Us', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML21'}, {'title': 'Learn More', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList13'}, {'title': 'Bi\u1ec3u m\u1eabu li\xean h\u1ec7', 'type': 'ContactForm', 'sectionId': 'footer-widget', 'id': 'ContactForm1'}, {'title': 'Copyright', 'type': 'HTML', 'sectionId': 'copyright', 'id': 'HTML23'}, {'title': 'SVG Icons', 'type': 'HTML', 'sectionId': 'jet-options', 'id': 'HTML24'}]}]);
_WidgetManager._RegisterWidget('_ImageView', new _WidgetInfo('Image10', 'upload-image', document.getElementById('Image10'), {'resize': true}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML10', 'header-main', document.getElementById('HTML10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList10', 'header-main', document.getElementById('LinkList10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList11', 'header-main', document.getElementById('LinkList11'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_FeaturedPostView', new _WidgetInfo('FeaturedPost1', 'before-blog', document.getElementById('FeaturedPost1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'blog-post', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/2068071173-lbx__vi.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/1964470060-lightbox_bundle.css'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML15', 'ads-post', document.getElementById('HTML15'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts10', 'sidebar-static', document.getElementById('PopularPosts10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label10', 'sidebar-static', document.getElementById('Label10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label11', 'sidebar-static', document.getElementById('Label11'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML19', 'sidebar-static', document.getElementById('HTML19'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML21', 'footer-widget', document.getElementById('HTML21'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList13', 'footer-widget', document.getElementById('LinkList13'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_ContactFormView', new _WidgetInfo('ContactForm1', 'footer-widget', document.getElementById('ContactForm1'), {'contactFormMessageSendingMsg': '\u0110ang g\u1eedi...', 'contactFormMessageSentMsg': 'Th\u01b0 c\u1ee7a b\u1ea1n \u0111\xe3 \u0111\u01b0\u1ee3c g\u1eedi.', 'contactFormMessageNotSentMsg': 'Kh\xf4ng th\u1ec3 g\u1eedi th\u01b0.\xa0Vui l\xf2ng\xa0th\u1eed l\u1ea1i sau.', 'contactFormInvalidEmailMsg': 'C\u1ea7n nh\u1eadp \u0111\u1ecba ch\u1ec9 email h\u1ee3p l\u1ec7.', 'contactFormEmptyMessageMsg': 'Tr\u01b0\u1eddng th\u01b0 kh\xf4ng th\u1ec3 \u0111\u1ec3 tr\u1ed1ng.', 'title': 'Bi\u1ec3u m\u1eabu li\xean h\u1ec7', 'blogId': '602305327945510887', 'contactFormNameMsg': 'T\xean', 'contactFormEmailMsg': 'Email', 'contactFormMessageMsg': 'Th\xf4ng b\xe1o', 'contactFormSendMsg': 'G\u1eedi', 'contactFormToken': 'AOuZoY7NR7hDNBiaIgF-RyKWYpGlGsuL4A:1743632149492', 'submitUrl': 'https://www.blogger.com/contact-form.do'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML23', 'copyright', document.getElementById('HTML23'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML24', 'jet-options', document.getElementById('HTML24'), {}, 'displayModeFull'));
</script>
</body>*/</style>