Microsoft Excel – All for You

Menghitung dan Fungsi Sum di Excel

Fungsi yang paling umum digunakan di Excel adalah fungsi menghitung dan jumlah. Anda dapat menghitung dan jumlah berdasarkan satu kriteria a...

Fathoni 30 Jan, 2015

Microsoft Excel

Format Tanggal dan Waktu di Excel

Tanggal dan waktu di Excel dapat ditampilkan dalam berbagai cara. Untuk menerapkan Tanggal waktu atau Format, jalankan langkah-langkah berik...

Fathoni 28 Jan, 2015

Microsoft Excel

Mengatur Decimal di Excel

Pelajari cara untuk menunjukkan tempat desimal lebih sedikit di Excel tanpa mengubah nilai nomor itu sendiri. Anda juga dapat membulatkan an...

Fathoni 28 Jan, 2015

Microsoft Excel

Quick Access Toolbar Excel

Jika Anda sering menggunakan perintah Excel, Anda dapat menambahkannya ke Quick Access Toolbar. Anda bahkan dapat menambahkan perintah ke Qu...

Fathoni 28 Jan, 2015

Microsoft Excel

Mengubah Urutan di Excel

Gunakan opsi 'Paste Khusus Transpose' untuk beralih baris untuk kolom atau kolom untuk baris di Excel. Anda juga dapat menggunakan f...

Fathoni 28 Jan, 2015

Microsoft Excel

Menyembunyikan Kolom atau Baris di Excel

Kadang-kadang dapat berguna untuk menyembunyikan kolom atau baris di Excel. Menyembunyikan Untuk menyembunyikan kolom, jalankan langkah-l...

Fathoni 28 Jan, 2015

Microsoft Excel

Membuat Komentar di Excel

Anda dapat menyisipkan komentar untuk memberikan umpan balik tentang isi sel. Masukkan Komentar Untuk menyisipkan komentar, jalankan lang...

Fathoni 28 Jan, 2015

Microsoft Excel

Membuat Daftar kustom di Excel

Jika Anda membuat daftar kustom di Excel, Anda dapat dengan mudah mengisi kisaran dengan daftar Anda sendiri departemen, klien, kota, nomor ...

Fathoni 28 Jan, 2015

Microsoft Excel

Urutan Fibonacci di Excel

Sangat mudah untuk membuat segala macam urutan di Excel. Sebagai contoh, urutan Fibonacci. 1. Dua angka pertama dalam urutan Fibonacci ada...

Fathoni 28 Jan, 2015

Microsoft Excel

Bekerja Dengan Microsoft Excel

Mengenal Workbook dan Worksheet 1. Membuat Worksheet baru •Klik tombol Insert Worksheet pada tab Worksheet. •Anda akan mendapatkan Worksh...

Fathoni 16 Feb, 2013

<!--

<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/851759228-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AAPvtVl2TI0VE3xcspCLKDPxRXGx:1789666622099';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d3976261034658282476','//icollecta.blogspot.com/search/label/Microsoft%20Excel?max-results\x3d10','3976261034658282476');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '3976261034658282476', 'title': 'All for You', 'url': 'https://icollecta.blogspot.com/search/label/Microsoft%20Excel?max-results\x3d10', 'canonicalUrl': 'https://icollecta.blogspot.com/search/label/Microsoft%20Excel?max-results\x3d10', 'homepageUrl': 'https://icollecta.blogspot.com/', 'searchUrl': 'https://icollecta.blogspot.com/search', 'canonicalHomepageUrl': 'https://icollecta.blogspot.com/', 'blogspotFaviconUrl': 'https://icollecta.blogspot.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': false, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': 'UA-38705278-1', 'encoding': 'UTF-8', 'locale': 'id', 'localeUnderscoreDelimited': 'id', '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\x22All for You - Atom\x22 href\x3d\x22https://icollecta.blogspot.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22All for You - RSS\x22 href\x3d\x22https://icollecta.blogspot.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22All for You - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/3976261034658282476/posts/default\x22 /\x3e\n', 'meTag': '\x3clink rel\x3d\x22me\x22 href\x3d\x22https://www.blogger.com/profile/10084002456598824821\x22 /\x3e\n', 'adsenseClientId': 'ca-pub-1560747079619197', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': false, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/7ce469edaf870342', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Dapatkan link', 'key': 'link', 'shareMessage': 'Dapatkan link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Bagikan ke Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'Bagikan ke X', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Bagikan ke 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: \x27id\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': true, 'jumpLinkMessage': 'Read more \xbb', 'pageType': 'index', 'searchLabel': 'Microsoft Excel', 'pageName': 'Microsoft Excel', 'pageTitle': 'All for You: Microsoft Excel'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Tautan disalin ke papan klip!', 'ok': 'Oke', 'postLink': 'Tautan Pos'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Khusus', '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': 'All for You', 'description': 'No Need Day Tomorrow', 'url': 'https://icollecta.blogspot.com/search/label/Microsoft%20Excel?max-results\x3d10', 'type': 'feed', 'isSingleItem': false, 'isMultipleItems': true, 'isError': false, 'isPage': false, 'isPost': false, 'isHomepage': false, 'isArchive': false, 'isSearch': true, 'isLabelSearch': true, 'search': {'label': 'Microsoft Excel', 'resultsMessage': 'Menampilkan postingan dengan label Microsoft Excel', 'resultsMessageHtml': 'Menampilkan postingan dengan label \x3cspan class\x3d\x27search-label\x27\x3eMicrosoft Excel\x3c/span\x3e'}}}, {'name': 'widgets', 'data': [{'title': 'Logo', 'type': 'HTML', 'sectionId': 'header-main', 'id': 'HTML50'}, {'title': '#Search and Icons', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList52'}, {'title': 'Menu', 'type': 'PageList', 'sectionId': 'header-main', 'id': 'PageList50'}, {'title': 'Featured Post', 'type': 'FeaturedPost', 'sectionId': 'before-blog', 'id': 'FeaturedPost50', 'postId': '7436093338637726709'}, {'title': 'Postingan Blog', 'type': 'Blog', 'sectionId': 'blog-post', 'id': 'Blog50', 'posts': [{'id': '798212639698269959', 'title': 'Menghitung dan Fungsi Sum di Excel', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiVUnEjxmVijExLO7prC-Bf9BhA1tmgpp2mIt-_OCjq3g9o0eITQY73Lq_B2qwaV8mPcjXOxTCJ5mAkBdX-zxQ1odGFTgYCTW2Hj93oh5INmuLLEE1TMv-juXunaBq9Keccbas4V_6PxMe5/s1600/count-function.png', 'showInlineAds': false}, {'id': '7080300844764786020', 'title': 'Format Tanggal dan Waktu di Excel', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEif0lOtbWlpDcu9JXc_u7GLNmxKeS6AEsUKF7OzmMY36hzi3sEJ9IpDxQsj5OH2bdxqZMFUQqfpYEkNiWb8_rAg6hYvnpZcg-uNB-2j1Uu_L-BPOWQf4a9L1CFNosWbOoWs6uceKbKzIQhy/s1600/date-time-formats.png', 'showInlineAds': false}, {'id': '7334360379466232357', 'title': 'Mengatur Decimal di Excel', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7lm0qMqdhhpB3yjZjEfkiciTxYDxZU70d924hfNtHC2OhYkOos1Dm63eYuPlXEa1XJAQMYj-eaWP3aRvaofOZS_4l5Hpd0PR1rcGwZsajl1TyJ2WAzkf0HulK1BP2XtsttwK7_UeeKj3N/s1600/three-decimal-places.png', 'showInlineAds': false}, {'id': '7017174925245708581', 'title': 'Quick Access Toolbar Excel', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhoioLlTbk8hK1rtsklYETnebisWjesiBBfhjeEJhaGAyqXWSnFj7DooDJ4OyUOBe-MJrK3Z9YrSVSXdHBrOCjUHwi7GKVqw3OeBzeSpgcWobMeuxNuUregJls7_JKp4zLYdUoZiYyX9nbu/s1600/customize-quick-access-toolbar.png', 'showInlineAds': false}, {'id': '2482565412749166119', 'title': 'Mengubah Urutan di Excel', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiuuwJzu6XxP0wHHoYDQnFs9cxiEO6RYXlBSpkvY8BLQUTBBKlvFVeTBWWWINQQMYj90vbUxBWlQD-z1U9D1GHTpBP3pXeK611SCwCGTPPUZ7qCD7c65wLeHJ6-3d9dgjb-zMBlCHKAayWi/s1600/right-click-copy.png', 'showInlineAds': false}, {'id': '7808682596683592380', 'title': 'Menyembunyikan Kolom atau Baris di Excel', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhi2R_n0noSXHTk_zQKUXBw-ClAbwznZRe4YcOUHedtME1HKhv8EMj2jIM1mYOeGTC0fESSfzVwyjJeZfTr85Q9J5g51FoRP8LLEB2i-E4_8robGKC1_xuCEIXLDCAMU6RpAqUVtgP6NAtx/s1600/hide-column-example.png', 'showInlineAds': false}, {'id': '8148100941680506771', 'title': 'Membuat Komentar di Excel', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWfRfG8S3pNdvJkpmFsUoTf1EUT99V9tpLsvEb3ru8Rcwf4Wcn9X57MsFX4fppJMJ7GGTjX8Jmf9NxTa5sHG0VeYpCOiSuQXOB0MB13p2bjB0tP1SvDqQafRmq2xsWJgGdHxbGDzyAo33r/s1600/insert-comment.png', 'showInlineAds': false}, {'id': '7467344917120792367', 'title': 'Membuat Daftar kustom di Excel', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHXoAGGU7_X4-Hs-HR70ciTf5Ztd8VQKkYv-gPwOZTB51fhep4a3y_Rgvs6HOaDBYkc592iVdJwufdNwXUnueGQ-zIuZgQlCFpz2jn4Ab66Mi4OVGvipjUhgVdeGOGex_Oiw43izSoKSUj/s1600/built-in-list-example.png', 'showInlineAds': false}, {'id': '4386060082078920712', 'title': 'Urutan Fibonacci di Excel', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFecpnCqszopL7cFhztFriFn7J6yWPzH9XcACBeFGuXpYqKzbSr0OMfXnUVVT6B0IGimWllsTjB3SAp99RFWzwIc06Jb7W4EEkIvR8pKZ0avQ2ZU-XjiBZaFcg9cEY3uySMse3AvdsZv5g/s1600/first-two-numbers.png', 'showInlineAds': false}, {'id': '8196277871783752925', 'title': 'Bekerja Dengan Microsoft Excel', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3bmO_EKAB9YdPoqlTCPwvKaqTzBeUhBLAc7ABzUSljcvW-pr8ojWOYb2N6_Z7-bz8ymbCEWsAMmKuEH7H27wlQYvICihLk6jVMx7hShINXo5gK9JZP5DQhyphenhyphenOG2G7A_1xecvowgS3vRRbn/s320/20.png', 'showInlineAds': false}], 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'author', 'label': 'Diposting oleh'}, {'name': 'comments', 'label': 'Review'}]}], 'allBylineItems': [{'name': 'author', 'label': 'Diposting oleh'}, {'name': 'comments', 'label': 'Review'}]}, {'title': '#You may also like', 'type': 'HTML', 'sectionId': 'ads-post', 'id': 'HTML1'}, {'title': 'Popular Posts', 'type': 'PopularPosts', 'sectionId': 'sidebar-static', 'id': 'PopularPosts50', 'posts': [{'title': 'Menyembunyikan Kolom atau Baris di Excel', 'id': 7808682596683592380}, {'title': 'Membuat Komentar di Excel', 'id': 8148100941680506771}, {'title': 'Tutorial Smart Billing \u2013 Gwarnet', 'id': 4345336939709854438}, {'title': 'Kisah Nabi Luth', 'id': 3099446491535330147}, {'title': 'Avatar Korra Book 1 Episode 04', 'id': 3658546376101990003}]}, {'title': 'Categories', 'type': 'Label', 'sectionId': 'sidebar-static', 'id': 'Label50'}, {'title': 'About Us', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML55'}, {'title': 'Learn More', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList50'}, {'title': 'Follow Us', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList51'}, {'title': 'Newsletter', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML58'}, {'title': 'Copyright', 'type': 'HTML', 'sectionId': 'copyright', 'id': 'HTML56'}, {'title': 'SVG Icons', 'type': 'HTML', 'sectionId': 'jet-options', 'id': 'HTML57'}, {'title': 'JetScript Options', 'type': 'HTML', 'sectionId': 'jet-options', 'id': 'HTML59'}]}]);
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML50', 'header-main', document.getElementById('HTML50'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList52', 'header-main', document.getElementById('LinkList52'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PageListView', new _WidgetInfo('PageList50', 'header-main', document.getElementById('PageList50'), {'title': 'Menu', 'links': [{'isCurrentPage': false, 'href': '/p/about.html', 'title': 'About'}, {'isCurrentPage': false, 'href': '/search/label/Teknologi?max-results\x3d10', 'title': 'Tech'}, {'isCurrentPage': false, 'href': '#sub-start', 'title': 'Dropdown'}, {'isCurrentPage': false, 'href': '/search/label/Windows?max-results\x3d10', 'title': 'Windows'}, {'isCurrentPage': false, 'href': '#sub-start', 'title': 'Dropdown'}, {'isCurrentPage': false, 'href': '/search/label/Software?max-results\x3d10', 'title': 'Windows Software'}, {'isCurrentPage': false, 'href': '/search/label/Windows%20OS?max-results\x3d10', 'title': 'Windows OS'}, {'isCurrentPage': false, 'href': '#sub-end', 'title': 'Dropdown-#2'}, {'isCurrentPage': false, 'href': '#', 'title': 'Android'}, {'isCurrentPage': false, 'href': '#sub-end', 'title': 'Sub Menu #1'}, {'isCurrentPage': false, 'href': '/p/contact.html', 'title': 'Contact'}, {'isCurrentPage': false, 'href': '/p/sitemap.html', 'title': 'Sitemap'}], 'mobile': false, 'showPlaceholder': true, 'hasCurrentPage': false}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_FeaturedPostView', new _WidgetInfo('FeaturedPost50', 'before-blog', document.getElementById('FeaturedPost50'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog50', 'blog-post', document.getElementById('Blog50'), {'cmtInteractionsEnabled': false, 'navMessage': 'Tampilkan postingan dengan label \x3cb\x3eMicrosoft Excel\x3c/b\x3e. \x3ca href\x3d\x22https://icollecta.blogspot.com/\x22\x3eTampilkan semua postingan\x3c/a\x3e', 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/120969204-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/828616780-lightbox_bundle.css'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML1', 'ads-post', document.getElementById('HTML1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts50', 'sidebar-static', document.getElementById('PopularPosts50'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label50', 'sidebar-static', document.getElementById('Label50'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML55', 'footer-widget', document.getElementById('HTML55'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList50', 'footer-widget', document.getElementById('LinkList50'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList51', 'footer-widget', document.getElementById('LinkList51'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML58', 'footer-widget', document.getElementById('HTML58'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML56', 'copyright', document.getElementById('HTML56'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML57', 'jet-options', document.getElementById('HTML57'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML59', 'jet-options', document.getElementById('HTML59'), {}, 'displayModeFull'));
</script>
</body>

-->