<style>/*<link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=3897097043849371124&zx=8b7334b1-ba70-4238-87b0-dd5822e21397' media='none' onload='if(media!='all')media='all'' rel='stylesheet'/><noscript><link href='https://www.blogger.com/dyn-css/authorization.css?targetBlogID=3897097043849371124&zx=8b7334b1-ba70-4238-87b0-dd5822e21397' rel='stylesheet'/></noscript>
<meta name='google-adsense-platform-account' content='ca-host-pub-1556223355139109'/>
<meta name='google-adsense-platform-domain' content='blogspot.com'/>

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

Excel Advance Class-02 [Count | Counta | Countif

bdnews25

20 Sep, 2025

Excel Advance Class-02

[Count | Counta | Countif]

💼 চাকুরীজীবনে Excel-এর ব্যবহার

1. 📊 ডেটা বিশ্লেষণ ও রিপোর্টিং

Pivot Table, Charts, Conditional Formatting—এই টুলগুলো দিয়ে সহজেই বিশ্লেষণ করা যায় বড় ডেটাসেট।
যেমন: বিক্রয় রিপোর্ট, কর্মীদের পারফরম্যান্স বিশ্লেষণ।

2. 💰 অর্থনৈতিক পরিকল্পনা ও বাজেটিং

SUM, IF, VLOOKUP ইত্যাদি ফাংশন দিয়ে আয়-ব্যয় হিসাব রাখা যায়।
ফিনান্স টিম বা ছোট ব্যবসার মালিকদের জন্য অত্যন্ত কার্যকর।

3. 📅 প্রজেক্ট ম্যানেজমেন্ট ও সময়সূচী

কাজের তালিকা, ডেডলাইন, এবং অগ্রগতি ট্র্যাক করতে Excel খুবই উপযোগী।
Gantt Chart তৈরি করেও প্রজেক্ট ট্র্যাকিং করা যায়।

4. 🧮 স্বয়ংক্রিয় হিসাব ও ফর্মুলা

বারবার একই হিসাব করতে হয়? Excel ফর্মুলা দিয়ে একবার সেট করলেই কাজ হয়ে যায়।
COUNTIF, SUMIF, IFERROR—এই ফাংশনগুলো সময় বাঁচায়।

5. 📦 ইনভেন্টরি ও স্টক ম্যানেজমেন্ট

পণ্যের পরিমাণ, দাম, এবং স্টক ট্র্যাক করতে Excel ব্যবহার হয়।
ছোট দোকান থেকে বড় কোম্পানি—সব জায়গায় ব্যবহৃত।

আরো জানতে চাইলে এখানে ক্লিক করুন

Class -02

Video Link

Link-01 | Link-02 | Link-03

[Note: আপনি যখন প্রথমে ক্লিক করবেন তখন অন্য কোন ওয়েব সাইটে নিয়ে যাবে। আপনি কেটে দিয়ে আবার ক্লিক করবেন তাহলে ভিডিওটি ওপেন হয়ে যাবে]

Microsoft Office Microsoftedu MS Word MS-Excel

<style>/*
<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/382300504-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AOuZoY67cjpK73GV0GEr3vHR1YrksnLQwQ:1767002823706';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d3897097043849371124','//www.iifnews.shop/2025/09/excel-advance-class-02-count-counta.html','3897097043849371124');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '3897097043849371124', 'title': 'IIF News', 'url': 'https://www.iifnews.shop/2025/09/excel-advance-class-02-count-counta.html', 'canonicalUrl': 'https://www.iifnews.shop/2025/09/excel-advance-class-02-count-counta.html', 'homepageUrl': 'https://www.iifnews.shop/', 'searchUrl': 'https://www.iifnews.shop/search', 'canonicalHomepageUrl': 'https://www.iifnews.shop/', 'blogspotFaviconUrl': 'https://www.iifnews.shop/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': '', 'encoding': 'UTF-8', 'locale': 'en', 'localeUnderscoreDelimited': 'en', '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\x22IIF News - Atom\x22 href\x3d\x22https://www.iifnews.shop/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22IIF News - RSS\x22 href\x3d\x22https://www.iifnews.shop/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22IIF News - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/3897097043849371124/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22IIF News - Atom\x22 href\x3d\x22https://www.iifnews.shop/feeds/6256845458503477877/comments/default\x22 /\x3e\n', 'meTag': '', '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/daef15016aa26cab', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Get link', 'key': 'link', 'shareMessage': 'Get link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Share to Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'Share to X', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Share to 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: \x27en\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': false, 'jumpLinkMessage': 'Read more', 'pageType': 'item', 'postId': '6256845458503477877', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirHNzt4UZmN-_LFyWHdgAX_WGTXjS6HHHVhklwKjI_RX56-A89ht2CvipJ6DXdkfEmc64JaORSfh3cOaXhtK7rKq65ogSK54RD22tKKoJQLAjLbB5sqJv3hL47jGraY-ACu264Ja76HHa9gjgoh0dwjF4Ya-4uhpK6lK58SkhIrIAgZHo6pAgcOYv7sFs/s72-w426-c-h640/Copilot_20250920_164200.png', 'postImageUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirHNzt4UZmN-_LFyWHdgAX_WGTXjS6HHHVhklwKjI_RX56-A89ht2CvipJ6DXdkfEmc64JaORSfh3cOaXhtK7rKq65ogSK54RD22tKKoJQLAjLbB5sqJv3hL47jGraY-ACu264Ja76HHa9gjgoh0dwjF4Ya-4uhpK6lK58SkhIrIAgZHo6pAgcOYv7sFs/w426-h640/Copilot_20250920_164200.png', 'pageName': 'Excel Advance Class-02 [Count | Counta | Countif', 'pageTitle': 'IIF News: Excel Advance Class-02 [Count | Counta | Countif', 'metaDescription': ''}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Link copied to clipboard!', 'ok': 'Ok', 'postLink': 'Post Link'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Custom', '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': 'Excel Advance Class-02 [Count | Counta | Countif', 'description': 'www.iifnews.shop Website: News, Sports, today cricket live, today Football match, Private Job, Cricket, Football, IT', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirHNzt4UZmN-_LFyWHdgAX_WGTXjS6HHHVhklwKjI_RX56-A89ht2CvipJ6DXdkfEmc64JaORSfh3cOaXhtK7rKq65ogSK54RD22tKKoJQLAjLbB5sqJv3hL47jGraY-ACu264Ja76HHa9gjgoh0dwjF4Ya-4uhpK6lK58SkhIrIAgZHo6pAgcOYv7sFs/w426-h640/Copilot_20250920_164200.png', 'url': 'https://www.iifnews.shop/2025/09/excel-advance-class-02-count-counta.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 6256845458503477877}}, {'name': 'widgets', 'data': [{'title': 'Upload Image', 'type': 'Image', 'sectionId': 'upload-image', 'id': 'Image10'}, {'type': 'Attribution', 'sectionId': 'upload-image', 'id': 'Attribution1'}, {'title': '', 'type': 'ReportAbuse', 'sectionId': 'upload-image', 'id': 'ReportAbuse1'}, {'title': 'About Me', 'type': 'Profile', 'sectionId': 'upload-image', 'id': 'Profile1'}, {'title': 'Search This Blog', 'type': 'BlogSearch', 'sectionId': 'upload-image', 'id': 'BlogSearch1'}, {'title': 'Labels', 'type': 'Label', 'sectionId': 'upload-image', 'id': 'Label1'}, {'title': '', 'type': 'PopularPosts', 'sectionId': 'upload-image', 'id': 'PopularPosts1', 'posts': [{'title': 'Bangladesh VS Pakistan Today Match', 'id': 1908550443757706826}, {'title': '', 'id': 1524338637193783017}, {'title': ' \ud83d\udccc\u0986\u09aa\u09a8\u09be\u09b0 \u09b9\u09be\u09a4\u09c7 \u09a5\u09be\u0995\u09be \u09b8\u09cd\u09ae\u09be\u09b0\u09cd\u099f \u09ab\u09cb\u09a8 \u09a6\u09bf\u09df\u09c7 \u09a1\u09b2\u09be\u09b0 \u0986\u09df \u0995\u09b0\u09a4\u09c7 \u09aa\u09be\u09b0\u09c7\u09a8!!!\ud83d\udccc', 'id': 4643789526210395038}]}, {'title': '', 'type': 'PageList', 'sectionId': 'upload-image', 'id': 'PageList1'}, {'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': 'Banner Ads', 'type': 'HTML', 'sectionId': 'before-blog', 'id': 'HTML11'}, {'title': 'Blog Posts', 'type': 'Blog', 'sectionId': 'blog-post', 'id': 'Blog1', 'posts': [{'id': '6256845458503477877', 'title': 'Excel Advance Class-02 [Count | Counta | Countif', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirHNzt4UZmN-_LFyWHdgAX_WGTXjS6HHHVhklwKjI_RX56-A89ht2CvipJ6DXdkfEmc64JaORSfh3cOaXhtK7rKq65ogSK54RD22tKKoJQLAjLbB5sqJv3hL47jGraY-ACu264Ja76HHa9gjgoh0dwjF4Ya-4uhpK6lK58SkhIrIAgZHo6pAgcOYv7sFs/w426-h640/Copilot_20250920_164200.png', 'showInlineAds': false}], 'headerByline': {'regionName': 'header1', 'items': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': 'By'}, {'name': 'timestamp', 'label': 'd MMM, yyyy'}]}, 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'comments', 'label': 'Comment'}, {'name': 'icons', 'label': ''}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': ''}]}], 'allBylineItems': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': 'By'}, {'name': 'timestamp', 'label': 'd MMM, yyyy'}, {'name': 'comments', 'label': 'Comment'}, {'name': 'icons', 'label': ''}, {'name': 'labels', 'label': ''}]}, {'title': 'About Us', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML21'}, {'title': 'Learn More', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList13'}, {'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': false}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_AttributionView', new _WidgetInfo('Attribution1', 'upload-image', document.getElementById('Attribution1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_ReportAbuseView', new _WidgetInfo('ReportAbuse1', 'upload-image', document.getElementById('ReportAbuse1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_ProfileView', new _WidgetInfo('Profile1', 'upload-image', document.getElementById('Profile1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogSearchView', new _WidgetInfo('BlogSearch1', 'upload-image', document.getElementById('BlogSearch1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label1', 'upload-image', document.getElementById('Label1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts1', 'upload-image', document.getElementById('PopularPosts1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PageListView', new _WidgetInfo('PageList1', 'upload-image', document.getElementById('PageList1'), {'title': '', 'links': [{'isCurrentPage': false, 'href': 'http://iifnews25.blogspot.com/', 'title': 'Home'}], 'mobile': false, 'showPlaceholder': true, 'hasCurrentPage': false}, '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('_HTMLView', new _WidgetInfo('HTML11', 'before-blog', document.getElementById('HTML11'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'blog-post', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/2485970545-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/828616780-lightbox_bundle.css'}, '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('_HTMLView', new _WidgetInfo('HTML23', 'copyright', document.getElementById('HTML23'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML24', 'jet-options', document.getElementById('HTML24'), {}, 'displayModeFull'));
</script>
</body>*/</style>